Danke Leute,
es hat funktioniert. Super!
Danke Leute,
es hat funktioniert. Super!
Für die Sauberkeit des Codes bin ich nicht zuständig^^
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" width="480" height="296" id="utv566703">
<param name="flashvars" value="autoplay=false&brand=embed&cid=8490592&v3=1"/>
<param name="allowfullscreen" value="true"/><param name="allowscriptaccess" value="always"/>
<param name="movie" value="http://www.ustream.tv/flash/viewer.swf"/>
<embed flashvars="autoplay=false&brand=embed&cid=8490592&v3=1" width="480" height="296" allowfullscreen="true" allowscriptaccess="always" id="utv566703" name="utv_n_554212" src="http://www.ustream.tv/flash/viewer.swf" type="application/x-shockwave-flash" />
</object>
Also das Bild wollte ich über das Bild des Videos legen. So das es ein Teil des Videos verdeckt.
Das Video binde ich über ein Script von ustream.tv ein!
Hey, ich würde gern ein Bild über ein Video setzen,
wie könnte ich das anstellen?
Alles klar, danke...hat alles funktioniert!
Nur die der aktivierten
OMG..wie dumm...ich hatte irgendwie vergessen das JavaScript einzubinden...-.- (*indennackenschlag*)
Ok...Wenn ich jetzt "admin" reinschreibe, erscheint das label, aber wenn ich jetzt admin wieder lösche,
ist das Label noch immer da...wie kann ich das ändern?
Ok, $_SERVER['SCRIPT_NAME'] wird jetzt verwendet, danke
Aber zurück zu meinem Problem...wenn ich das mit CSS "hidde" (lustig^^) dann ists ja komplett weg
und ich kann nichts mehr damit machen. Aber soll ja nur auftauchen wenn die Überprüfung den
Name "admin" hergibt....
Ich checks nicht...
<span class="syntaxdefault"><br />$qryAlleEintraege </span><span class="syntaxkeyword">= </span><span class="syntaxstring">"<br /> SELECT *<br /> FROM gaestebuch<br /> WHERE aktiviert='1'<br /> ORDER BY datum DESC LIMIT 10"</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">$qryAlleEintraege </span><span class="syntaxkeyword">);<br /><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="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 /> echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<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">// Ausgabe der Daten<br /> </span><span class="syntaxkeyword">echo </span><span class="syntaxstring">"Date: "</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">"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">"Message: <br /><br />"</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 /> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /> }<br /> </span><span class="syntaxdefault"></span>
Sieht jetzt so aus
<span class="syntaxdefault"><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 /> FROM gaestebuch<br /> WHERE aktiviert='1'<br /> ORDER BY datum DESC LIMIT 10"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> $qryAlleEintraege </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">;<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"> $qryAlleEintraege </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 /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> </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>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span>
Nur zeigt er mir jetzt alle Einträge wieder an und die auch nicht nach Datum!
Anziegen der Einträge
<span class="syntaxdefault"><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 /> echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<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">// Ausgabe der Daten<br /> </span><span class="syntaxkeyword">echo </span><span class="syntaxstring">"Date: "</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">"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">"Message: <br /><br />"</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 /> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /> }<br /><br /> </span><span class="syntaxdefault">mysql_free_result</span><span class="syntaxkeyword">( </span><span class="syntaxdefault">$db_erg </span><span class="syntaxkeyword">);<br /><br /> </span><span class="syntaxdefault">$result </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">);<br /> </span><span class="syntaxdefault">$count </span><span class="syntaxkeyword">= </span><span class="syntaxdefault">mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$result</span><span class="syntaxkeyword">);<br /> if(</span><span class="syntaxdefault">$count </span><span class="syntaxkeyword">> </span><span class="syntaxdefault">10</span><span class="syntaxkeyword">)<br /> {<br /> echo </span><span class="syntaxstring">'<a href="gaestebuch-alt.php">---Go to older posts---</a>'</span><span class="syntaxkeyword">;<br /> }<br /> </span><span class="syntaxdefault"></span>
Nein leider nicht. Noch nicht
<span class="syntaxdefault"><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 /> FROM gaestebuch<br /> WHERE aktiviert='1'<br /> ORDER BY datum DESC LIMIT 10"</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="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 /> echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /> </span><span class="syntaxdefault"></span>
Nächste Problem,
das Passwortfeld ist jetzt immer da. Wie kann ich das wegmachen, so dass es nur kommt wenn der Name überprüft wurde und z.B. admin drin steht?
Ging ja am Anfang...
Formular:
<span class="syntaxdefault"><br /></span><span class="syntaxkeyword"><</span><span class="syntaxdefault">form name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"" </span><span class="syntaxdefault">action</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_SERVER['PHP_SELF'].'"<br /> </span><span class="syntaxdefault">method</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"POST" </span><span class="syntaxdefault">enctype</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text/html"</span><span class="syntaxkeyword">><br /> <</span><span class="syntaxdefault">label </span><span class="syntaxkeyword">for=</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Your Name</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">name</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"name" </span><span class="syntaxdefault">id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"name" </span><span class="syntaxdefault">onblur</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"checkName();" </span><span class="syntaxdefault">value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_POST['name'].'" </span><span class="syntaxdefault">size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50" </span><span class="syntaxdefault">maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"150" </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /> <</span><span class="syntaxdefault">div id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"admin" </span><span class="syntaxkeyword">class=</span><span class="syntaxstring">"hidden"</span><span class="syntaxkeyword">><br /> <</span><span class="syntaxdefault">label </span><span class="syntaxkeyword">for=</span><span class="syntaxstring">"password"</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Password</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">password</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/> </</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /> <</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"password" </span><span class="syntaxdefault">id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"password" </span><span class="syntaxdefault">value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_POST['password'].'"</span><span class="syntaxkeyword">><br /> </</span><span class="syntaxdefault">div</span><span class="syntaxkeyword">><br /><br /> <</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Your E</span><span class="syntaxkeyword">-</span><span class="syntaxdefault">Mail</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">email</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"email" </span><span class="syntaxdefault">value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_POST['email'].'" </span><span class="syntaxdefault">size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50" </span><span class="syntaxdefault">maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"150" </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /> <</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Your Homepage</span><span class="syntaxkeyword">:<</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"url" </span><span class="syntaxdefault">value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"" </span><span class="syntaxdefault">size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50" </span><span class="syntaxdefault">maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"150" </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /> <</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Message</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">eintrag</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">textarea name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"eintrag" </span><span class="syntaxdefault">rows</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"10" </span><span class="syntaxdefault">cols</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50"</span><span class="syntaxkeyword">></span><span class="syntaxstring">'.$_POST['</span><span class="syntaxdefault">eintrag</span><span class="syntaxstring">'].'</span><span class="syntaxkeyword"></</span><span class="syntaxdefault">textarea</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /> <</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"reset" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"reset" </span><span class="syntaxdefault">value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"Reset" </span><span class="syntaxdefault">onclick</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"return confirm(\'Reset this form?\')" </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> </span><span class="syntaxdefault">Please type the following code</span><span class="syntaxkeyword">: <</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">img src</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"captcha.php" </span><span class="syntaxdefault">id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"code" </span><span class="syntaxdefault">border</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"0" </span><span class="syntaxdefault">title</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"Code"</span><span class="syntaxkeyword">/><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">code</span><span class="syntaxstring">']).' </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /> <</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"code" </span><span class="syntaxdefault">size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"20" </span><span class="syntaxdefault">maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"5"</span><span class="syntaxkeyword">/><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /> <</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"submit" </span><span class="syntaxdefault">name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"action" </span><span class="syntaxdefault">value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"Send" </span><span class="syntaxkeyword">/><br /> </</span><span class="syntaxdefault">form</span><span class="syntaxkeyword">>'</span><span class="syntaxdefault">;<br /></span>
Richtig, die Anzahl wird nur auf der Seite angegeben, auf der die neuesten Einträge sind
<!-- w --><a class="postlink" href="http://www.riensartwork.de/gaestebuch.php">http://www.riensartwork.de/gaestebuch.php</a><!-- w -->
Genau, alles was vor den letzten 10 war soll auf die nächste Seite
Das mit dem LIMIT 10 bei meinen älteren, führt zu einem Syntac Error
Ungültige Abfrage: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OFFSET 10' at line 4
Das Problem ist, wenn ich das LIMIT 10 weg mache, werden alle Einträge auf einer Seite angezeigt, dass will ich nicht.
Ich will das max. 10 EInträge angezeigt werden und der Rest auf einer 2. Seite...sieht man ja.
Moin Leute,
folgendes Problem. Die Anzahl meiner Gästebucheinträge steht bei 11, obwohl es mehr sind. Woran kanns liegen?
Gästebuch.php
<span class="syntaxhtml"><br /><span class="syntaxdefault"><?php<br /><br /> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</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 /><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 /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<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">'No connection this time - try later'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> $db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> MYSQL_DATENBANK </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> </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 /> FROM gaestebuch<br /> WHERE aktiviert='1'<br /> ORDER BY datum DESC LIMIT 10 "</span><span class="syntaxkeyword">;<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"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> </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">)+</span><span class="syntaxdefault">1</span><span class="syntaxkeyword">;</span><span class="syntaxdefault"> </span><span class="syntaxcomment">//Hier wird die Anzahl berechnet<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<p>Number of guestbook entries: $anzahl_eintraege </p>"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<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 /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// Ausgabe der Daten<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Message: <br /><br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> $result </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_query</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"SELECT * FROM gaestebuch"</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> $count </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_num_rows</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$result</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$count </span><span class="syntaxkeyword">></span><span class="syntaxdefault"> 10</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">'<a href="gaestebuch-alt.php">---Go to older posts---</a>'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> ?><br /></span></span>
Ich habe aber noch eine Gästebuchseite mit älteren Beiträgen
<span class="syntaxhtml"><br /> <span class="syntaxdefault"><?php<br /><br /> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_HOST'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_BENUTZER'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_KENNWORT'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> define </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxstring">'MYSQL_DATENBANK'</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> </span><span class="syntaxstring">'+++'</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 /><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 /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<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">'No connection this time - try later'</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> $db_sel </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> mysql_select_db</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> MYSQL_DATENBANK </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> or die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">"Auswahl der Datenbank fehlgeschlagen"</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> </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 /> FROM gaestebuch<br /> WHERE aktiviert='1'<br /> ORDER BY datum DESC LIMIT 10 OFFSET 10"</span><span class="syntaxkeyword">;<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"> </span><span class="syntaxkeyword">!</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> die</span><span class="syntaxkeyword">(</span><span class="syntaxstring">'Ungültige Abfrage: '</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">.</span><span class="syntaxdefault"> mysql_error</span><span class="syntaxkeyword">());<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<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 /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> </span><span class="syntaxcomment">// Ausgabe der Daten<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Date: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'datum'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Name: "</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"Message: <br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo $daten</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<hr />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">"<br />"</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /><br /></span><span class="syntaxdefault"> mysql_free_result</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> $db_erg </span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault"> ?><br /></span></span>
Es gibt keine bescheuerten Fragen, nur bescheuerte Antworten
Ich sehe keinen Fehler in der mail()
Der letzte Parameter?
So?
<span class="syntaxdefault"><br /></span><span class="syntaxkeyword">...<br /></span><span class="syntaxdefault">mail</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$empfaenger</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">$betreff</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">$nachricht</span><span class="syntaxkeyword">, </span><span class="syntaxdefault">$mailtext</span><span class="syntaxkeyword">);<br /></span><span class="syntaxdefault">$header </span><span class="syntaxkeyword">= </span><span class="syntaxstring">'From: webmaster@example.com' </span><span class="syntaxkeyword">. </span><span class="syntaxstring">"\r\n"</span><span class="syntaxkeyword">; <br />...<br /> </span><span class="syntaxdefault"></span>
EDIT: Nach rumprobieren hats geklappt!
Ich hab versucht, das Javascript einzubinden. Also den onblur() Effekt
Um zu testen ob sich überhaupt ein Label öffnet. Das hat geklappt....
Fehlerüberprüfung:
<span class="syntaxdefault"><br /></span><span class="syntaxkeyword">if(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">""</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> if</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">==</span><span class="syntaxdefault"> </span><span class="syntaxstring">"admin"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">&&</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'password'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">!=</span><span class="syntaxdefault"> </span><span class="syntaxstring">"rien"</span><span class="syntaxkeyword">)<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $errors</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">'Wrong password for admin!'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> else<br /> </span><span class="syntaxkeyword">{<br /></span><span class="syntaxdefault"> $errors</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'name'</span><span class="syntaxkeyword">]</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">'Name is not allowed to be empty!'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword">}<br /></span><span class="syntaxdefault"> </span>
Formular
<span class="syntaxdefault"><br /></span><span class="syntaxkeyword"><</span><span class="syntaxdefault">form name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">""</span><span class="syntaxdefault"> action</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_SERVER['PHP_SELF'].'"<br /></span><span class="syntaxdefault"> method</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"POST"</span><span class="syntaxdefault"> enctype</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text/html"</span><span class="syntaxkeyword">><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">label for</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"name"</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Your Name</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">name</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"name"</span><span class="syntaxdefault"> id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"name"</span><span class="syntaxdefault"> onblur</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"checkName();"</span><span class="syntaxdefault"> value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_POST['name'].'"</span><span class="syntaxdefault"> size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50"</span><span class="syntaxdefault"> maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"150"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">div id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"admin"</span><span class="syntaxdefault"> class</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"hidden"</span><span class="syntaxkeyword">><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">label for</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"password"</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Password</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">password</span><span class="syntaxstring">']).'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword"></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"password"</span><span class="syntaxdefault"> id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"password"</span><span class="syntaxdefault"> value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_POST['password'].'"</span><span class="syntaxkeyword">><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"></</span><span class="syntaxdefault">div</span><span class="syntaxkeyword">><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Your E</span><span class="syntaxkeyword">-</span><span class="syntaxdefault">Mail</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">email</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"email"</span><span class="syntaxdefault"> value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"'.$_POST['email'].'"</span><span class="syntaxdefault"> size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50"</span><span class="syntaxdefault"> maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"150"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Your Homepage</span><span class="syntaxkeyword">:<</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"url"</span><span class="syntaxdefault"> value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">""</span><span class="syntaxdefault"> size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50"</span><span class="syntaxdefault"> maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"150"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxdefault">Message</span><span class="syntaxkeyword">:</span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">eintrag</span><span class="syntaxstring">']).'</span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">><</span><span class="syntaxdefault">textarea name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"eintrag"</span><span class="syntaxdefault"> rows</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"10"</span><span class="syntaxdefault"> cols</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"50"</span><span class="syntaxkeyword">></span><span class="syntaxstring">'.$_POST['</span><span class="syntaxdefault">eintrag</span><span class="syntaxstring">'].'</span><span class="syntaxkeyword"></</span><span class="syntaxdefault">textarea</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">p</span><span class="syntaxkeyword">></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"reset"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"reset"</span><span class="syntaxdefault"> value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"Reset"</span><span class="syntaxdefault"> onclick</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"return confirm(\'Reset this form?\')"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> Please type the following code</span><span class="syntaxkeyword">:</span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">img src</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"captcha.php"</span><span class="syntaxdefault"> id</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"code"</span><span class="syntaxdefault"> border</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"0"</span><span class="syntaxdefault"> title</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"Code"</span><span class="syntaxkeyword">/><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">></span><span class="syntaxstring">'.getError($errors['</span><span class="syntaxdefault">code</span><span class="syntaxstring">']).'</span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"text"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"code"</span><span class="syntaxdefault"> size</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"20"</span><span class="syntaxdefault"> maxlength</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"5"</span><span class="syntaxkeyword">/><</span><span class="syntaxdefault">br </span><span class="syntaxkeyword">/></</span><span class="syntaxdefault">label</span><span class="syntaxkeyword">><br /><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"><</span><span class="syntaxdefault">input type</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"submit"</span><span class="syntaxdefault"> name</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"action"</span><span class="syntaxdefault"> value</span><span class="syntaxkeyword">=</span><span class="syntaxstring">"Send"</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">/><br /></span><span class="syntaxdefault"> </span><span class="syntaxkeyword"></</span><span class="syntaxdefault">form</span><span class="syntaxkeyword">>'</span><span class="syntaxdefault">;<br /></span>
Kann ich da noch was verbessern?
EDIT2:
Ich will das im Anschluss in der Mail die ich bekomme, der Text und der Name drin steht, wie geht das?
<span class="syntaxdefault"><br />$empfaenger </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">'info@riensartwork.de'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> $betreff </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">'Guestbook'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> $nachricht </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> </span><span class="syntaxstring">' Freigeben: '</span><span class="syntaxkeyword">.</span><span class="syntaxstring">' http://riensartwork.de/gaestebuch-freischalten.php?id='</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">mysql_insert_id</span><span class="syntaxkeyword">().</span><span class="syntaxdefault"> </span><span class="syntaxstring">'<br /> oder<br /> Loeschen: '</span><span class="syntaxkeyword">.</span><span class="syntaxstring">' http://riensartwork.de/gaestebuch-loeschen.php?id='</span><span class="syntaxkeyword">.</span><span class="syntaxdefault">mysql_insert_id</span><span class="syntaxkeyword">();<br /></span><span class="syntaxdefault"> <br /> $mailtext </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> $_POST</span><span class="syntaxkeyword">[</span><span class="syntaxstring">'eintrag'</span><span class="syntaxkeyword">];</span><span class="syntaxdefault"> </span><span class="syntaxcomment">//Hier soll der Name und der Text hin<br /><br /></span><span class="syntaxdefault"> mail</span><span class="syntaxkeyword">(</span><span class="syntaxdefault">$empfaenger</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> $betreff</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> $nachricht</span><span class="syntaxkeyword">,</span><span class="syntaxdefault"> $mailtext</span><span class="syntaxkeyword">);<br /><br /></span><span class="syntaxdefault"> echo </span><span class="syntaxstring">'<h5>Thank you for your comment</h5><meta http-equiv="refresh" content="3; URL=test.php" />'</span><span class="syntaxkeyword">;<br /></span><span class="syntaxdefault"> </span>
Hmm..also ich bekommst beim besten Willen nicht hin...
HTML-Seminar.de - mit Videos zum schnellen Lernen, wie man eine Website selbst erstellt.