//alert(json.data);
},
error: function(xhr, textStatus, errorThrown) {
//called when there is an error
}
});
}
/**
* On-hook paging event
* Parameter page_page current page
* Parameter page_end Number of pages */
function admin_content_page(page_page,page_end) {
$("#mainPage a").click(function() {
var charStr = $(this).text();
var num = charStr;
if (charStr == "»") {
num = parseInt(page_page) + 1;
if (page_end
return;
}
} else if (charStr == "«") {
num = parseInt(page_page) - 1;
if (num
return;
}
}
admin_content(num);
});
}
function admin_content_del (id) {
alert(id);
}
function getLocalTime(nS) {
return new Date(parseInt(nS) * 1000).toLocaleString().replace(/:d{1,2}$/, ' ');
}
//alert(json.data);
},
error: function(xhr, textStatus, errorThrown) {
//called when there is an error
}
});
}
/**
* On-hook paging event
* Parameter page_page current page
* Parameter page_end Number of pages */
function admin_content_page(page_page,page_end) {
$("#mainPage a").click(function() {
var charStr = $(this).text();
var num = charStr;
if (charStr == "»") {
num = parseInt(page_page) + 1;
if (page_end
return;
}
} else if (charStr == "«") {
num = parseInt(page_page) - 1;
if (num
return;
}
}
admin_content(num);
});
}
function admin_content_del (id) {
alert(id);
}
function getLocalTime(nS) {
return new Date(parseInt(nS) * 1000).toLocaleString().replace(/:d{1,2}$/, ' ');
}这是分页请求的服务端代码
[php] public function content()
{
//引入分页类
include "page.class.php";
//得到data表的数据数量
$rows = $this->db->count('select * from data');
//创建分页对象
$page = new Page($rows, 5, "");
$list=$this->db
->order('id DESC')
->table('data')
->limit($page->getLimit())
->select();
/*
echo "
public function content()
{
//Introduce paging class
Include "page.class.php";
//Get the number of data in the data table
$rows = $this->db->count('select * from data');
//Create paging object
$page = new Page($rows, 5, "");
$list=$this->db
->order('id DESC')
->table('data')
->limit($page->getLimit())
->select();
/*
echo "
";<br>
var_dump($list);<br>
echo "
Copy after login
";
*/
$json['state']='ok';
$json['start']=$page->getStart();
$json['end']=$page->getEnd();
$json['page']=$page->getPage();
$json['data']=$list;
echo json_encode($json);
//exit();
}
When doing this paging, because it is ajax, the html code generation is all on the client side. After my observation, there is a problem with this paging class. In fact a lot of the code doesn't need to exist. I'll kill him when I have time.
Attach the code page.class.php
[php]
/**
File: page.class.php
Perfect paging type Page
@Qq496928838
*/
Class Page {
private $total;
private $listRows;
Private $ Limit; // SQL statement uses limit clauses to limit the number of records
private $uri; //Automatically obtain the request address of the url
private $pageNum;
private $page;
private $config = array(
'head' => "record",
'prev' => "Previous page",
'next' => "Next page",
'first'=> "Home",
'last' => "Last page"
);
Private $ listnum = 10; // The number of default layout lists
/**
Construction method, you can set the properties of the paging class
@param int $total
’ ’ s ’ s ’ s ’ t ’ t ’ t ’ to ’ t ’ t ’ to ’ t ’ ’ s to ’ ’ s ’ s ’ t ‐ ‐ ‐ ‐
@Param Mixed $ Query can choose parameters to the target page, which can be an array or query string format
@param bool $ord Optional, the default value is true, the page will be displayed from the first page, false will be the last page
*/
public function __construct($total, $listRows=25, $query="", $ord=true){
$this->total = $total; $this->listRows = $listRows;
$this->uri = $this->getUri($query);
$this->pageNum = ceil($this->total / $this->listRows);
/*以下判断用来设置当前面*/
if(!empty($_GET["page"])) {
$page = $_GET["page"];
}else{
if($ord)
$page = 1;
else
$page = $this->pageNum;
}
/**
For the information for setting the paging, you can perform coherent operations
@param string $param is the subscript of the member attribute array config
@param string $value is used to set the element value corresponding to the config subscript
@Return Object Return to this object itself $ this, used to operate
*/
function set($param, $value){
if(array_key_exists($param, $this->config)){
$this->config[$param] = $value;
}
return $this;
}
/* Private method used inside the object to get the number of records at the beginning of the current page */
private function start(){
If($this->total == 0)
Return 0;
else
return ($this->page-1) * $this->listRows+1;
}
/* Private method used inside the object to get the number of records at the end of the current page */
private function end(){
return min($this->page * $this->listRows, $this->total);
}
/* Private method used inside the object to obtain the operation information of the previous page and home page */
private function firstprev(){
If($this->page > 1) {
$str = " {$this->config["first"]} ";
$str .= "{$this->config["prev"] } ";
return $str;
}
/* Private method used inside the object to obtain page list information */
private function pageList(){
$linkPage = " ";
$inum = floor($this->listNum/2);
/*List in front of the current page */
for($i = $inum; $i >= 1; $i--){
$page = $this->page-$i;
If($page >= 1)
$linkPage .= "{$page} ";
/*Information of the current page */
If($this->pageNum > 1)
$linkPage .= "{$this->page} ";
/*List behind the current page */
for($i=1; $i $page = $this->page+$i;
If($page pageNum)
$linkPage .= "{$page} ";
else
break;
$linkPage .= '';
return $linkPage;
}
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
