HTML Code
<tr>
<td><input type="text" size="15" name="lfname" id="lfname" /></td>
<td><input type="text" size="15" name="llname" id="llname" /></td>
<td><input type="text" size="15" name="lcom" id="lcom" /></td>
<td><input type="text" size="15" name="lwophone" id="lwophone" /></td>
<td><input type="text" size="15" name="lmob" id="lmob" /></td>
<td><input type="text" size="15" name="lemail" id="lemail" /></td>
<td><input type="button" name="lsearch" id="lsearch" class="lsearch" value="search" /></td>
</tr>
jqery code
$(".lsearch").click(function(){
if($("#lfname").length)
{
var lfname=$("#lfname").val();
var data="lfname="+lfname;
$.ajax({
type:"POST",
url:"ajax/search.php",
data:data,
success:function(abc)
{
$res=abc.split("/");
if($res[0]==1)
{
window.location.href="showleads?forces="+$res[1];
}
else
{
}
}
});
}
if($("#llname").length)
{
var llname=$("#llname").val();
var data="llname="+llname;
$.ajax({
type:"POST",
url:"ajax/search.php",
data:data,
success:function(abc)
{
$res=abc.split("/");
if($res[0]==1)
{
window.location.href="showleads?forces1="+$res[1];
}
else
{
}
}
});
}
if($("#lcom").length)
{
var lcom=$("#lcom").val();
}
});
search.php
if(isset($_REQUEST['lfname']))
{
$lfname=$_REQUEST['lfname'];
$ans=$obj->select("le_fname,le_lname,le_comp,le_work_ph,le_mobile,le_email","leads","le_fname='$lfname'");
if($ans=="0")
{
echo 0;
}
else
{
$searchcond2=$lfname;
echo "1"."/".$searchcond2;
}
}
else if(isset($_REQUEST['llname']))
{
$llname=$_REQUEST['llname'];
$ans=$obj->select("le_fname,le_lname,le_comp,le_work_ph,le_mobile,le_email","leads","le_lname='$llname'");
if($ans=="0")
{
echo 0;
}
else
{
$searchcond3=$llname;
echo "1"."/".$searchcond3;
}
}
showleads.php
if(isset($_REQUEST['forces']))
{
$name=$_REQUEST['forces'];
//echo $name;
$ans1=$obj->select("*","leads","le_fname='$name' ORDER BY le_id desc");
?>
<tr align="center">
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td> <a href="#" class="table-icon assign" title="Assign" id="<?php echo $val1[0]; ?>"></a>
<a href="editlead?id=<?php echo $val1[0]; ?>" class="table-icon edit" title="Edit"></a>
<a href="#" class="table-icon delete" title="Delete" id="<?php echo $val1[0]; ?>"></a></td>
</tr>
=$_REQUEST[=$obj-select("*","leads","le_lname='$lname' ORDER BY le_id desc");
?>
<tr align="center">
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td> <a href="#" class="table-icon assign" title="Assign" id="<?php echo $val1[0]; ?>"></a>
<a href="editlead?id=<?php echo $val1[0]; ?>" class="table-icon edit" title="Edit"></a>
<a href="#" class="table-icon delete" title="Delete" id="<?php echo $val1[0]; ?>"></a></td>
</tr>