I write to seek your kind assistant in my Project of student registration. after echoing the table data, the student is expected to select the course he wish and the record will be sent to database. but I only receive the student Id with out other parameters. Below is the codes:

<div class="span10">



<div class="alert alert-info"><Strong>Registered Courses!</strong>&nbsp;Welcome to Online Grade Inquiry</div>



<form class="form-horizontal" method="POST" action="">
<?php
include('dbcon.php');

$q = "SELECT status FROM invoice WHERE student_no = '$session_id'";
$result = mysqli_query ($db, $q);
if (mysqli_num_rows($result) > 0){

$qry = mysqli_query($db,"SELECT course, year_level FROM students WHERE student_no = '$session_id'" or die("Error: ".mysqli_error($db));

while($row1 = mysqli_fetch_array($qry)){
$course_id = $row1['course'];
$level = $row1['year_level'];

$query_course = mysqli_query($db, "SELECT * FROM subject where course_id = '$course_id' AND year = '$level' "or die(mysqli_error());


echo"<table class='table table-hover table-striped table-responsive'>";
echo "<tr><th>Course COde</th><th>Title</th><th>Status</th><th>Unit</th><th>Check</th></tr>";

while($row = mysqli_fetch_array($query_course)) {
$code = $row['code'];
$title = $row['title'];
$status = $row['status'];
$unit = $row['unit'];
$amm = $row['subject_id'];


$tick ="<input name='check[]' value='<?php echo $amm; ?>' id='coursecode' rel = '$unit' type='checkbox' />";
$unt ="<input name='unit[]' value='<?php echo $unit; ?>' id='coursecode' rel = '$unit' type='hidden' />";


echo"<tr>";

echo "<td>" .$row['code']. "</td>";

echo "<td>" .$row['title']. "</td>";

echo "<td>" .$row['status']. "</td>";
echo "<td>" .$row['unit']. "</td>";



echo "<td>"."<input name='check[]' value='<?php echo $amm; ?>' id='coursecode' rel = '$unit' type='checkbox' />"."</td>";

echo "</tr>";


}
}


echo"</table>";


mysqli_close($db);

}else{

echo '<h2>System Error</h2>
<p class="error">Registration failed because of a system error. We apologize for the inconvenience.</p>';

}

?>
<button type='submit' class='btn btn-info btn-lg' name = 'submit' >Register</button>
</form>

<div class="alert alert-info pull-right" ><Strong>Registered Units!</strong>&nbsp;<span id="output"></span> </div>


</div>

</div>
</div>
</div>




<?php

include('dbcon.php');

if(isset($_POST['submit']))
{

$counter = count($_POST["check"]); /* COUNT THE PASSED ON NAME */

for($x=0; $x<=$counter; $x++){

if(!empty($_POST["check"][$x])){

$subj = $_POST["check"][$x];
// $sub = $_POST["check"][$x];
// $un = mysqli_real_escape_string($_POST[".$row['unit']."][$x]);
$student_id = $session_id;

$qry="INSERT INTO registration (course, student) VALUES ('$subj','$student_id')";
mysqli_query($db, $qry);

} /* END OF CHECKING THE CHECKBOX IF SELECTED */

}
} /* END OF FOR LOOP */

?>

Please help me Professional Programmers, I am Newbee[color=#990000][/color][font=Lucida Sans Unicode][/font]

Hello, Thanks for your kind response, I am looking for how to insert array of data with checkbox into mysql database.

try pdo, I will copy you my crud class and change the way you loop

usman4people:
Hello, Thanks for your kind response, I am looking for how to insert array of data with checkbox into mysql database.

Your question is not clear, but let me try from what I understand:

I imagine you have a tables as so:

student_subjects Table Structure
___________________________
| id | subject_id | student_id |
------------------------------------
|___|__________|___________|
|___|__________|___________|

You have an array variable say $check that holds all the subject that were checked
And another variable $student_id which holds the ID of the student in context of your code.
Then the $conn variable which I assume is a mqsqli connection to your database

A code as simple as below should do the trick (note the code is without error checking or performance considerations).

<?php
$check_count = count($check);
for($i=0; $i < $check_count; $i++)
{
	$sql = "INSERT into student_subjects (subject_id, student_id) VALUES ('".$check[$i]."','".$student_id."' ) " ;
	$conn->query($sql)
}
?>