static function Retrieve($user_id, $cfg_name) { if (!$user_id || !$cfg_name) { return null; } $entity = new Entity(); $query = "SELECT * FROM #__messages_cfg WHERE user_id = ? AND cfg_name = ?"; return $entity->GetFirstResult($query, array($user_id, $cfg_name), __CLASS__); }
static function Retrieve($category_id) { if (!$category_id) { return null; } $entity = new Entity(); $query = "SELECT * FROM #__categories WHERE id = ?"; $object = $entity->GetFirstResult($query, $category_id, __CLASS__); return $object; }
static function Retrieve($id) { if (!$id) { return null; } $entity = new Entity(); $query = "SELECT * FROM #__content WHERE id = ?"; $object = $entity->GetFirstResult($query, $id, __CLASS__); if (!$object->id) { return null; } return $object; }
static function Retrieve($id) { if (!$id) { return null; } $entity = new Entity(); $query = "SELECT * FROM #__contact_details WHERE id = ?"; $object = $entity->GetFirstResult($query, $id, __CLASS__); if (!$object) { return null; } $object->user = User::Retrieve($object->user_id); return $object; }
/** * Retrieve row from database where id = $id ( or id => $id_name ) * @param int $id * @param string $id_name * @param string $class * @return object * Returns object type of entity */ static function Retrieve($id, $class = __CLASS__) { if (!$id) { return null; } $object = new $class(); $object->BuildSchema(); $entity = new Entity(); $query = "SELECT * FROM `{$object->table_name}` WHERE `{$object->id_name}` = ? LIMIT 1"; $object = $entity->GetFirstResult($query, $id, $class); if (!$object) { return null; } return $object; }
static function RetrieveByFile($file) { $query = "SELECT * FROM image WHERE file = ?"; $entity = new Entity(); return $entity->GetFirstResult($query, $file, __CLASS__); }