PHP error code in inserting a row in MySQL connected database

( ! ) 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')";