Join Date: February 2009
Location: India ( chennai )
Posts: 9
sort
i need my page result to be sorted with ajax can u help me?
benaya
Posted on Feb 20, 2009
Join Date: June 2007
Location: India ( Chennai )
Posts: 90
RE : sort
Hi, First create 2 files one for displaying and another one for serverside script.
First file sortHtml.html which have ajax to call serverside --------------------------------------------------------------------------------- <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Basic Level Ajax for Sorting</title> <script language="javascript"> //Creating ajax function for calling serverside script for sorting datas
function getDataDisplay(orderBy) { var xmlHttp; try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { return false; } } } xmlHttp.onreadystatechange=function() { if(xmlHttp.readyState==4) { //Accessing serverside values into div tag document.getElementById("divDisplay").innerHTML=xmlHttp.responseText; } } xmlHttp.open("GET","server.php?orderBy="+orderBy,true); xmlHttp.send(null); } </script> </head>
Second file server.php which have serverside scripting -------------------------------------------------------------------------------- <?php $con = mysql_connect("localhost","root",""); mysql_select_db("test_db");
$strOrderBy = ($_REQUEST["orderBy"]=="D") ? " order by student_name desc" : " order by student_name";
$strSql = "Select student_name from student ".$strOrderBy; $results = mysql_query($strSql);
Hot Discussion