How to implement conditional query in php

How to implement conditional query in php: first call the previously encapsulated class; then use keyword fuzzy query; then create a form, submit the data to the current page, extract the keyword query; and finally use PHP code Traverse the elements in the table and turn the keywords into red.

Recommended: "PHP Video Tutorial"

1. Single condition Query is a query with only one condition:

1. First call the previously encapsulated class, and then use keywords to fuzzy query:

2. Create a form, submit the data to the current page, and extract the keyword query:

 
姓名： 
 

 

         Copy after login
        
3. Traverse the elements in the table and turn the keywords into red:

        
query($sql); foreach($arr as $v) { $str = str_replace($Sname,"{$Sname}",$v[1]);//用span标签使关键字变为红色， echo "
"; } ?>

         Copy after login
        
Final result:
## 2. Multi-condition query:
1. First make a form and create a table to display the table:

        
 
 
姓名
 
性别
 
班级
 
        
       
       
       
 
{$str}
 
{$v[2]}
 
{$v[4]}
 
        
       
       
       
       
       
       
 
 
代号
 
名称
 
系列
 
上市时间
 
价格
 
 

2. Call the encapsulation class, create corresponding conditions, and check whether the data is empty :

3. Use PHP code to traverse the database table and turn the keywords into red (php should be embedded in the table):

query($sql);foreach($arr as $v) { $str = str_replace($name,"{$name}",$v[1]); echo " {$v[0]} {$str} {$v[2]} {$v[3]} {$v[7]} ";}?>

The final result is:

The above is the detailed content of How to implement conditional query in php. For more information, please follow other related articles on the PHP Chinese website!