<?php
mysql_connect("localhost","","") or die ("Server nicht gefunden");
mysql_select_db("gaestebuch") or die ("Datenbank nicht gefunden");
?>

<?php  
	include("dbconnect.php");
?>

<h2>Signieren Sie mein G&auml;stebuch</h2>

<form action="do.php" method="post">
	Name:
		<input type=text size=40 name=name>
		

	Ort:
		<input type=text size=40 name=ort>
		

	E-Mail:
		<input type=text size=40 name=email>
		

	URL:
		<input type=text size=40 name=url>
		

	Kommentar:
		<textarea name=kommentar cols=40 rows=4 wrap=virtual></textarea>
	
 
	<input type=submit name=submit value="Go">
	<input type=reset name=reset value=L&ouml;schen>
</form>

<?php 
	include("dbconnect.php");
?>

<?php		
	if ($submit == "Go")		
		{		
		$query = "insert into gaestebuch " 
		. " (name,ort,email,url,kommentar) values" 
		. "('$name', '$ort', '$email', '$url', '$kommentar')";
		mysql_query($query);
?>

<h2>Danke</h2>
<h2>Eintrag ansehen</h2>

<?php
		}
	else
		{
		echo("fehler");
		// include("sign.php");
		}
?>

<?php 
	include("dbconnect.php");
?>

<h2>G&auml;stebuch</h2>

<?php

	$result = mysql_query("select * from gaestebuch") or die ("Fehler");
	if($result)
		{
		while($row = mysql_fetch_array($result))
			{
			print "Name:";
			print $row["name"];
			print "
";
			print "Ort:";
			print $row["ort"];
			print "
";
			print "E-Mail:";
			print $row["email"];
			print "
";
			print "URL:";
			print $row["url"];
			print "
";
			print "Kommentar:";
			print $row["kommentar"];
			print "
";
			print "
";
			print "
";
			}
		mysql_free_result($result);
		}
?>

<h2>Nochmal</h2>

<?php       
   if ($submit == "Go")       
      {       
      $query = "insert into gaestebuch " 
      . " (name,ort,email,url,kommentar) values" 
      . "('$name', '$ort', '$email', '$url', '$kommentar')"; 
      mysql_query($query); 
?>

<?php       
   if ($_POST['submit'] == "Go")       // verändert
      {       
      $query = "insert into gaestebuch " 
      . " (name,ort,email,url,kommentar) values"           //das geht noch net
      . "('$name', '$ort', '$email', '$url', '$kommentar')"; 
      mysql_query($query); 
?>

<?php        
   if ($_POST['submit'] == "Go")       // verändert 
      {        
      $query = "insert into gaestebuch " 
      . " ('name','ort','email','url','kommentar') values"           //das geht noch net 
      . ('$_POST['name'], usw..);                  //versuch
      mysql_query($query); 
?>

'$_POST[name]',

<?php        
   if ($_POST['submit'] == "Go")  
          {        
          $query = "insert into gaestebuch 
          (
           name,
           ort,
           email,
           url, 
           kommentar
           ) 
          values          
          (
          '$_POST[name]',
          '$_POST[name]',
          usw.
           )"; 
      mysql_query($query) or die ('Error[INSERT.USERDATA]:
'.mysql_error()); 
?>