I created a web page which makes an ajax call to a php page every time a value in an input box changes.

 

In addition to having that php script check the value in the input box for invalid characters (with preg) and other forms of validation, I also have it making a call to a database to see if the value is already in that database.

 

While everything works perfectly locally, when I upload it to my server the whole AJAX call still functions perfectly except the one clause for checking the database. Obviously I thought it may be an error with my PDO statements, so I copied them into a new file tried querying the database using the same object and it worked perfectly (although I didn't use ajax to make the call on the test file).

 

This is the first time I've tried to take a project of mine to a live server. Has anyone else experienced a similar issue and solved it? It's very odd because I know the AJAX call is working because the other validation is fine, and I know my PDO statements are working fine because of the test file, but for some reason the combination of the 2 won't seem to work (except locally).

 

Thanks for anyone who took the time to read this!

You would possibly get more response to your problem if you showed your coding. Is the live server running the same builds of PHP etc as that of your local config?

Really stupid error based on some inexperience working with a live server on my part.

 

I exported my local database to an .sql file and imported it to my live server, unfortunately (for some reason I still don't know), it did not port all of my stored procedures for the associated database.

 

My PHP script was running these stored procedures in the functions handling AJAX call.

 

I've described my problem (and solution) here in case anyone else comes across a similar error, hopefully it saves them some time.