PHP utils Utils::getConnect示例

示例#1

文件： Section.php 项目： hacke151/StudyProject_php

 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();
 }

示例#2

文件： Element.php 项目： hacke151/StudyProject_php

 public static function getBySectionID($sectionID)
 {
     $stmt = Utils::getConnect()->prepare("SELECT * FROM elements WHERE sectionID = :sectionID");
     $stmt->execute(array('sectionID' => $sectionID));
     return $stmt->fetchAll();
 }