PHP insert into MySQL Errors

Asked Oct 17 '16 at 15:32

Active Oct 17 '16 at 15:35

Viewed 34 times

I know there must be some sort of error here but I cannot find it at all. If someone could please have a look at my code with fresh eyes maybe I am missing something

This is my code to insert into DB

// Create connection
$conn = new mysqli($host, $username, $password, $db_name);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "INSERT INTO panic (Name, msisdn, lat, long)
VALUES ('$slname', '$slcustom1', '$lat', '$long')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

This is my error:

Error: INSERT INTO panic (Name, msisdn, lat, long) VALUES ('eTrack Demo', '0839008225', '-26.253604199999998', '28.2023469') 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 'long) VALUES ('eTrack Demo', '0839008225', '-26.253604199999998', '28.2023469')' at line 1

It is drawing all the correct values but still gives the error.

All the tables are named correctly and all are INT type

edited Oct 17 '16 at 15:35

RiggsFolly

93,638
21
103
149

asked Oct 17 '16 at 15:32

James Wright

1

`right syntax to use near 'long` - It's telling you where the problem is; you could have Google'd that. It's a MySQL reserved word. – Funk Forty Niner Oct 17 '16 at 15:34
Long is a mysql keyword. – Sharlike Oct 17 '16 at 15:35
1

@Sharlike "Reserved", not "keyword"; two different animals altogether. https://dev.mysql.com/doc/refman/5.5/en/keywords.html *"Keywords and Reserved Words"* – Funk Forty Niner Oct 17 '16 at 15:35
@Sharlike thanks I changed the "long" and it worked – James Wright Oct 17 '16 at 15:39
@Fred-ii- Good to know. Thanks. – Sharlike Oct 17 '16 at 19:19
@Sharlike You're welcome. – Funk Forty Niner Oct 17 '16 at 19:21

PHP insert into MySQL Errors

0 Answers0