How to prepare SQL statement with POINT using mysqli when using INSERT

Question

I can't seem to find where documented to successfully prepare a statement that uses the POINT data type.

This previous question (How to use POINT mysql type with mysqli - php) shows something marked as correct, but it doesn't work. I even tried using their simple query in their example:

$stmt = $this->conn->prepare("INSERT INTO days(day,POINT(lat,lon)) VALUES(?,?,?)");
$stmt->bind_param("sdd", $day, $lat, $lon);

This just simply returns and 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 '(lat,lon)) VALUES(?,?,?)' at line 1

INSERT INTO days(day,point) VALUES(?,POINT(?,?))!?

JustOnUnderMillions
– JustOnUnderMillions

2017-03-29 12:47:04 +00:00
Commented Mar 29, 2017 at 12:47 — JustOnUnderMillions
– JustOnUnderMillions, Commented Mar 29, 2017 at 12:47

Hikmat Sijapati · Accepted Answer · 2017-03-29 12:51:32Z

2

Try like below;

$stmt = $this->conn->prepare("INSERT INTO days(day,column_name) VALUES(?,POINT(?,?))"); //column_name is name of of column that you want to insert POINT(lat,lon)
    $stmt->bind_param("sdd", $day, $lat, $lon);
    $stmt->execute();

answered Mar 29, 2017 at 12:51

Hikmat Sijapati

6,9691 gold badge11 silver badges19 bronze badges

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

1 Comment

rigid.design Over a year ago

Awesome! Thank you very much :-) I can't believe I couldn't find that documented anywhere

Collectives™ on Stack Overflow

How to prepare SQL statement with POINT using mysqli when using INSERT

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related