SQL syntax error Maria DB server Mysqli_query

Question

I have this SQL:

$sql = "INSERT INTO orders (ID, Order_ID, Status, FName, LName, Email, 
Phone)VALUES ($UID, $orderID, 'Pending', '$fname', '$lname', '$email', 
'$phone');
INSERT INTO orders_inventory (Order_invID, Item_ID, Order_ID, Quantity) 
VALUES 
(NULL, $item_ID, $orderID, 1);";

This is how I connect it:

if(mysqli_query($db, $sql)){
   echo "three";
}

I did an echo on the $sql and this is what I got:

INSERT INTO orders (ID, Order_ID, Status, FName, LName, Email, Phone) 
VALUES (92, 625015841, 'Pending', '1', '1', '1@1', '1'); 
INSERT INTO orders_inventory (Order_invID, Item_ID, Order_ID, Quantity) 
VALUES (NULL, 1, 625015841, 1);

The SQL works when I paste it into the database manually, but the database crashes when I use the website PHP. The $DB is to connect to the database and it works because I tested it, and I have also been using it throughout the whole website.

I then did an error check using mysqli_error(db) and I get this error:

"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 'INSERT INTO orders_inventory (Order_invID, Item_ID, Order_ID, Quantity) VALUES (' at line 2"

Help would be greatly appreciated as I'm very stuck and don't know how to get around this or fix this problem

sorry the database doesnt crash when i use the website php, the php code just doesnt reach the echo "three" — Declan Watts
– Declan Watts, Commented Aug 31, 2018 at 2:42
Try removing the semicolon at the end. The semicolon is not part of SQL and some database drivers don't like it. — The Impaler
– The Impaler, Commented Aug 31, 2018 at 2:45
Command line and GUI tools usually support multi-statements, whille the PHP API does not (per default). — mario
– mario, Commented Aug 31, 2018 at 2:53

Nick · Accepted Answer · 2018-08-31 02:56:00Z

3

You're attempting to run two queries at once, which mysqli_query will not do. However you can use mysqli_multi_query instead:

if(mysqli_multi_query($db, $sql)){
    echo "three";
}

answered Aug 31, 2018 at 2:56

Nick

147k23 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL syntax error Maria DB server Mysqli_query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related