PHP - Dynamic Checkboxes - Extra Checkbox

Hi all,

I need some help here.

Currently I am using 2 functions.
1) To call out the 'academic levels'
2) To call out the 'subjects' which matches to the specific 'academic level'

However, I am stucked in the codes.

Please view my picture attachment, my question is, how do I assigned 'red box (Pre-School)' to 'red box (subjects)' and so on...What are the codes or tweaks that I should make so that it will look like 'what do I want to achieve.jpg'


My process and execution

    $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die(mysqli_error($dbc));
    
    //Run query
    $tutor_id = mysqli_real_escape_string($dbc, $_GET['tutor_id']);
    $query = "SELECT tl.level_id, tl.level_name,
                     ts.subject_id, ts.subject_name, tsl.subject_level_id, 
                     IF(tosl.tutor_id='{$tutor_id}', 1, 0) as checked
              FROM tutor_level AS tl
              INNER JOIN tutor_subject_level AS tsl
                  USING (level_id)
              INNER JOIN tutor_subject AS ts
                  USING (subject_id)
              LEFT JOIN tutor_overall_level_subject AS tosl
                  ON tosl.subject_level_id = tsl.subject_level_id
                  AND tosl.tutor_id = '{$tutor_id}'
              ORDER BY tl.level_id, ts.subject_name";
    $sql = mysqli_query($dbc, $query) or die(mysqli_error($dbc));

$query1 = "SELECT tl.level_id, tl.level_name,
                     IF(tslvl.tutor_id='{$tutor_id}', 1, 0) as checked
              FROM tutor_level AS tl
              LEFT JOIN tutor_selected_level AS tslvl
                  ON tslvl.level_id = tl.level_id
                  AND tslvl.tutor_id='{$tutor_id}'
              ORDER BY tl.level_id, tl.level_name";
    $sql1 = mysqli_query($dbc, $query1) or die(mysqli_error($dbc));

//Process the results
    $checkboxes = ''; //Create variable for output
    $current_level_id = false; //Flag to check when records change level
    while($data = mysqli_fetch_array($sql)) //Iterate throug the DB results
    {
        if($current_level_id != $data['level_id']) //Determine if this level is different from the last
        {

print_r ($data);
            $subjectCheckboxes .= createSubjectCheckboxes($subject_data, 5);
            $current_level_id = $data['level_id'];
            $subject_data = array();
        }
        //Add the current record to the $level_data array
        $subject_data[] = $data;
    }

//$checkboxes .= createLevelCheckboxes($subject_data, $level_data, 5);

while($data1 = mysqli_fetch_array($sql1))

{

print_r ($data1);

$levelCheckboxes .= createLevelCheckboxes($level_data, 5);
            $level_data = array();

$level_data[] = $data1;

}

    //Call the createLevelCheckboxes() function to generate the HTML for the LAST level records
    $levelCheckboxes .= createLevelCheckboxes($level_data, 5);

$subjectCheckboxes .= createSubjectCheckboxes($subject_data, 5);



My functions

function createLevelCheckboxes($levelArray, $columns)
    {

        if(count($levelArray)==0) { return false; }
        $htmlOutput = '';

foreach($levelArray as $data1)
        {
        //Display level header row
        $levelID   = $levelArray[0]['level_id'];
        $levelName = $levelArray[0]['level_name'];

$checked = ($data1['checked'] == 1) ? '  checked="checked"' : '';
        $htmlOutput .= "<tr>\n";
        $htmlOutput .= "<th colspan=\"{$columns}\" style=\"text-align:left;padding-top:15px;\">";
        $htmlOutput .= "<input name=\"level[]\" type=\"checkbox\" id=\"level_{$levelID}\" type=\"checkbox\" {$checked} value=\"{$levelID}\">";
        $htmlOutput .= "<span class=\"zone_text_enlarge\"><label for=\"level_{$levelID}\">{$levelName}</label></span>";
        $htmlOutput .= "</th>\n";
        $htmlOutput .= "</tr>\n";

}

return $htmlOutput;

}

function createSubjectCheckboxes($subjectArray, $columns)
    {

        //Display each subject
        $recordCount = 0;
        foreach($subjectArray as $data)
        {
            //Increment counter
            $recordCount++;
 
            //Start new row if needed, 1/5 = R1 --> So create a new row
            if ($recordCount % $columns == 1)
            {
                $htmlOutput .= "<tr>\n";
            }
            
            //Display the record
            $subjectID   = $data['subject_level_id'];
            $subjectName = $data['subject_name'];
            $checked = ($data['checked'] == 1) ? '  checked="checked"' : '';
            $htmlOutput .= "  <td>\n";
            $htmlOutput .= "    <input name=\"subject_level[]\" class=\"subject_a\" type=\"checkbox\" {$checked}";
            $htmlOutput .= " id=\"subject_level_{$subjectID}\" value=\"{$subjectID}\"/>\n";
            $htmlOutput .= "    <label for=\"subject_level_{$subjectID}\" class=\"subject_1\">{$subjectName}</label>\n";
            $htmlOutput .= "</td>\n";
            
            //Close row if needed, 5/5 = 0 --> So close the row
            if ($recordCount % $columns == 0)
            {
                $htmlOutput .= "</tr>\n";
            }
        }
        //Close last row if needed
        if ($recordCount % $columns != 0)
        {
            $htmlOutput .= "</tr>\n";
        }
        return $htmlOutput;
    }

since many do not know the term sticky = when a form is submitted, the data contained is not deleted but instead last checked data will be shown.

I have some dynamically generated checkboxes from the database. I tried the below code to make them sticky but they are simply preselected in stead of becoming sticky. What am I doing wrong?

<?php
$sql2 = "SELECT relation FROM table_rel_info";
$result2 = @mysqli_query($dbc, $sql2);
while($row2 = mysqli_fetch_array($result2, MYSQLI_ASSOC)) {
echo "<label>" . $row2['relation'] . "</label>";
echo "<input class='box' type='checkbox' value=1";
?> <?php if (isset($row2['relation'])) { echo 'checked="checked"';}?>
<?php
echo "'/>" . "<br />";
} ?>

Please guys, I need your help on this one. How can call the data from mysql and make the values checked on the checkboxes Have got three tables. I am retrieving data and updating two tables at once...

Am new to php... I have been battling on my dynamic checkboxes in such a way that if none is checked the form is return, also I need to retain what was checked when the form postback due to other invalid inputs.

Code: [Select]
$result = mysql_query("SELECT * FROM course") or die(mysql_error()); if ($result) { while ($row = mysql_fetch_array($result)){ if (isset($_POST['courses']) and $_POST['courses'] == $row['cid']) {echo $row['cid'];} print "<input type=\"checkbox\" name=\"courses[]\" value=\"$row[cid]\">$row[cname]\n"; } }
Help needed purely on php codes. Thanks in advance

Hello all, I found this dynamic checkbox list online.  I have changed it to suit my needs, added some of my own parts but now, after getting past all the terminal errors, it now produces absolutely nothing.  Can I get some help on why there is no echo occurring?  Thanks!

<?php

function dynamic_checkbox_table ($sql_str, $col_label, $col_name, $val_checked, $cant_cols_tbl){

        $sql_str = dynamic_checkbox_table("SELECT * FROM Categories");
        $col_label = "catlevel3";
        $col_name = "catlevel3";
        $val_checked="S";
        $cant_cols_tbl=3;
        
        //connect DB and run query
        $db="TB";
        $db_user="";
        $pass="";
        $host="localhost";
        @mysql_connect($host,$db_user,$pass);
        @mysql_select_db($db) or die ("cannot connect to DB");
        $q_resultado = mysql_query($sql_str);
        mysql_close();
        if (mysql_num_rows($q_resultado)==0) exit("no rows returned");
        
        $next_row = mysql_fetch_array($q_resultado); //fetch first row
        
        $output = "<table  border=\"1\">\n"; //open table tag
        do {
                $output .= "<tr>\n"; //open row tag
                for ($i=1 ; $i <= $cant_cols_tbl ; $i++ ){ //loops as many times as $cant_cols_tbl
                        $row=$next_row; 
                        $output .= "<td>"; //open TD tag
                        $output .= (!$row) ? "" : '<input type="checkbox" name="'.$row[$col_name].'" value="'.$val_checked.'" />'.$row[$col_label]; 
                        echo (!$row) ? "" : '<input type="checkbox" name="'.$row[$col_name].'" value="'.$row[$val_checked].'" />'.$row[$col_label]; 
                        $next_row = mysql_fetch_array($q_resultado); //retrieve next row
                        $output .= "</td>\n"; //close TD
                } //close for loop
                $output .= "</tr>\n"; //close row
        } while ($next_row); //close do-while (and checks if there's another row)
        $output .= "</table>\n"; //close table
        return $output; 
}

?>