Laravel store latitude and longitude

user_388364 0
Viewed 8177

I'm storing latitude and longitude and the problem I'm having is when it is being stored it gets rounded up, which isn't what I want. Otherwise those field values become incorrect when using the latitude and longitude on the map.

This is what I'm using:

$table->decimal('lat', 10, 8)->nullable();
$table->decimal('lng', 11, 8)->nullable();

this value -40.95560269999999 gets turned into this -40.9556027000 when I just want -40.9556026999

laravel latitude-longitude mysql php
2 Answers

Use double in your migrations instead of decimals, see below

$table->double('lat')->nullable();
$table->double('lng')->nullable();
user_95514070

your field's data type might be not decimal, make it sure that your field of lat long is decimal too

user_27562360
Related