flashbook.co - using mysql + lat/long to filter and return artists within a certain distance

On today's stream, we used Jonathan Reinink's geographic filtering approach (https://laracasts.com/series/eloquent...) to allow users to filter down art by artists who aren't within a given distance. We created a query scope on our Artist model which takes in the person's entered location plus some distance constraint and then filter out any artists that don't fall within that geographic boundary using MySQL's ST_SRID function.

Then, once we had the raw filtering working, we built a React component that allows the user to actually enter these values and have the frontend request any matching art.

Thanks for tuning in!

-- LINKS --
📺 Twitch -   / nexxai  
🏈 StubSquad - https://stubsquad.com
🐦 Twitter -   / nexxai  

-- MY GEAR --
💻 Apple M1 MacBook Air laptop - https://amzn.to/3SiweIc
⌨️ Shurikey Saizo-003 keyboard - https://amzn.to/492KpXm
⌨️ KBDFans Taco75 keyboard - https://kbdfans.com/collections/taco
⌨️ PBTFans Kabuki Cho keycaps - https://kbdfans.com/products/pbtfans-...
⌨️ Gateron Oil King switches - https://amzn.to/3TgmM7C
🎤 PreSonus Revelator Dynamic microphone - https://amzn.to/48n638Y
🕸️ PreSonus Revelator SHK-2 shockmount - https://amzn.to/41ZHWe3
💡 Amaran P60x light and softbox - https://amzn.to/3S9BLke
🚏 AmazonBasics light stand - https://amzn.to/3RWSyWr

Disclosure: I am a member of the Amazon Associates affiliate program. Purchasing the products listed above through the given links does not increase the cost for you but does return a small percentage of the sale to the channel as revenue.