/**
* Delete a student by ID
* @global type $CFG
* @param type $studentID
* @return type
* TODO make this transaction based so we don't end up with orphan data
*/
public function delete_student($studentID)
{
global $CFG;
try {
$conn = new PDO("mysql:host={$CFG->db};dbname={$CFG->schema}", $CFG->dbuser, $CFG->dbuserpass);
} catch (PDOException $e) {
die('<data><error>failed connecting to database</error><detail>' . $e->getMessage() . '</detail></data>');
}
$returnStr = 'false';
// Delete student entry
$query = "DELETE FROM students WHERE ID = :studentID;";
$stmt = $conn->prepare($query);
$stmt->bindValue(':studentID', $studentID, PDO::PARAM_INT);
$stmt->execute() or die('<data><error>delete_student query failed</error><detail>' . $stmt->errorCode() . '</detail></data>');
if ($stmt->rowCount() > 0) {
$medialib = new MediaLib();
if ($medialib->deleteStudentImage($studentID)) {
$returnStr = 'true';
} else {
$returnStr = 'false';
}
} else {
$returnStr = 'false';
}
return "<data><status>{$returnStr}</status></data>";
}
