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.

Rendering

Search for the record whose name is "place" Rendering

Thoughts

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.

• 1. p CSS (Step 1 at the beginning of the album is introduced to implement user operations. Here we only need to add additional: the style of the search button of the keyword input box)
• 2 , PHP receives parameters MYSQL query
  receives the keyword submitted by the user, assigns it to $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.

• 3. Test Debug modification
  After the entire required function is implemented, simply test it again. Sometimes when you experience the function you made from the user's perspective, you will find different problems. We need to improve it and modify the debug before submitting it to Product acceptance. I believe that if you insist on doing this, this rigorous attitude will bring you unexpected gains.

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.

Complete codeUsed 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 &#39;config.php&#39;;

$page = !empty($_GET[&#39;page&#39;])?intval($_GET[&#39;page&#39;]):1;
$keyword = !empty($_GET[&#39;keyword&#39;])?strip_tags($_GET[&#39;keyword&#39;]):&#39;&#39;;
$pagesize = 1;

// 统计总记录数，便于计算出总页数
if(!empty($keyword)){
    $sql = "SELECT * FROM feedback WHERE name LIKE &#39;%{$keyword}%&#39;";
}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 &#39;%{$keyword}%&#39; 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 id="留言板">留言板</h3>
                <h5 id="LIST">LIST</h5>
            
            <p>
                </p><p>
                </p>

                     关键词：                                  

                                 

                                         
• 姓名： 联系方式： 内容：
                                     

                

                    

                                                 
• >&keyword=">
                                             

                                           

Summary

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!