Brauche doch mal wirklich Hilfe zum Gästebuch in PHP

<span class="syntaxhtml"><form name="" action="<span class="syntaxdefault"><?php echo $_localhost</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'PHP_SELF'</span><span class="syntaxkeyword">];</span><span class="syntaxdefault"> ?></span>"<br /> method="POST" enctype="text/html"><br /><p>Ihr Name:<br /><br /><input type="text" name="name" value="" size="50" maxlength="150" /><br /></p><br /><br /><p>Ihre E-Mail-Adresse:<br /><br /><input type="text" name="email" value="" size="50" maxlength="150" /><br /></p><br /><br /><p>Ihre Homepage:<br /><br /><input type="text" name="url" value="" size="50" maxlength="150" /><br /></p><br /><br /><p>Gästebucheintrag:<br /><br /><textarea name="eintrag" rows="10" cols="50"></textarea><br /></p><br /><br /><input type="Submit" name="" value="speichern" /><br /></form><br /><span class="syntaxdefault"><?php<br />define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">''</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">''</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">''</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'homepageanwendungen'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">$db_link </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">@</span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_BENUTZER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_link </span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// hier sollte dann später dem Programmierer eine<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// E-Mail mit dem Problem zukommen gelassen werden<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// die Fehlermeldung für den Programmierer sollte<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// das Problem ausgeben mit: mysql_error()<br /></span><span class="syntaxdefault">    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'keine Verbindung zur Zeit möglich - später probieren '</span><span class="syntaxkeyword">);<br />}<br /></span><span class="syntaxdefault">$db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> MYSQL_DATENBANK </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">    or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<h2>Eintrag speichern</h2>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// hier kommt nun der entsprechende PHP-Code<br /></span><span class="syntaxdefault">    exit</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" INSERT INTO gaestebuch "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" SET "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" name   ='"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" email  ='"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'email'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" url    ='"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'url'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" eintrag='"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxstring">"' "</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">echo </span><span class="syntaxstring">"</table>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">);<br /><br /><br /></span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $sql </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">  die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br />}<br /><br /><br /></span><span class="syntaxcomment">// jetzt werden alle Einträge ausgewählt und mal auf dem Bildschirm ausgegeben<br />// SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"<br />    SELECT<br />        *<br />    FROM gaestebuch<br />    ORDER BY datum<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $sql </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br />}<br /><br /></span><span class="syntaxdefault">while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">))<br />{<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// Aushabe der Daten<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<pre>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    print_r </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"</pre>"</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">?><br /></span></span>

while ($daten = mysql_fetch_array( $db_erg, MYSQL_ASSOC))

while ($daten = mysql_fetch_assoc( $db_erg))

<span class="syntaxdefault"><br />if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br /><br />{<br /></span><span class="syntaxdefault">    echo </span><span class="syntaxstring">"<h2>Eintrag speichern</h2>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// hier kommt nun der entsprechende PHP-Code<br /></span><span class="syntaxdefault">    exit</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault"> </span>

<span class="syntaxdefault"><br />$sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"<br />    SELECT<br />        *<br />    FROM gaestebuch<br />    ORDER BY datum<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span>

<span class="syntaxdefault"><br />error_reporting</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">E_ALL</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span>

<span class="syntaxhtml"><br />    <form name="" action="<span class="syntaxdefault"><?php echo $_localhost</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'PHP_SELF'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">?></span>"<br />     method="POST" enctype="text/html"><br />    <p>name:<br /><br />    <input type="text" name="name" value="" size="50" maxlength="150" /><br />    </p><br /><br />    <p>email:<br /><br />    <input type="text" name="email" value="" size="50" maxlength="150" /><br />    </p><br /><br />    <p>url:<br /><br />    <input type="text" name="url" value="" size="50" maxlength="150" /><br />    </p><br /><br />    <p>eintrag:<br /><br />    <textarea name="eintrag" rows="10" cols="50"></textarea><br />    </p><br />    <!-- input ok, wird benutzt zum überprüfen ob das formular wirklich gesendet wurde --><br />    <input type="hidden" name="ok" value="send" /><br />    <input type="Submit" name="send" value="speichern" /><br />    </form><br /><br />    <span class="syntaxdefault"><?php<br /><br /> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'localhost'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'root'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'unknow'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'unknow'</span><span class="syntaxkeyword">);<br /><br /><br /></span><span class="syntaxdefault"> $db_link </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">@</span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_BENUTZER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault"> $db_link</span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// hier sollte dann später dem Programmierer eine<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// E-Mail mit dem Problem zukommen gelassen werden<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// die Fehlermeldung für den Programmierer sollte<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// das Problem ausgeben mit: mysql_error()<br /></span><span class="syntaxdefault">    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'keine Verbindung zur Zeit möglich - später probieren '</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}<br /><br /><br /></span><span class="syntaxdefault"> $db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_DATENBANK</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /><br />/**<br /> * Der geänderte teil alles was mit dem 'Senden' der daten zu tun hat,<br /> *         Kommt in die if hinein. Damit es nur ausgeführt wird, wenn das Formular<br /> *         gesendet wurde.<br /> */<br /><br />// HIER WIRD GEPRÜFT OB DAS FORMULAR GESENDET WURDE<br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'ok'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> </span><span class="syntaxstring">"send"</span><span class="syntaxkeyword">)<br /><br />{<br /></span><span class="syntaxdefault">    <br />    <br />     </span><span class="syntaxcomment">// mysql_real_escape_string maskiert gefährliche zeichen<br /></span><span class="syntaxdefault">     $name </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     $email </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"email"</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     $url </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"url"</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     $eintrag </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// mit strip_tags werden z.B html code entfernt.<br /></span><span class="syntaxdefault">     $eintrag </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> strip_tags</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$eintrag</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// ÜBERPRÜFUNG OB ALLE FELDER AUGEFÜLLT WURDEN<br /></span><span class="syntaxkeyword">if(</span><span class="syntaxdefault">$name </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> AND $email </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> AND $url </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> AND $eintrag </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxkeyword">){<br /></span><span class="syntaxdefault">        <br />        <br />         </span><span class="syntaxcomment">// Die Insert SQL erstmal in die if abfrage packen.<br /></span><span class="syntaxdefault">        $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" INSERT INTO gaestebuch "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" SET "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" name   ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $name </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" email  ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $email </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" url    ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $url </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" datum  ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> date</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Y-m-d H:i:s"</span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" eintrag='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $eintrag </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"' "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">        <br />        <br />         </span><span class="syntaxcomment">// AUCH DEN QUERY IN DIE IF PACKEN<br /></span><span class="syntaxdefault">        </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">        $db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">         if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">        </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">             die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault">             <br />             </span><span class="syntaxkeyword">}else{</span><span class="syntaxdefault"> </span><span class="syntaxcomment">// HIER DIE ELSE. FALLS DER QUERY ERFOLGREICH WAR WIRD DAS AUSGEGEBEN<br /></span><span class="syntaxdefault">            <br />             echo </span><span class="syntaxstring">"<h2 style=\"color: #00ff00;\">Eintrag erfolgreich Gespeichert</h2>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">             echo </span><span class="syntaxstring">'<p><a href="gaestebuch.php">Gästebuch anzeigen</a></p>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">             <br />             </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault">        <br />         </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">/**<br />     * ende der if für das eintragen<br />     */<br /></span><span class="syntaxdefault">     else</span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">     <br />         echo </span><span class="syntaxstring">"<p style=\"color: #ff0000;\">Sie haben nicht alle Felder ausgef&uuml;llt. Daher konnte der eintrag nicht<br />        gespeichert werden.</p>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">        <br />         </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}</span><span class="syntaxdefault"> </span><span class="syntaxcomment">//ENDE DER IF<br /><br />/**<br /> */<br /><br /><br /><br /><br />/**<br /> * Hier die Mysql abfrage für die eingetragenen daten<br /> */<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"<br />        SELECT<br />            *<br />        FROM gaestebuch<br />        ORDER BY id DESC<br />    "</span><span class="syntaxkeyword">;</span><span class="syntaxdefault"> </span><span class="syntaxcomment">//IDS von GROß NACH KLEIN SORTIEREN<br /><br /><br /><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">     die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}<br /></span><span class="syntaxcomment">/**<br /> * Hier der bereich der ausge des GB<br /> */<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// anzahl<br /></span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<p>Anzahl der Gästebuch-Einträge: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxcomment">// While schleife der einträge<br /></span><span class="syntaxdefault">while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">))<br /><br />{<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"ID: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'id'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    <br />     echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    <br />     echo </span><span class="syntaxstring">"E-Mail: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'email'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    <br />     echo </span><span class="syntaxstring">"URL: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'url'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    <br />     echo </span><span class="syntaxstring">"Datum: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">    <br />     echo </span><span class="syntaxstring">"Gästebucheintrag: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">     echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// Ende der Whileschlife<br /></span><span class="syntaxdefault">?><br /></span><br /></span>

<span class="syntaxhtml"><br />  <!--<br />  Habe CSS code hinzugefügt. Und unten div boxen.<br />  Und habe dein Formular leicht überarbeitet.<br /><br /><br />   --><br /><br />  <style type="text/css"><br /><br />    #site{<br />    width: 600px;<br />       margin: auto;<br />       text-align: center;<br />    }<br />      .GBwrapper{<br />        margin: auto;<br />        border: thin solid;<br />        padding: 5px;<br />        text-align: left;<br /><br />      }<br /><br />      .GBhead{<br />        background-color: #000000;<br />        color: #FFFFFF;<br />        text-align: left;<br /><br />      }<br /><br />      .GBbody{<br />        font-size: medium;<br />        text-align: left;<br />      }<br /><br />      .GBfoot{<br />        border-top: solid thin;<br />        text-align: left;<br />      }<br />    </style><br /><br />     <div id="site"><br />     <h2>G&auml;stebuch</h2><br />    <form name="" action="<span class="syntaxdefault"><?php echo $_localhost</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'PHP_SELF'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">?></span>"<br />     method="POST" enctype="text/html"><br />    <p>Name:<br /><br />    <input type="text" name="name" value="" size="18" maxlength="150" /><br /><br /><br />   <br />E-Mail:<br /><br />    <input type="text" name="email" value="" size="18" maxlength="150" /><br /><br /><br />    <br />Homepage: <br /><br />    <input type="text" name="url" value="" size="18" maxlength="150" /><br /><br /><br />    <br />Eintrag:<br /><br />    <textarea name="eintrag" rows="10" cols="50"></textarea><br /><br />    <!-- input ok, wird benutzt zum überprüfen ob das formular wirklich gesendet wurde --><br />    <input type="hidden" name="ok" value="send" />  <br /><br />    <input type="Submit" name="send" value="speichern" /><br />    </form><br /><br />       </p>;<br />    <span class="syntaxdefault"><?php<br /><br /> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'localhost'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'root'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'timtim'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'test'</span><span class="syntaxkeyword">);<br /><br /><br /></span><span class="syntaxdefault"> $db_link </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">@</span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_BENUTZER</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault"> $db_link</span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// hier sollte dann später dem Programmierer eine<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// E-Mail mit dem Problem zukommen gelassen werden<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// die Fehlermeldung für den Programmierer sollte<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">// das Problem ausgeben mit: mysql_error()<br /></span><span class="syntaxdefault">    die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'keine Verbindung zur Zeit möglich - später probieren '</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}<br /><br /><br /></span><span class="syntaxdefault"> $db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_DATENBANK</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /><br />/**<br /> * Der geänderte teil alles was mit dem 'Senden' der daten zu tun hat,<br /> *         Kommt in die if hinein. Damit es nur ausgeführt wird, wenn das Formular<br /> *         gesendet wurde.<br /> */<br /><br />// HIER WIRD GEPRÜFT OB DAS FORMULAR GESENDET WURDE<br /></span><span class="syntaxdefault">if </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'ok'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> </span><span class="syntaxstring">"send"</span><span class="syntaxkeyword">)<br /><br />{<br /><br /><br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// mysql_real_escape_string maskiert gefährliche zeichen<br /></span><span class="syntaxdefault">     $name </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     $email </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"email"</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     $url </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"url"</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     $eintrag </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">]);<br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// mit strip_tags werden z.B html code entfernt.<br /></span><span class="syntaxdefault">     $eintrag </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> strip_tags</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$eintrag</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">     </span><span class="syntaxcomment">// ÜBERPRÜFUNG OB ALLE FELDER AUGEFÜLLT WURDEN<br /></span><span class="syntaxkeyword">if(</span><span class="syntaxdefault">$name </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> AND $email </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> AND $url </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxdefault"> AND $eintrag </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxkeyword">){<br /><br /><br /></span><span class="syntaxdefault">         </span><span class="syntaxcomment">// Die Insert SQL erstmal in die if abfrage packen.<br /></span><span class="syntaxdefault">        $sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" INSERT INTO gaestebuch "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" SET "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" name   ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $name </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" email  ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $email </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" url    ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $url </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" datum  ='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> date</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Y-m-d H:i:s"</span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">         $sql </span><span class="syntaxkeyword">.=</span><span class="syntaxdefault"> </span><span class="syntaxstring">" eintrag='"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> $eintrag </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> </span><span class="syntaxstring">"' "</span><span class="syntaxkeyword">;<br /><br /><br /></span><span class="syntaxdefault">         </span><span class="syntaxcomment">// AUCH DEN QUERY IN DIE IF PACKEN<br /></span><span class="syntaxdefault">        </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">        $db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">         if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault">        </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault">             die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /><br /></span><span class="syntaxdefault">             </span><span class="syntaxkeyword">}else{</span><span class="syntaxdefault"> </span><span class="syntaxcomment">// HIER DIE ELSE. FALLS DER QUERY ERFOLGREICH WAR WIRD DAS AUSGEGEBEN<br /><br /></span><span class="syntaxdefault">             echo </span><span class="syntaxstring">"<h2 style=\"color: #00ff00;\">Eintrag erfolgreich Gespeichert</h2>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">             echo </span><span class="syntaxstring">'<p><a href="gaestebuch.php">Gästebuch anzeigen</a></p>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">                  exit</span><span class="syntaxkeyword">();<br /></span><span class="syntaxdefault">             </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault">         </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">/**<br />     * ende der if für das eintragen<br />     */<br /></span><span class="syntaxdefault">     else</span><span class="syntaxkeyword">{<br /><br /></span><span class="syntaxdefault">         echo </span><span class="syntaxstring">"<p style=\"color: #ff0000;\">Sie haben nicht alle Felder ausgef&uuml;llt. Daher konnte der eintrag nicht<br />        gespeichert werden.</p>"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">         </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}</span><span class="syntaxdefault"> </span><span class="syntaxcomment">//ENDE DER IF<br /><br />/**<br /> */<br /><br /><br /><br /><br />/**<br /> * Hier die Mysql abfrage für die eingetragenen daten<br /> */<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"<br />        SELECT<br />            *<br />        FROM gaestebuch<br />        ORDER BY id DESC<br />    "</span><span class="syntaxkeyword">;</span><span class="syntaxdefault"> </span><span class="syntaxcomment">//IDS von GROß NACH KLEIN SORTIEREN<br /><br /><br /><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> if </span><span class="syntaxkeyword">(!</span><span class="syntaxdefault"> $db_erg</span><span class="syntaxkeyword">)<br />{<br /></span><span class="syntaxdefault">     die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}<br /></span><span class="syntaxcomment">/**<br /> * Hier der bereich der ausge des GB<br /> */<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// anzahl<br /></span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<p>Anzahl der Gästebuch-Einträge: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /><br /><br /><br /></span><span class="syntaxcomment">// While schleife der einträge<br /><br /><br /></span><span class="syntaxdefault">while </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> MYSQL_ASSOC</span><span class="syntaxkeyword">))<br /><br />{<br /></span><span class="syntaxdefault">    </span><span class="syntaxcomment">//id name email eintrag datum url<br /></span><span class="syntaxdefault">       </span><span class="syntaxcomment">//hier stehen die <div> boxen, die üben durch den CSS code definiert werden.<br /></span><span class="syntaxdefault">    echo</span><span class="syntaxstring">"  <div class=\"GBwrapper\">  "</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">        echo </span><span class="syntaxstring">"<div class=\"GBhead\">"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">            echo </span><span class="syntaxstring">"<h3>Nr: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"id"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">" | Autor: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">"</h3>"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">       echo </span><span class="syntaxstring">"</div>"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">       echo </span><span class="syntaxstring">"<div class=\"GBbody\">"</span><span class="syntaxdefault"> <br /></span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">              echo </span><span class="syntaxstring">"<b>G&auml;stebuch eintrag:</b><p>Vom: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"datum"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">"</p><br />              <br /><br />              <p>"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"eintrag"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">"</p>"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">       echo </span><span class="syntaxstring">" </div>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">     <br />       echo </span><span class="syntaxstring">" <div class=\"GBfood\">"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault">           <br />       echo </span><span class="syntaxstring">"Homepage: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"url"</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">            </span><span class="syntaxcomment">//EMAIL rauslassen, sollte nciht angezeigt werden<br /></span><span class="syntaxdefault">       echo </span><span class="syntaxstring">"</div>"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> echo  </span><span class="syntaxstring">"</div>"</span><span class="syntaxkeyword">;<br /><br /><br /><br /><br /><br /></span><span class="syntaxdefault">     </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// Ende der Whileschlife<br /></span><span class="syntaxdefault">?></span>  </div><br /><br /><br /></span>

<span class="syntaxhtml"><br />  <!--<br />  Habe CSS code hinzugefügt. Und unten div boxen.<br />  Und habe dein Formular leicht überarbeitet.<br /><br /><br />   --><br /><br />  <style type="text/css"><br /><br />    #site{<br />    width: 600px;<br />       margin: auto;<br />       text-align: center;<br />    }<br />      .GBwrapper{<br />        margin: auto;<br />        border: thin solid;<br />        padding: 5px;<br />        text-align: left;<br /><br />      }<br /><br />      .GBhead{<br />        background-color: #000000;<br />        color: #FFFFFF;<br />        text-align: left;<br /><br />      }<br /><br />      .GBbody{<br />        font-size: medium;<br />        text-align: left;<br />      }<br /><br />      .GBfoot{<br />        border-top: solid thin;<br />        text-align: left;<br />      }<br />    </style><br /><br />     <div id="site"><br />     <h2>G&auml;stebuch</h2><br />    <form name="" action="<span class="syntaxdefault"><?php </span><span class="syntaxkeyword">echo </span><span class="syntaxdefault">$_localhost</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'PHP_SELF'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault">?></span>"<br />     method="POST" enctype="text/html"><br />    <p>Name:<br /><br />    <input type="text" name="name" value="" size="18" maxlength="150" /><br /><br /><br />   <br />E-Mail:<br /><br />    <input type="text" name="email" value="" size="18" maxlength="150" /><br /><br /><br />    <br />Homepage: <br /><br />    <input type="text" name="url" value="" size="18" maxlength="150" /><br /><br /><br />    <br />Eintrag:<br /><br />    <textarea name="eintrag" rows="10" cols="50"></textarea><br /><br />    <!-- input ok, wird benutzt zum überprüfen ob das formular wirklich gesendet wurde --><br />    <input type="hidden" name="ok" value="send" />  <br /><br />    <input type="Submit" name="send" value="speichern" /><br />    </form><br /><br />       </p><br />    <span class="syntaxdefault"><?php<br /><br /> define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">, </span><span class="syntaxstring">'localhost'</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxdefault">define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">, </span><span class="syntaxstring">'root'</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxdefault">define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">, </span><span class="syntaxstring">'timtim'</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxdefault">define </span><span class="syntaxkeyword">(</span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">, </span><span class="syntaxstring">'test'</span><span class="syntaxkeyword">);<br /><br /><br /> </span><span class="syntaxdefault">$db_link </span><span class="syntaxkeyword">= @</span><span class="syntaxdefault">mysql_connect </span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_HOST</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_BENUTZER</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_KENNWORT</span><span class="syntaxkeyword">);<br /><br /> if (! </span><span class="syntaxdefault">$db_link</span><span class="syntaxkeyword">)<br />{<br />     </span><span class="syntaxcomment">// hier sollte dann später dem Programmierer eine<br />    // E-Mail mit dem Problem zukommen gelassen werden<br />    // die Fehlermeldung für den Programmierer sollte<br />    // das Problem ausgeben mit: mysql_error()<br />    </span><span class="syntaxkeyword">die(</span><span class="syntaxstring">'keine Verbindung zur Zeit möglich - später probieren '</span><span class="syntaxkeyword">);<br />     }<br /><br /><br /> </span><span class="syntaxdefault">$db_sel </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">MYSQL_DATENBANK</span><span class="syntaxkeyword">)<br /> or die(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxcomment">// SQL-Befehl für den Zugriff<br /><br />/**<br /> * Der geänderte teil alles was mit dem 'Senden' der daten zu tun hat,<br /> *         Kommt in die if hinein. Damit es nur ausgeführt wird, wenn das Formular<br /> *         gesendet wurde.<br /> */<br /><br />// HIER WIRD GEPRÜFT OB DAS FORMULAR GESENDET WURDE<br /></span><span class="syntaxkeyword">if (</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'ok'</span><span class="syntaxkeyword">] == </span><span class="syntaxstring">"send"</span><span class="syntaxkeyword">)<br /><br />{<br /><br /><br />     </span><span class="syntaxcomment">// mysql_real_escape_string maskiert gefährliche zeichen<br />     </span><span class="syntaxdefault">$name </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">]);<br />     </span><span class="syntaxdefault">$email </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"email"</span><span class="syntaxkeyword">]);<br />     </span><span class="syntaxdefault">$url </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"url"</span><span class="syntaxkeyword">]);<br />     </span><span class="syntaxdefault">$eintrag </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_real_escape_string</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">]);<br />     </span><span class="syntaxcomment">// mit strip_tags werden z.B html code entfernt.<br />     </span><span class="syntaxdefault">$eintrag </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">strip_tags</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$eintrag</span><span class="syntaxkeyword">);<br />     </span><span class="syntaxcomment">// ÜBERPRÜFUNG OB ALLE FELDER AUGEFÜLLT WURDEN<br /><br />     //Hab noch was wichtiges vergessen.... die länge der eingetragenen daten zu prüfen.<br />                    //immer erst prüfung ob nicht größer als. Und dann nicht kleiner als.<br /><br />     </span><span class="syntaxkeyword">if(</span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$name</span><span class="syntaxkeyword">) < </span><span class="syntaxdefault">25 </span><span class="syntaxkeyword">AND </span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$name</span><span class="syntaxkeyword">) > </span><span class="syntaxdefault">2 </span><span class="syntaxkeyword">){<br />         if(</span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$email</span><span class="syntaxkeyword">) < </span><span class="syntaxdefault">64 </span><span class="syntaxkeyword">AND </span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$email</span><span class="syntaxkeyword">) > </span><span class="syntaxdefault">2</span><span class="syntaxkeyword">){<br />            if(</span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$url</span><span class="syntaxkeyword">) < </span><span class="syntaxdefault">64 </span><span class="syntaxkeyword">AND </span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$url</span><span class="syntaxkeyword">) >= </span><span class="syntaxdefault">0</span><span class="syntaxkeyword">){<br />              if(</span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$eintrag</span><span class="syntaxkeyword">) < </span><span class="syntaxdefault">500 </span><span class="syntaxkeyword">AND </span><span class="syntaxdefault">strlen</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$eintrag</span><span class="syntaxkeyword">) > </span><span class="syntaxdefault">2</span><span class="syntaxkeyword">){<br />                  </span><span class="syntaxcomment">//alle längen ok dann<br />                  </span><span class="syntaxdefault">$check </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">true</span><span class="syntaxkeyword">;<br />                }else{<br />                    </span><span class="syntaxdefault">$check </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">false</span><span class="syntaxkeyword">;<br />                    echo </span><span class="syntaxstring">"Der eingegebne text muss min: 3 - max: 500 zeichen gro&szlig; sein"</span><span class="syntaxkeyword">;<br />                }<br />             }else{<br />                 </span><span class="syntaxdefault">$check </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">false</span><span class="syntaxkeyword">;<br />                 echo </span><span class="syntaxstring">"Die angegebne url ist zu lang"</span><span class="syntaxkeyword">;<br />             }<br />         }else{<br />                echo </span><span class="syntaxstring">"Die Email muss zwischen 3 und 63 zeichen lang sein"</span><span class="syntaxkeyword">;<br />             </span><span class="syntaxdefault">$check </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">false</span><span class="syntaxkeyword">;<br />         }<br />     }else{<br />            echo </span><span class="syntaxstring">"Der name muss zwischen 3 und 24 Zeichen lang sein"</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$check </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">false</span><span class="syntaxkeyword">;<br />     }<br /><br />     </span><span class="syntaxcomment">//Ende der obigen prüfung. Wenn nun die variablen nicht die gewünschten inhalte haben.<br />     //bzw, die länge. Wird der speichervorgang abgebrochen.<br />     //Grausames skript =D.<br /></span><span class="syntaxkeyword">if( </span><span class="syntaxdefault">$check </span><span class="syntaxkeyword">== </span><span class="syntaxdefault">true</span><span class="syntaxkeyword">){<br /><br /><br />         </span><span class="syntaxcomment">// Die Insert SQL erstmal in die if abfrage packen.<br />        </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">= </span><span class="syntaxstring">" INSERT INTO gaestebuch "</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.= </span><span class="syntaxstring">" SET "</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.= </span><span class="syntaxstring">" name   ='" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$name </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.= </span><span class="syntaxstring">" email  ='" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$email </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.= </span><span class="syntaxstring">" url    ='" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$url </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.= </span><span class="syntaxstring">" datum  ='" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">date</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Y-m-d H:i:s"</span><span class="syntaxkeyword">) . </span><span class="syntaxstring">"', "</span><span class="syntaxkeyword">;<br />         </span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">.= </span><span class="syntaxstring">" eintrag='" </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">$eintrag </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"' "</span><span class="syntaxkeyword">;<br /><br /><br />         </span><span class="syntaxcomment">// AUCH DEN QUERY IN DIE IF PACKEN<br />        // ausführen des mysql-Befehls<br />        </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br />         if (! </span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">)<br />        {<br />             die(</span><span class="syntaxstring">'Ungültige Abfrage: ' </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">mysql_error</span><span class="syntaxkeyword">());<br /><br />             }else{ </span><span class="syntaxcomment">// HIER DIE ELSE. FALLS DER QUERY ERFOLGREICH WAR WIRD DAS AUSGEGEBEN<br /><br />             </span><span class="syntaxkeyword">echo </span><span class="syntaxstring">"<h2 style=\"color: #00ff00;\">Eintrag erfolgreich Gespeichert</h2>"</span><span class="syntaxkeyword">;<br />             echo </span><span class="syntaxstring">'<p><a href="gaestebuch.php">Gästebuch anzeigen</a></p>'</span><span class="syntaxkeyword">;<br />                  exit();<br />             }<br /><br />         }<br />    </span><span class="syntaxcomment">/**<br />     * ende der if für das eintragen<br />     */<br />     </span><span class="syntaxkeyword">else{<br /><br />         echo </span><span class="syntaxstring">"<p style=\"color: #ff0000;\">Sie haben nicht alle Felder korrekt ausgef&uuml;llt. Daher konnte der eintrag nicht<br />        gespeichert werden.</p>"</span><span class="syntaxkeyword">;<br /><br />         }<br />     } </span><span class="syntaxcomment">//ENDE DER IF<br /><br />/**<br /> */<br /><br /><br /><br /><br />/**<br /> * Hier die Mysql abfrage für die eingetragenen daten<br /> */<br /> // SQL-Befehl für den Zugriff<br /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">= </span><span class="syntaxstring">"<br />        SELECT<br />            *<br />        FROM gaestebuch<br />        ORDER BY id DESC<br />    "</span><span class="syntaxkeyword">; </span><span class="syntaxcomment">//IDS von GROß NACH KLEIN SORTIEREN<br /><br /><br /><br /><br /> // ausführen des mysql-Befehls<br /></span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$sql</span><span class="syntaxkeyword">);<br /> if (! </span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">)<br />{<br />     die(</span><span class="syntaxstring">'Ungültige Abfrage: ' </span><span class="syntaxkeyword">. </span><span class="syntaxdefault">mysql_error</span><span class="syntaxkeyword">());<br />     }<br /></span><span class="syntaxcomment">/**<br /> * Hier der bereich der ausge des GB<br /> */<br /> // anzahl<br /></span><span class="syntaxdefault">$anzahl_eintraege </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">);<br /> echo </span><span class="syntaxstring">"<p>Anzahl der Gästebuch-Einträge: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /><br /><br /><br /></span><span class="syntaxcomment">// While schleife der einträge<br /><br /><br /></span><span class="syntaxkeyword">while (</span><span class="syntaxdefault">$daten </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_fetch_array</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$db_erg</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">MYSQL_ASSOC</span><span class="syntaxkeyword">))<br /><br />{<br />    </span><span class="syntaxcomment">//id name email eintrag datum url<br />       //hier stehen die <div> boxen, die üben durch den CSS code definiert werden.<br />    </span><span class="syntaxkeyword">echo</span><span class="syntaxstring">"  <div class=\"GBwrapper\">  "</span><span class="syntaxkeyword">;<br /><br />        echo </span><span class="syntaxstring">"<div class=\"GBhead\">"</span><span class="syntaxkeyword">;<br />         echo </span><span class="syntaxstring">"<h3>Nr: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"id"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">" | Autor: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">"</h3>"</span><span class="syntaxkeyword">;<br />        echo </span><span class="syntaxstring">"</div>"</span><span class="syntaxkeyword">;<br />       echo </span><span class="syntaxstring">"<div class=\"GBbody\">" </span><span class="syntaxkeyword">;<br />            echo </span><span class="syntaxstring">"<b>G&auml;stebuch eintrag:</b><p>Vom: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"datum"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">"</p><br />             <br /><br />              <p>"</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"eintrag"</span><span class="syntaxkeyword">].</span><span class="syntaxstring">"</p>"</span><span class="syntaxkeyword">;<br />       echo </span><span class="syntaxstring">" </div>"</span><span class="syntaxkeyword">;<br />       echo </span><span class="syntaxstring">" <div class=\"GBfood\">"</span><span class="syntaxkeyword">;<br />            echo </span><span class="syntaxstring">"Homepage: "</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">"url"</span><span class="syntaxkeyword">];<br />            </span><span class="syntaxcomment">//EMAIL rauslassen, sollte nciht angezeigt werden<br />        </span><span class="syntaxkeyword">echo </span><span class="syntaxstring">"</div>"</span><span class="syntaxkeyword">;<br /><br /> echo  </span><span class="syntaxstring">"</div>"</span><span class="syntaxkeyword">;<br /><br /><br /><br /><br /><br />     }<br /><br /> </span><span class="syntaxcomment">// Ende der Whileschlife<br /></span><span class="syntaxdefault">?></span>  </div><br /><br /></span>