Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Feb 2006
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool Free search script download

    is there anywhere i can get a free search script download??

  • #2
    fci
    fci is offline
    Senior Coder
    Join Date
    Aug 2004
    Location
    Twin Cities
    Posts
    1,345
    Thanks
    0
    Thanked 0 Times in 0 Posts
    could you be more clear about what you are asking.
    what do you want it to search?
    have you tried looking here?
    http://www.hotscripts.com/PHP/Script...ams/index.html

    you are too vague for me to be of any real help to you(yet).

  • #3
    New Coder
    Join Date
    Feb 2006
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool

    Quote Originally Posted by fci
    could you be more clear about what you are asking.
    what do you want it to search?
    have you tried looking here?
    http://www.hotscripts.com/PHP/Script...ams/index.html

    you are too vague for me to be of any real help to you(yet).
    search data from 4 tables in a database. like table 1, table 2 and table 3 have a common field with table4. select some info from tables 1,2, and 3 that has a common field linked to table4

  • #4
    fci
    fci is offline
    Senior Coder
    Join Date
    Aug 2004
    Location
    Twin Cities
    Posts
    1,345
    Thanks
    0
    Thanked 0 Times in 0 Posts
    unlikely you'd find what you were looking for on the web, i'd suggest writing it yourself or post the create syntax for the tables so we can post queries you could use (at least that's how much I'd be willing to help).
    Last edited by fci; 02-14-2006 at 03:20 PM.

  • #5
    New Coder
    Join Date
    Feb 2006
    Posts
    64
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cool need help in searching data from 3 tables

    Quote Originally Posted by fci
    unlikely you'd find what you were looking for on the web, i'd suggest writing it yourself or post the create syntax for the tables so we can see post queries you could use (at least that's how much I'd be willing to help).
    Code:
    <?php 
    
    if (isset($_POST['submit']))
    {
      search_query();
      
    }else{
      search_form();
    } 
    
    function search_form()
    {
    ?>
    	<html> 
    	<style type="text/css"> 
    	<!-- 
    	.style1 { 
    	color: #FF6600; 
    	font-weight: bold; 
    	font-family: Verdana; 
    	} 
    	.style4 {font-family: Arial, Helvetica, sans-serif} 
    	--> 
    	</style> 
    	<bodY> 
    	<form method="POST" action="<?php echo $_SERVER['PHP_SELF'];?>"> 
    	 <table width="430" border="0" cellpadding="0"> 
    	   <tr> 
    	     <td width="350"><span class="style1"><u>Search</u></span></td> 
    	     <td width="74">&nbsp;</td> 
    	   </tr> 
    	   <tr> 
    	     <td><span class="style4">Member Code: 
    	       <input type="text" name="Code"> 
    	       <br> 
    	     </span></td> 
    	   </tr> 
    	   <tr> 
    	     <td><span class="style4">Member Name: 
    	       <input type="text" name="Name">        
    	       </span></td> 
    	   </tr> 
    	   <tr> 
    	     <td><span class="style4">Organisation Name: 
    	       <input type="text" name="orgName"> 
    	     </span></td> 
    	     
    	   </tr>
    	   <tr><td colspan='2' align='center'><input type="SUBMIT" name='submit' value="Search"></td> </tr>
    	 </table> 
    	</form> 
    	</bodY> 
    	</html> 
    
    <?php
    }//end function 
    
    function search_query()
    {
    // PHP Search Script 
    include("db.php"); 
    
    // connect to db 
    $db = mysql_connect($dbhost, $dbusername, $dbpassword); 
    mysql_select_db($dbname,$db); 
    
    //initialize vars
    $Code = '';
    $Name = '';
    $orgName = '';
    
    if (!empty($_POST['Code'])) {$Code =$_POST['Code'];    }
    if (!empty($_POST['Name'])) {$Name =$_POST['Name'];    }
    if (!empty($_POST['orgName'])) {$orgName =$_POST['orgName'];    }
    
    if(($Code != '') || ($Name != '') || ($orgName != ''))
    { 
      //build the query with the requested info 
      $search_query1 = "select m.memCode, m.memName, c.clientName 
    					from member as m left outer join  client as c on m.clientCode = c.clientCode";  
    				
      $search_query2 = 	"select n.nmCode, n.nmName, c.clientName 
    					from nonmember as n left outer join  client as c on n.clientCode = c.clientCode"; 
    					
      $search_query3 = "select ni.nimCode, ni.nimName, c.clientName 
    					from nimember as ni left outer join  client as c on ni.clientCode = c.clientCode";	
    				   
      if($Code != ''){    
      $search_query1 .= " and m.memCode  like '%$Code%' "; 
      $search_query2 .= " and n.nmCode  like '%$Code%' "; 
      $search_query3 .= " and ni.nimCode  like '%$Code%' ";  }
      
      if($Name != ''){   
      $search_query1 .= " and m.memName like '%$Name%' ";
      $search_query2 .= " and n.nmName like '%$Name%' ";
      $search_query3 .= " and ni.nimName like '%$Name%' "; }
      
      if($orgName != ''){ 
      $search_query1 .= " and c.clientName  like '%$orgName%' ";  
      $search_query2 .= " and c.clientName  like '%$orgName%' ";  
      $search_query3 .= " and c.clientName  like '%$orgName%' "; }  
      
      $search_query = '(' . $search_query1 . ') UNION ('. $search_query2 . ') UNION (' . $search_query3 . ')';
      
      //run the query
      $search = mysql_query($search_query,$db) or die (mysql_error());
        
      if (mysql_num_rows($search)>0)
      {
      	while(list ($CodeResult, $NameResult, $orgNameResult)=mysql_fetch_array($search))
    	{ 
          echo "<font color= #ff6600><u><b>Search Results</b></u>";
    	  echo "<table width=500 border=1 cellpadding=0>"; 
    	  echo "</tr bgcolor=#ff9900>";
    	  echo "</tr>";
    	  echo "<td bgcolor = #ff9900><b>Member Code</b>";
    	  echo "<td bgcolor = #ff9900><b>Name</b>";
    	  echo "<td bgcolor = #ff9900><b>Organisation</b>";
    	  echo "</tr>";
    	  echo "<td> $CodeResult";
    	  echo "<td> $NameResult";
    	  echo "<td> $orgNameResult";
    	  echo "</table>";
    	  echo "<br><br>";
      	  
    	} 
      }
      else
      {
        //no results from search
        echo "<font color=red>*No results found matching your criteria of [ member code = $Code";
    	if (!empty($Code)) { echo ",member code = $Code ";}
    	if (!empty($Name)) { echo ", member name = $Name "; }
    	if (!empty($orgName)) { echo ", org name = $orgName";  }
    	echo "]</font>";
      } 
    
    }else{
      //call the search form again and pop up an alert box to tell the user to choose an option
      search_form();
      die("<script language='javascript'>alert('Enter Member Code at the very least!');</script>");
    }
    }//end function
    
    ?>
    this code here is works. but just that, it wont select the data if i type in for danny for example. it will populate data from all 3 tables. how can it be changed so that when i type danny, all dannys will be selected from the tables?

    please kindly assist. i need it urgently...
    Last edited by cheryl; 02-14-2006 at 04:40 PM. Reason: URGENT


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •