Auf Thema antworten 2026

Beitrag

<blockquote data-quote="WebmasterHelp" data-source="post: 2110557">Hallo,bau grad ein Bestellformular in PHP welches die Daten in einer MySQL Datenbank speichern soll. Nun bekomme ich immer diesen Fehler:You have an error in your SQL syntax; check the manual that corresponds&nbsp; to your MySQL server version for the right syntax to use near &#039;key)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; VALUES (&#039;firma&#039;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &#039; at line 2So sie der query aus:[PHP]$render = sha1(mt_rand());$key = substr($render, 0, 16);$query = &quot;INSERT INTOcustomers (anrede, firma, vorname, nachname, anschrift, wohnort, land, lizenz, homepage, email, telefon, passwort, zahlung, bestellung, aktiv, key)VALUES (&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;anrede&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;firma&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;vorname&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;nachname&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;anschrift&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;wohnort&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;land&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;lizenz&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;homepage&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;email&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;telefon&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;passwort&#039;])) . &quot;&#039;,&#039;&quot; . mysqli_real_escape_string($connect, trim($_POST[&#039;zahlung&#039;])) . &quot;&#039;,NOW(),&#039;0&#039;,&#039;&quot; . mysqli_real_escape_string($connect, $key) . &quot;&#039;)&quot;;$result = mysqli_query($connect, $query) OR die(mysqli_error($connect));[/PHP]Weiß jemand Rat?Mfg</blockquote>

[QUOTE="WebmasterHelp, post: 2110557"] Hallo, bau grad ein Bestellformular in PHP welches die Daten in einer MySQL Datenbank speichern soll. Nun bekomme ich immer diesen Fehler: [I]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 'key) VALUES ('firma', ' at line 2[/I] So sie der query aus: [PHP]$render = sha1(mt_rand()); $key = substr($render, 0, 16); $query = "INSERT INTO customers (anrede, firma, vorname, nachname, anschrift, wohnort, land, lizenz, homepage, email, telefon, passwort, zahlung, bestellung, aktiv, key) VALUES ('" . mysqli_real_escape_string($connect, trim($_POST['anrede'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['firma'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['vorname'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['nachname'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['anschrift'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['wohnort'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['land'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['lizenz'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['homepage'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['email'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['telefon'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['passwort'])) . "', '" . mysqli_real_escape_string($connect, trim($_POST['zahlung'])) . "', NOW(), '0', '" . mysqli_real_escape_string($connect, $key) . "')"; $result = mysqli_query($connect, $query) OR die(mysqli_error($connect));[/PHP] Weiß jemand Rat? Mfg [/QUOTE]

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

Authentifizierung

Wenn ▲ = 7, ▼ = 3, ◇ = 2 und die Summe von ▲ und ▼ durch ◇ geteilt wird, was ist das Ergebnis?