function delete() { Category::requirePermission("DELETE"); $link = Database::getConnection(); $query = "DELETE FROM category WHERE id=".Database::sqlValue($this->id); mysql_query($query) or die(Database::formatError($query, Text::getText("QueryFailed"))); Database::returnConnection($link); }
/** * Takes an INSERT query and returns the inserted ID, * or 0 if query does not generate an AUTO_INCREMENT * value. */ function insert($sql) { $con = Database::getConnection(); $result = mysql_query($sql) or die(Database::formatError($sql, Text::getText("QueryFailed"))); $record = new DatabaseRecord($result); $id = mysql_insert_id($con); Database::returnConnection($con); return $id; }