Home arrow JavaScript arrow Communicating with the Server of a MySQL Client with AJAX

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.

Author Info:
By: Alejandro Gervasio
Rating: 4 stars4 stars4 stars4 stars4 stars / 11
September 12, 2006
  1. · Communicating with the Server of a MySQL Client with AJAX
  2. · Refresher course: the MySQL client's login module
  3. · A final review: the MySQL applicationís client module
  4. · Running queries on the server: a simple PHP script

print this article

Communicating with the Server of a MySQL Client with AJAX
(Page 1 of 4 )


Now, with reference to the second article, youíll surely recall that I concentrated all my efforts on defining the group of JavaScript functions dedicated to sending out, via AJAX, all the queries entered by the user, as well as to displaying the corresponding responses received from the server.

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.

blog comments powered by Disqus

- Project Nashorn to Make Java, JavaScript Wor...
- JavaScript Virus Attacks Tumblr Blogs
- Google Releases Stable Dart Version, JavaScr...
- Khan Academy Unveils New JavaScript Learning...
- Accessing Nitro? There`s an App for That
- JQuery 2.0 Leaving Older IE Versions Behind
- Fastest JavaScript Engine Might Surprise You
- Microsoft Adjusting Chakra for IE 10
- Brendan Eich: We Don`t Need Google Native Cl...
- An Overview of JavaScript Statements
- An Overview of JavaScript Operators
- Overview of JavaScript Variables
- More of the Top jQuery Social Plugins
- The Top jQuery Social Plugins
- More of the Top jQuery Slider Plugins

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2019 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials