PHP about jquery-store-locator-plugin HOT 5 CLOSED

You need to select the database before doing the query. You could use mysql_select_db($db,$dbhandle); and set the $db variable above with your other settings or you could use a mysqli connection if your server supports it.

from jquery-store-locator-plugin.

Ok great! I was able to connect, thank you! I'm also a little confused because on your blog it says to just set the "dataLocations" setting to the php file, but in the Json example you're setting it to a location.json file. How are you pulling the data into the json file that the php file renders?

from jquery-store-locator-plugin.

I just copied the source from the browser and pasted it into a file for the example. If you read above the screenshot: "The JSON file included in the GitHub repository is just there as an example. The file was generated via PHP from a MySQL database."

from jquery-store-locator-plugin.

Also, if you've downloaded 1.4.9 be sure to use name instead of locname in your locations table.

from jquery-store-locator-plugin.

Ok thanks!

from jquery-store-locator-plugin.