php實現搜尋功能代碼

本文主要和大家分享php實現搜尋功能代碼，主要以文字和代碼跟大家講解，希望能協助到大家。

/********一個簡單的搜尋*****///將搜尋語句加到最開始的查詢語句裡面；從而實現了代碼的精簡$news_sql = "SELECT * from books where 1=1 ".$searchAddSql." order by book_number ";// $searchAddSql最開始是為空白的，如果使用者輸入了搜尋條件，$searchAddSql就會變成一個包涵查詢語句的字串：//先判定使用者是否輸入了搜尋條件if(isset($_GET["searchText"])){$searchText = $_GET["searchText"];$searchAddSql = $searchAddSql." and (book_number like '%".$searchText."%' or book_name like '%".$searchText."%'or book_sum like '%".$searchText."%'or book_author like '%".$searchText."%')";}//最開始的$news_sql = "SELECT * from books where 1=1 ".$searchAddSql." order by book_number ";就會變成：$news_sql="SELECT * from books where 1=1 and (book_number like '%中%' or book_name like '%中%' or book_sum like '%中%' or book_author like '%中%' ) order by book_number"；//相當於重設了查詢語句，從而達到搜尋的目地