[Resolved] search script by 2 or more parameters - mySQL database

taya

Hello,

I adapted a search script for mySQL databse (members of the site)
by age.

Now I want to add a 2nd parameter ( and may be more later),
but it's really seems hard now.

can you help me please or point to a good script?

here's the code of search.php:

PHP Code:

<? 

include ("page.php" )  ; 

$content= ''; 
$content= '<table width="100%" border="10" 
cellspacing="0" cellpadding="0"> 


                <tr> 
                    <td> '; 



if (!IsSet($page)) 
{ 
$page=1 ; 
} 

$ads_pro_page = 2 ; 
$ads_on_page = 2 ; 

$start_num = ($page-1)* $ads_pro_page ;   

$end_num = $start_num + $ads_pro_page ; 

//ECHO ($start_num); 
//ECHO ($end_num) ; 

$stampmebaby =getdate(time()) ; 
$day= $stampmebaby[mday] ; 
$month=$stampmebaby[mon] ; 
$year=$stampmebaby[year] ; 
//echo ($month."-".$day."-".$year) ; 




// convert Age1 and Age2 to date 
// find out what the age is 
$stampmebaby =getdate(time()) ; 
$day= $stampmebaby[mday] ; 
$month=$stampmebaby[mon] ; 
$year=$stampmebaby[year] ; 

$year1=$year-$Age1  ; 

$year2=$year-$Age2 ; 

$checkage="(( bday<='$day' 
AND bmonth<='$month' AND byear='$year1' ) 
OR (  byear<'$year1' )) AND 
(( bday<='$day' AND bmonth<='$month' 
AND byear='$year2' ) 
OR (  byear>'$year2' ))"   ; 



  require_once ("mysql_connect.php" ); 


$query="SELECT * FROM members, photos 
WHERE ".$checkage." AND member.members=photos.friendID 
AND small='y' 
order by friendID desc"; 
$result = mysql_query($query) 
     or die(mysql_error()); 



$n = 1 ; 

while ($row = mysql_fetch_array($result) ) 
{ 
// find out what the age is 
$stampmebaby =getdate(time()) ; 
$day= $stampmebaby[mday] ; 
$month=$stampmebaby[mon] ; 
$year=$stampmebaby[year] ; 
//echo ($month."-".$day."-".$year) ; 
$age_year= $year-$row[byear]   ; 
$age=$age_year      ; 
//echo($row[byear]) ; 

if ($month>=$row[bmonth] AND $day>=$row[bday]) 
$age=$age_year      ; 
else 
$age=$age_year-1 ; 

if ( $n>$start_num and $n<=$end_num) 
{ 

$content .= ' 
        </td></tr> 
        <tr><td> 



                    <br> 
<table width="90%" border="0" cellspacing="5" cellpadding="5"> 
  <tr align="left" width="40%"> 
    <td align="center"><br>&nbsp;&nbsp; 
    <img src="' . $row['photo'] . '" border="0" alt="' . $row['FirstName'] . '"> 
    <br><b>&nbsp;&nbsp;'.$row['FirstName'].'</b>&nbsp;&nbsp;Age: '.$age.'<br> 
    <A href="profile.php?personalID='.$row['friendid'].'">About Me Page</A><br> 


</td></tr> 


</table> 




'; 



} 
else 
{ 
echo("" ) ; 
} 

$n = $n + 1 ; 

} 

$total_records = mysql_num_rows($result) ; 
//echo ($total_records) ; 
$number_pages = 1 + $total_records / $ads_pro_page ; 


$aarrgghh1=urlencode($Age1); 
$aarrgghh2=urlencode($Age2); 



$c = 1 ; 
while ($c <= $number_pages) 
{ 
$content.='<table width="100%" border="0" cellspacing="0" cellpadding="0"> 
<tr><TD>'; 
echo("<a HREF=\"$PHP_SELF?Age1=$aarrgghh1&Age2=$Age2&page=$c\">$c</a></td> 
</tr></table>" ); 
$c = $c + 1 ; 
} 



  $homepage = new Page(); 


  $homepage -> SetContent($content);    

    $homepage->Display(); 
?>

THANK YOU IN ADVANCE!

taya

Hello,

i almost resolved my problem

here's the code:





<?

include ("page.php")  ;
require_once ("mysql_connect.php"); 
 $content=""; 


   {  function Display()
 {
    echo "<html>\n<head>\n";
    $this -> DisplayTitle();
    $this -> DisplayKeywords();
	$this -> DisplayContentdescription();
    $this -> DisplayStyles();
    echo "</head>\n<body
 cellspacing=0 cellpadding=0 leftmargin=0
 rightmargin=0 topmargin=0 marginheight=0 
marginwidth=0>\n";
    $this -> DisplayHeader();
    $this -> DisplayMenu($this->buttons);

echo $this->content;
$this -> DisplayFooter();
echo "</body>\n</html>\n";
  }
}

$stampmebaby =getdate(time()) ;
$day= $stampmebaby[mday] ;
$month=$stampmebaby[mon] ;
$year=$stampmebaby[year] ;
//echo ($month."-".$day."-".$year) ;




// convert Age1 and Age2 to date
// find out what the age is
$stampmebaby =getdate(time()) ;
$day= $stampmebaby[mday] ;
$month=$stampmebaby[mon] ;
$year=$stampmebaby[year] ;

$year1=$year-$Age1  ;

$year2=$year-$Age2 ;

$checkage="(( bday<='$day'
 AND bmonth<='$month' AND byear='$year1' ) 
OR (  byear<'$year1' ))
 AND 
(( bday<='$day' AND bmonth<='$month'
 AND byear='$year2' ) 
OR (  byear>'$year2' ))"   ;





$a = "0" ;  

 $content .='<table width="100%"
 border="0" cellspacing="0" cellpadding="0">'; 

$query="SELECT * FROM members, photos 
WHERE ".$checkage." AND
 member.members=photos.friendID 
AND small='y' 
AND 2nd_parameter= '".$_REQUEST['2nd_parameter']."'
order by friendID desc";  

$result = mysql_query($query)  

 or die(mysql_error());  





while ($row = mysql_fetch_array($result) )  {

if (($a==0)||($a%4)==0) {$content .='</tr><tr>'; }


$content.='<td align="center">
<BR><BR><br><a
 href="profile.php?personalID='.$row['friendid'].' ">

 <img src="'.$row['photo'].'" border=0
 alt="' . $row['FirstName'] . '"></a><br>
<br><b>' . $row['FirstName'] . '</b> <br> 
Birthdate: '.$row['birthday'].'<br>'; 
$a = $a +1; 

}

$content.='</table>';



 $homepage = new Page();
 $homepage -> SetContent($content);   

  $homepage->Display();
?>

the only thing is that in the search page
when i choose neither 2nd_parameter1
nor 2nd_parameter2
but option"Any" - no results

and i would like to show all results in
case someone chooses
"Any" in his/her search

CAN SOMEONE HELP IN THIS?

<? 
require_once ("page.php"); 



$content= ''; 
$content .= ' 
    <table width="100%" 
align="center" bgcolor="white" border="0" 
cellspacing="0" cellpadding="20"> 
                                 <td> 
                        <br> 
                   <form action="searchthem.php" method="GET"> 

                        <p class="header">Search </p>


                        From: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="text" size="3" name="Age1" value="18"> 
                       To: <input type="text" size="3" name="Age2" 
value="99"> 
                            <BR><BR> 

					2nd_parameter:  
 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
							<select name="2nd_parameter">
<option value="Any">
Any

<option value="1" >2nd_parameter1
<option value="2" >2nd_parameter2


</select>


<br><br>



<button type="submit" value="Search"> 
Search</button>
                        </form> 
                                                                 </td> 
                    </tr> 
                </table>  '; 

   $homepage = new Page();


  $homepage -> SetContent($content);   

    $homepage->Display();
?>

taya

i've done it a few days ago, just my comp was down 🙁

so i think it might be useful for some newbies like me.

here's the code


<?

include ("page.php")  ;
require_once ("mysql_connect.php"); 
 $content=""; 


$a = "0" ;  

 $content .='<table width="100%" border="0" cellspacing="0" cellpadding="0">'; 



$2ndparameter =@$_REQUEST['2ndparameter'];

if ($2ndparameter == 'Any') {
$query="SELECT * FROM friends, photos 
WHERE ".$checkage." 
AND friendid=photos.friendid
AND small='y' 
order by friendid";

}

else{
 $check2ndparameter  = $2ndparameter ;
 //echo $check2ndparameter ;
 $query="SELECT * FROM friends, photos 
WHERE ".$check2ndparameter ." 
AND friendid=photos.friendsid 
AND small='y' 
AND 2ndparameter ='".$check2ndparameter ."'
order by friendid ";
 }



$result = mysql_query($query)
     or die(mysql_error());




$rows = mysql_num_rows($result);  

if($rows > 0) {  

while ($row = mysql_fetch_array($result) )  {

if (($a==0)||($a%4)==0) {$content .='</tr><tr>'; }


$content.='..........
<br><b>' . $row['FirstName'] . '</b> <br> Birthdate: '.$row['birthday'].'<br>'; 
$a = $a +1; 

}
}  

else {  

    $content.='<tr><td align="center"><br><br><br>No results found. <br>
	Please return back and try again
	with different parameters.</td></tr>';
}  

$content.='</table>';
mysql_close($db);  

...
?>

the only thing that embarrrases me - what if later i'll add a 3rd parameter? 🙂