PHP development query search keywords change color
Keyword color change
In the previous section, we have basically completed how to search for keywords. Next, we will beautify the search display.
Add the following code to the fuzzy query statement
$row['username'] = str_replace($keywords,'<font color="red">'.$keywords.'</font>',$row['username']);
What it means is to replace the query keywords in the query name with red fonts.
<?php
$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
$conn = @mysql_connect("localhost", "root", "root") or die("數(shù)據(jù)庫鏈接錯(cuò)誤");
mysql_select_db("sql", $conn);
mysql_query("set names 'utf8'"); //使用utf-8中文編碼;
//PHP模糊查詢
$sql="SELECT * FROM user WHERE username LIKE '%{$keywords}%'";
$rs= mysql_query($sql);
$users = array();//保存所以得查詢到的用戶
if(!empty($keywords)){
while ($row=mysql_fetch_assoc($rs)){
$row['username'] = str_replace($keywords,'<font color="red">'.$keywords.'</font>',$row['username']);
$users[] = $row;
}
}
?>In this way, our search is basically completed.
Complete code display
<?php
$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
$conn = @mysql_connect("localhost", "root", "root") or die("數(shù)據(jù)庫鏈接錯(cuò)誤");
mysql_select_db("sql", $conn);
mysql_query("set names 'utf8'"); //使用utf-8中文編碼;
//PHP模糊查詢
$sql="SELECT * FROM user WHERE username LIKE '%{$keywords}%'";
$rs= mysql_query($sql);
$users = array();//保存所以得查詢到的用戶
if(!empty($keywords)){
while ($row=mysql_fetch_assoc($rs)){
$row['username'] = str_replace($keywords,'<font color="red">'.$keywords.'</font>',$row['username']);
$users[] = $row;
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>查詢器</title>
<style>
.textbox {
width: 355px;
height: 40px;
border-radius: 3px;
border: 1px solid #e2b709;
padding-left: 10px;
}
.su {
width: 365px;
height: 40px;
background-color: #7fbdf0;
color: white;
border: 1px solid #666666;
}
table{ background-color: #7fbdf0; line-height:25px;}
th{ background-color:#fff;}
td{ background-color:#fff; text-align:center}
</style>
</head>
<body >
<form action="" method="get">
<p><input type="text" name="keywords" value="" placeholder="請輸入內(nèi)容"/>
<p><input type="submit" value="查詢"/>
</form>
<?php
if ($keywords){
echo '<h3>查詢關(guān)鍵詞：<font color="red">'.$keywords.'</font></h3>';
}
if ($users){
echo '<table width="500" cellpadding="5" >';
echo '<tr><th>用戶名</th><th>密碼</th><th>郵箱</th><th>性別</th><th>愛好</th>';
foreach ($users as $key=>$value){
echo '<tr>';
echo '<td>'.$value['username'].'</td>';
echo '<td>'.$value['password'].'</td>';
echo '<td>'.$value['sex'].'</td>';
echo '<td>'.$value['email'].'</td>';
echo '<td>'.$value['hobby'].'</td>';
echo '</tr>';
}
}else{
echo '沒有查詢到相關(guān)用戶';
}
?>
</body>
</html>
