How to multiple search by the one word


<?php  

   
  if ( $_POST["funSearch"] != ""  )
 
     {
      $cond='';

  if  ( $_POST["name"]  != ""  )
      {
    $cond .=" and  firstname like '%". $_POST["name"] ."%' " ;
$_SESSION["nam"]=$_POST["name"];
  }
  else
  {
   $_SESSION["nam"]="";
  }
 
   if  ( $_POST["mobile"]  != ""  )
      {
    $cond .=" and  mobile1 like '%". $_POST["mobile"] ."%' " ;
  $_SESSION["mob"]=$_POST["mobile"];
  }
  else
  {
   $_SESSION["mob"]="";
  }
 
   if  ( $_POST["address"]  != ""  )
      {
    $cond .= " and  address1 like '%". $_POST["address"] ."%' ";
   $_SESSION["add"]= $_POST["address"];
  }
  else
  {
   $_SESSION["add"]="";
  }
 
   if  ( $_POST["city"]  != ""  )
      {
    $cond .=" and  city like '%". $_POST["city"] ."%' " ;
 $_SESSION["cit"]=$_POST["city"];
   }
else
{
$_SESSION["cit"]="";
}
 
    if  ( $_POST["state"]  != ""  )
      {
    $cond .=" and  state like '%". $_POST["state"] ."%' " ;
 $_SESSION["sta"]=$_POST["state"];
   }
else
{
$_SESSION["sta"]="";
}

 if  ( $_POST["email"]  != ""  )
      {
    $cond .=" and  email1 like '%". $_POST["email"] ."%' " ;
 $_SESSION["ema"]=$_POST["email"];
   }
else
{
$_SESSION["ema"]="";
}
 
 
 
  $searchquery="SELECT * FROM `contact` where  firstname <> ''  " ;
  if ( $cond  != "" )
    {
   $searchquery=$searchquery . $cond ;
    }
// $searchquery1=$searchquery . " ORDER BY ID desc LIMIT $StartRow,$PageSize ";
// $searchquery=$searchquery . "   ORDER BY  ID desc ";
     
//echo  $searchquery;
 
   //$TRecord = mysql_query($searchquery);


$result = mysql_query($searchquery);

 }


 else
 {

$result = mysql_query("SELECT * FROM `contact` where cat_id ='0'");

       }



//Total of record
//  $RecordCount = mysql_num_rows($TRecord);

//Set Maximum Page
// $MaxPage = $RecordCount % $PageSize;
//// if($RecordCount % $PageSize == 0){
// $MaxPage = $RecordCount / $PageSize;
// }else{
// $MaxPage = ceil($RecordCount / $PageSize);
// }
?>
----------------------call this by on click search---------------------------------------------
<input  type="hidden"   name="funSearch" value="1">
     <input type="submit" name="Search" value="Search" />

Comments

Post a Comment

Popular Posta

How to enable .htaccess in wamp server

Image
How to enable .htaccess in wamp server In this article,I will explain how  to enable  . htaccess  in wamp server. 1 .  Open wamp_server   (Go to  Wamp  -> Right click at icon in the taskbar=>  Apache =>  httpd.conf ) 2.Edit httpd.conf file. 3 . Just remove the # sign before the  LoadModule  rewrite_module modules/mod_rewrite.so  4 .  Save  the file .Mod Rewriting is enabled. 5.Restart the Server (Go to  Wamp  -> Right click at icon in the taskbar=>  Restart All services ) 6 . Now Create new file. Copy and paste the following code in it. Options +FollowSymLinks RewriteEngine On 7 .Save it as  .htaccess  in the root directory. 8 .Done. We have successfully enabled .htaccess in Wamp server.
Read more

Web Scraping Amazon with PHP

This snippet of PHP code demonstrates web scraping. It reads a sample page from Amazon.com, compares the HTML text against certain class name and outputs that matched text in an RSS feed.  <?php  $now   = date("D, d M Y H:i:s T"); $ASIN  = $url = $img = $title = $bio = $name = ""; $head = '<?xml version="1.0" encoding="ISO-8859-1"?>'; $head .= '<rss version="2.0">'; $head .= '<channel>'; $head .= '<title>Amazon </title>'; $head .= '<link>http://www.amazon.com</link>'; $head .= '<description>Amazon RSS Feed</description>'; $url = "http://www.amazon.com/Best-Sellers-Kindle-Store/zgbs/digital-text/"; $text = file_get_html($url); foreach ($text->find("div.zg_item_compact") as $class) {   foreach ($class->find('strong.price') as $price) {     if ($price->plaintext == "Free...
Read more

Disable right click script and Google Instant Map Search

<!DOCTYPE html created my solomon  > <html>     <head>         <meta name="viewport" content="initial-scale=1.0, user-scalable=no"/>         <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>         <title>Google Instant Map Search | spixup- demo </title>         <style type="text/css">             #map_canvas{                 height: 400px;                 width: 500px;                 margin: 5px auto;             }      </style>     </head>     <body> <SCRIPT TYPE="text/javascript"> //-------------Disable right click script ------------ //visit http://www.rainbow.arch.scr...
Read more