Example #1
0
 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);
 }
Example #2
0
 /**
  * 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;
 }