search process using php and mysql not workingg -
i have search page 3 types of search allow user use searching newest member searching according specialization entering first name , each query display different message , different results
the page display default query only
3 types not work can me ???
member_search.php
<?php // connect database require_once('include/connect.php'); //default message on top of result display $querysrting="where registered_date!='' order registered_date asc "; $querymsg="showing newest oldest memebrs default"; ///if statment distingouich searching if(isset($_post['listbyq']) { if($_post['listbyq']=="newest_members") { $querysrting="where registered_date!='' order registered_date desc " or die(mysql_error()); $querymsg="showing senior oldest memebrs"; } elseif($_post['listbyq']=="by_specialization") { $querysrting="where specialization! = '' order user_id desc" or die(mysql_error()); $querymsg="showing members specs"; } elseif($_post['listbyq']=="by_firstname") { $fname = $_post['fname']; $fname = stripcslashes($fname); $fname = strip_tags($fname); $querysrting="where first_name '%$fname%'"or die(mysql_error()); $querymsg="showing member name searched for"; } } ///******query member data using querystring*******// $sql = mysql_query("select user_id, first_name, last_name, birth_date, registered_date user $querysrting") or die(mysql_error()); //**********************outputlist*********************************// $outputlist=""; while($row = mysql_fetch_array($sql)) { $id=$row['user_id']; $firstname=$row['first_name']; $lastname=$row['last_name']; $birthdate=$row['birth_date']; $registereddate=$row['registered_date']; ////***********for upload image*************************// $check_pic="members/$id/image01.jpg"; $default_pic="members/0/image01.jpg"; if(file_exists($check_pic)) { $user_pic="<img src=\"$check_pic\"width=\"120px\"/>"; } else { $user_pic="<img src=\"$default_pic\"width=\"120px\"/>"; } $outputlist.=' <table width="100%"> <tr> <td width="23%" rowspan="3"><div style="height:120px;overflow:hidden;"><a href = "http://localhost/newadamkhoury/profile.php?user_id='.$id.'" target="_blank">'.$user_pic.'</a></div></td> <td width="14%"><div align="right">name:</div></td> <td width="63%"><a href = "http://localhost/newadamkhoury/profile.php?user_id='.$id.'" target="_blank">'.$firstname.' '.$lastname.'</a></td> </tr> <tr> <td><div align="right">birth date:</div></td> <td>'.$birthdate.'</td> </tr> <tr> <td><div align="right">registered:</div></td> <td>'.$registereddate.'</td> </tr> </table> <hr /> '; }//close while ?> <!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>lam_el_chamel</title> <link href='http://fonts.googleapis.com/css?family=oswald:400,300' rel='stylesheet' type='text/css' /> <link href='http://fonts.googleapis.com/css?family=abel|satisfy' rel='stylesheet' type='text/css' /> <link href="default.css" rel="stylesheet" type="text/css" media="all" /> <!--[if ie 6]> <link href="default_ie6.css" rel="stylesheet" type="text/css" /> <![endif]--> </head> <body> <div id="banner"> <div class="img-border"> <div id="header-wrapper"> <div id="header"> <div id="logo"> <marquee width="80%" behavior="scroll" direction="left" onmouseover="this.stop();" onmouseout="this.start();"> <h1><b>social media</b></h1> </marquee> </div> <?php /*require_once('login.php')*/; ?> </div> </div> <a href="#"><img src="images/web_header copy.jpg" width="1121" height="210" alt="" /></a></div> </div> <div id="wrapper"> <div id="page-wrapper"> <div id="page"> <div id="wide-content"> <table width="94%" height="63"> <tr> <td width="29%"><form id="form1" method="post" action="member_search.php"> browse newest members <input type="submit" name="button" id="button" value="go" /> <input type="hidden" name="listbyq" value="newest_members" /> </form></td> <td width="28%"><form id="form2" name="form2" method="post" action="member_search.php"> search specialization <input type="submit" name="button2" id="button2" value="go" /> <input type="hidden" name="listbyq" value="by_specialization" /> </form></td> <td width="43%"><form id="form3" name="form3" method="post" action="member_search.php"> search firstname <label> <input type="text" name = "fname" id="fname" /> </label> <input type="submit" name="button3" id="button3" value="go" /> <input type="hidden" name="listbyq" value="by_firstname" /> </form></td> </tr> </table> <br /> <table width="70%" align="center"> <tr> <td><?php print "$querymsg"; ?> <br /> <?php print "$outputlist"; ?> </td> </tr> </table> <h2> </h2> </div> </div> </div> </div> </div> <?php /*require_once('footer.php');*/ ?> </body> </html>
your html is:
<input type="hidden" name="listbyq" value="newest_members" /> but php is:
if($_post['listbyq']=="newest_members") the fieldnames aren't matching, because case isn't same; post variable has capitalized 'b'.
you need rename either fields in form or in php both sets match.
Comments
Post a Comment