Könnt ihr hier den Fehler finden ?
Code
$mysqli = mysqli_connect('localhost', 'sebastian1012_10', 'blablub', 'sebastian1012_10');
if (mysqli_connect_errno()) die ("Connect failed: " . mysqli_connect_error($mysqli));
mysqli_set_charset($mysqli, "utf8");
$query = "Insert into 'pn' (`name`, `message`, `time`, `ip` ,`wert` , `from` ) values ('%s', '%s', '%s', '%s', '%s', '%s')";
$message=htmlspecialchars($_POST['message']);
$name=htmlspecialchars($_POST['name']);
$time=htmlspecialchars($_POST['ip']);
$ip=htmlspecialchars($_POST['wert']);
$wert=htmlspecialchars($_POST['time']);
$from=htmlspecialchars($_POST['from']);
$query = sprintf($query,mysqli_real_escape_string($mysqli, $from),
mysqli_real_escape_string($mysqli, $name),
mysqli_real_escape_string($mysqli, $message),
mysqli_real_escape_string($mysqli, $time),
mysqli_real_escape_string($mysqli, $ip),
mysqli_real_escape_string($mysqli, $wert));
$result = mysqli_query($mysqli, $query) or die ("MySQL-Error: " . mysqli_error($mysqli));
if($result){
echo 'Gespeichert';
}else{
echo mysqli_error($mysqli);
}
Alles anzeigen
Die Fehlermeldung bringt mich nicht weiter
Code
MySQL-Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= +1 WHERE id=1' at line 1
Es wahr vorher @mysql ,habe bestimmt was übersehen