ajax_lecture3 - Rapid Application Web Development Lecture...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Rapid Application Web Development Fall 2006 Dr. McDaniel Lecture 3: Database-Driven AJAX
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Agenda Lecture Part I on integrating MySQL with Ajax applications Lecture Part II on using the prototype.js JavaScript library Discuss oral presentation assignment Group work time on project 2
Background image of page 2
Review Last week, we used XML to direct server output to specific <div> and <span> tags in our user interface. In today’s lecture, we’ll see how to expand AJAX to work with a MySQL database. We’ll start by looking at a very simple example.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Lecture Part I: MySQL MySQL is a multithreaded, multiuser, relational DBMS. What do each of these terms mean? It integrates easily with popular server-side languages such as PHP. MySQL AB is free for non-corporate use under the GPL, and is part of the installation package with XAMPP. See http://en.wikipedia.org/wiki/MySQL for more information about MySQL.
Background image of page 4
Integrating MySQL with Ajax Adding MySQL support to an Ajax application is as simple as connecting to the database using a server-side script and doing something meaningful with a database query. Typical queries include selecting data tuples, inserting new data, creating or altering tables, deleting data tuples or tables, and joining various related tables into single units of information.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Example (Using with a Database) This application will use an AJAX framework to communicate with a MySQL database. We will use the following file structure:
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 37

ajax_lecture3 - Rapid Application Web Development Lecture...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online