php数据库模糊查询

最新推荐文章于 2023-11-22 15:31:30 发布

原创最新推荐文章于 2023-11-22 15:31:30 发布 · 1.5k 阅读

4 ·

CC 4.0 BY-SA版权

php 专栏收录该内容

4 篇文章

订阅专栏

php中的格式，q是html穿过来的参数

$sql="SELECT * FROM zy WHERE name like '%".$q."%'";

一般格式

$sql="SELECT * FROM zy WHERE name like '%猫%'";

这样例如 name为黑猫，黑猫警长的数据都会被查询到
完整php代码

<?php
$q =($_GET['q']);
echo "$q";
$con = mysqli_connect('rm-2ze19853tg90d442jao.mysql.rds.aliyuncs.com:3306','root','13821280093aA','ziyuan');
if (!$con) {
    die('Could not connect: ' . mysqli_error($con));
}

$sql="SELECT * FROM zy WHERE name like '%".$q."%'";
$result = mysqli_query($con,$sql);

echo "<table>";
while($row = mysqli_fetch_array($result)) {
    echo "<tr><th>CustomerID</th><td>" . $row['id'] . "</td></tr>";
    echo "<tr><th>CompanyName</th><td>" . $row['name'] . "</td></tr>";
    echo "<tr><th>ContactName</th><td>" . $row['show'] . "</td></tr>";
    echo "<tr><th>link</th><td>" . $row['link2'] . "</td></tr>";
    echo "<tr><th>link</th><td>" . $row['link3'] . "</td></tr>";
	  echo "<tr><th>link</th><td>" . $row['link'] . "</td></tr>";
  
}
echo "</table>";
mysqli_close($con);
?>