Kata kunci carian pertanyaan pembangunan PHP bertukar warna
Kata kunci bertukar warna
Dalam bahagian sebelumnya, kami pada asasnya telah menyelesaikan cara mencari kata kunci Seterusnya, kami akan mencantikkan paparan carian.
Tambahkan kod berikut pada pernyataan pertanyaan kabur
$row['username'] = str_replace($keywords,'<font color="red">'.$keywords.'</font>',$row['username']);
Maksudnya ialah menggantikan kata kunci pertanyaan dalam nama pertanyaan dengan fon merah.
<?php
$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
$conn = @mysql_connect("localhost", "root", "root") or die("數(shù)據(jù)庫鏈接錯誤");
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;
}
}
?>Dengan cara ini, pencarian kami pada asasnya selesai.
Paparan kod penuh
<?php
$keywords = isset($_GET['keywords']) ? trim($_GET['keywords']) : '';
$conn = @mysql_connect("localhost", "root", "root") or die("數(shù)據(jù)庫鏈接錯誤");
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>
