/home/techb158/workloadmatch.com/api
Edit: /home/techb158/workloadmatch.com/api/test.php (1113B)
"error", "message" => "Unauthorized"]);
exit();
}
header('Content-Type: application/json');
if ($mysqli->connect_errno) {
echo json_encode([
"status" => "error",
"message" => "Failed to connect to MySQL: " . $mysqli->connect_error
]);
exit();
}
$query = "SELECT COUNT(*) AS cnt FROM teacher_profile";
$result = $mysqli->query($query);
if ($result) {
$row = $result->fetch_assoc();
echo json_encode([
"status" => "success",
"message" => "Database connection OK",
"teacher_count" => $row['cnt']
]);
} else {
echo json_encode([
"status" => "error",
"message" => "Query failed: " . $mysqli->error
]);
}
exit();
?>