You have an error in your SQL syntax - XAMPP

Question

I've tried running a query but it says that I have an error in my SQL syntax. Why?

This should be the only code you need:

$sql = "INSERT (email, username, password) VALUES ($email, $username, $password)";

I am also aware of SQL injection. I will add a patch which is mysqli_real_eacape_string() function.

This should be the only answer you need: INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...) — arbogastes, May 21 '17 at 16:09
If you were really aware of SQL injection, you would use prepared statements - not escape the input. — Qirel, May 21 '17 at 16:12

score 1 · Answer 1 · edited May 21 '17 at 16:11

1

You are missing the table name. Try

$sql = "INSERT INTO table_name (email, username, password) VALUES ($email, $username, $password)";

edited May 21 '17 at 16:11

Qirel

answered May 21 '17 at 16:09

Tobias Walter

one big correction +1 – Adib Aroui May 21 '17 at 16:17
2

this is only 50% of the problem. I can't see why this received so many upvotes. I honestly doubt that all of those values are integers. – Funk Forty Niner May 21 '17 at 16:20
@Fred-ii-, I totally agree, I also think that the two links in duplicate section are not for 100% direct answers to the issue – Adib Aroui May 21 '17 at 18:13
*"I also think that the two links in duplicate section are not for 100% direct answers to the issue"* - @whitelettersinblankpapers I doubt that. – Funk Forty Niner May 21 '17 at 19:16

1 Answers1