- 论坛徽章:
- 0
|
在PHP中执行
switch($sql)
{
case !is_null($search_type_first_name) & is_null($search_type_main_phone); //只输入名字,不输入电话的查询
$sql="select * from person_info_basic where first_name like '%".$search_type_first_name."%' ";
break;
case !is_null($search_type_first_name) & !is_null($search_type_main_phone); //名字和电话同时输入后查询
$sql="select * from person_info_basic where first_name like '%".$search_type_first_name."%' and main_phone='$search_type_main_phone' ";
break;
case is_null($search_type_first_name) and !is_null($search_type_main_phone); //只输入电话的查询
$sql="SELECT * FROM person_info_basic WHERE main_phone = '$search_type_main_phone'";
break;
}
$result=mysql_query($sql);
执行后无法按照上述条件输出结果集,我用嵌套的switch办法可以实现这个功能(如下),但想请教大侠们,如果我为了图省事,不想用嵌套的办法,我能不能像上面所写的那样,对$sql这个变量进行直接判断?
switch($search_type_first_name)
{
case !is_null($search_type_first_name):
switch($search_type_main_phone)
{
case is_null($search_type_main_phone):
$sql="select * from person_info_basic where first_name like '%".$search_type_first_name."%' ";
break;
case !is_null($search_type_main_phone):
$sql="select * from person_info_basic where first_name like '%".$search_type_first_name."%' and main_phone='$search_type_main_phone' ";
break;
}
break;
case is_null($search_type_first_name):
switch($search_type_main_phone)
{
case is_null($search_type_main_phone):
echo "Sorry, Please Enter the searching conditions!";
break;
case !is_null($search_type_main_phone):
$sql="SELECT * FROM person_info_basic WHERE main_phone = '$search_type_main_phone'";
break;
}
break;
}
$result=mysql_query($sql);
[ 本帖最后由 kkboy_dyc 于 2008-7-23 06:18 编辑 ] |
|