PHP7Column 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.
Search for the record whose name is "place" Rendering
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)
nbsp;html>列表带搜索功能_留言板_科科分享
留言板
LIST
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!