public function ACT_delete() { $record_id = (int) $this->path_option->getPathSection(2); if ($record_id == 0) { $this->notFound(array('specifier' => 'record_id')); } MDL_Record_Edit::delete($record_id); $this->locator->redirect('admin_record_list'); }
/** * remove * @param int $prob_id * @return void */ public static function remove($prob_id) { $db = BFL_Database::getInstance(); $stmt = $db->delete(DB_TABLE_PROB, 'where `prob_id`=:prob_id'); $stmt->bindParam(':prob_id', $prob_id); $stmt->execute(); $stmt = $db->delete(DB_TABLE_PROBMETA, 'where `pmeta_prob_id`=:prob_id'); $stmt->bindParam(':prob_id', $prob_id); $stmt->execute(); $records = MDL_Problem_List::getRecords($prob_id); foreach ($records as $record) { MDL_Record_Edit::delete($record['record_id']); } }
public static function remove($user_id) { $db = BFL_Database::getInstance(); $stmt = $db->delete(DB_TABLE_USER, 'where `user_id`=:user_id'); $stmt->bindParam(':user_id', $user_id); $stmt->execute(); $stmt = $db->delete(DB_TABLE_USERMETA, 'where `umeta_user_id`=:user_id'); $stmt->bindParam(':user_id', $user_id); $stmt->execute(); $stmt = $db->factory('select `record_id` from ' . DB_TABLE_RECORD . ' where `record_user_id`=:user_id'); $stmt->bindParam(':user_id', $user_id); $stmt->execute(); $records = $stmt->fetchAll(); $stmt = NULL; foreach ($records as $record) { MDL_Record_Edit::delete($record['record_id']); } }