hallo an alle,
habe die letzten tage schon wieder dazu gelernt, aber es klappt noch nicht richtig
daten satz wird in mysql neu angelegt, aber ohne einträge
bei speichern wird nur dies Anzahl der Gästebuch-Einträge: 11 angezeigt,
wo sind meine fehler, könnt ihr mir hier etwas schreiben das es dann klappt,
mein urlaub geht zu ende und ich wollte es doch noch fertig bekommen
danke für eure hilfe
schönes wochenende
gruss speedy
PHP
<span class="syntaxhtml"><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">]; </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="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">, </span><span class="syntaxstring">'' </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">'' </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">'' </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">'homepageanwendungen' </span><span class="syntaxkeyword">);<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 />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 /></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 /></span><span class="syntaxdefault">$sql </span><span class="syntaxkeyword">= </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 />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 />if ( </span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">] != </span><span class="syntaxstring">"" </span><span class="syntaxkeyword">)<br />{<br /> echo </span><span class="syntaxstring">"<h2>Eintrag speichern</h2>"</span><span class="syntaxkeyword">;<br /> </span><span class="syntaxcomment">// hier kommt nun der entsprechende PHP-Code<br /> </span><span class="syntaxkeyword">exit;<br />}<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">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'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">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'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">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'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">" 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="syntaxstring">"' "</span><span class="syntaxkeyword">;<br /><br />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 />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 />echo </span><span class="syntaxstring">'<p><a href="gaestebuch.php">Gästebuch anzeigen</a></p>'</span><span class="syntaxkeyword">;<br />exit;<br />{<br /> </span><span class="syntaxcomment">// Aushabe der Daten<br /> </span><span class="syntaxkeyword">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 /> echo </span><span class="syntaxstring">"</pre>"</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">?><br /></span></span>