public static function get($id) { if (!$id || !is_numeric($id)) { return false; } $db = SqlHandler::getInstance(); $q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE id = ?'; $row = $db->pSelectRow($q, 'i', $id); $obj = SqlObject::loadObject($row, __CLASS__); if (!$obj) { throw new \Exception('bad id ' . $id); } $obj->episodes = TvEpisode::getAllByOwner($id); return $obj; }
public static function getByReference($type, $reference) { $q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE type = ? AND reference = ?'; $row = Sql::pSelectRow($q, 'ii', $type, $reference); return SqlObject::loadObject($row, __CLASS__); }
public static function getLatestByOwner($type, $owner) { $q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE type = ? AND owner = ?' . ' ORDER BY time_saved DESC' . ' LIMIT 1'; $row = Sql::pSelectRow($q, 'ii', $type, $owner); return SqlObject::loadObject($row, __CLASS__); }
public static function get($id) { $q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE id = ?' . ' AND time_deleted IS NULL'; $row = Sql::pSelectRow($q, 'i', $id); return SqlObject::loadObject($row, __CLASS__); }
static function get($id) { $q = 'SELECT * FROM tblPolls WHERE id = ? AND deleted_by = ?'; $row = Sql::pSelectRow($q, 'ii', $id, 0); return SqlObject::loadObject($row, __CLASS__); }
public static function getByOwner($id) { $q = 'SELECT * FROM ' . self::$tbl_name . ' WHERE owner = ?' . ' ORDER BY time_saved DESC' . ' LIMIT 1'; $res = Sql::pSelectRow($q, 'i', $id); return SqlObject::loadObject($res, __CLASS__); }