lundi 9 novembre 2015

HTML Table and Checkboxes

I have 1 table with checkboxes in it.. What I want to happen is to set the value of the checkbox to be the student_id

Here's my code:

      <?php 
        require_once('xcon.php'); 
        $q = mysql_query("SELECT * FROM Students");
      ?>

      <table><br><br>
            <thead>
                <tr>
                    <th>Choice</th>
                    <th>Student ID</th>
                    <th>Student First Name</th>
                    <th>Student Last Name</th>
                    <th>Level</th>
                </tr>
            </thead>
            <?php
                 while($row = mysql_fetch_assoc($q)){

                    echo "<tbody>";    
                    echo "<tr>";
                    echo "<td><input type = 'checkbox' name = 'checkbox[]' ></td>";
                    echo "<td>".$row['student_id']."</td>";
                    echo "<td>".$row['fname']."</td>";
                    echo "<td>".$row['lname']."</td>";
                    echo "<td>".$row['yearlevel']."</td>";
                    echo "</tr>";
                    echo "</tbody>";
                }  
            ?> 

    </table>

I seem to be having the trouble of getting the logic in this and i got confused.

Thank you in advance for your help.




Aucun commentaire:

Enregistrer un commentaire