Php Sqlite acos function

In Laravel I've got a query builder method for ordering items based on
the users location with long and latitude.

Laravel

long

latitude

It looks like this:

public function location($location)

$location = explode(',', $location);

$lat = $location[0];
$long = $location[1];

return $this->builder->select(DB::raw(sprintf('(
6371 * acos (
cos ( radians(%s) )
* cos( radians( lat ) )
* cos( radians( lng ) - radians(%s) )
+ sin ( radians(%s) )
* sin( radians( lat ) )
)
) AS distance', $lat, $long, $lat)))
->orderBy('distance');



The problem is that I use a sqlite database. And acos is not supported. How could I get this to work with sqlite?

acos

Already saw this but this is not for php I guess?

acos function in Sqlite

0

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy