This question already has an answer here:
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>
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);