Android needs to display the number of merchants in the vicinity, and how to design coordinates for php databases

Android requires nearby merchants to display, how many meters of businesses are displayed, how to design coordinates for php database android requires nearby merchants to display, how many meters of businesses are displayed, and how to design coordinates for php database

Reply to discussion (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!

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.

This field exists in the child mysql itself.

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.

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.

Are there such functions? Ask for advice

How does Android display sellers around it?

I am using the method on the first floor. the circle needs to compare the distance. This distance is more complicated than this estimate. Hope to have a good share