//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>
fetching xml values from xml files using Simple XML
//fetching values from the xml files
$xml_content = simplexml_load_file('example.xml');
foreach ($xml_content as $fields){
$resultfirstname=$fields->firstname;
$resultlastname=$fields->lastname;
$resultdescription=$fields->description;
}
Output
Inserting nodes into xml files using XML DOM in PHP .
//creating the dom object
$dom = new DOMDocument();
$dom->formatOutput = true;
//loading the existing XML file
$dom->load('example.xml');
//writting new xml node
$rootnode = $dom->getElementsByTagName("details")->item(0);
$root=$dom->createElement("inner");
$firstnameVal = $dom->createElement("firstname,$firstname);
$lastnameVal = $dom->createElement("lastname",$lastname);
$description = $dom->createElement("description", $description);
$root->appendChild($firstnameVal);
$root->appendChild($lastnameVal);
$root->appendChild($description);
$rootnode->appendChild($root);
$dom->appendChild($rootnode);
//saving the new node into the existing xml file
$dom->save(''example.xml');
Output the XML FILE
<details>
<inner>
<firstname>AP</firstname>
<lastname>John</lastname>
<description>programmer</description>
</inner>
<inner>
<firstname>KH</firstname>
<lastname>Samuel</lastname>
<description>programmer</description>
</inner>
<inner>
<firstname>KH</firstname>
<lastname>Samuel</lastname>
<description>programmer</description>
</inner>
</details>
to view an image on mouse over
<html>
<head>
<TITLE></TITLE>
<link type="text/css" href="new.css" rel="stylesheet" />
<script language="javascript" src="Mouseover.js" type="text/javascript"></script>
<style>
#imageidSet{
font-size: 0.75em;
position: absolute;
display: none;
left: 0px;
top: 0px;
width: 400px;
height: 0px;
z-index: 200;
}
</style>
</head>
<body>
<a href="" alt="" title="">
<img class="searchImg" alt="Asia and Australia on Planet earth" title="" src="background.jpg" onmouseover="showMouseOver('background.jpg','Asia and Australia on Planet earth','Asia and Australia on Planet earth',300,300);" hideMouseOver="hidetrail();" height="73" width="110">
</a>
</body>
</html>
the js file - Mouseover.js
var offsetfrommouse=[15,15]; //image x,y offsets from cursor position in pixels. Enter 0,0 for no offset
var displayduration=0; //duration in seconds image should remain visible. 0 for always.
var currentimageheight = 270; // maximum image size.
if (document.getElementById || document.all){
document.write('<div id="imageidSet">');
document.write('</div>');
}
function gettrailobj(){
if (document.getElementById)
return document.getElementById("imageidSet").style
else if (document.all)
return document.all.trailimagid.style
}
function gettrailobjnostyle(){
if (document.getElementById)
return document.getElementById("imageidSet")
else if (document.all)
return document.all.trailimagid
}
function truebody(){
return (!window.opera && document.compatMode && document.compatMode!="BackCompat")? document.documentElement : document.body
}
function showMouseOver(imagename,title,description,width,height){
if (height > 0){
currentimageheight = height;
}
document.onmousemove=followmouse;
newHTML = '<div style="padding: 5px; background-color: #FFF; border: 1px solid #888;">';
newHTML = newHTML + '<h2>' + title + '</h2>';
newHTML = newHTML + description + '<br/>';
newHTML = newHTML + '<div align="center" style="padding: 8px 2px 2px 2px;">';
newHTML = newHTML + '<img src="' + imagename + '" width="' + width + '" border="0"></div>';
newHTML = newHTML + '</div>';
gettrailobjnostyle().innerHTML = newHTML;
gettrailobj().display="inline";
}
function hideMouseOver(){
gettrailobj().innerHTML = " ";
gettrailobj().display="none"
document.onmousemove=""
gettrailobj().left="-500px"
}
function followmouse(e){
var xcoord=offsetfrommouse[0]
var ycoord=offsetfrommouse[1]
var docwidth=document.all? truebody().scrollLeft+truebody().clientWidth : pageXOffset+window.innerWidth-15
var docheight=document.all? Math.min(truebody().scrollHeight, truebody().clientHeight) : Math.min(window.innerHeight)
if (typeof e != "undefined"){
if (docwidth - e.pageX < 380){
xcoord = e.pageX - xcoord - 400; // Move to the left side of the cursor
} else {
xcoord += e.pageX;
}
if (docheight - e.pageY < (currentimageheight + 110)){
ycoord += e.pageY - Math.max(0,(110 + currentimageheight + e.pageY - docheight - truebody().scrollTop));
} else {
ycoord += e.pageY;
}
} else if (typeof window.event != "undefined"){
if (docwidth - event.clientX < 380){
xcoord = event.clientX + truebody().scrollLeft - xcoord - 400; // Move to the left side of the cursor
} else {
xcoord += truebody().scrollLeft+event.clientX
}
if (docheight - event.clientY < (currentimageheight + 110)){
ycoord += event.clientY + truebody().scrollTop - Math.max(0,(110 + currentimageheight + event.clientY - docheight));
} else {
ycoord += truebody().scrollTop + event.clientY;
}
}
if(ycoord < 0) { ycoord = ycoord*-1; }
gettrailobj().left=xcoord+"px"
gettrailobj().top=ycoord+"px"
}