public static function getByParentID($parentID) { if (!$parentID) { $stmt = Utils::getConnect()->prepare("SELECT * FROM sections WHERE sectionParentID is null"); } else { $stmt = Utils::getConnect()->prepare("SELECT * FROM sections WHERE sectionParentID = :sectionParentID"); } $stmt->execute(array('sectionParentID' => $parentID)); return $stmt->fetchAll(); }
public static function getBySectionID($sectionID) { $stmt = Utils::getConnect()->prepare("SELECT * FROM elements WHERE sectionID = :sectionID"); $stmt->execute(array('sectionID' => $sectionID)); return $stmt->fetchAll(); }