I am new to PHP. When writing the content of the search box, I found that I cannot query multiple conditions at the same time. Could anyone please give me some ideas on how to write it? I am grateful for
# This is the pHP content written below:
& LT *) as total from tb_file where f_type=1"; //Find published content
$sql = mysqli_query($conn,$inquire);
$result = mysqli_fetch_assoc($sql ; #
Pagination class
! How to query multiple conditions at the same time$inquireCon = "select * from tb_file where f_qualitynum like '%$fileNum%' or f_filename like '%$fileName%' or f_department='$department' or f_classify='$qualityfile' order by f_date desc limit ".$page->limit()."";
$sqlCon = mysqli_query($conn, $inquireCon);
while($resultCon = mysqli_fetch_assoc($sqlCon)){
?>
}
}
?>
Let’s see if something like this works. This is how tp is written. For native, use splicing. I haven’t written native for a long time.
According to the data obtained, if it is not empty, the splicing conditions will be fine.
Upvote it, if you know anything, I hope you can help me. grateful