Communicating with the Server of a MySQL Client with AJAX
Looking for a comprehensive tutorial that shows you how to create a MySQL client application with the help of AJAX? Then this is the article you’ve been waiting for! Welcome to the concluding part of the series "Creating a MySQL Client with AJAX." In three parts, this series walks you through the process of building a simple application that allows you to run select, insert, update and delete SQL commands against a given MySQL database table, all from your own browser.
Communicating with the Server of a MySQL Client with AJAX (Page 1 of 4 )
Also, I covered the creation of a simple front end. This came in handy for performing a number of tasks, such as typing in the mentioned queries and sending them straight to the server, along with showing the data returned by SELECT statements.
Of course, all the processes that I described above were quite simple to implement, since AJAX comes equipped with a set of methods and properties that makes it really easy to send HTTP requests in the background.
After walking through a brief recapitulation of all the topics that were covered in detail during the previous tutorial, it’s time to pay attention to the current one. More specifically, this last article of the series will be dedicated to creating a fairly understandable PHP script, which will be capable of running on the MySQL server all the queries entered by the user. It will also be able to send back to the client the corresponding results in a format suitable for display to the browser.
With the preliminaries out of our way, let’s get started.