سلام.
علت این ارور چیه ؟
Fatal error: Uncaught mysqli_sql_exception: 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 ''fullname','age','sex','isSingle') values ('Reza ',20,'m',0)' at line 2 in C:\\xampp\\htdocs\\7learn.php\\php-MySql-Driver\\MySql\\3-insert.php:18 Stack trace: #0 C:\\xampp\\htdocs\\7learn.php\\php-MySql-Driver\\MySql\\3-insert.php(18): mysqli->query('insert into peo...') #1 {main} thrown in C:\\xampp\\htdocs\\7learn.php\\php-MySql-Driver\\MySql\\3-insert.php on line 18
include_once "1-connection-mysqli.php";
# SAVE DATA IN TABLE
$userDate = array(
'fullname' => "Reza",
'age' => 20,
'sex' => 'm',
'isSingle' => 0
);
# INSERT QUERY
$sql = "insert into people
('fullname','age','sex','isSingle')
values
('{$userDate['fullname']}',{$userDate['age']},'{$userDate['sex']}',{$userDate['isSingle']})";
# QUERY CHECK
if ($mysqli -> query($sql))
{
echo "Inserted into Table".PHP_EOL;
}else{
echo "Insert failed ($mysqli -> error)".PHP_EOL;
}