public static function findByNameAndPageId($name, $id, $class = __CLASS__) { $params['where'] = sprintf("name='%s' AND page_id=%d", $name, $id); $sql = Record::buildSql($params, $class); return self::connection()->query($sql, PDO::FETCH_CLASS, $class)->fetch(); }
public static function find($params = null, $class = __CLASS__) { $retval = array(); $sql = Record::buildSql($params, $class); foreach (self::connection()->query($sql, PDO::FETCH_CLASS, $class) as $object) { $retval[] = $object; } return $retval; }
public static function findBySlugAndParentId($slug, $parent_id = 0, $class = __CLASS__) { /* TODO: Behaviour pagehack seems kludgish. */ $parent = Page::findById($parent_id); if ($parent && $parent->behaviorId()) { $class = Behavior::loadPageHack($parent->behaviorId()); } $params['where'] = sprintf("slug=%s AND parent_id=%d", self::connection()->quote($slug), $parent_id); $sql = Record::buildSql($params, $class); // print_r(self::connection()->query($sql, PDO::FETCH_CLASS, $class)->fetch()); return self::connection()->query($sql, PDO::FETCH_CLASS, $class)->fetch(); }