( ! ) Parse error: syntax error, unexpected '"', expecting identifier (T_STRING) or variable (T_VARIABLE) or number (T_NUM_STRING) in C:\wamp\www\mystore\customer.php on line 33
$servername = "localhost";
$username = "root";
$password = "goodoneboy";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>
$servername = "localhost";
$username = "root";
$password = "goodoneboy";
$dbname = "my store";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo $_POST["name"];
echo $_POST["address"];
echo $_POST["amount_paid"];
$sql = "INSERT INTO customer (Name,Address,Amount_paid)
VALUES ('$_POST["name"]','$_POST["address"]',' $_POST["amount_paid"]')";
if ($conn->query($sql) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}
?>
Answer
i would put your post values in a variable and then use them in your sql statement or concatenate the string to avoid the use of so many quotations.
"INSERT INTO customer (Name,Address,Amount_paid) VALUES (" . $_POST["name"] . "," .$_POST["address"]. "," . $_POST["amount_paid"] . ")";
Try that instead. Or
"INSERT INTO customer (Name,Address,Amount_paid) VALUES ( '$name', '$address','$amount_paid')";
No comments:
Post a Comment