Home >Backend Development >PHP Tutorial >How to implement query function in php
This article mainly introduces the query function and data access in PHP, which has certain reference value. Interested friends can refer to it
The specific content is as follows
Enter keyword effect
Code:
<body>
<h1>汽车信息</h1>
<?php
require"DBDA.class1.php";//$type 代表SQL语句的类型，0代表增删改，1代表查询
$db = new DBDA();
//如果没有提交数据，显示所有
//如果有提交数据，根据关键字查询显示
$name = "";
$tj1 = " 1=1 ";//第一个条件，对应名称，注意空格
$tj2 = " 1=1 ";//第二个条件，对应系列，注意空格
if(!empty($_POST["name"]))
{
$name = $_POST["name"];
$tj1 = " name like '%{$name}%'";
}
if(!empty($_POST["brand"]))
{
$brand = $_POST["brand"];
$tj2 = " brand like '%{$brand}%'";
}
//总条件
$tj ="{$tj1} and {$tj2}";
$sql = "select * from car where ".$tj;//注意where后空格
/*echo $sql;*/
?>
<form action="chaxun.php" method="post">
<p>名称：<input type="text" name="name" value="<?php echo $name ?>"/>系列：<input type="text" name="brand"/><input type="submit" value="查询" /></p>
</form>
<br/>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>代号</td>
<td>名称</td>
<td>系列</td>
<td>上市时间</td>
<td>价格</td>
</tr>
<?php
//只适用于单条件查询
/*$sql = "select * from car";
$name="";
if(!empty($_POST["name"]))
{
$name = $_POST["name"];
$sql = "select * from car where name like '%{$name}%' ";
}*/
$arr = $db->query($sql);
foreach($arr as $v)
{
$str = str_replace($name,"<span style='color:red'>{$name}</span>",$v[1]);
echo "<tr>
<td>{$v[0]}</td>
<td>{$str}</td>
<td>{$v[2]}</td>
<td>{$v[3]}</td>
<td>{$v[7]}</td>
</tr>";
}
?>
</table>
</body>
</html>
referenced Encapsulation class
<?php
class DBDA
{
public $host = "localhost";
public $uid = "root";
public $pwd = "123";
public $dbname = "newssystem";
//执行SQL语句返回相应的结果
//$sql 要执行的SQL语句
//$type 代表SQL语句的类型，0代表增删改，1代表查询
function query($sql,$type=1)
{
$db = new MySQLi($this->host,$this->uid,$this->pwd,$this->dbname);
$result = $db->query($sql);
if($type)
{
//如果是查询，显示数据
return $result->fetch_all();
}
else
{
//如果是增删改，返回true或者false
return $result;
}
}
}
Related recommendations:
Related knowledge about php mysql fuzzyquery function
ajax implements paging and Detailed explanation of the steps of paging Query function
The above is the detailed content of How to implement query function in php. For more information, please follow other related articles on the PHP Chinese website!