[HaBo]

<table>
<form action=gastebuch.php method=post>
<textarea cols=50 rows=1 name="namedestyps">Name</textarea>
<p>
<textarea cols=50 rows=10 name="text">Nachricht</textarea>
<p>
<textarea cols=50 rows=1 name="homepage">Homepage</textarea>
<p>
<textarea cols=50 rows=1 name="email">eMail</textarea>
<p>
<input type=submit value="Eintragen">
</form>
</table>

<table>
<a href="eintragen.php">Eintragen</a>
<?
$date = date("j.n.y");

if($text != "") {

$fp=fopen("text.php","a");
fwrite ($fp, "<table>$namedestyps $date <a href='$homepage' target='_blank'>$homepage</a> <a href='mailto:$email'>mail</a><br> $text <hr width='50%'></table>");
fclose($fp);
}

$array=file("text.php");
$lines=sizeof($array);

$text=file("text.php");
$lines=sizeof($text);

for($i=0;$i<$lines;$i++) {
echo $text[$i];
}

?>
</table>

$order=='asc'

<table>
<script language="javascript">
function leeren (Wert,Wert2)
{
if (document.bar.elements[Wert2].value == Wert) 
 {
 document.bar.elements[Wert2].value='';
 }
}
</script>
<form name="bar" action=gastebuch.php method=post>
<input type="text" name="namedestyps" value="Name" onclick="leeren('Name','namedestyps')">
<p>
<textarea cols=50 rows=10 name="text" onclick="leeren('Nachricht','text')">Nachricht</textarea>
<p>
<input type="text" name="homepage" value="Homepage" onclick="leeren('Homepage','homepage')">
<p>
<input type="text" name="email" value="Email" onclick="leeren ('Email','email')">
<p>
<input type=submit value="Eintragen">
</form>
</table>

<table>
<a href="eintragen.php">Eintragen</a><br><br>
<?
$date = date("j.n.y");

if($text != "") {
$fp=fopen("text.php","a");
fwrite ($fp, "<table>$namedestyps $date <a href='$homepage' target='_blank'>$homepage</a> <a href='mailto:$email'>mail</a><br> $text <hr width='50%'></table>
"); //dieser Zeilenumbruch muss hier stehen
echo "Erfolgreich eingetragen";
fclose($fp);
}

$text=file("text.php");
$lines=count($text);
$text = array_reverse ($text); //dreht Array rum.
for($i=0;$i<$lines;$i++) 
{
 echo $text[$i]."<br><br>";
}

?>
</table>

$time = date("h:m");

<table>
<a href="eintragen.php">Eintragen</a><br><br>
<?
$date = date("j.n.y");

if($text != "") {
$fp=fopen("text.php","a");
$eintragtext = str_replace("\n", '<br>', $text);
fwrite ($fp, "<table>$namedestyps $date <a href='$homepage' target='_blank'>$homepage</a> <a href='mailto:$email'>mail</a><br> $eintragtext <hr width='50%'></table>
"); //dieser Zeilenumbruch muss hier stehen
echo "Erfolgreich eingetragen";
fclose($fp);
}

$text=file("text.php");
$lines=count($text);
$text = array_reverse ($text); //dreht Array rum.
for($i=0;$i<$lines;$i++) 
{
 echo $text[$i]."<br><br>";
}

?>
</table>

 

    define('MYSQL_HOST',     'localhost'); 
    define('MYSQL_USER',     'user');
    define('MYSQL_PASS',     'pass');
    define('MYSQL_DATABASE', 'dbase');

mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
mysql_select_db(MYSQL_DATABASE);

$sql = "INSERT INTO tabellenname ( `ID` , `name` , `nachricht` , `homepage`, `email` , `datum`) 
	VALUES ('', '$name', '$message', '$hp', '$email', now())";

mysql_query($Sql);

SELECT * FROM tabellenname ORDER BY datum DESC";

$res = mysql_query($Sql);

while ($row = mysql_fetch_assoc($result)) { }

echo "<table><td>name:</td><td>".$row[name]."</td> (...) ";