Ajax in PHP

Question

Hi Friends I want to know how to use ajax in PHP ? Please tellme anyone with an example of ajax in PHP Thanks.

Satyapriya Nayak · Answer

Hi Vineet Pagination using ajax in Php Normal 0 Table creation -- phpMyAdmin SQL Dump -- version 2.11.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Nov 22 2008 at 03:06 AM -- Server version: 5.0.51 -- PHP Version: 5.2.5 SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO; -- -- Database: `home_work` -- -- -------------------------------------------------------- -- -- Table structure for table `user_info` -- CREATE TABLE `user_info` ( `id_user_info` int(11) NOT NULL auto_increment `fullname` varchar(255) NOT NULL default '' `email` varchar(255) NOT NULL default '' `contact_no` varchar(255) NOT NULL default '' PRIMARY KEY (`id_user_info`) ) TYPE=MyISAM AUTO_INCREMENT=24 ; # # Dumping data for table `user_info` # INSERT INTO `user_info` VALUES (1 'John Smith' 'john.smith@ymail.com' '98675410181'); INSERT INTO `user_info` VALUES (2 'Micheal Doughlas' 'michael.doughlas@hotmail.com' '98675410131'); INSERT INTO `user_info` VALUES (3 'Mary Anderson' 'mary.anderson@gmail.com' '91675433181'); INSERT INTO `user_info` VALUES (4 'James McCarthy' 'mac.james@hotmail.com' '98675550131'); INSERT INTO `user_info` VALUES (5 'Rosalind Holmes' 'rosalindh@ymail.com' '94675433181'); INSERT INTO `user_info` VALUES (6 'Pete McCuin' 'pete.cuin@yahoo.co.uk' '98475550131'); INSERT INTO `user_info` VALUES (7 'Nicolas Finh' 'nicolas.finh@ymail.com' '98675410181'); INSERT INTO `user_info` VALUES (8 'Tommy Lee' 'tommy.lee@hotmail.com' '98675710131'); INSERT INTO `user_info` VALUES (9 'Sujoku Jim' 'sujoku.jim@gmail.com' '91675433181'); INSERT INTO `user_info` VALUES (10 'James Hull' 'james.hull@hotmail.com' '98655550131'); INSERT INTO `user_info` VALUES (11 'Sherly Peters' 'sherlyp@ymail.com' '94675433181'); INSERT INTO `user_info` VALUES (12 'Abraham Holder' 'abraham.holder@yahoo.co.uk' '98400550131'); INSERT INTO `user_info` VALUES (13 'Pete Sampras' 'pete.sampras@ymail.com' '98600010132'); INSERT INTO `user_info` VALUES (14 'Kirk Doughlas' 'kirk.doughlas@hotmail.com' '98675410144'); INSERT INTO `user_info` VALUES (15 'Dorothy James' 'dorothy.james@gmail.com' '91675433165'); INSERT INTO `user_info` VALUES (16 'Sebastian Urchin' 'sebastian.urchin@hotmail.com' '98675550197'); INSERT INTO `user_info` VALUES (17 'Tabitha Gregory Golmes' 'tabithagg@ymail.com' '94675433133'); INSERT INTO `user_info` VALUES (18 'Albert Einstien' 'albert.einstien@yahoo.co.uk' '98475550144'); INSERT INTO `user_info` VALUES (19 'Yasser Arafat' 'yasser.arafat@ymail.com' '98675410155'); INSERT INTO `user_info` VALUES (20 'Bruce Lee' 'bruce.lee@hotmail.com' '98675710166'); INSERT INTO `user_info` VALUES (21 'Johny Depp' 'johny.depp@gmail.com' '91675433171'); INSERT INTO `user_info` VALUES (22 'Celina Jaitly' 'celina.jaitly@hotmail.com' '98655550199'); INSERT INTO `user_info` VALUES (23 'Leander Peas' 'leanderpeas@ymail.com' '94675433100'); config.php $DBHOST = localhost; $DBNAME = home_work; $DBUSER = root; $sLink = mysql_connect($DBHOST$DBUSER'') or die('Connection with MySql Server failed'); mysql_select_db($DBNAME $sLink) or die('MySql DB was not found'); ?> Pagination.php include('./config.php'); ?> User Information .blackText{ font-weight:normal; font-size:11.5px; font-family: verdana arial helvetica sans-serif; color:#000000; font-style:normal; } .blackTextDDM{ font-weight:normal; font-size:11.5px; font-family: verdana arial helvetica sans-serif; color:#000000; font-style:normal; padding: 2px; border: 1px solid #000000; } .blueText{ font-weight:normal; font-size:11px; font-style:normal; font-family: verdana arial helvetica sans-serif; color:#84C0FC; } .errText{ font-weight:italic; font-size:10.5px; font-family: verdana arial helvetica sans-serif; color:red; } records.php $sPageNo = 1; $sRecordsPerPage = 5; $sOrderBy = id_user_info ASC; if ($_POST['page_no'] || $_POST['orderby'] || $_POST['records_per_page']) { include('./config.php'); if($_POST['page_no']) $sPageNo = $_POST['page_no']; if($_POST['orderby']) $sOrderBy = $_POST['orderby']; if($_POST['records_per_page']) $sRecordsPerPage = $_POST['records_per_page']; } $sSelQry = SELECT count(*) as no_records FROM user_info; $aCountRec = mysql_fetch_array(mysql_query($sSelQry)); $iTotalRecords = $aCountRec['no_records']; $sNoOfPages = ceil($iTotalRecords/$sRecordsPerPage); $sStartRange = ($sPageNo * $sRecordsPerPage) - $sRecordsPerPage; $sEndRange = $sRecordsPerPage; $sSelQry = SELECT * FROM user_info ORDER BY $sOrderBy LIMIT $sStartRange$sEndRange; $aUserInfo = mysql_query($sSelQry); if(mysql_num_rows($aUserInfo) == 0 && $_POST['records_per_page']) { $sPageNo = $sNoOfPages; $sStartRange = ($sPageNo * $sRecordsPerPage) - $sRecordsPerPage; $sEndRange = $sRecordsPerPage; $sSelQry = SELECT * FROM user_info ORDER BY $sOrderBy LIMIT $sStartRange$sEndRange; $aUserInfo = mysql_query($sSelQry); } //=============================== if ($sOrderBy == 'fullname ASC') $sOrderByFN = 'fullname DESC'; else $sOrderByFN = 'fullname ASC'; //=============================== //=============================== if ($sOrderBy == 'email ASC') $sOrderByEM = 'email DESC'; else $sOrderByEM = 'email ASC'; //=============================== //=============================== if ($sOrderBy == 'contact_no ASC') $sOrderByCN = 'contact_no DESC'; else $sOrderByCN = 'contact_no ASC'; //=============================== ?> No of Records Per Page: '' 'this.value)> >5 >10 >20 '' '' ')> .$j. ; } else { echo($j. ); } ?> Sl. No. '' '' ')>Fullname     '' '' ')>Email     '' '' ')>Contact No     $i = ($sRecordsPerPage * $sPageNo) - ($sRecordsPerPage - 1); while($aUserInfoRS = mysql_fetch_array($aUserInfo)) { $sUserName = $aUserInfoRS['fullname']; $sEmail = $aUserInfoRS['email']; $sContact = $aUserInfoRS['contact_no']; ?> $i++; } ?> ajax_sort.js function ajax_sort(sort_orderpage_norecords_per_page) { http_request = false; if (window.XMLHttpRequest) { // Mozilla Safari... http_request = new XMLHttpRequest(); if (http_request.overrideMimeType) { // set type accordingly to anticipated content type //http_request.overrideMimeType('text/xml'); http_request.overrideMimeType('text/html'); } } else if (window.ActiveXObject) { // IE try { http_request = new ActiveXObject(Msxml2.XMLHTTP); } catch (e) { try { http_request = new ActiveXObject(Microsoft.XMLHTTP); } catch (e) {} } } if (!http_request) { alert('Cannot create XMLHTTP instance'); return false; } var url = 'records.php'; var parameters = 'orderby='+sort_order+'&page_no='+page_no+'&records_per_page='+records_per_page; http_request.onreadystatechange = ajax_sort_callback; http_request.open('POST' url true); http_request.setRequestHeader(Content-type application/x-www-form-urlencoded); http_request.setRequestHeader(Content-length parameters.length); http_request.setRequestHeader(Connection close); http_request.send(parameters); } function ajax_sort_callback() { if (http_request.readyState == 4) { if (http_request.status == 200) { result = http_request.responseText; //alert(result); //return false; document.getElementById('sorting_rec').innerHTML = result; } else { alert('There was a problem with the request.'); } } } Thanks