• <tr id='VWFNvc'><strong id='VWFNvc'></strong><small id='VWFNvc'></small><button id='VWFNvc'></button><li id='VWFNvc'><noscript id='VWFNvc'><big id='VWFNvc'></big><dt id='VWFNvc'></dt></noscript></li></tr><ol id='VWFNvc'><option id='VWFNvc'><table id='VWFNvc'><blockquote id='VWFNvc'><tbody id='VWFNvc'></tbody></blockquote></table></option></ol><u id='VWFNvc'></u><kbd id='VWFNvc'><kbd id='VWFNvc'></kbd></kbd>

    <code id='VWFNvc'><strong id='VWFNvc'></strong></code>

    <fieldset id='VWFNvc'></fieldset>
          <span id='VWFNvc'></span>

              <ins id='VWFNvc'></ins>
              <acronym id='VWFNvc'><em id='VWFNvc'></em><td id='VWFNvc'><div id='VWFNvc'></div></td></acronym><address id='VWFNvc'><big id='VWFNvc'><big id='VWFNvc'></big><legend id='VWFNvc'></legend></big></address>

              <i id='VWFNvc'><div id='VWFNvc'><ins id='VWFNvc'></ins></div></i>
              <i id='VWFNvc'></i>
            1. <dl id='VWFNvc'></dl>
              1. <blockquote id='VWFNvc'><q id='VWFNvc'><noscript id='VWFNvc'></noscript><dt id='VWFNvc'></dt></q></blockquote><noframes id='VWFNvc'><i id='VWFNvc'></i>

                SELECT COUNT(photo_id) AS SP_COUNTER FROM gsp_photo WHERE category_id= or category_id in (1,2,23,66,88,102,103,108,210)
                执行错误: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or category_id in (1,2,23,66,88,102,103,108,210)' at line 1

                57.      {
                58.          $this->arrSql[] = $sql;
                59.          if( $result mysql_query($sql$this->conn) ){
                60.              return $result;
                61.          }else{
                62.              spError("{$sql}<br />执行错误: " mysql_error());
                63.          }
                64.      }
                65.      
                66.      /**
                67.       返回∴影响行数
                21.       
                22.       * @param sql  执行的SQL语句
                23.       */
                24.      public function getArray($sql)
                25.      {
                26.          if( ! $result $this->exec($sql) )return array();
                27.          if( ! mysql_num_rows($result) )return array();
                28.          $rows = array();
                29.          while($rows[] = mysql_fetch_array($result,MYSQL_ASSOC)){}
                30.          mysql_free_result($result);
                31.          array_pop($rows);
                290.              if(null != $conditions)$where "WHERE ".$conditions;
                291.          }
                292.          $this->pk=isset($this->pk)?$this->pk:"*";
                293.          $sql "SELECT COUNT({$this->pk}) AS SP_COUNTER FROM {$this->tbl_name} {$where}";
                294.          
                295.          $result $this->_db->getArray($sql);
                296.          return $result[0]['SP_COUNTER'];
                297.      }
                298. 
                299.      /**
                300.       魔术函数,执行模型扩展】类的自动加载及使用
                473.          $pageSize $this->input_args[1];
                474.          @list($conditions$sort$fields ) = $func_args;
                475.          if('findSql'==$func_name){
                476.              $total_count array_poparray_pop$this->model_obj->findSql("SELECT COUNT({$this->model_obj->pk}) as sp_counter FROM ($conditions) sp_tmp_table_pager1") ) );
                477.          }else{
                478.              $total_count $this->model_obj->findCount($conditions);
                479.          }
                480.          if($total_count $pageSize){
                481.              $total_page ceil$total_count $pageSize );
                482.              $page min(intval(max($page1)), $total_count); // 对页码进行规范运算
                483.              $this->pageData = array(
                448.      /** 
                449.       魔术函数,支持多重函数☆式使用类的方法
                450.       */
                451.      public function __call($func_name$func_args){
                452.          if( ( 'findAll' == $func_name || 'findSql' == $func_name ) && != $this->input_args[0]){
                453.              return $this->runpager($func_name$func_args);
                454.          }elseif(method_exists($this,$func_name)){
                455.              return call_user_func_array(array($this$func_name), $func_args);
                456.          }else{
                457.              return call_user_func_array(array($this->model_obj$func_name), $func_args);
                458.          }
                40.          
                41.          $condition=$category->getIds($category_id);
                42.          
                43.          
                44.          
                45.          $this->photolist=$photo->spPager($this->spArgs('page',1),$pagesize)->findAll($condition,"ord asc","photo_id,photo_name,photo_pic,adddate,viewnum,photo_content,photo_area");
                46.          $this->pager=$photo->spPager()->getPager();
                47.          if($this->pager)
                48.          {
                49.              import("page.php");
                50.              $page=new Page($this->pager["total_count"],$pagesize,$this->spArgs('page',1));
                40.          
                41.          $condition=$category->getIds($category_id);
                42.          
                43.          
                44.          
                45.          $this->photolist=$photo->spPager($this->spArgs('page',1),$pagesize)->findAll($condition,"ord asc","photo_id,photo_name,photo_pic,adddate,viewnum,photo_content,photo_area");
                46.          $this->pager=$photo->spPager()->getPager();
                47.          if($this->pager)
                48.          {
                49.              import("page.php");
                50.              $page=new Page($this->pager["total_count"],$pagesize,$this->spArgs('page',1));
                16.      if(!is_object($handle_controller) || !method_exists($handle_controller$__action)){
                17.          eval($GLOBALS['G_SP']["dispatcher_error"]);
                18.          exit;
                19.      }
                20.      // 路由并执行用户代『码
                21.      $handle_controller->$__action();
                22.      // 控制←器程序运行完毕,进行模板的自动输出
                23.      if(FALSE != $GLOBALS['G_SP']['view']['auto_display']){
                24.          $__tplname $__controller.$GLOBALS['G_SP']['view']['auto_display_sep'].
                25.                  $__action.$GLOBALS['G_SP']['view']['auto_display_suffix']; // 拼装模板路径
                26.          $handle_controller->auto_display($__tplname);
                24.      ),
                25.  );
                26. 
                27.  require(SP_PATH."/SpeedPHP.php");
                28.  require(SP_PATH."/Extensions/cyFunctions.php");
                29.  spRun();
                30. 
                31.  ?>