PHP query mysql multi-condition judgment output display_PHP tutorial

PHP 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

http://www.bkjia.com/PHPjc/820406.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/820406.htmlTechArticlephp query mysql multi-condition judgment output display background: query the value of each field from mysql and display it in red font according to the conditions The field value satisfies the condition. Conditions: 1.syntime is less than the current...