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.";
//}
?>