So here is my PHP code:
这是我的PHP代码:
$checkProject1Column = "SELECT * FROM tbl_studentchoice WHERE Project1 = '1'";
$resultProject1Column = mysqli_query($conn, $checkProject1Column);
while($row = mysqli_fetch_assoc($resultProject1Column)) {
//Create an array of students
$array[] = ['studentid' => $row['studentid']];
}
//check marks database
$checkmarks = "SELECT studentid,marks FROM tbl_marks";
$checkResult = mysqli_query($conn, $checkmarks);
if ($checkResult->num_rows >= 0){
while($row1 = mysqli_fetch_assoc($checkResult)){
//Create an array of students
$array1[] = [
'marks' => $row1['marks'],
'studentid' => $row1['studentid']
];
}
print_r($array);
print_r($array1);
$checkP