โค้ด: เลือกทั้งหมด
$sql = "SELECT student.id_s,student.firstname_s,student.lastname_s,student.nickname_s,orderdetail.id_course,orderdetail.id_sec FROM student INNER JOIN orderdetail ON student.id_s = orderdetail.id_s WHERE orderdetail.id_sec=1301" ;
$query = mysqli_query($dbcon, $sql);
$re= mysqli_query($dbcon, $sql);
$num_rows= mysqli_num_rows($re);
echo "<br><br>ค้นพบข้อมูลทั้งหมด $num_rows record<br><br>";
if($num_rows>0){
while ($row = mysqli_fetch_row($re)) {
echo "<tr>";
echo "<th scope=row>$row[0]</th>";
echo "<td>$row[1]</td>";
echo "<td>$row[2]</td>";
echo "<td>$row[3]</td>";
echo "<td>$row[4]</td>";
echo "<td>$row[5]</td>"; ?>
<td><input type="checkbox" name="check[]" value=<?php $row[0]?>></td>
<?PHP
echo "</tr>";
}
}
?>
</tbody>
</table>
<input type="submit" name="submit" value="submit">
<?php
if(isset($_POST['submit'])){
date_default_timezone_set("Asia/Bangkok");
$date_time=date("Y-m-d H:i:s");
$sql1=" INSERT INTO learn ('id_learn','check_time','id_s') VALUE (NULL,$date_time,??)";
}
แนะนำด้วยค่ะ