如何使用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

Answer 1

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>";