Home Backend Development PHP Tutorial PHP query mysql multi-condition judgment output display_PHP tutorial

PHP query mysql multi-condition judgment output display_PHP tutorial

Jul 13, 2016 am 10:27 AM
mysql php judgment exhibit show condition Inquire background output

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:

php查询mysql 多条件判断输出展示  帮客之家

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

www.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...
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

CakePHP Date and Time

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

CakePHP Project Configuration

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

CakePHP File upload

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

CakePHP Routing

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

Discuss CakePHP

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

CakePHP Quick Guide CakePHP Quick Guide Sep 10, 2024 pm 05:27 PM

CakePHP Quick Guide

See all articles