But there is a problem I wants to pass multiple values through ajax and wants to get result back.
I am posting the code here.The main file is Search.php which is communicating with SearchDetails through search.js . please try to understand and help me.
Search.php
Code: Select all
<?php
include_once('../classes/Connection.php');
$db='mis_paacce';
$obj=new Connection;
$con=$obj->connect();
mysql_select_db($db,$con) or die(mysql_error());
$query1="select name,city from frenchisie_details";
$query2="select DISTINCT college from visa_status_details";
$query3="select DISTINCT course from visa_status_details";
$query4="select DISTINCT country from visa_status_details";
$result1=mysql_query($query1);
$result2=mysql_query($query2);
$result3=mysql_query($query3);
$result4=mysql_query($query4);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>PAACCE Intranet</title>
<script type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<style type="text/css">
<!--
a:link {color: #0000ff;}
a:visited {color: #0000FF;}
a:active {color: #FF0000;}
a:hover {background-color: #ffffff;}
a {text-decoration: none;}
-->
</style>
<LINK REL=StyleSheet HREF="../css/calendar.css" TYPE="text/css">
<SCRIPT type="text/javascript" SRC="../js/weeklycalendar.js">
</SCRIPT>
<script type="text/javascript">
buildWeeklyCalendar(1);
</script>
<script type="text/javascript" src="../js/search.js"></script>
</head>
<body>
<form action="" method="post">
<table width="583" height="140" border="0" cellpadding="0" cellspacing="0" align="center">
<tr>
<td colspan="4" align="center" bgcolor="#BBBBBB">Search Cases</td>
</tr>
<div id="setCases">
<tr>
<td>Frenchisie</td>
<td><select name="frenchisie" id="frenchisie">
<option value="all" selected="selected">All</option>
<?php
while($row=mysql_fetch_row($result1))
{
?>
<option value="<?php echo $row[1]; ?>"><?php echo $row[0]." (".$row[1].")"; ?></option>
<?php
}
?>
</select></td>
<td width="73">College</td>
<td width="146"><select name="college" id="college">
<option value="all" selected="selected">All</option>
<?php
while($rorw1=mysql_fetch_row($result2))
{
?>
<option value="<?php echo $row1[0];?>"><?php echo $row1[0]; ?></option>
<?php
}
?>
</select></td>
<td><div id="txtCollege"></div></td>
</tr>
<tr>
<td>Country</td>
<td><select name="country" id="country">
<option value="all" selected="selected">All</option>
<?php
while($row4=mysql_fetch_row($result4))
{
?>
<option value="<?php echo $row4[0]?>"><?php echo $row4[0]; ?></option>
<?php
}
?>
</select></td>
<td>Courses</td>
<td><select name="course" id="course">
<option value="all" selected="selected">All</option>
<?php
while($row2=mysql_fetch_row($result3))
{
?>
<option value="<?php echo $row2[0]; ?>"><?php echo $row2[0]; ?></option>
<?php
}
?>
</select></td>
</tr>
</div>
<tr>
<td width="153">From</td>
<td width="211"><input name="fromDate" type="text" id="fromDate" readonly="readonly" />
<a href="#" onClick="w_displayDatePicker('fromDate');"><img src="../images/cal.gif" /></a>
</td>
<td></td><td></td>
</tr>
<tr>
<td>To</td>
<td><input name="toDate" type="text" id="toDate" readonly="readonly" />
<a href="#" onClick="w_displayDatePicker('toDate');"><img src="../images/cal.gif" /></a></td>
<td></td><td></td>
</tr>
<tr>
<td></td>
<td><input type="button" value="Find" name="find" onClick="searchStrings(document.getElementById('frenchisie').value,document.getElementById('college').value,document.getElementById('country').value,document.getElementById('course').value,document.getElementById('fromDate').value,document.getElementById('toDate').value);" /></td>
<td></td><td></td>
</tr>
</table>
</form>
<hr />
<div id="search">
<table width="297" height="180" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="239"><a href="#" onclick="MM_openBrWindow('totalEnquiries.php','Enquiries','scrollbars=yes,width=600,height=700')">Total Enquiries</a></td>
<td width="268"> </td>
</tr>
<tr>
<td><a href="#" onclick="MM_openBrWindow('registeredEnquiries.php','registred','scrollbars=yes,width=600,height=700')">Registered Enquiries</a></td>
<td> </td>
</tr>
<tr>
<td><a href="#" onclick="MM_openBrWindow('docPending.php','Pending','scrollbars=yes,width=600,height=700')">Documents Pending</a></td>
<td> </td>
</tr>
<tr>
<td><a href="#" onclick="MM_openBrWindow('docRecieved.php','Recieved','scrollbars=yes,width=660,height=700')">Documents Recieved</a></td>
<td> </td>
</tr>
<tr>
<td><a href="#" onclick="MM_openBrWindow('offerLetter.php','letter','scrollbars=yes,width=660,height=700')">Offer Letter Recieved</a></td>
<td> </td>
</tr>
<!-- <tr><td><input name="offLetter" type="radio" value="rev" checked="checked" />
Letter Recieved</td><td><input name="offLetter" type="radio" value="notRev" />
Not Recieved</td></tr>-->
<tr>
<td><a href="#" onclick="MM_openBrWindow('visaApplied.php','VisaApplied','scrollbars=yes,width=675,height=700')">Visa Applied</a></td>
<td> </td>
</tr>
<tr>
<td><a href="#" onclick="MM_openBrWindow('visaGranted.php','VisaGranted','scrollbars=yes,width=675,height=700')">Visa Granted</a></td>
<td> </td>
</tr>
</table>
</div>
</body>
</html>
search.js
// JavaScript Document
var xmlhttp;
function searchStrings(frenchisie,college,country,course,fromDate,toDate)
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}
var url="SearchDetails.php";
url=url+"?fren="+frenchisie+"&coll"+college+"&count"+country+"&cour"+course+"&from"+fromDate+"&to"+toDate;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
function stateChanged()
{
if (xmlhttp.readyState==4)
{
document.getElementById("search").innerHTML=xmlhttp.responseText;
}
}
function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
{
// code for IE7+, Firefox, Chrome, Opera, Safari
return new XMLHttpRequest();
}
if (window.ActiveXObject)
{
// code for IE6, IE5
return new ActiveXObject("Microsoft.XMLHTTP");
}
return null;
}
SearchDetails.php
<?php
$query='';
$frenchisie=$_REQUEST['fren'];
$college=$_REQUEST['coll'];
$country=$_REQUEST['count'];
$course=$_REQUEST['cour'];
$fDate=$_REQUEST['from'];
$tDate=$_REQUEST['to'];
$sDate='14-Oct-09';
$curDate=date('d-M-y');
include_once('../classes/Connection.php');
$db='mis_paacce';
$obj=new Connection;
$con=$obj->connect();
mysql_select_db($db,$con) or die(mysql_error());
if($toDate=='' || $toDate==null && $fromDate=='' || $fromDate==null)
{
if($frenchisie=='all' && $college=='all' && $country=='all' && $course=='all')
{
$query="select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd";
}
else
{
if($frenchisie=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where vs.regNo=pd.regNo and vs.college='%s' and vs.cousre='%s' and vs.country='%s'",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($country));
}
else if($college=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where frenchisieCode='%s' and cousre='%s' and country='%s'",mysql_real_escape_string($frenchisie),mysql_real_escape_string($course),mysql_real_escape_string($country));
}
else if($country=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and cousre='%s' and frenchisieCode='%s'",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($frechisie));
}
else if($course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and frenchisieCode='%s' and country='%s'",mysql_real_escape_string($college),mysql_real_escape_string($frenchisie),mysql_real_escape_string($country));
}
}
}
else if($toDate=='' || $toDate==null)
{
if($frenchisie=='all' && $college=='all' && $country=='all' && $course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($sDate),mysql_real_escape_string($curDate));
}
else
{
if($frenchisie=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where vs.regNo=pd.regNo and vs.college='%s' and vs.cousre='%s' and vs.country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($country),mysql_real_escape_string($sDate),mysql_real_escape_string($curDate));
}
else if($college=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where frenchisieCode='%s' and cousre='%s' and country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($frenchisie),mysql_real_escape_string($course),mysql_real_escape_string($country),mysql_real_escape_string($sDate),mysql_real_escape_string($curDate));
}
else if($country=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and cousre='%s' and frenchisieCode='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($frenchisie),mysql_real_escape_string($sDate),mysql_real_escape_string($curDate));
}
else if($course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and frenchisieCode='%s' and country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($frenchisie),mysql_real_escape_string($country),mysql_real_escape_string($sDate),mysql_real_escape_string($curDate));
}
}
}
else if($fromDate=='' || $fromDate==null)
{
if($frenchisie=='all' && $college=='all' && $country=='all' && $course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else
{
if($frenchisie=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where vs.regNo=pd.regNo and vs.college='%s' and vs.cousre='%s' and vs.country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($country),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else if($college=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where frenchisieCode='%s' and cousre='%s' and country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($frenchisie),mysql_real_escape_string($course),mysql_real_escape_string($country),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else if($country=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and cousre='%s' and frenchisieCode='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($frenchisie),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else if($course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and frenchisieCode='%s' and country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($frenchisie),mysql_real_escape_string($country),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
}
}
else
{
if($frenchisie=='all' && $college=='all' && $country=='all' && $course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else
{
if($frenchisie=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where vs.regNo=pd.regNo and vs.college='%s' and vs.cousre='%s' and vs.country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($country),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else if($college=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where frenchisieCode='%s' and cousre='%s' and country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($frenchisie),mysql_real_escape_string($course),mysql_real_escape_string($country),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else if($country=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and cousre='%s' and frenchisieCode='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($course),mysql_real_escape_string($frenchisie),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
else if($course=='all')
{
$query=sprintf("select DISTINCT vs.regNo,vs.frenchisiCode,vs.applicationDate,vs.country,vs.offLetterDate,pd.fName,pd.lName,pd.passport,pd.inquiryDate,pd.dob,fd.name,fd.state from visa_status_details vs,personal_details pd,frenchisie_details fd where college='%s' and frenchisieCode='%s' and country='%s' and pd.inquiryDate IN ('%s','%s')",mysql_real_escape_string($college),mysql_real_escape_string($frenchisie),mysql_real_escape_string($country),mysql_real_escape_string($fDate),mysql_real_escape_string($tDate));
}
}
}
$result=mysql_query($query);
echo "<table width='297' height='180' border='0' align='center' cellpadding='0' cellspacing='0'>
<tr>
<td width='239'><a href='#' onclick='MM_openBrWindow(totalEnquiries.php?result=$result,Enquiries,scrollbars=yes,width=600,height=700)'>Total Enquiries</a></td>
<td width='268'> </td>
</tr>
<tr>
<td><a href='#' onclick='MM_openBrWindow(registeredEnquiries.php?result=$result,registred,scrollbars=yes,width=600,height=700)'>Registered Enquiries</a></td>
<td> </td>
</tr>
<tr>
<td><a href='#' onclick='MM_openBrWindow(docPending.php?result=$result,Pending,scrollbars=yes,width=600,height=700)'>Documents Pending</a></td>
<td> </td>
</tr>
<tr>
<td><a href='#' onclick='MM_openBrWindow(docRecieved.php?result=$result,Recieved,scrollbars=yes,width=660,height=700)'>Documents Recieved</a></td>
<td> </td>
</tr>
<tr>
<td><a href='#' onclick='MM_openBrWindow(offerLetter.php?result=$result,letter,scrollbars=yes,width=660,height=700)'>Offer Letter Recieved</a></td>
<td> </td>
</tr>
<!-- <tr><td><input name='offLetter' type='radio' value='rev' checked='checked' />
Letter Recieved</td><td><input name='offLetter' type='radio' value='notRev' />
Not Recieved</td></tr>-->
<tr>
<td><a href='#' onclick='MM_openBrWindow(visaApplied.php?result=$result,VisaApplied,scrollbars=yes,width=675,height=700)'>Visa Applied</a></td>
<td> </td>
</tr>
<tr>
<td><a href='#' onclick='MM_openBrWindow(visaGranted.php?result=$result,VisaGranted,scrollbars=yes,width=675,height=700)'>Visa Granted</a></td>
<td> </td>
</tr>
</table>";
?>