How can we create an image as shown below with PHP and save their coordinates in the MYSQL database.
Take a look at the OpenGIS ( Spatial Data Support ) MySQL extension and the PHP GD2 extension .
UPD:
Features OpenGIS Simple Features for SQL can be useful. Many database management systems support it.