This question already has an answer here:
I'm having an issue solving this MySQL but while attempting to send to do an INSERT into a DB, any suggestions would be greatly appreciated.
Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '')' at line 1
Code:
<?php
$get_addeventname = $_POST["eventname"];
$get_addeventsummary = $_POST["eventsummary"];
$get_addeventdetails = $_POST["eventdetails"];
$get_addeventdate = $_POST["eventdate"];
$get_addeventprice = $_POST["eventprice"];
$get_addeventimage = $_POST["eventimagesrc"];
include("../../conn.php");
$queryinsert = "INSERT INTO thedatabase (id, eventname, eventsummary, eventdetails, eventdate, eventprice, eventimagesrc) VALUES (null,'$get_addeventname','$get_addeventsummary','$get_addeventdetails','$get_addeventdate',$get_addeventprice','$get_addeventimage')";
$result = mysqli_query($conn, $queryinsert) or die(mysqli_error($conn));
?>
If every thing was working as expected, the HTML should display confirming that the INSERT was successful.
Thanks in advance for any help.
</div>
In your insert statement for $queryinsert you are missing the single quote in front of $get_addeventprice.
,$get_addeventprice' should be => ,'$get_addeventprice'