How to use POINT mysql type with mysqli - php [duplicate]

Question

Based on this table from PHP .net :

Type specification chars
Character   Description
i   corresponding variable has type integer
d   corresponding variable has type double
s   corresponding variable has type string
b   corresponding variable is a blob and will be sent in packets

I write code:

$stmt = $this->conn->prepare("INSERT INTO days(day,startLocation) VALUES(?,?)");
        $stmt->bind_param("ss", $day, $startLocation);

but problem is becouse my startLocation field in database use type POINT, so

How I can make bind_param with POINT dataType in mysql?

INSERT INTO days(day,startLocation) VALUES(?, POINT(?, ?)? — u_mulder
– u_mulder, Commented Dec 5, 2014 at 20:19
no, I get error Call to a member function bind_param() on a non-object in - on that line where is INSERT etc... — LaraBeginer
– LaraBeginer, Commented Dec 5, 2014 at 20:23
The bind_param() on a non-object error means the prepare() call already failed, so something is amiss with the SQL statement itself rather than variable types. Check echo $this->conn->error; to find out why after attempting to call prepare(). — Michael Berkowski
– Michael Berkowski, Commented Dec 5, 2014 at 20:28

cardeol · Accepted Answer · 2014-12-10 12:30:32Z

1

You should use MYSQL function POINT in order to convert from Latitude/Longitude

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

answered Dec 10, 2014 at 12:30

cardeol

2,25818 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to use POINT mysql type with mysqli - php [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related