connect_error) {
die("Connection failed: " . $mysqli->connect_error);
}
//if (isset($_POST['Top_Teacher_ID']) && isset($_POST['Teacher_Level'])) {
// $Top_Teacher_ID = $_POST['Top_Teacher_ID'];
// $Teacher_Level = $_POST['Teacher_Level'];
//
// // Debugging: Check the POST data
// error_log('Top_Teacher_ID: ' . $Top_Teacher_ID);
// error_log('Teacher_Level: ' . $Teacher_Level);
//
// // Update the database
// $query = "UPDATE top_teacher_list SET Teacher_Level = ? WHERE Top_Teacher_ID = ?";
// $stmt = $mysqli->prepare($query);
// $stmt->bind_param("ii", $Teacher_Level, $Top_Teacher_ID);
//
// if ($stmt->execute()) {
// // Successfully updated
// echo "Teacher Level updated successfully";
// } else {
// // Error occurred
// echo "Error updating Teacher Level";
// }
//} else {
// // Missing data in POST request
// error_log('Missing data: Top_Teacher_ID or Teacher_Level');
// echo "Invalid request: Missing data";
//}
// Check if data is passed via POST
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['Top_Teacher_ID']) && isset($_POST['Teacher_Level'])) {
$Top_Teacher_ID = $_POST['Top_Teacher_ID'];
$Teacher_Level = $_POST['Teacher_Level'];
//echo "Error executing query: " . $Top_Teacher_ID .'-'.$Teacher_Level;
// Debug: Check the data received
// error_log("Received: Top_Teacher_ID = $Top_Teacher_ID, Teacher_Level = $Teacher_Level");
// Prepare the SQL statement
if ($stmt = $mysqli->prepare("UPDATE top_teacher_list SET Teacher_Level = ? WHERE Top_Teacher_ID = ?")) {
// Bind parameters
$stmt->bind_param("ii", $Teacher_Level, $Top_Teacher_ID);
// Execute the query
if ($stmt->execute()) {
// Debug: Check affected rows
if ($stmt->affected_rows > 0) {
echo "Teacher Level updated successfully";
} else {
echo "No rows affected. Teacher Level may be the same as before.";
}
} else {
echo "Error executing query: " . $stmt->error;
}
$stmt->close();
} else {
echo "Error preparing query: " . $mysqli->error;
}
} else {
echo "Invalid request. Please make sure the POST parameters are set.";
}
?>