PHP實(shí)現(xiàn)關(guān)鍵字搜索后描紅功能示例

!DOCTYPE html>
html>
head>
  meta charset="utf-8">
  meta http-equiv="X-UA-Compatible" content="IE=edge">
  title>/title>
  link rel="stylesheet" href="">
/head>
body>
form action="14.php" method="post">
  請(qǐng)輸入關(guān)鍵字：input type="text" name="keyword">
  input type="submit" value="提交" />
/form>
?php
  if(!empty($_POST['keyword'])){
    $keyword = $_POST['keyword'];//獲取輸入的關(guān)鍵字
    //進(jìn)行數(shù)據(jù)庫連接
    $conn = mysql_connect("localhost","root","1234");
    if(!$conn){
      die("數(shù)據(jù)庫連接失敗");
    }
    $flag = mysql_select_db("book",$conn);
    if(!$flag){
      die("數(shù)據(jù)庫打開失敗");
    }
    mysql_query("set names utf8");
    $sql = "select * from book where name like '%$keyword%' or description like '%$keyword%'";
    $result = mysql_query($sql,$conn);
    while($row = mysql_fetch_assoc($result)){
?>
div style="width:300px;height:100px;background-color: #ccc;margin-bottom: 10px">
  p>書名：?php echo str_ireplace($keyword, "font color='#f00'>$keyword/font>",$row['name'])?>/p>
  p>描述：?php echo str_ireplace($keyword, "font color='#f00'>$keyword/font>",$row['description'])?>/p>
/div>
?php
  }
}else{
  echo "很遺憾，沒有找到書籍";
}
?>
/body>
/html>