---
title: "Using AJAX with Database in PHP"
description: "AJAX can be used for interactive communication with a database. The following example will demonstrate how a web page can fetch information from a da"
author: "Anonymous User"
published: 2011-09-27
updated: 2020-03-04
canonical: https://www.mindstick.com/articles/745/using-ajax-with-database-in-php
category: "php"
tags: ["php"]
reading_time: 2 minutes
---
# Using AJAX with Database in PHP
AJAX can be used for [interactive](https://answers.mindstick.com/qa/38931/who-has-won-the-2016-fifa-interactive-world-cup-fiwc) [communication](https://www.mindstick.com/articles/126321/5-fails-and-fixes-of-the-office-communication) with a database.\
The following example will demonstrate how a [web page](https://answers.mindstick.com/qa/92898/how-to-create-a-web-page-using-bootstrap-4) can [fetch information](https://answers.mindstick.com/qa/93905/how-to-fetch-information-from-a-normal-file-with-ajax) from a database with AJAX:
##### Example:
The [database table](https://www.mindstick.com/forum/159366/how-to-test-regular-expressions-in-sql-without-using-database-table) we use in the example above looks like this:
In this example, I will show you how a web page can fetch information from a database by using, selecting user name from user list.
```
AJAX with Database Select User Name :
```
\
Now [select](https://www.mindstick.com/forum/34066/use-select-operator-in-linq) any [user name](https://answers.mindstick.com/qa/30717/how-to-retrieve-user-name-in-case-of-window-authentication) from user list, when you select any user name then ‘DatabaseAjax.php’ will be called.
##### ‘DatabaseAjax.php’ code:
```
Error : ". mysql_error()); } // select database name mysql_select_db("tempdatabase",$con); //select record from table $qry = "Select * from tempdatabase.tbltemp where username = '".$val."'"; // query result $qryResult = mysql_query($qry,$con); //print table structure echo " | Id | UserName | EmailId | Address | Mobile No |
"; // Display data in table column while ($rowData = mysql_fetch_array($qryResult)) { echo ""; echo "| ".$rowData['Id']." | "; echo "".$rowData['Username']." | "; echo "".$rowData['EmailId']." | "; echo "".$rowData['Address']." | "; echo "".$rowData['MobileNo']." | "; echo "
"; } // close table tag echo "
" ; // close the connection mysql_close($con); ?>
```
##### Output:
Select any one user name user list; here I am selecting ‘Arun’
\
---
Original Source: https://www.mindstick.com/articles/745/using-ajax-with-database-in-php
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.