Auf Thema antworten 2026

Beitrag

<blockquote data-quote="Lukiiii" data-source="post: 870866" data-attributes="member: 272323">AW: Probleme mit der DatenbankIch habe es mal ein bisschen verändert. Kannst du mal probieren, ob es funktionier!&lt;?phpif ( isset($_GET[&#039;Vorname&#039;]) and isset ($_GET[&#039;Nachname&#039;]) and isset ($_GET[&#039;Email&#039;]) and isset ($_GET[&#039;Telefon&#039;]) and isset ($_GET[&#039;Gedichttitel&#039;]) and isset ($_GET[&#039;Gedicht&#039;]) ){require(&quot;inc/datenbank_kontakt.php&quot;);$vname=$_GET[&#039;Vorname&#039;];$nname=$_GET[&#039;Nachname&#039;];$mail=$_GET[&#039;Email&#039;];$tel=$_GET[&#039;Telefon&#039;];$titel=$_GET[&#039;Gedichttitel&#039;];$gedicht=$_GET[&#039;Gedicht&#039;];$date = date(&quot;d. M. Y h:i&quot;);$sql_tabelle1 =&quot;INSERT INTO tbl_kontakt (t_vorname,t_nachname,t_email,t_telefon)&quot;. &quot;VALUES (&#039;$vname&#039;, &#039;$nname&#039;, &#039;$mail&#039;, &#039;$tel&#039;)&quot;;$sql_tabelle2 =&quot;INSERT INTO tbl_wettbewerb (t_gedichttitel,t_gedicht,t_date)&quot;. &quot;Values (&#039;$titel&#039;, &#039;$gedicht&#039;, &#039;$date&#039;)&quot;;mysql_query($sql_tabelle1) or die (&quot;SQL: $sql_tabelle1 ---falsch&quot;);mysql_query($sql_tabelle2) or die (&quot;SQL: $sql_tabelle2 ---falsch&quot;);mysql_close($conn);}else{include (&quot;inc/head.php&quot;);?&gt;&lt;body onload = document.getElementsByName(&quot;Vorname&quot;)[0].focus()&gt;&lt;form action=&quot;index.php&quot; method=&quot;get&quot; name=&quot;Feedback&quot;&gt;&lt;table&gt;&lt;tr&gt;&lt;td&gt;Vorname:&lt;/td&gt;&lt;td class=&quot;Stil4&quot;&gt;*&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Vorname&quot; size=&quot;30&quot; maxlength=&quot;30&quot; onBlur=&quot;check_Vorname ()&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Nachname:&lt;/td&gt;&lt;td class=&quot;Stil4&quot;&gt;*&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Nachname&quot; size=&quot;30&quot; maxlength=&quot;50&quot; onBlur=&quot;check_Nachname ()&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Stra&amp;szlig;e/Nr.:&lt;/td&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Strasse&quot; size=&quot;30&quot; maxlength=&quot;50&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;PLZ:&lt;/td&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;PLZ&quot; size=&quot;5&quot; maxlength=&quot;10&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Ort:&lt;/td&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Ort&quot; size=&quot;30&quot; maxlength=&quot;50&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Email:&lt;/td&gt;&lt;td class=&quot;Stil4&quot;&gt;*&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Email&quot; size=&quot;30&quot; maxlength=&quot;50&quot; onBlur=&quot;check_Mail ()&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Telefon:&lt;/td&gt;&lt;td class=&quot;Stil4&quot;&gt;*&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Telefon&quot; size=&quot;30&quot; maxlength=&quot;50&quot; onBlur=&quot;check_Telefon ()&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Gedichttitel:&lt;/td&gt;&lt;td class=&quot;Stil4&quot;&gt;*&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Gedichttitel&quot; size=&quot;30&quot; maxlength=&quot;50&quot; onBlur=&quot;check_Gedichttitel ()&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;K&amp;uuml;nstlername:&lt;/td&gt;&lt;td&gt;&amp;nbsp;&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;Kuenstlername&quot; size=&quot;30&quot; maxlength=&quot;50&quot;&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td class=&quot;test&quot;&gt;Gedicht:&lt;/td&gt;&lt;td class=&quot;Stil4&quot;&gt;*&lt;/td&gt;&lt;td&gt;&lt;textarea name=&quot;Gedicht&quot; rows=&quot;15&quot; cols=&quot;22&quot; onBlur=&quot;check_Gedicht ()&quot;&gt;&lt;/textarea&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;p&gt;&lt;input type=&quot;submit&quot; value=&quot;Abschicken&quot; onclick=&quot;return check ()&quot;&gt;&lt;/p&gt;&lt;/form&gt;&lt;?phpinclude (&quot;inc/foot.php&quot;);}?&gt;</blockquote>

[QUOTE="Lukiiii, post: 870866, member: 272323"] [b]AW: Probleme mit der Datenbank[/b] Ich habe es mal ein bisschen verändert. Kannst du mal probieren, ob es funktionier! <?php if ( isset($_GET['Vorname']) and isset ($_GET['Nachname']) and isset ($_GET['Email']) and isset ($_GET['Telefon']) and isset ($_GET['Gedichttitel']) and isset ($_GET['Gedicht']) ) { require("inc/datenbank_kontakt.php"); $vname=$_GET['Vorname']; $nname=$_GET['Nachname']; $mail=$_GET['Email']; $tel=$_GET['Telefon']; $titel=$_GET['Gedichttitel']; $gedicht=$_GET['Gedicht']; $date = date("d. M. Y h:i"); $sql_tabelle1 ="INSERT INTO tbl_kontakt (t_vorname,t_nachname,t_email,t_telefon)" . "VALUES ('$vname', '$nname', '$mail', '$tel')"; $sql_tabelle2 ="INSERT INTO tbl_wettbewerb (t_gedichttitel,t_gedicht,t_date)" . "Values ('$titel', '$gedicht', '$date')"; mysql_query($sql_tabelle1) or die ("SQL: $sql_tabelle1 ---falsch"); mysql_query($sql_tabelle2) or die ("SQL: $sql_tabelle2 ---falsch"); mysql_close($conn); } else { include ("inc/head.php"); ?> <body onload = document.getElementsByName("Vorname")[0].focus()> <form action="index.php" method="get" name="Feedback"> <table> <tr> <td>Vorname:</td> <td class="Stil4">*</td> <td><input type="text" name="Vorname" size="30" maxlength="30" onBlur="check_Vorname ()"></td> </tr> <tr> <td>Nachname:</td> <td class="Stil4">*</td> <td><input type="text" name="Nachname" size="30" maxlength="50" onBlur="check_Nachname ()"></td> </tr> <tr> <td>Straße/Nr.:</td> <td> </td> <td><input type="text" name="Strasse" size="30" maxlength="50"></td> </tr> <tr> <td>PLZ:</td> <td> </td> <td><input type="text" name="PLZ" size="5" maxlength="10"></td> </tr> <tr> <td>Ort:</td> <td> </td> <td><input type="text" name="Ort" size="30" maxlength="50"></td> </tr> <tr> <td>Email:</td> <td class="Stil4">*</td> <td><input type="text" name="Email" size="30" maxlength="50" onBlur="check_Mail ()"></td> </tr> <tr> <td>Telefon:</td> <td class="Stil4">*</td> <td><input type="text" name="Telefon" size="30" maxlength="50" onBlur="check_Telefon ()"></td> </tr> <tr> <td>Gedichttitel:</td> <td class="Stil4">*</td> <td><input type="text" name="Gedichttitel" size="30" maxlength="50" onBlur="check_Gedichttitel ()"></td> </tr> <tr> <td>Künstlername:</td> <td> </td> <td><input type="text" name="Kuenstlername" size="30" maxlength="50"></td> </tr> <tr> <td class="test">Gedicht:</td> <td class="Stil4">*</td> <td><textarea name="Gedicht" rows="15" cols="22" onBlur="check_Gedicht ()"></textarea></td> </tr> </table> <input type="submit" value="Abschicken" onclick="return check ()"> </form> <?php include ("inc/foot.php"); } ?> [/QUOTE]

Bilder bitte hier hochladen und danach über das Bild-Icon (Direktlink vorher kopieren) platzieren.

Authentifizierung

Wenn ▲ = 5, ▼ = 2 und ■ = 7, was ist ▲ × ▼ + ■?