php mysql数据库操作分页类

2019-04-10 20:34:49刘景俊

         * $tablename 表名, $where 查询条件, $orderby 排序字段(默认以id倒序排列)
         */
        function get_rows($tablename, $where="", $orderby=""){
            $this->table["tablename"]    = $tablename;
            $this->table["where"]        = $where;
            $orderby ? $this->table["orderby"] = $orderby : "";
            $arr = array(
                "page"    => $this->show_page(),            //分页代码
                "rows"    => $this->get_rows_by_sql(),    //记录数
                "sum"    => $this->total_records,        //总记录数
            );
            return $arr;
        }
        /*
         * 特殊查询,$sql_query 查询sql语句, $row_count 统计总数
         */
        function get_rows_sql($sql_query, $row_count=0) {
            $this->total_records = $row_count;
            $arr["rows"]    = $this->get_rows_by_sql($sql_query);
            $arr["page"]    = $this->show_page();
            $arr["sum"]        = $this->total_records;
            return $arr;
        }
        function get_sql(){
            if ($this->total_records>10000) {
相关文章 大家在看