[RESOLVED] Showing 0 or 1 record as a tickbox (mysql extracted via php)

[christillis]

Hi all,

Sorry again, I really try avoiding questions and have read up already but it's not going my way.

I would like to display mysql records true/false content as a ticked or unticked box. This is as opposed to displaying (as a PHP page) a column of 0's and 1's. Hope that makes sense.

Any pointed would be gratefully read!

Many thanks,

Chris

[laserlight]

Think along the lines of 'if value = 1 then print checked="checked"'.

[christillis]

Thank you laserlight, I'll have a go and report back! 🙂

[christillis]

I'm kind of thinking aloud here, having tried this for a while (luckily I think in paragraphs).

The very basics are that if I want to display within a php page, a list of information retrieved from a mysql db, I simply do:

while ($newArray = mysqli_fetch_array($res, MYSQLI_ASSOC)) {
$things_in_the_column_name = $newArray['the_column_name'];} 

Instead of listing a column of 0's and 1's, I would like to display either unticked or ticked boxes. In an idea world an idiot like me would be able to write something like:

while ($newArray = mysqli_fetch_array($res, MYSQLI_ASSOC)) {
$things_in_the_column_name = $newArray['the_column_name'] 
IF ($things_in_the_column_name) ? value='1' then untick : value='0' then tick;}

sadly I'm still very new at this, but it's just another hurdle to jump, I'm at least getting used to reading the scripts.

[laserlight]

Consider this example:

while ($row = mysqli_fetch_array($res, MYSQLI_ASSOC)) {
    echo htmlspecialchars($row['item'])
        . '<input type="checkbox" name="item[' . (int)$row['id'] . ']"';
    if ($row['available']) {
        echo ' checked="checked"';
    }
    echo " /><br />\n";
}

So, each row has an id ($row['id']), an item name ($row['item']) and an availability field ($row['available']). We print the item name and the checkbox with the item id (so we can access $_POST['item'] as an array of item ids of the checked items). If the item is available ($row['available'] is non-zero), we print ' checked="checked"', which causes the checkbox to be checked.

[christillis]

Hello again Laserlight, I'm really grateful for your input on my self-educating of PHP - it really is very much appreciated! Thank you for supplying the example and breaking it down into a description, I think I will refer back to my manual(s) for a while, so I bother you less in future!

Many thanks,
Chris