Home > Article > Backend Development > PHP7 message board development list search
PHP7 Column introduction Message board development related list search
Free recommendation:PHP7
#When the amount of data increases, it is very difficult to find one of them by just turning the page. This is when you need Using data search, we can instantly find the data we want, either fuzzy search or precise search.
In the [Paging] section, we have already turned pages. Now we add a search box to this list to search.
Get the task If you don’t have a design drawing, you should have a rough idea in your mind. Of course, if you have experience, you can directly code it; if it’s not easy to start, then you can draw one by yourself (paper and pen are indispensable). Everything is ready, just start coding.
$keyword
, and assembles the sql query keyword statement "SELECT * FROM feedback WHERE name LIKE '%{$keyword} %'";
, to execute the sql statement or return the corresponding data to the front desk to present to the user. Note:
name LIKE '%{$keyword}%'"
means to obtain the record set containing$keyword
in the name field, The%
percent signs on both sides refer to matching characters of any type and length, that is, fuzzy search. For precise search, just remove the percent sign.
It is nothing more than the first three steps, complete the task steadily, and see if it is One step closer to becoming a full-stack engineer.
Used in conjunction with the code at the beginning of the course
Friends PHP7 message board development (Step 1)
Friends PHP7 Message Board Development (Step 2)
Friends PHP7 Message Board Development (Step 3)
<?php include 'config.php'; $page = !empty($_GET['page'])?intval($_GET['page']):1; $keyword = !empty($_GET['keyword'])?strip_tags($_GET['keyword']):''; $pagesize = 1; // 统计总记录数,便于计算出总页数 if(!empty($keyword)){ $sql = "SELECT * FROM feedback WHERE name LIKE '%{$keyword}%'"; }else{ $sql = "SELECT * FROM feedback"; } $result = mysqli_query($mysqli, $sql); $total = mysqli_affected_rows($mysqli); $total_page = ceil($total/$pagesize); // 进一法取整获取总页数 // 开始分页查询,根据page计算偏移量 $offset = ($page - 1) * $pagesize; if(!empty($keyword)){ $sql = "SELECT * FROM feedback WHERE name LIKE '%{$keyword}%' LIMIT {$offset}, {$pagesize}"; }else{ $sql = "SELECT * FROM feedback LIMIT {$offset}, {$pagesize}"; } $result = mysqli_query($mysqli, $sql); $lists = array(); while($rows = mysqli_fetch_array($result)){ $lists[] = $rows; } ?> nbsp;html> <meta> <title>列表带搜索功能_留言板_科科分享</title> <!-- 2.新建css样式文件并根据效果图编写css代码 --> <link> <!-- 工作区,呈现给用户看的 --> <!-- 1.开始搭建脚手架 --> <p> </p><p> </p><h3>留言板</h3> <h5>LIST</h5> <p> </p><p> </p>
Keywords: like (like, like... )
Querying the keywords entered by the user is to query the data that the user likes in the database and present it to the user.
At the end of this section, remember to practice frequently and try to write the code by hand.
If there are any errors or doubts in the content Remember to doodle in the comment area below!~
The above is the detailed content of PHP7 message board development list search. For more information, please follow other related articles on the PHP Chinese website!