- PHP Tutorial
- PHP Syntax
- PHP Variables
- PHP Data Types
- PHP Constants
- PHP Operators
- PHP if elseif else statements
- PHP Switch Statement
- Arrays in PHP
- Loops in PHP
- Strings in PHP
- GET and POST in PHP
- Functions in PHP
- Cookies in PHP
- Sessions in PHP
- Include and Require in PHP
- File Opening and Reading in PHP
- File Creation and Writing in PHP
- Form Validation in PHP
- Date and Time Functions in PHP
- Validation and Sanitizing Data Via PHP Filters
- Introduction to Object Oriented Programming in PHP
- Parameterized Constructors in PHP
- Inheritance in Object Oriented PHP
- Abstract Class in PHP
- Math Functions in PHP
- Error and Exception Handling in PHP
- Reading XML data in PHP
- Reading XML Nodes/Attributes Values in PHP
- XML DOM Parser
- Sorting Arrays in PHP
- Commonly Used Array Functions in PHP
- Commonly Used String Functions in PHP
- Access Modifiers in PHP
- Variable Examination Functions in PHP
- File Upload in PHP
- PHP and AJAX
- PHP Frameworks
- Connecting PHP to MySQL
- Create Database in MySQL via PHP Script
- Drop Database in MySQL via PHP Script
- Selecting Mysql Database via PHP Script
- Create Table in MySQL via PHP Script
- Drop Table in MySQL
- Inserting Data in MySQL Table via PHP Script
- Selecting MySQL Table Data via PHP Script
- Where Clause in MySQL
- Update MySQL Table data via PHP Script
- Deleting Data From MySQL Table via PHP Script
- Sorting MySQL table data via PHP Script
- LIKE Query in MySQL
- Select Unique Data via Distinct In MySQL
- IN Operator in MySQL
- Using BETWEEN operator in MySQL
- AND/OR Operators In MySQL
- Selecting Limited records via LIMIT in MySQL
- Max and Min Functions in MySQL
- SUM and AVG Functions in MySQL
- Using COUNT Function in MySQL
- UCASE and LCASE Functions in MySQL
- GROUP BY and HAVING Clauses in MySQL
- INSERT INTO SELECT in MySQL
- DEFAULT Statement in MySQL
- Implementing Check on Table Columns
- INNER JOIN in MySQL
- LEFT JOIN in MySQL
- RIGHT JOIN In MySQL
- Implementing FULL Join in MySQL
PHP and AJAX
AJAX stands for asynchronous JavaScript and XML. It is not a technology itself, rather it is an approach which uses combination of technologies. Ajax basically allows partial reloading of a page. Without Ajax, when you click on a button, an HTTP request is created and sent to the server, the server in response resend the whole webpage. This results in large amount of data transportation between a server and a client. Ajax reduces the amount of data travelling between client and server via partial page reloads thus speeding up the application. Following are the steps that are required to implement Ajax in your web application.
- Create an XMLHTTPRequest Object
- Send the Request to server
- Create a function to execute when response is received
- Process the returned response via JavaScript
- Update the page accordingly
Live Movie Name Hint Example
To demonstrate how Ajax works, we will create a webpage which contains a text box, when user enters name of the movie in the text box, hints about the movie name shall appear.
Lets create a form and JavaScript function that will be executed when user enters something in the form.
Start typing the name of the movie in the text box:
Suggestions:
Download the code
Run the code
When user starts entering the name of the movie displayMovieHint JavaScript method executes which starts looking for hints. Another PHP file “Php-moviehint.php” contains names of all the movie hints in an array. When user enters text in text box, an XMLHttpRequest is send to this php file, which processes the input query and returns hints if exists. The contents of the “Php-moviehint.php” are as follows.