Member Avatar for gunnerone

How could i create x amount of checkboxes based on how many items are in a database and populate each check box with a php variable containing the data from the database.

thanks.

  • 2 Contributors
  • 2 Replies
  • 81 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by simplypixie

Dani AI

Generated

A correct solution is to iterate the full result set and emit one checkbox per row, giving each checkbox a distinct value (usually the row id) and using an array-style name so multiple selections are posted. The original attempt fetched a single row and then tried to treat that array like a string; it also used the old mysql_* functions and single-quoted HTML (which prevents variable interpolation). As noted, a loop is the right idea — but use modern DB APIs and escape output.

Example (PDO, escaping, and restoring checked state after submit):

<?php
$pdo = new PDO('mysql:host=localhost;dbname=mydb;charset=utf8mb4', 'dbuser', 'dbpass', [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
]);

$rows = $pdo->query('SELECT id, name FROM items ORDER BY name')->fetchAll(PDO::FETCH_ASSOC);
$selected = $_POST['items'] ?? [];

foreach ($rows as $r) {
    $id = htmlspecialchars($r['id'], ENT_QUOTES, 'UTF-8');
    $label = htmlspecialchars($r['name'], ENT_QUOTES, 'UTF-8');
    $checked = in_array($r['id'], $selected, true) ? ' checked' : '';
    echo "<label><input type=\"checkbox\" name=\"items[]\" value=\"$id\"$checked> $label</label>\n";
}
?>

UX and troubleshooting tips: use <label> for accessibility and group related boxes in a <fieldset>. If the table has hundreds of rows, replace raw checkboxes with a searchable multi-select (e.g., Select2) or paging to avoid overwhelming users. Always escape displayed data with htmlspecialchars (htmlspecialchars) and prefer PDO or mysqli over deprecated mysql_* functions (PDO manual).

Recommended Answers

All 2 Replies

Member Avatar for gunnerone

I have had a go and come up with the code below:

$sql1 = mysql_query("SELECT equipmentid, description FROM equipment") or die(mysql_error());
$row = mysql_fetch_assoc($sql1);

<?php for($i = "0"; i < strlen($row); $i++){ echo'<input type="checkbox" name="equipment" value="$row"/>';}?>

But i cant seem to get it to work.

Member Avatar for simplypixie

The for loop is incorrect but you are better off using a while loop as much easier for what you require:

$sql1 = mysql_query("SELECT equipmentid, description FROM equipment") or die(mysql_error());
while ($row = mysql_fetch_assoc($sql1)) {
echo '<input type="checkbox" name="equipment" value="$row['equipmentid']"/>
}
Edited by simplypixie because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.