ubceats / foodfoodfood

🍕 UBCEats: A web portal for food items at UBC
http://www.ubceats.ca
3 stars 0 forks source link

Implement check on lat lon #13

Open falkirks opened 6 years ago

agottardo commented 6 years ago

Should also be added to the CREATE TABLE syntax we will attach to the submission, so not closing for now.

agottardo commented 6 years ago

@iandelrio remember to add this at the end of the final .sql when submitting:

ALTER TABLE locations ADD CHECK (longitude>=-123.27 AND longitude <= -123.22 AND latitude >= 49.241 AND latitude <= 49.283);

In PHP:

$longitude >= -123.27 && $longitude <= -123.22 && $latitude >= 49.241 && $latitude <= 49.283;