header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past include("./includes/predefined_vars.php"); include("./includes/connect.php"); include("./includes/var.php"); include("./includes/function.php"); ?>
$search0 = $search[0]; // word
$search1 = $search[1]; // search type
if ($search0 != "") {
$where_clause = "Food_Name like '%$search0%' or Food_NameE like '%$search0%' or Description like '%$search0%' ";
if (($search1 != "") && ($search1 != "searchword")) {
$where_clause .= " and ";
}
}
if ($search1 != "") {
switch ($search1){ // display page image
//--------- select which search type
case "north":
case "ne":
case "central":
case "south":
$field_search = "Part";
$where_clause .= "$field_search like '%$search_word2%'";
break;
case "category";{
$field_search = "Food_category";
$where_clause .= "$field_search like '%$search_select%'"; // search_select form search box
break;}
case "type";{
$field_search = "Food_type ";
$where_clause .= "$field_search like '%$search_select%'"; // search_select form search box
break;}
// case "material";{ // การค้นหาอาหาร ตามวัตถุดิบ ต้องเอาวัตถุดิบไปหา ในสูตร แล้วค่อยไปเอา foodid มา join เอาชื่ออาหาร
// $field_search = "material";
// $where_clause .= "$field_search like '%$search_select%'"; // search_select form search box
// break;}
} // end switch
}
if ($search1 == "material" ) { // การค้นหาอาหาร ตามวัตถุดิบ ต้องเอาวัตถุดิบไปหา ในสูตร แล้วค่อยไปเอา foodid มา join เอาชื่ออาหาร
$query = "SELECT t1.Food_id, t2.Food_id , Ingredient_name , Food_Name , Food_NameE , Part ,Food_category , Food_type , Description , Receipe FROM $table_ingredient as t1 , $table_food as t2 where t1.Ingredient_name = '$search_select' and (t1.Food_id = t2.Food_id) ";
} else {
if ($search1 == "") {
$query = "SELECT Food_id, Part, Food_Name,Food_NameE,Food_category,Food_type,Description , Receipe FROM $table_food";
} else {
$query = "SELECT Food_id, Part, Food_Name,Food_NameE,Food_category,Food_type,Description , Receipe FROM $table_food where $where_clause order by Food_Name";
}
}
//echo $query;
$result = mysql_query( $query , $link );
$nrow = mysql_num_rows($result);
$goto = countpage($nrow,$record_front,$current,$page);
$query = $query. " limit $goto,$record_front";
$result= mysql_query( $query , $link );
//echo $search1 ." " . $search_select . " " . $query ; $totalpage = $nrow/$record_front; $display_search_select = $search_word2.$search_select; $search0 = $search[0]; // word $search1 = $search[1]; // search type $search2 = $search_select; // search select from search box ?>
|