How to handle display of data from database using a condition in PHP?

Question

I have a table named account.

Table: account

+---------+---------------------+-----------+
| user_id | email               | u_name    |
+---------+---------------------+-----------+
|      63 | [email protected]     | Pross     |
|      64 | [email protected]       | Pross     |
|      73 | [email protected]    | Victorss  |
|      74 | [email protected] | Ifecosss  |
+---------+---------------------+-----------+

But I want to change all the display u_name into "No" from my table whose u_name = "Pross" in my page like this:

+---------+---------------------+-----------+
| user_id | email               | u_name    |
+---------+---------------------+-----------+
|      63 | [email protected]     | No        |
|      64 | [email protected]       | No        |
|      73 | [email protected]    | Victorss  |
|      74 | [email protected] | Ifecosss  |
+---------+---------------------+-----------+

But my code here replaces all the rows with "No". Seems like the placement of my condition is wrong. Here's my code in php to fetch data from database.

<!--############# TABLE CONTENT ##############-->
<tbody>
<?php 
while($row = mysql_fetch_array($s1)) {
    # Columns from DB
    $db_id = $row['user_id'];
    $db_email = $row['email'];
    $db_uname = $row['u_name']; 

    # Condition to handle display of u_name row
    if($db_uname == "Pross") {
        $db_uname_edit = "No";
    }
?>

<tr>
    <td><?php echo $db_id ?></td>
    <td><?php echo $db_email ?></td>
    <td><?php echo $db_uname_edit ?></td>
</tr>
<?php } ?>

</tbody>
<!--##########################################-->

But the unwanted output of this is :

+---------+---------------------+-----------+
| user_id | email               | u_name    |
+---------+---------------------+-----------+
|      63 | [email protected]     | No        |
|      64 | [email protected]       | No        |
|      73 | [email protected]    | No        |
|      74 | [email protected] | No        |
+---------+---------------------+-----------+

Why ? Can anybody help me with my code above ? Thanks

v2solutions.com · Accepted Answer · 2015-01-20 07:01:10Z

4

You should set the value of $db_uname_edit to $db_uname in else part:

if($db_uname == "Pross") {
    $db_uname_edit = "No";
} else {
    $db_uname_edit = $db_uname;
}

answered Jan 20, 2015 at 7:01

v2solutions.com

1,4399 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vick · Accepted Answer · 2015-01-20 06:59:21Z

1

# Condition to handle display of u_name row
if($db_uname == "Pross") {
    $db_uname_edit = "No";
}
else {
    $db_uname_edit = $db_uname;
}

This should work.

And here is the shortened edition, you won't need an if clause:

<td><?php echo $db_uname == 'Pross' ? 'No' : $db_uname ?></td>

answered Jan 20, 2015 at 6:59

Vick

2872 silver badges8 bronze badges

Comments

Vladimir Drenovski · Accepted Answer · 2015-01-20 07:11:57Z

0

change your "if" statement to:

 if($db_uname === "Pross") {
        $db_uname_edit = "No";
    }

when compareing strings you should use the "===" operator instead of "=="

answered Jan 20, 2015 at 7:11

Vladimir Drenovski

245 bronze badges

Comments

Girish · Accepted Answer · 2015-01-20 07:20:54Z

0

you need to add else part in if condition if condition not matched then code goto else condition

if($db_uname == "Pross") {
    $db_uname_edit = "No";
} else {
    $db_uname_edit = $db_uname;
}

OR better user ternary operator to reduce code

$db_uname_edit = $db_uname == "Pross" ? "No" : $db_uname;

And You can do this in DB query, that would be good for performance

select user_id, email, IF(u_name = 'Pross', 'No', u_name) AS u_name FROM account

answered Jan 20, 2015 at 7:20

Girish

12.1k3 gold badges37 silver badges54 bronze badges

Collectives™ on Stack Overflow

How to handle display of data from database using a condition in PHP?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related