//this page is called by variance_report.php.
//this is used for ajax based pagination
var xmlHttp
function showPage(starting)
{
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="AjaxTest.php"
url=url+"?starting="+starting;
url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=stateChanged;
xmlHttp.open("GET",url,true)
xmlHttp.send(null)
}
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById('suspend').innerHTML=xmlHttp.responseText
}
}
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
the php page:
<?php
require_once "functions.php";
include("db_connection.php");
//error_reporting(E_ERROR ^ E_WARNING);
//for retreving suspended client records
$starting=$_REQUEST['starting'];
$type=$_REQUEST['section'];
$recpage=5;
$qry="SELECT * FROM personal1";
$page=paginate($qry,$starting,$recpage);
$rst=$page[0];
?>
<table width="100%" border="0" cellpadding="7" cellspacing="0" bgcolor="#EFF8FF">
<tr>
<td><table width="100%" border="0" cellpadding="4" cellspacing="0" bgcolor="#FFFFFF" class="border-blue">
<tr bgcolor="#46B0FF" class="border-blue-tr">
<td><div align="left"><STRONG>First Name</STRONG></div></td>
<td><DIV align=left><STRONG>Last Name </STRONG></DIV></td>
</tr>
<? if(mysql_num_rows($rst)>0){
$counter=1;
while($data=mysql_fetch_array($rst)){
if($counter%2==0){ $color="#95D2FF"; } else { $color="#CAE8FF"; } ?>
<tr bgcolor="<? echo $color?>" class="border-blue-tr">
<td><div align="left"><? echo $data['first_name']; ?></div></td>
<td><? echo $data['last_name']; ?></td>
</tr>
<? $counter++;
} } ?>
</table></td>
</tr><tr><TD><?
echo $page[1]." ".$page[2];
?></TD></tr>
</table>
the Main Page
<html>
<head>
<TITLE>Ajax Test</TITLE>
<script src="AjaxTest.js"></script>
</head>
<body>
<form name="form2" method="post" action="">
<div id="suspend">
</div>
</form>
</body>
</html>
0 comments
Post a Comment
Please put your comments here. your questions, your suggestions, also what went wrong with me.