Cześć,
dostaję błąd:
Polaczono z baza
Error: INSERT INTO test2 (1, 2, 3) VALUES ('1', '2', '3')
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, 2, 3) VALUES ('1', '2', '3')' at line 1
mój kod:
<?php
$servername = "127.0.0.1";
$database = "";
$username = "";
$password = "";
$conn = mysqli_connect($servername, $username, $password, $database);
if (!$conn) {
die("failed: " . mysqli_connect_error());
}
echo "Polaczono z baza<br>";
$sql = "INSERT INTO test2 (1, 2, 3) VALUES ('1', '2', '3')";
if (mysqli_query($conn, $sql)) {
echo "Dodano rekord";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>