PHP self::getDataByArray Examples

Example #1

File: User.php Project: tuyenv/litpi-framework-3

 private static function getList($where, $joinString, $order, $limit, $bindParams)
 {
     $db = self::getDb();
     $outputList = array();
     $sql = 'SELECT * FROM ' . TABLE_PREFIX . 'ac_user u
             ' . $joinString . '';
     if ($where != '') {
         $sql .= ' WHERE ' . $where;
     }
     if ($order != '') {
         $sql .= ' ORDER BY ' . $order;
     }
     if ($limit != '') {
         $sql .= ' LIMIT ' . $limit;
     }
     $stmt = $db->query($sql, $bindParams);
     while ($row = $stmt->fetch()) {
         $myUser = new self();
         $myUser->getDataByArray($row);
         $outputList[] = $myUser;
     }
     return $outputList;
 }