Spatial Point functions using Laravel Eloquent ORM

Question

I get longitude and latitude and want to store the location with [Spatial Point] with mysql,,

what's the queries and functions that can help me to insert the values ..

Vladislav Rastrusny · Accepted Answer · 2015-03-05T18:52:27.543

3

You can use DB::raw() to do this:

    DB::table('table')->insert([
        'field' => DB::raw("SPECIAL_FUNC(X)"),
    ]);

edited Mar 05 '15 at 18:52

answered Mar 05 '15 at 14:32

@MahmoudNassar Updated answer with links. They are findable using Google BTW. – Vladislav Rastrusny Mar 05 '15 at 18:52
Is using Query Builder the only solution?! I want to use Eloquent ORM is there any way? – Mahmoud Nassar Mar 09 '15 at 13:59
1

Ok I could Solve it using ORM with that : $location = DB::raw("(GeomFromText('POINT(37.774929 -122.419415)'))"); $newItem->Item_location = $location; $newItem->save(); – Mahmoud Nassar Mar 09 '15 at 16:23
Query Builder and Eloquent Builder have almost the same features and in many cases can be addressed universally. – Vladislav Rastrusny Mar 10 '15 at 07:34
I want a query that to retrieve all items within specific rang ,, I receive the longitude & latitude and have to return all items within 10 m of that location !! – Mahmoud Nassar Mar 10 '15 at 12:02
@MahmoudNassar http://stackoverflow.com/questions/21168380/use-mysql-spatial-extensions-to-select-points-inside-circle – Vladislav Rastrusny Mar 10 '15 at 18:53

1 Answers1