Mysql Search Output Question

doveroh · #1 (**permalink**) 02-15-05, 08:39 PM

I have a search form that you can either select an item from the drop down box or select "all", how can I search all the lines in mysql with this... Here is my code. when all the select boxes is at ALL it should show all the files in mysql that the user has.

function search($host, $user, $pass, $DBName){
print ("<form method=post action=account.php><input type=hidden name=action value=search2>");
print ("<center><font face=verdana,arial size=2>Search For Classes<P>");
print ("<TABLE WIDTH=800 BORDER=3 CELLSPACING=0 CELLPADDING=0>");

print ("<form action=search.php method=post><TABLE BORDER=1 CELLSPACING=0 CELLPADDING=10>");
print ("<tr>");
print ("<td class=addclassinside>STATUS</td><td><SELECT name=status><OPTION SELECTED>Enrolled<OPTION>Available</select></td></tr><tr>");
print ("<tr>");
print ("<td class=addclassinside>START TIME</td>");
print ("<td><select name=start_hour><option>00 <option>01<option>02<option>03");
print ("<option>04<option>05<option>06<option>07<option> 08<option>09<option>10<option>11");
print ("<option>12<option>13<option>14<option>15<option> 16<option>17");
print ("<option>18<option>19<option>20<option>21<option> 22<option>23</option></select>:");
print ("<select name=start_minute>");
print ("<option>00<option>05<option>10<option>15<option> 20<option>25<option>30<option>35<option>40<option> 45<option>50<option>55 </select></td></tr><tr>");
/*
print ("<td class=addclassinside>END TIME</td><td><select name=end_hour><option>00 <option>01<option>02<option>03<option>04<option>05 <option>06<option>07<option>08<option>09<option>10 <option>11<option>12<option>13<option>14<option>15 <option>16<option>17<option>18<option>19<option>20 <option>21<option>22<option>23</option></select>:<select name=end_minute><option>00<option>05<option>10<opt ion>15<option>20<option>25<option>30<option>35<opt ion>40<option>45<option>50<option>55 ");
print ("</select></td></tr>");
*/
print ("<tr><td class=addclassinside>CLASS</td><td><SELECT name=class><OPTION VALUE=\"*\">ALL");
$Link = mysql_connect ($host, $user, $pass);
$query = "SELECT * FROM classes ORDER BY class";
$result = mysql_db_query($DBName, $query, $Link);
while ($row = mysql_fetch_array($result)){
print ("<OPTION>$row[class]");
}
print ("</select></td></tr><tr>");
print ("<td class=addclassinside>LANGUAGE</td><td><SELECT name=language><OPTION VALUE=\"*\">ALL");
$query = "SELECT * FROM language ORDER BY language";
$result = mysql_db_query($DBName, $query, $Link);
while ($row = mysql_fetch_array($result)){
print ("<OPTION>$row[language]");
}

print ("</select></td></tr>");
print ("<tr>");
print ("<td class=addclassinside>INSTRUCTOR</td><td><SELECT name=instructor><OPTION VALUE=\"*\">ALL");
$query = "SELECT * FROM instructor ORDER BY instructor";
$result = mysql_db_query($DBName, $query, $Link);
while ($row = mysql_fetch_array($result)){
print ("<OPTION>$row[instructor]<br>");

}

print ("</select></td></tr><tr>");
print ("<td class=addclassinside>CLASS ROOM</td><td><SELECT name=room><OPTION VALUE=\"*\">ALL");
$query = "SELECT * FROM room ORDER BY room";
$result = mysql_db_query($DBName, $query, $Link);
while ($row = mysql_fetch_array($result)){
print ("<OPTION>$row[room]<br>");

}
print ("</select></td></tr>");
print ("<tr><TD COLSPAN=3><center><input type=submit name=submit value=FIND CLASS></td></tr>");
print ("</TD></TR><B></table></B></table></form>");

}

function search2($host, $user, $pass, $DBName, $status, $start_hour, $start_minute, $class, $language, $instructor, $room){
// Show search results
search($host, $user, $pass, $DBName);
$membernr = $_SESSION['membernr'];
print ("<center><b>Classes Found</b></center>");
$Link = mysql_connect ($host, $user, $pass);
if ($status == "Enrolled"){

// search for classes that they are already enrolled in
$query = "SELECT * FROM registration where membernr = '$membernr' AND class = '$class' AND instructor = '$instructor' AND room = '$room'";
}
print ("<TABLE WIDTH=800 BORDER=3 CELLSPACING=0 CELLPADDING=0><tr><td>");
print ("<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=10>");
print ("<tr><td valign=center align=center><b>Day</b></td><td valign=center align=center><b>Class Start</b></td><td valign=center align=center><b>Class Ends</b></td><td valign=center align=center><b>Class Name</b></td><td valign=center align=center><b>Class Room</b></td><td valign=center align=center><b>Language</b></td><td valign=center align=center><b>Instructor</b></td><td valign=center align=center><b>Book Class</b></td>");

$result = mysql_db_query($DBName, $query, $Link);
while ($row = mysql_fetch_array($result)){
$month_name = date('M', $row[date]);
$day_name = date('d', $row[date]);
$year_name = date('Y', $row[date]);
print ("<tr><td>$day_name-$month_name-$year_name</td></tr>");

}
print ("</table></table>");
}