hallo mal wieder
bis hier hat alles geklappt, wenn ich nun daten in die maske eingeben will und auf speichern gehe
kommt diese fehlermeldung
Ungültige Abfrage: Unknown column 'datum' in 'field list'
danke für eure hilfe
vg
speedy
Beiträge von Speedy00123
-
-
allo tim tim,
vielen dank für deine hilfe
habe es gerade mal getestet, es klappt :=) . sieht wohl noch ein wenig konfuss aus das stimmt, nun arbeite ich am layout,
und weiter in php , aber hier bin ich fast verzweifelt, da hatte ich wirklich mal hilfe gebraucht
Ist es möglich das man auch alles mit farben und rahmen, wie man es von gästebüchern kennt, mit php zu machen
oder braucht man dort dann html ??
vg
speedy
-
hallo tim tim,
danke dir, so werde ich es heute abend mal zu hause versuchen, aber ich denke so ein profi
wie du macht alles richtig, hast ja schon viel im forum geschrieben und leute geholfen
werde dann wieder posten, wenn ich alles dann auch bei der tabelle in mysql richtig angelegt habe ( ich hoffe ;=) )
sollte auch alles klappen. so kann ich frohen mutes auf der arbeit mein job weiter machen.
vg
speedy
-
hallo tim tim,
danke dir für deine hilfe, nun wird mir auch vieles klar, wo meine fehler sind,
es ist für mich aber noch sehr schwerr deine guten beschreibungen auch richtig um zusetzen,
was ich gut finden würde, wenn du dir das von mir eingebene
scribt von kurz raus kopieren würdest, und dann korrekgiert
wieder zurück als antwort, dann verstehe ich auch besser wo der fehler war, so kann ich 1 zu 1 sehen, und besser dazu
lernen, noch ist php neuland für mich
nochmals danke für deine hilfe
vg
speedy
-
hallo R4Zz0R,
danke dir erstmal das du mir helfen möchtest,
du hast ja lange am pc bis morgens gesessen, dann geht es mir auch immer so
man wird müde halt irgendwann
vg
speedy
-
hallo axel
ich habe es fast geschafft, nur werden bei einem eintrag nicht mehr als datum gespeichert
aber für dich bestimmt eine leichtigkeit, den fehler oder ein tipp zu geben,
viele grüße
speedy
Anzahl der Gästebuch-Einträge: 1
ID: 209
Name:
E-Mail:
URL:
Datum: 2010-07-11 20:29:58
Gästebucheintrag: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>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 /><br /><input type="Submit" name="" value="speichern" /><br /></form><br /><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">'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">'xyz' </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 /><br /><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">" 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">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">] .</span><span class="syntaxstring">"' "</span><span class="syntaxkeyword">;<br /><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 />{<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 /><br />echo </span><span class="syntaxstring">'<p><a href="gaestebuch.php">Gästebuch anzeigen</a></p>'</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 /><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 /></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 /><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 />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 /> echo </span><span class="syntaxstring">"ID: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'id'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"E-Mail: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'email'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"URL: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'url'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Datum: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Gästebucheintrag: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<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 /><br /></span><span class="syntaxdefault">?><br /></span></span> -
hallo axel,
bin ein stück weiter
so steht es unter der eingabe maske, aber das sollte doch eigentlich erst kommen wenn man das gäste buch
auf anzeigen geht
und neue einträge werden aber immer noch nicht angezeigt in der datenbank und unter da wo ID steht
aber du siehst bestimmt wo noch kleine fehler sind
ich komme aber immer mehr ans ziel dank deiner grosen hilfe
schönen sonntag noch
vg
speedy
--------------------------------------------------
Gästebuch anzeigenAnzahl der Gästebuch-Einträge: 9
ID: 7
Name: testHHHHHHHHHHHHHH
E-Mail: <!-- e --><a href="mailto:lll@ww.se">lll@ww.se</a><!-- e -->
URL: <!-- m --><a class="postlink" href="http://www.test.de">http://www.test.de</a><!-- m -->
Datum: 0000-00-00 00:00:00
Gästebucheintrag:
ID: 170
Name:
E-Mail:
URL:
Datum: 0000-00-00 00:00:00
Gästebucheintrag:
ID: 169
Name:
E-Mail:
URL:
Datum: 0000-00-00 00:00:00-----------------------------------------------------------
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">'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">'xyz' </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 /><br /><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 /> 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 /><br /><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 /><br /><br /><br /><br /><br />echo </span><span class="syntaxstring">'<p><a href="gaestebuch.php">Gästebuch anzeigen</a></p>'</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 /><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 /></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 /><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 />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 /> echo </span><span class="syntaxstring">"ID: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'id'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"E-Mail: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'email'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"URL: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'url'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Datum: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Gästebucheintrag: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<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 /><br /></span><span class="syntaxdefault">?><br /></span></span> -
hallo axel,
bin doch ein stück alleine weiter :=)
nur neue einträge werden noch nicht erkannt
wo liegt der fehler ? danke für ein weiteren tip
vg
stefan
PHP<span class="syntaxhtml"><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">]; </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">'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">'xyz' </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 /><br /><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 /> 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 /><br /><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">"<br /> SELECT<br /> *<br /> FROM gaestebuch<br /> ORDER BY datum<br />"</span><span class="syntaxkeyword">;<br /><br /><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 /><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 /></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 /></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 /></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 /></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 /><br /><br />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 /> </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 />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 /> echo </span><span class="syntaxstring">"ID: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'id'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"E-Mail: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'email'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"URL: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'url'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Datum: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Gästebucheintrag: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">?><br /></span></span> -
hallo axel
nun habe ich etwas umgestellt. erst schreiben und dann speicher,
auch array aber irgendwie funkt es noch nicht
wäre dankbar für weitere hilfe
vg
stefan
PHP<span class="syntaxhtml"><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">]; </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">'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">'' </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 /><br /><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 /> 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 /><br /><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">"<br /> SELECT<br /> *<br /> FROM gaestebuch<br /> ORDER BY datum<br />"</span><span class="syntaxkeyword">;<br /><br /><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 /><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 /></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 /></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 /> </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 />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 /> echo </span><span class="syntaxstring">"ID: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'id'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"E-Mail: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'email'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"URL: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'url'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Datum: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /> echo </span><span class="syntaxstring">"Gästebucheintrag: "</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxdefault">$daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br />}<br /></span><span class="syntaxdefault">?><br /></span></span> -
guten morgen axel,
danke für den tip, werde es gleich mal versuchen
vg
speedy
-
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> -
hallo axel,
danke für deine hilfe, nun weiss ich ja das man hier hilfe bekommt,
ist natürlich besser als wenn man das ergebnis einfach präsentiert bekommt, wenn ich es dann verstanden habe ist es um so schöner,
aber ich bin auf der zielinie
vg
speedy
-
hallo axel,
danke für deine antwort
habe hier weiter gemacht, wie weit wird hier in die datei geschrieben ???
vg
speedyPHP<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">'localhost'</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 /></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 datum<br />"</span><span class="syntaxkeyword">;<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 /></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="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> -
hallo an alle,
habe xampp installiert, und arbeite mit webocton, bin über den <!-- m --><a class="postlink" href="http://www.php-kurs.com">http://www.php-kurs.com</a><!-- m --> eingestigen
<!-- m --><a class="postlink" href="http://www.php-kurs.com/beispiel-gaestebuch-programmieren-in-php-und-mysql.htm">http://www.php-kurs.com/beispiel-gaeste ... -mysql.htm</a><!-- m --> ( hier habe die beiden dateien erstellt )
habe nun auch schon 2 dateien geschrieben, eingabeformular und verbindung zur mysql daten bank hergestellt
eingabeformular :
PHP
Alles anzeigen<form name="" action="<?php echo $_localhost['PHP_SELF']; ?>" method="POST" enctype="text/html"> <p>Ihr Name:<br /> <input type="text" name="name" value="" size="50" maxlength="150" /> </p> <p>Ihre E-Mail-Adresse:<br /> <input type="text" name="email" value="" size="50" maxlength="150" /> </p> <p>Ihre Homepage:<br /> <input type="text" name="url" value="" size="50" maxlength="150" /> </p> <p>Gästebucheintrag:<br /> <textarea name="eintrag" rows="10" cols="50"></textarea> </p> <input type="Submit" name="" value="speichern" /> </form>zugang :
PHP<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">'localhost'</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 /></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 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 /></span><span class="syntaxcomment">// Anzeige der Anzahl der Einträge<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 /></span><span class="syntaxdefault">?><br /></span>Mein problem ist wo ich nicht weiterkomme, ist wie muss es nun weitergehen, das ich in das eingabeformular die daten eingeben kann undf es in der datenbank gespeichert wird, ich meine das die einträge im gästebuch sichtbar erscheinen
nach dem ich etwas eingetragen,
ich danke euch für eure hilfe
viele grüße
speedy