Click here to Skip to main content
15,902,112 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HTML Code

XML
<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

JavaScript
$(".lsearch").click(function(){
				/*************** lfname start *************/
				if($("#lfname").length)
				{
					var lfname=$("#lfname").val();
					var data="lfname="+lfname;
					//alert(data);
					$.ajax({
						type:"POST",
						url:"ajax/search.php",
						data:data,
						success:function(abc)
						{
							//alert(res);
							$res=abc.split("/");
							//alert($res);
							 if($res[0]==1)
				{
					window.location.href="showleads?forces="+$res[1];
					/*window.open('searchvendor?forces='+$res[1],'Vendor Search','width=800,height=500');*/
					
				}
				else
				   {
					   //alert("Please enter the First name");
				   }
						}
						   
						   });
				}
				/*************** lfname end *************/
				
				/*************** llname start *************/
				if($("#llname").length)
				{
					var llname=$("#llname").val();
					var data="llname="+llname;
					//alert(data);
					$.ajax({
						type:"POST",
						url:"ajax/search.php",
						data:data,
						success:function(abc)
						{
							//alert(res);
							$res=abc.split("/");
							//alert($res);
							 if($res[0]==1)
				{
					window.location.href="showleads?forces1="+$res[1];
					/*window.open('searchvendor?forces='+$res[1],'Vendor Search','width=800,height=500');*/
					
				}
				else
				   {
					   //alert("Please enter the last name");
				   }
						}
						   
						   });
				}
				/*************** llname end *************/
				if($("#lcom").length)
				{
					var lcom=$("#lcom").val();
					//alert(lcom);
				}
										 });


search.php

PHP
/*************** lname leads search page start *********/
if(isset($_REQUEST['lfname']))
{
$lfname=$_REQUEST['lfname'];
//echo $lfname;
$ans=$obj->select("le_fname,le_lname,le_comp,le_work_ph,le_mobile,le_email","leads","le_fname='$lfname'");


//print_r($ans);

if($ans=="0")
{
    echo 0;
}
else
{
    $searchcond2=$lfname;
      echo "1"."/".$searchcond2;
    //echo 1;
}
}
/*************** lname leads search page end *********/
/*************** llname leads search page start *********/
else if(isset($_REQUEST['llname']))
{
$llname=$_REQUEST['llname'];
//echo $lfname;
$ans=$obj->select("le_fname,le_lname,le_comp,le_work_ph,le_mobile,le_email","leads","le_lname='$llname'");


//print_r($ans);

if($ans=="0")
{
    echo 0;
}
else
{
    $searchcond3=$llname;
      echo "1"."/".$searchcond3;
    //echo 1;
}
}
/*************** lname leads search page end *********/


showleads.php

XML
if(isset($_REQUEST['forces']))
                {
                    $name=$_REQUEST['forces'];
                //echo $name;
                $ans1=$obj->select("*","leads","le_fname='$name' ORDER BY le_id desc");
                ?>


                <?php
                foreach($ans1 as $val1)
                {?>
                    <tr align="center">
    <td><?php echo $val1[3] ?></td>
     <td><?php echo $val1[4]; ?></td>
    <td><?php echo $val1[2]; ?></td>
    <td><?php echo $val1[7]; ?></td>
    <td><?php echo $val1[8]; ?></td>
    <td><?php echo $val1[6]; ?></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>
                <?php }
                }
                if(isset($_REQUEST['forces1']))
                {
                    $lname=$_REQUEST['forces1'];
                //echo $name;
                $ans1=$obj->select("*","leads","le_lname='$lname' ORDER BY le_id desc");
                ?>


                <?php
                foreach($ans1 as $val1)
                {?>
                    <tr align="center">
    <td><?php echo $val1[3] ?></td>
     <td><?php echo $val1[4]; ?></td>
    <td><?php echo $val1[2]; ?></td>
    <td><?php echo $val1[7]; ?></td>
    <td><?php echo $val1[8]; ?></td>
    <td><?php echo $val1[6]; ?></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>
                <?php }
                }
Posted
Updated 16-Jul-14 21:48pm
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900