Nabend, so bin fertig mit arbeiten.
Ehm.. das geht nur über HTML/CSS.
Aber du kannst mit PHP html code ausgeben.
z.B
PHP
<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ä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ü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ä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>
Ist jetzt nichts besonderers. Und müsste überarbeitet werden. Aber um zu zeigen, wie man html/css in verbindung mit PHP nutzt, ganz ok.
Da giebt man sich ja auch nicht so die mühe
EDIT:
Habe noch was eingebaut.. ne zeichengränze. Hatten bei jemandem hier im Forum schonmal das Problem, das leute zu lange texte gepostet haben.
Wie gesagt das ganze ist in recht simpler technik geschrieben. Und zum Anschauen ganz nett. Aber sehr verbesserungs würdig.
PHP
<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ä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ß 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ü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ä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>
Greetz