MySQL query from HTML Form - Handing JSON response
Hey everyone. Got a problem that I really need help solving.
I have a page where a user is able to search a database for certain criteria (species/location/dates etc). What I have so far is when the form is submitted, the values are posted to a PHP script, which performs a MySQL query and then returns the result in json_encode(). What I want to happen is:
- User fills form
- User clicks submit
Now I have all the key features here, but combining them together is causing me a headache, and I know that AJAX is my solution. Here's my HTML that calls the JS.