【PHP教程】PHP模糊查询事例代码

wangy · 发表于 2021-6-20 21:50:23

<?php
2 V$ ]4 B, i. ]
header("content-type:text/html;charset=utf-8");
& \4 M( P0 l! z2 N0 J
//获取用户数据1 c7 P. p8 j a( c0 |, t
$keywords=$_POST['keywords'];8 N$ j, u5 j( e( f9 V( J
//连接数据库( Y; c5 V2 f' y
$conn=@mysql_connect('localhost','root','') or die('数据库链接失败');
% W' \' ]2 {9 K Y
//选择数据库，设置字符集
; P/ F2 d: d) J. }! g1 x. ?
mysql_select_db('search');
7 ?- {. o+ Q2 o
mysql_set_charset('utf8');
6 k+ K4 e$ j. R+ B0 ^1 P) c5 J
//php模糊查询
* b; r4 S/ @/ b7 c1 W5 x: E1 \
if(empty($keywords)){/ L9 y* z$ i7 P1 _% n$ ~ R
$str= "请输入要查询的内容";& {" O7 x2 k; ~, B. ~9 o6 z
}else{. L1 W& R: Z) B0 O4 B) r
$sql="SELECT * FROM user WHERE username LIKE '%$keywords%'";, L; B4 u! G/ A* f3 r6 R g; {
}
% Z, o6 c3 N! }; u* j
$rs=mysql_query($sql);
( i2 a7 ]! |; s/ O1 u; G
$users = array();
* ^2 \8 f0 N* I
while($row=mysql_fetch_assoc($rs)){
; A& A, k. p; K# p' a
//高亮替换% r, K. f6 b" X0 k
$row['username'] = str_replace($keywords, '<font color="red">'.$keywords.'</font>', $row['username']);! ?* @8 E, j# Q: O: i) }, q
$users[] = $row;
$ G& F- [$ q5 H. I& N$ I
}
7 P* w' Z ^! W1 `1 w3 _' T( a$ z
//print_r($users);
6 P, {( _2 F$ A `- o8 b y
?>
+ E6 v' \2 P3 k% `8 D; |& r: o
<!DOCTYPE html>( c* T$ Z$ c. w6 u% M# \( y& g
<html>7 Q2 P+ f: k6 Z8 ? P
<head>
" w! `& E3 I: {4 O6 D& ]
<meta charset="UTF-8">
E A' w: B O
<title>php模糊查询</title>
+ B; D+ Y& X4 w8 w
</head>
4 x0 T: R/ W' Y0 V( o
<body>+ b5 d3 A: [# J( @6 d2 ~
<h1>php模糊查询器之用户查询</h1>
; X( J6 A0 \ n& p6 Q) m6 b
<form action="" method="post">9 K' r/ B. r m& o
用户名：<input type="text" name="keywords" placeholder="请输入查询内容"/> <input type="submit" value="提交查询"/>
# z6 D9 Y: A6 q
</form>( P4 V6 d+ a( q; _" o8 j. v
<?php
/ ?7 i+ g$ C( e5 N1 l
if($keywords){
$ d( X, I3 ]8 w, X
echo '<h3>查询关键字 <font color="red"> '.$keywords.' </font>结果是：</h3>';& V. C: w ]- c, x3 T; T2 N
if($users){1 O- A9 P* S( H7 x" E! _* o
echo "<table width='500px' border='1px' cellpadding='3px' cellspacing=0>";
8 L' S7 ?" E g$ `
echo "<tr bgcolor='#ddd'><th>UID</th><th>用户名</th><th>性别</th><th>邮箱</th><th>兴趣爱好</th></tr>";
$ \% f& \# l2 v) E8 I
foreach ($users as $key => $value){% p4 S1 b( u7 C& W5 ~6 @6 }
echo "<tr>";
' S% s" x4 P( K+ _2 @, } ]
echo "<td>".$value['uid']."</td>";
9 h, l- ^) e$ H
echo "<td>".$value['username']."</td>";
: D% ^! t- _$ u+ B
echo "<td>".$value['sex']."</td>";. {8 E- v7 i2 L! `8 e5 a) W8 ?; L
echo "<td>".$value['email']."</td>";- c. h1 h. C2 Y. F5 c: `/ u
echo "<td>".$value['hobby']."</td>";' h9 r3 G; [- b
echo "</tr>";# P+ e( g) e6 }2 s
}8 ]; l- e3 W8 D7 a) m
echo "</table>";
0 m0 g# F7 J" h; f; U- m6 H- c
}else {
( y3 h3 M4 f7 @
echo "没有查询到相关用户";( H9 F( m, x4 f# x+ G1 C
}( d# ?% t1 s5 k& z' K; `! o7 y
}else{
/ `: @- x3 {% Y A
echo "<h4> <font color='red'>".$str."</font></h4><br/>";
3 O$ h+ ^* d: C, D1 w
}# E9 ^: y7 h1 s; _
?>
4 s5 \. z2 N. }+ H" P% m8 g
</body>5 h& E( w, V7 C5 U
</html>7 T1 z. e$ v) v. o

复制代码

[PHP教程] 【PHP教程】PHP模糊查询事例代码

荣誉管理

论坛元老