


PHP query mysql multi-condition judgment output display_PHP tutorial
Jul 13, 2016 am 10:27 AMPHP query mysql multi-condition judgment output display
Background:
Query the output of each field value from mysql and display the field value that meets the condition in red font according to the condition.
Conditions:
1. If the syntime is less than the current time of the previous week, it will be displayed in red.
2. If field A is "None", it will be displayed in red.
3. If the B field is "None", it will be displayed in red.
Figure 1 Database structure:

Values of each field in the database in Figure 2:

My code: (I only satisfied the first condition, and I don’t know how to write the other two conditions)
$sql = "select username, onoff, intime, syntime, device, a,b,person,dtime from cdmobile order by username desc ";
$rst = mysql_query($sql);
while($row=mysql_fetch_array($rst)){
$nowtime=strtotime('+7 day');
$syntime=strtotime($row['syntime']) ;
if($nowtime>=$syntime){
echo "{$row['username']}{$row['onoff']}{$row['intime']}{$row['syntime']}{$row['device']}
>{$row['a']}{$row['b']}{$row['person']}{$row['dtime']}";
}
else
echo "{$row['username']}{$row['onoff']}{$row['intime']}{$row['syntime']}{$row['device']} {$row['a']}{$row['b']}{$row['person']}{$row['dtime']}";
}
Please help me improve the code. To meet the three conditions at the same time and output correctly, the places that should display red will display red. Here are the results so far:

------Solution--------------------
echo "{$row['username']}{$row['onoff']}{$row['intime']}";
if ($nowtime>=$syntime)
echo "{$row['syntime']}";
else
echo "{$row['syntime']}";
echo "{$row['device']}";
if ($row['a' ]== "None")
echo "{$row['a']}";
else
echo "{$row['a']}";
if ($row['b'] == "None")
echo "{$row['b']}";
else
echo "{$row['b']}";
echo "{$row['person']}{$row['dtime']}";
Correction

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

How to fix mysql_native_password not loaded errors on MySQL 8.4
