php large number or integer problem converting its adding some plus symbol

php large number or integer problem converting its adding some plus symbol


example:
$var = 100000179860794

echo $var;
output => 1.0000017986079E+14

Using number_format function

$modified = number_format($var, 0, "", "");
output => 100000179860794

Mysql query float value in where condition is giving empty result set for google latitue and longitude values

Mysql query float value in where condition is giving empty result set for google latitue and longitude values

SELECT lat, lon FROM googletable WHERE ABS(TRIM(lat)) = ABS(TRIM(51.5137));