i am developing an API and when I try to insert datas in my database , I get a aql syntax error . What’s the problem ?
here’s my code
<code><?php
header("Access-Control-Allow-Origin:*");
header("Content-Type:application/json");
include("../dbconfig/database.php");
if (isset($_POST)) {
$name = $_GET['name'];
$password = $_GET['password'];
$email = $_GET['email'];
$phone_number = $_GET['phone_number'];
$home_number = $_GET['home_number'];
$national_Code = $_GET['national_Code'];
$card_number = $_GET['card_number'];
$birth_date = $_GET['birth_date'];
try {
$result = $con->prepare("INSERT INTO user SET name=$name , password=$password , email=$email , phone_number=$phone_number , home_number=$home_number , national_Code =$national_Code , card_number=$card_number , birth_date=$birth_date");
$result->execute();
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
}
</code>
<code><?php
header("Access-Control-Allow-Origin:*");
header("Content-Type:application/json");
include("../dbconfig/database.php");
if (isset($_POST)) {
$name = $_GET['name'];
$password = $_GET['password'];
$email = $_GET['email'];
$phone_number = $_GET['phone_number'];
$home_number = $_GET['home_number'];
$national_Code = $_GET['national_Code'];
$card_number = $_GET['card_number'];
$birth_date = $_GET['birth_date'];
try {
$result = $con->prepare("INSERT INTO user SET name=$name , password=$password , email=$email , phone_number=$phone_number , home_number=$home_number , national_Code =$national_Code , card_number=$card_number , birth_date=$birth_date");
$result->execute();
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
}
</code>
<?php
header("Access-Control-Allow-Origin:*");
header("Content-Type:application/json");
include("../dbconfig/database.php");
if (isset($_POST)) {
$name = $_GET['name'];
$password = $_GET['password'];
$email = $_GET['email'];
$phone_number = $_GET['phone_number'];
$home_number = $_GET['home_number'];
$national_Code = $_GET['national_Code'];
$card_number = $_GET['card_number'];
$birth_date = $_GET['birth_date'];
try {
$result = $con->prepare("INSERT INTO user SET name=$name , password=$password , email=$email , phone_number=$phone_number , home_number=$home_number , national_Code =$national_Code , card_number=$card_number , birth_date=$birth_date");
$result->execute();
$con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
}
New contributor
SAMURAI JACK is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.