PHP Validate::isNullArray方法代碼示例

 protected function select(array $selectFields, array $param, $tables)
 {
     $limit = $order = $where = $fromTables = $like = '';
     $fields = implode(',', $selectFields);
     //處理篩選條件
     if (!Validate::isNullArray($param)) {
         $limit = isset($param['limit']) ? ' LIMIT  ' . $param['limit'] : '';
         $order = isset($param['order']) ? ' ORDER BY ' . $param['order'] : '';
         if (isset($param['where'])) {
             $isAnd = '';
             foreach ($param['where'] as $value) {
                 $isAnd .= $value . ' AND ';
             }
             $where = ' WHERE ' . substr($isAnd, 0, -4);
         }
         if (isset($param['like'])) {
             foreach ($param['like'] as $key => $value) {
                 $like = " WHERE {$key} LIKE '%{$value}%'";
             }
         }
     }
     //處理多表聯查
     foreach ($tables as $value) {
         $fromTables .= $value . ' ,';
     }
     $fromTables = substr($fromTables, 0, -1);
     $sql = "SELECT {$fields} FROM {$fromTables} {$where} {$like} {$order} {$limit} ";
     $stmt = $this->execute($sql);
     $result = array();
     while (!!($obj = $stmt->fetchObject())) {
         $result[] = $obj;
     }
     return Tool::setHtmlString($result);
 }

 public function filter(array $fields)
 {
     $selectDate = array();
     if (Validate::isArray($_POST) && !Validate::isNullArray($_POST)) {
         foreach ($_POST as $key => $value) {
             if (Validate::inArray($key, $fields)) {
                 $selectDate[$key] = $value;
             }
         }
     }
     return $selectDate;
 }

 public function filter(array $_fields)
 {
     $_selectData = array();
     if (Validate::isArray($_POST) && !Validate::isNullArray($_POST)) {
         //篩選準備入庫的字段和數據
         foreach ($_POST as $_key => $_value) {
             if (Validate::inArray($_key, $_fields)) {
                 $_selectData[$_key] = $_value;
             }
         }
     }
     return $_selectData;
 }

 public static function setHtmlString($_data)
 {
     $_string = null;
     if (Validate::isArray($_data)) {
         if (Validate::isNullArray($_data)) {
             return $_data;
         }
         foreach ($_data as $_key => $_value) {
             $_string[$_key] = self::setHtmlString($_value);
         }
     } elseif (is_object($_data)) {
         foreach ($_data as $_key => $_value) {
             $_string->{$_key} = self::setHtmlString($_value);
         }
     } else {
         $_string = htmlspecialchars($_data);
     }
     return $_string;
 }

 public function fileUser($file)
 {
     foreach ($file as $key => $value) {
         if (!is_object($value)) {
             $user = parent::select(array('id,user,thumb'), array('where' => array("thumb='upload/{$_GET['file']}/{$value}'")));
             if (!Validate::isNullArray($user)) {
                 $user[0]->pic = $value;
                 $user[0]->link = 'user';
                 $user[0]->name = $user[0]->user . '[<strong style="color:green;font-size:12px;">會員頭像</strong>]';
                 $file[$key] = $user[0];
             }
         }
     }
     return $file;
 }

 protected function select($_tables, array $_field, array $_param = array())
 {
     $_limit = '';
     $_order = '';
     $_where = '';
     $_like = '';
     if (Validate::isArray($_param) && !Validate::isNullArray($_param)) {
         $_limit = isset($_param['limit']) ? 'LIMIT ' . $_param['limit'] : '';
         $_order = isset($_param['order']) ? 'ORDER BY ' . $_param['order'] : '';
         $_where = '';
         if (isset($_param['where'])) {
             foreach ($_param['where'] as $_key => $_value) {
                 $_where .= $_value . ' AND ';
             }
             $_where = 'WHERE ' . substr($_where, 0, -4);
         }
         if (isset($_param['like'])) {
             foreach ($_param['like'] as $_key => $_value) {
                 $_like = "WHERE {$_key} LIKE '%{$_value}%'";
             }
         }
     }
     $_selectFields = implode(',', $_field);
     $_table = isset($_tables[1]) ? $_tables[0] . ',' . $_tables[1] : $_tables[0];
     $_sql = "SELECT {$_selectFields} FROM {$_table} {$_where} {$_like} {$_order} {$_limit} ";
     $_stmt = $this->execute($_sql);
     $_result = array();
     while (!!($_objs = $_stmt->fetchObject())) {
         $_result[] = $_objs;
     }
     return Tool::setHtmlString($_result);
 }

 private function getNavId()
 {
     $this->_tables = array(DB_PREFIX . 'nav');
     //商品副類id數組
     $_idArr = parent::select(array('id'), array('where' => array("sid='{$this->_R['navid']}'")));
     $_id = '';
     //副類處理
     if (Validate::isNullArray($_idArr)) {
         $_id = $this->_R['navid'];
     } else {
         foreach ($_idArr as $_key => $_value) {
             $_id .= $_value->id . ',';
         }
         $_id = substr($_id, 0, -1);
     }
     $this->_tables = array(DB_PREFIX . 'goods');
     return $_id;
 }

 private function getNavId()
 {
     //商品副類id數組
     $_idArr = parent::select(array('id'), array('where' => array("sid='{$this->_R['navid']}'")));
     $_id = array();
     //副類處理
     if (Validate::isNullArray($_idArr)) {
         $_id[] = $this->_R['navid'];
     } else {
         foreach ($_idArr as $_key => $_value) {
             $_id[] .= $_value->id;
         }
     }
     return $_id;
 }

 public function fileRotator($file)
 {
     foreach ($file as $key => $value) {
         if (!is_object($value)) {
             $rotator = parent::select(array('id,thumb,name'), array('where' => array("thumb='upload/{$_GET['file']}/{$value}'")));
             if (!Validate::isNullArray($rotator)) {
                 $rotator[0]->pic = $value;
                 $rotator[0]->link = 'index';
                 $rotator[0]->name = $rotator[0]->name . '[<strong style="color:green;font-size:12px;">輪播器</strong>]';
                 $file[$key] = $rotator[0];
             }
         }
     }
     return $file;
 }

 public function fileGoods($file)
 {
     foreach ($file as $key => $value) {
         if (!is_object($value)) {
             $goods = parent::select(array('id,nav,name'), array('where' => array("thumb='upload/{$_GET['file']}/{$value}' OR\r\n\t\t\t\t\t\tthumb_small='upload/{$_GET['file']}/{$value}' OR\r\n\t\t\t\t\t\t\t\tcontent LIKE '%upload/{$_GET['file']}/{$value}%'")));
             if (!Validate::isNullArray($goods)) {
                 $goods[0]->pic = $value;
                 $goods[0]->name = $goods[0]->name . '[<strong style="color:green;font-size:12px;">商品</strong>]';
                 $file[$key] = $goods[0];
             }
         }
     }
     return $file;
 }

 public function getFrontAttr()
 {
     //用於存放所有的符合查詢條件的導航信息id
     $array = array();
     //獲得全部的導航
     $allNav = parent::select(array('id', 'sid'));
     foreach ($allNav as $key => $value) {
         //通過主導航保存子導航id
         if ($value->sid == $this->R['navid']) {
             $array[] = $value->id;
         } else {
             //保存子導航id
             $array[] = $this->R['navid'];
         }
     }
     $this->tables = array(DB_FREFIX . 'attr');
     //查詢屬性信息
     $allAttr = parent::select(array('name', 'item', 'id', 'nav'));
     //用於保存最終生成的屬性信息
     $frontAttr = array();
     foreach ($allAttr as $key => $value) {
         //屬性中的nav字段轉為數組
         $value->nav = explode(',', $value->nav);
         //如果導航id與屬性nav集合之間有交集則證明該導航有相關屬性信息
         if (array_intersect($array, $value->nav)) {
             //轉屬性為數組
             $value->item = explode('|', $value->item);
             //轉url屬性為數組
             $getAttr = explode('-', $this->R['attr']);
             //用於存放每組屬性與url的交集，屬性每組隻有一個位於url中，所以該數組永遠隻有一個元素
             $attrArray = array_intersect($getAttr, $value->item);
             //顯示“全部”是否被選中，用flag做判定，如果URL中已有信息為該屬性的則證明已有屬性被選中，flag為TRUE
             $value->flag = $attrArray ? true : false;
             //存放前台顯示全部按鈕的具體href信息 顯示全部即為去掉當前屬性中的相關信息
             $value->all = implode('-', array_diff($getAttr, $value->item)) ? '&attr=' . implode('-', array_diff($getAttr, $value->item)) : null;
             //該循環用於過濾url中由於多次點擊而重複出現的attr屬性
             foreach ($value->item as $k => $v) {
                 if (!Validate::isNullArray($attrArray)) {
                     //該處$attrArray永遠隻有一個元素，因為attr中相關屬性隻能有一個
                     foreach ($attrArray as $val) {
                         $attrArray[0] = $val;
                     }
                     //如果url中已有相關屬性值用最新的替換之，temp用於存放生成的url地址欄信息
                     $value->temp[] = $temp = str_replace($attrArray[0], $v, $this->R['attr']);
                 } elseif (!isset($this->R['attr']) || empty($this->R['attr'])) {
                     //初次加載URL中沒有相關attr時
                     $value->temp[] = $v;
                 } elseif (Validate::isNullArray($attrArray)) {
                     //用於不同屬性之間的鏈接
                     $value->temp[] = $this->R['attr'] . '-' . $v;
                 }
             }
             //將item與temp鏈接item為key，temp為值
             $value->attr = array_combine($value->item, $value->temp);
             $frontAttr[] = $value;
         }
     }
     return $frontAttr;
 }