How do i echo a variable that has a conditional statement using PHP?

Question

Im having a bit of an issue right now with my PHP code. So first of all, I have a MySQL database where I have some data stored, and I'm retrieving that data and displaying it on a page using PHP. Here's the code so I can better describe my problem:

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "my_database";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * FROM sample";
$result = $conn->query($sql);

if ($result->num_rows > 0) {


 // output data of each row
 while($row = $result->fetch_assoc()) {
     echo "<span class='infoTitle'>Now:</span>".$row["now"]."<br>".
"<span class='infoTitle'>Status:</span> ".$row["status"]."<br>";

if (trim($row["now"] == 1)) {echo "Yes";} if(trim($row["now"] == 0)) {echo "";}
if ($row["status"] == 3) {echo "Open";} if($row["status"] == 2) {echo "Closed";}

}

}


 else {
     echo '<h2 class="noInfo">Whoops! Looks like there is currently no information available.</h2>';
}

$conn->close();
?>

So the problem I am having is with the Conditional Statements. I have input hidden in the php page where this information is coming from that will input the values of the hidden field into MySQL. So what the code is currently displaying in my browser is something like this:

Now: 1
Status: 3
YesOpen

But what I'm trying to get it to do is this

Now: Yes
Status: Open

I don't know what are you trying to do but trim($row["now"] == 1) is wrong syntax — u_mulder
– u_mulder, Commented Jul 18, 2015 at 18:43
remove this line echo "Now:".$row["now"]." ". "Status: ".$row["status"]." "; and try you are getting 1 and 3 from this line of code — Shehary
– Shehary, Commented Jul 18, 2015 at 19:26

u_mulder · Accepted Answer · 2015-07-18 19:16:44Z

1

You've got few errors in Your code:

trim($row["now"] == 1) - it should be trim($row["now"]) == 1 and so on (otherwise You execute trim on boolean value since $row["now"] == 1 will be evaluated first)
echo is called just at the start of the loop and THEN 'status' and 'now' are checked and displayed and it has no effect to first echo since in next iteration new row is read and unformatted values put into 'first echo'

Just change while loop to something like that:

while ($row = $result->fetch_assoc()) {
    if (intval($row["now"]) == 1) {
        $now = "Yes";
    } else {
        $now = "";
    } 

    if ($row["status"] == 3) {
        $status = "Open";
    } else if($row["status"] == 2) {
        $status = "Closed";
    } else {
        $status = '';
    }

    echo "<span class='infoTitle'>Now:</span>".$now."<br><span class='infoTitle'>Status:</span> ".$status."<br>";
}

Then should be fine.

edited Jul 18, 2015 at 19:16

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

answered Jul 18, 2015 at 19:15

adam.pilacki

1016 bronze badges

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

Comments

BigScar · Accepted Answer · 2015-07-18 19:23:25Z

0

Does this make sense to you. I've established the values before I try to output the lines

// output data of each row
 while($row = $result->fetch_assoc()) {
$firstvar = "";
$secondvar = "";

if (trim($row['now']) == 1)
    {$firstvar = "Yes";}
if(trim($row['now']) == 0)
    {$firstvar = "";}
if ($row['status'] == 3)
    {$secondvar = "Open";}
if($row['status'] == 2)
    {$secondvar = "Closed";}
     echo "<span class='infoTitle'>Now: </span>" . $firstvar . "<br>";
     echo "<span class='infoTitle'>Status: </span> " . $secondvar . "<br>";

edited Jul 18, 2015 at 19:23

answered Jul 18, 2015 at 19:06

BigScar

3433 silver badges9 bronze badges

2 Comments

Arvin Flores Over a year ago

BigScar and adam.pilacki both of you were on the money! thanks a lot I appreciate it !!

BigScar Over a year ago

Thanks Adam for catching the Trim() syntax problem.

Collectives™ on Stack Overflow

How do i echo a variable that has a conditional statement using PHP?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related