Create checkboxes(table) from mysql table

Question

I want to write out details from MySQL database to checkboxes. And the checkboxes structure should look like 6*6 square. ( 6 in one row, 6 in one column).

MySQL database looks like :

|id|package|
|1 |HEI    |
|2 |TAG    |
|...|

I wrote this function (in php)

function getPackages3()
{
    $con = openLockMySQLdb('labcom', 'packages', 'READ');

    $q = mysql_query("SELECT id, package FROM packages ORDER BY package ASC", $con);
    while($row = mysqli_fetch_array($q)) {
        $packages .= '<ul>' . '<li>' . '<label>' . '<input type="checkbox" class="packages_2" id="tab_packages" name="' . $row['package'] . '" value="' . $row['id'] . '-' . $row['package'] . '">' . '<p class="checkbox_label">' . $row['package'] . '</p>' . '</label>' . '</ul>' . '</li>';
    }

    closeUnlockMySQLdb($con);

    return $packages;
}

to get in checkboxes, it's working but i can't but 6 in one row and 6 in one column. So i can't make a square from the checkboxes.

you're mixing ´mysql_` with mysqli_! And of course you should not use mysql_ at all. — Jeff
– Jeff, Commented Jun 23, 2016 at 15:07

JSchirrmacher · Accepted Answer · 2016-06-23 15:22:26Z

1

I suppose your database table contains 6 * 6 = 36 entries of packages, right? Then the only problem is to have a kind of 'line feed' after every 6th entry.

I'd prefer a CSS solution in this case and use the nth-of-type() selector. But you need to move the <ul> tag out of the loop:

function getPackages3()
{
    $con = openLockMySQLdb('labcom', 'packages', 'READ');

    $q = mysql_query("SELECT id, package FROM packages ORDER BY package ASC", $con);
    $packages = '<ul>';
    while($row = mysqli_fetch_array($q)) {
        $packages .= '<li>' . '<label>' . '<input type="checkbox" class="packages_2" id="tab_packages" name="' . $row['package'] . '" value="' . $row['id'] . '-' . $row['package'] . '">' . '<p class="checkbox_label">' . $row['package'] . '</p>' . '</label></li>';
    }
    $packages .= '</ul>';

    closeUnlockMySQLdb($con);

    return $packages;
}

The CSS would then be like that:

li {
    float: left;
}
li:nth-of-type(6n) {
    clear: left;
}

I kept your calls to the database functions even if they use mixed libraries (see comments from @jeff) because it is a different problem, but to make it work, you have to fix this as well.

answered Jun 23, 2016 at 15:22

JSchirrmacher

3,3692 gold badges22 silver badges31 bronze badges

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

3 Comments

Rickley14 Over a year ago

I fixed the syntax problems (comments from @jeff) . And tried to use your solution. Now putting in one <ul> all <li> . But i want 6 <ul> which contains 6 <li> per each <ul> . BTW thanks for helping!

JSchirrmacher Over a year ago

Ok, then it's even easier. Just keep the li { float: left; }' style and put the <ul>` tags back in the while loop again.

Rickley14 Over a year ago

I solved it . Without li:nth-of-type(6n) { clear: left; } I made a 6*6 with css. Thanks for help.

Collectives™ on Stack Overflow

Create checkboxes(table) from mysql table

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related