Why are mySQL query results not displaying text from table when executed in PHP?

Question

The below code is returning rows of checkboxes (the right number per the mySQL table) and with no error. The problem is that it is not grabbing the column values ((as per: ".$row['Zone'].": ".$row['RowNumber']. ))to place beside said checkboxes.

<?php
include'connect.php'
?>
<form method="post" action="chooseDate.php">

<?php   
$sql = "
    SELECT s.RowNumber, s.Zone, 
    FROM Seat AS s 
        LEFT JOIN Booking AS b, ON s.RowNumber = b.RowNumber, 
                                AND b.PerfDate = ?, 
                                AND b.PerfTime = ?, 
    WHERE b.RowNumber IS NULL, 
    GROUP BY s.RowNumber
";
$date = "$_POST[Date]";
$time = "$_POST[Time]"; 
$handle = $conn->prepare($sql); 
$handle->execute(array($date, $time));  
$res = $handle->fetchAll(); 
    foreach($res as $row) {
        echo "<input name='Seat' type='checkbox' value='".$row['Zone'].":   
             ".$row['RowNumber']."'><br>";  
    }   
?>

<input class="mybutton" type="submit" value="Choose Seat"/>
</form>

I have run queries using identical methods and they display the results as expected. The only difference here is that the query is LEFT JOIN. The results display in shell. This is a sample of the results and the expected output of one checkbox.

|**RowNumber**|**Zone**|
|-------------|--------|
|Z20          |box 4   |

Where am I going wrong? Thanks in advance.

What are the Names of the Columns ** RowNumber ** or RowNumber — Bernd Buffen
– Bernd Buffen, Commented Dec 3, 2016 at 12:18
What does print_r($res) look like when executed after $res = $handle->fetchAll();? — Martin Cup
– Martin Cup, Commented Dec 3, 2016 at 12:18
@MartinCup very ugly. About 500 of these in a consecutive string: "Array ( [0] => Array ( [RowNumber] => U03 [0] => U03 )" — Shooresh
– Shooresh, Commented Dec 3, 2016 at 12:21
Yes so it seems everything is there, it is not printed correctly in the HTML. You should have a look at GolezTrol's answer. — Martin Cup
– Martin Cup, Commented Dec 3, 2016 at 12:22

GolezTrol · Accepted Answer · 2016-12-03 12:24:55Z

2

Have you looked at the HTML output? You put the text inside the input element. The closing > is after the text.

You could fix that simply by just moving the > to the front, but I think it's bettter to generate a <label> element after the checkbox or surrounding the checkbox. If you give the checkbox an id, and the label a for attribute pointing to that id, the text is clickable too, which make an awesome UX. :)

So I suggest changing the for loop like this:

$idcounter = 0;
foreach($res as $row) {
    $id = 'Seat' . ($idcounter++); 
    echo "<input name='Seat' type='checkbox' id='$id'><label for='$id'>".$row['Zone'].":".$row['RowNumber']."</label><br>";  
}

Note that I removed the value attribute. I'm not sure if you would need it, but maybe you need both: the value and the label. If so you can put back that attribute like you had before, as long as you make sure to close the input element before opening the label.

edited Dec 3, 2016 at 12:24

answered Dec 3, 2016 at 12:18

GolezTrol

116k19 gold badges186 silver badges215 bronze badges

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

2 Comments

Shooresh Over a year ago

Can you demonstrate?

Shooresh Over a year ago

You're a gem. Thanks a lot.

Collectives™ on Stack Overflow

Why are mySQL query results not displaying text from table when executed in PHP?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related