Android wants to display nearby merchants, how many meters are displayed for sellers, how to design coordinates for php database android wants to display nearby merchants, and how many meters are displayed for sellers, how to Design coordinates for the php database ------ solution ------------------ minimum & nbsp; Longitude & nbsp; Latitude & nbsp; these two fields ~ & Nbsp android: shows the number of sellers in the vicinity and the coordinates of the php database.
Android needs to display the number of merchants in the vicinity, and how to design coordinates for php databases
------ Solution --------------------
At least two fields, longitude and latitude, are required ~ Then, you can use php or java to calculate the longitude and latitude of a certain point. the largest and smallest longitude and latitude of the center xx meters are the radius. in this way, you can get the four coordinate points. conditional shops with longitude and latitude, of course, this is the scope of a quadrilateral! It is troublesome to circle!
------ Solution --------------------
There are not many sellers in the meter range
But the number of meters the merchant is in.
Although it looks the same, the subject has changed.
The seller is the subject and his position is fixed. he will not move the seller because of your move.
You only need to save the merchant's coordinates.
------ Solution --------------------
This field exists in the child mysql itself.
------ Solution --------------------
Record the longitude and latitude of each seller.
Then calculate the distance between the current location and each seller
Create a distance calculation function in mysql to query it using SQL statements.