/** * Delete a record by id from the table in context * @param id $id the id of the record to be deleted * @return [type] [description] */ public static function destroy($id) { $table = self::getTableNameFromClass(); self::getOne($id); $query = "DELETE FROM {$table} WHERE id = " . $id; try { Connection::db()->query($query); return true; } catch (Exception $e) { return false; } }
/** * General Emoji Database Querier. * * @param string $query SQL query to be executed by the database * * @return $array SQl query results from the database */ public static function getQueryResults($query) { $results = Connection::db()->query($query); $results->setFetchMode(PDO::FETCH_ASSOC); return $results->fetch(); }