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:

姓名：




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 "
";    
}
?>
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!