标题中的错误有一个小问题,但是所有的括号都匹配,所以我不知道为什么会显示这个错误。有人知道为什么吗?
代码为:
<?php
session_start();
require_once 'db/connect.php';
//require_once 'entryformsuccess.php';
echo $_SESSION['Username'] . ' logged in successfully ' . ' <br> ';
if ($student_delete = $con->query("SELECT Student.Form, Teacher.Form, Forename, Surname, Student_ID, Username " .
"FROM student, teacher " .
"WHERE Student.Form = Teacher.Form AND Teacher.Username = '" . $_SESSION['Username'] . "'")) {
if (isset($_POST['Student_ID'])) {
$checkbox = $_POST['checkbox'];
for ($i=0;$i<count($checkbox);$i++) {
$del_student = $checkbox[$i];
$query= $con->query("DELETE FROM users WHERE Student_ID = 'Student_ID'")
}
}
}
?>
末尾缺少;
$query= $con->query("DELETE FROM users WHERE Student_ID = 'Student_ID'")
请更新。
<?php
session_start();
require_once 'db/connect.php';
//require_once 'entryformsuccess.php';
echo $_SESSION['Username'] . ' logged in successfully ' . ' <br> ';
if ($student_delete = $con->query("SELECT Student.Form, Teacher.Form, Forename, Surname, Student_ID, Username " .
"FROM student, teacher " .
"WHERE Student.Form = Teacher.Form AND Teacher.Username = '" . $_SESSION['Username'] . "'")) {
if (isset($_POST['Student_ID'])) {
$checkbox = $_POST['checkbox'];
for ($i=0;$i<count($checkbox);$i++) {
$del_student = $checkbox[$i];
$query= $con->query("DELETE FROM users WHERE Student_ID = 'Student_ID'");
}
}
}
?>
我想您在这一行的末尾缺少了一个分号:
$query= $con->query("DELETE FROM users WHERE Student_ID = 'Student_ID'");