BR
asked on
mysql php if statement sql sentence
Dear Experts,
would it be correct to write it like this?
if (!empty($name))
{
$sqlsentence. = " and Name like '" . $name . "%'"
}
if (!empty($gender))
{
$sqlsentence. = " and Gender like '" . $gender . "%'"
}
if (!empty($gender))
{
$sqlsentence. = " and City like '" . $city . "%'"
}
$sqlsentence= "SELECT * FROM Mytable where 1=1";
$mysqlsentence= "SELECT * FROM Mytable where 1=1" . $sqlsentence . ";
would it be correct to write it like this?
if (!empty($name))
{
$sqlsentence. = " and Name like '" . $name . "%'"
}
if (!empty($gender))
{
$sqlsentence. = " and Gender like '" . $gender . "%'"
}
if (!empty($gender))
{
$sqlsentence. = " and City like '" . $city . "%'"
}
$sqlsentence= "SELECT * FROM Mytable where 1=1";
$mysqlsentence= "SELECT * FROM Mytable where 1=1" . $sqlsentence . ";
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER