如何在mysqli中使用POINT mysql类型 - php [复制]

Question

This question already has an answer here:

• How to prepare SQL statement with POINT using mysqli when using INSERT 1 answer

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?

</div>

Answer 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);