Forum Location based query

posted 10 years ago

Architecture

Last updated 2 years ago.

replied 10 years ago

Let the database make as much filtering as possible. You can do this in SQL.

select * from technicians as t where (t.long- custLong)*(t.long- custLong) + (t.lat- custLat)*(t.lat- custLat) < t.max*t.max

The right side is km^2, but the left isn't take care of it.

Last updated 2 years ago.

We'd like to thank these amazing companies for supporting us

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Socials

The community