Classified information paging list program writing example

<?php
require('../../class/connect.php'); //Introduce database configuration files and public function files
require('../../class/db_sql.php'); //Introduce database operation files
require('../../data/dbcache/class.php'); //Introduce column cache files
require '../'.LoadLang("pub/fun.php"); //Introduce paging language pack file
$link=db_connect(); //Connect to MYSQL
$empire=new mysqlquery(); //Declare database operation class
$editor=1; //Declare directory hierarchy

//--------Paging parameters --------
$page=(int)$_GET['page'];
$start=0;
$line=10; //Display number of records per page
$page_line=8; //Display the number of paging links per page
$offset=$page*$line; //Total offset

//-------- Query SQL --------
//Get the total number of information
$totalquery="select count(*) as total from {$dbtbpre}ecms_info where checked=1";
$num=$empire->gettotal($totalquery);
//select query SQL
$query="select * from {$dbtbpre}ecms_info where checked=1";
$query.=" order by newstime desc limit $offset,$line";
$sql=$empire->query($query);

$listpage=page1($num,$line,$page_line,$start,$page,$search);//Get paging navigation
require('template/index.temp.php'); //Import template file

db_close(); //Close the MYSQL link
$empire=null; //Cancel operation class variables
?>