php为什么搜不到字段,php-通过多个字段搜索.有时一个领域,有时不止一个领域

我有搜索表.在这里多个领域.有时我将使用一个字段提交表单,有时将使用两个字段提交表单,有时使用多个字段值.

if (isset($_POST['search'])) {

$projectName = $_POST['pName'];

$clientId = $_POST['s_by_clientName'];

$departmentId = $_POST['s_by_department'];

$statusName = $_POST['s_by_status'];

if (!empty($projectName))

{

$searchSql = mysql_query("select * from project_list where projectName='$projectName'");

}

if (!empty($clientId))

{

$searchSql = mysql_query("select * from project_list where client_id='$clientId'");

}

if (!empty($departmentId))

{

$searchSql = mysql_query("select * from project_list where department_id='$departmentId'");

}

if (!empty($statusName))

{

$searchSql = mysql_query("select * from project_list where status='$statusName'");

}

}

这些查询仅用于按单个字段搜索.

如何进行按一个或多个字段值执行搜索的查询

可能吗？？

解决方法:

在查询变量中使用串联

$searchSql ="select * from project_list where 1=1 ";

if (isset($_POST['search'])) {

$projectName = $_POST['pName'];

$clientId = $_POST['s_by_clientName'];

$departmentId = $_POST['s_by_department'];

$statusName = $_POST['s_by_status'];

if (!empty($projectName))

{

$searchSql. = " AND projectName='$projectName'";

}

if (!empty($clientId))

{

$searchSql. = " AND client_id='$clientId'";

}

if (!empty($departmentId))

{

$searchSql. = " AND department_id='$departmentId'";

}

if (!empty($statusName))

{

$searchSql. = " AND status='$statusName'";

}

}

$result=mysql_query($searchSql);

注意：mysql_query()在PHP 5.5中已被弃用,在PHP 7中已被删除.请更新以使用PDO的mysqli库.

标签：mysql,php

来源： https://codeday.me/bug/20191118/2030344.html