求PHP搜索代码。下拉选项的。
答案:1 悬赏:80
解决时间 2021-01-13 14:02
- 提问者网友：沉默菋噵
- 2021-01-12 14:04
求PHP搜索代码。下拉选项的。
最佳答案
- 二级知识专家网友：梦中风几里
- 2021-01-12 15:04
$link = mysql_connect("localhost","mysql_user","mysql_password");
$db_selected = mysql_select_db("my_db",$link);
$value = $_POST['typeid'];
$text = $_POST['keyword'];
switch($value){
case "":
$sql = "SELECT * FROM table WHERe 'bianhao' LIKE '%" . $text . "%'";
break;
case 1:
$sql = "SELECt * FROM table WHERe 'name' LIKE '%" . $text . "%'";
break;
case 2:
$sql = "SELECt * FROM table WHERe 'dizhi' LIKE '%" . $text . "%'";
break;
case 3:
$sql = "SELECt * FROM table WHERe 'riqi' LIKE '%" . $text . "%'";
break;
default:
break;
}
$res = mysql_query($sql,$link);
print_r(mysql_fetch_array($res));
mysql_close($link);
?>
日期如果是记录时间戳的形式就得另写，可以在前端写一个日期选择器。追问给弄个全的吧
$db_selected = mysql_select_db("my_db",$link);
$value = $_POST['typeid'];
$text = $_POST['keyword'];
switch($value){
case "":
$sql = "SELECT * FROM table WHERe 'bianhao' LIKE '%" . $text . "%'";
break;
case 1:
$sql = "SELECt * FROM table WHERe 'name' LIKE '%" . $text . "%'";
break;
case 2:
$sql = "SELECt * FROM table WHERe 'dizhi' LIKE '%" . $text . "%'";
break;
case 3:
$sql = "SELECt * FROM table WHERe 'riqi' LIKE '%" . $text . "%'";
break;
default:
break;
}
$res = mysql_query($sql,$link);
print_r(mysql_fetch_array($res));
mysql_close($link);
?>
日期如果是记录时间戳的形式就得另写，可以在前端写一个日期选择器。追问给弄个全的吧
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息！
大家都在看
推荐信息