- PHP — AJAX and MySQL
- Example
- Example Explained — The MySQL Database
- Example Explained
- Example
- The PHP File
- PHP — AJAX Introduction
- What is AJAX?
- How AJAX Works
- AJAX is Based on Internet Standards
- Google Suggest
- Start Using AJAX Today
- PHP — AJAX and PHP
- Example
- Example Explained
- Example
- The PHP File — «gethint.php»
- Как использовать AJAX в PHP и jQuery
- Что такое AJAX?
- Как AJAX работает с использованием Vanilla JavaScript
- Как работает AJAX с использованием библиотеки jQuery
PHP — AJAX and MySQL
The following example will demonstrate how a web page can fetch information from a database with AJAX:
Example
Example Explained — The MySQL Database
The database table we use in the example above looks like this:
id | FirstName | LastName | Age | Hometown | Job |
---|---|---|---|---|---|
1 | Peter | Griffin | 41 | Quahog | Brewery |
2 | Lois | Griffin | 40 | Newport | Piano Teacher |
3 | Joseph | Swanson | 39 | Quahog | Police Officer |
4 | Glenn | Quagmire | 41 | Quahog | Pilot |
Example Explained
In the example above, when a user selects a person in the dropdown list above, a function called «showUser()» is executed. The function is triggered by the onchange event. Here is the HTML code:
Example
- Create an XMLHttpRequest object
- Create the function to be executed when the server response is ready
- Send the request off to a file on the server
- Notice that a parameter (q) is added to the URL (with the content of the dropdown list)
The PHP File
The page on the server called by the JavaScript above is a PHP file called «getuser.php».
The source code in «getuser.php» runs a query against a MySQL database, and returns the result in an HTML table:
table, td, th border: 1px solid black;
padding: 5px;
>
$con = mysqli_connect(‘localhost’,’peter’,’abc123′);
if (!$con) die(‘Could not connect: ‘ . mysqli_error($con));
>
mysqli_select_db($con,»ajax_demo»);
$sql=»SELECT * FROM user WHERE «;
$result = mysqli_query($con,$sql);
echo «
Firstname | Lastname | Age | Hometown | Job |
---|---|---|---|---|
» . $row[‘FirstName’] . « | » . $row[‘LastName’] . « | » . $row[‘Age’] . « | » . $row[‘Hometown’] . « | » . $row[‘Job’] . « |
«;
mysqli_close($con);
?>