mysql mysqli怎么查看_mysqli数据查询

无标题文档

查询数据

请输入汽车名称:

代号

名称

系列

油耗

价格

$tj = " 1=1 ";//做了一个恒成立的条件

$name = "";

if(!empty($_POST)){

$name = $_POST["name"];

$tj = " name like '%{$name}%'";

}

$db=new MySQLi("localhost","root","123","ceshi");

$sql = "select * from car where {$tj}";

echo $sql;

$relsut=$db->query($sql);

if($relsut){

$arr = $relsut->fetch_all();

foreach($arr as $v){

$v[1];$name;

$carname = str_replace($name,"{$name}",$v[1]);

echo "

{$v[0]}{$carname}{$v[2]}{$v[4]}{$v[7]}";

}

}

?>

多条件查询

无标题文档

查询数据

请输入汽车名称:

请输入系列代号:

代号

名称

系列

油耗

价格

$tj = " 1=1 ";//做了一个恒成立的条件

$tj2 = " 1=1 ";

$name = "";

if(!empty($_POST["name"])){

$name = $_POST["name"];

$tj = " name like '%{$name}%' ";

}

if(!empty($_POST["brand"])){

$brand = $_POST["brand"];

$tj2 = " brand = '{$brand}' ";

}

$db=new MySQLi("localhost","root","123","ceshi");

$sql = "select * from car where {$tj} and {$tj2}";

echo $sql;

$relsut=$db->query($sql);

if($relsut){

$arr = $relsut->fetch_all();

foreach($arr as $v){

echo "

{$v[0]}{$v[1]}{$v[2]}{$v[4]}{$v[7]}";

}

}

?>