location does not show on map when added from database

  • Resolved nijatmursali

    (@nijatmursali)


    5 years, 3 months ago

    Hello

    At the moment I’m working with this plugin, but it does not work when I add data dynamically from the MySQL database. So basically, in database, there is wp_asl_stores that you have added and inside that when I add new store(insert), it is shown in database, but in frontend map, it is not shown. But when I change one field in admin dashboard the map is located correctly. Why it is not possible to add data dynamically from the MySQL?

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Agile Logix

    (@agilelogix)

    5 years, 3 months ago

    Hi @nijatmursali, it is surely possible to directly load the data into the database table, I’m not sure what you are skipping as I don’t see your URL, please make sure that Lat/Lng values are there and because it will not load without Lat/Lng values.

    Thank you

    Thread Starter nijatmursali

    (@nijatmursali)

    5 years, 3 months ago

    I was just adding this one, as in admin dashboard when you just write these ones it shows the correct map location, but it does not show location when added from database. INSERT INTO wp_asl_stores(title, description, street, city, state, postal_code, country)

    Plugin Author Agile Logix

    (@agilelogix)

    5 years, 3 months ago

    Hi @nijatmursali , as I see your mysql query, you are not inserting the Lat/Lng values, it will not appear on the frontend as those values make them appear on the Google Maps.

    Please let me know if you have any questions.

    Thank you

    Thread Starter nijatmursali

    (@nijatmursali)

    5 years, 3 months ago

    But, why it works in admin dashboard when you just type country street without typing lat/lng?

    Plugin Author Agile Logix

    (@agilelogix)

    5 years, 3 months ago

    @nijatmursali Do you mean in the Edit Store? in the Edit Store, we call the Google Geocoding API and it fetches that Lat/Lng values for the store you edit, in the Manage Stores you will the that record but with empty values for Lat/Lng columns, please note that the Google Maps doesn’t work without Lat/Lng values.

    Thank you

    Thread Starter nijatmursali

    (@nijatmursali)

    5 years, 3 months ago

    So it’s not possible to add to stores with MySQL without lat/lng values?

    Plugin Author Agile Logix

    (@agilelogix)

    5 years, 3 months ago

    It is possible but you have to insert the Lat/Lng values as well for the stores, please edit your query and insert the lat and lng values as well.

    Thanks

    Thread Starter nijatmursali

    (@nijatmursali)

    5 years, 3 months ago

    Thanks for response, but I would like to do that without typing lat/lng just the address.

    Plugin Author Agile Logix

    (@agilelogix)

    5 years, 3 months ago

    Geocoding (Lat/Lng) values can only be fetched through 3rd party API calls such as Google Geocoding API, you can’t simply create them, and maps doesn’t work without them, that is a limitation.

    Thanks

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘location does not show on map when added from database’ is closed to new replies.