The eighth day of php practice_PHP tutorial-PHP Tutorial-php.cn

今天是学习做后台页面布局，用得是bootcss。那么效果展示一下。

The eighth day of php practice_PHP tutorial

布局的代码

[html]

无标题文档

瀑布流留言板管理系统

无标题文档

瀑布流留言板管理系统

Learn javascript functions from middle school

str.substr(0,20) means taking 20 characters starting from 0 characters

Math.random() takes a random number

switch statement

This background is ajax. I have been writing pagination for a long time. Okay, let’s get straight to the code.

[javascript] // JavaScript Document
$('body').off('.data-api');

$(document).ready(function(e) {

    $("#menu a").click(function() {

        switch ($(this).text()) {
            case '所有留言':
                admin_content(1);
                break;

            case '基本设置':
                $("#main #mainData").load('admin_config.html?r='+Math.random());
                break;

            default:
                break;
        }

    });

    $("#start").click();
});

/**
*留言管理
*/
function admin_content(page) {
    $.ajax({
        url: 'http://localhost/l/admin.php?m=admin&a=content&page=' + page + '&rand=' + Math.random(),
        type: 'get',
        dataType: 'json',
        data: {},
        complete: function(xhr, textStatus) {
            //called when complete
        },
        success: function(json, textStatus, xhr) {
            if (json['state'] == 'ok') {
                var page_start = json['start'];//分页开始
                var page_end = json['end'];//分页结束
                var page_page = json['page'];//分页当前页面
                var data = json['data'];//分页数据
/**
* 生成表格内容
*/
                var table_html = '

';
                for (i = 0; i                     var trClass = (i % 2 == 0) ? 'class="info"' : '';

                    var tr_html = '';
                    table_html = table_html + tr_html;
                }
                table_html = table_html + '

操作	用户名	留言内容	发表时间
删除	' + data[i].userName + '	' + data[i].content + '	' + getLocalTime(data[i].time) + '

';

/**
*生成分页
*/
var page_html = '

' + i + '

' + i + '

';

                var mainData = $("#main #mainData");
                mainData.html(table_html);
                mainData.append(page_html);

                admin_content_page(page_page,page_end); //挂接分页点击事件
            }

            //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}$/, ' ');
}

// JavaScript Document
$('body').off('.data-api');

$(document).ready(function(e) {

$("#menu a").click(function() {

  switch ($(this).text()) {
   case '所有留言':
    admin_content(1);
    break;

   case '基本设置':
    $("#main #mainData").load('admin_config.html?r='+Math.random());
    break;

   default:
    break;
  }

});

$("#start").click();
});

/**
*留言管理
*/
function admin_content(page) {
$.ajax({
  url: 'http://localhost/l/admin.php?m=admin&a=content&page=' + page + '&rand=' + Math.random(),
  type: 'get',
  dataType: 'json',
  data: {},
  complete: function(xhr, textStatus) {
   //called when complete
  },
  success: function(json, textStatus, xhr) {
   if (json['state'] == 'ok') {
    var page_start = json['start'];//分页开始
    var page_end = json['end'];//分页结束
    var page_page = json['page'];//分页当前页面
    var data = json['data'];//分页数据
/**
* 生成表格内容
*/
    var table_html = '

';
for (i = 0; i var trClass = (i % 2 == 0) ? 'class="info"' : '';

var tr_html = '

';
     table_html = table_html + tr_html;
    }
    table_html = table_html + '

操作	用户名	留言内容	发表时间
删除	' + data[i].userName + '	' + data[i].content + '	' + getLocalTime(data[i].time) + '

/**
*生成分页
*/
var page_html = '

' + i + '

' + i + '

    }
    if (page_end !== 0) {
     if (page_page == page_end) {
      page_html = page_html + '

}
page_html = page_html + '

    var mainData = $("#main #mainData");
    mainData.html(table_html);
    mainData.append(page_html);

admin_content_page(page_page,page_end); //挂接分页点击事件
}

   //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 "

";<br>
    var_dump($list);<br>
    echo "

Copy after login

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;
            }

            if($total > 0) {
                if(preg_match('/D/', $page) ){
                    $this->page = 1;
                }else{
                    $this->page = $page;
                }
            }else{
                $this->page = 0;
            }

            $this->limit = "LIMIT ".$this->getLimit();
        }

        /**
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;
        }

        /* 不是直接去调用，通过该方法，可以使用在对象外部直接获取私有成员属性limit和page的值 */
        function __get($args){
            if($args == "limit" || $args == "page")
                return $this->$args;
            else
                return null;
        }

        /**
            按指定的格式输出分页
            @param int 0-7的数字分别作为参数，用于自定义输出分页结构和调整结构的顺序，默认输出全部结构
            @return string 分页信息内容
         */
        function fpage(){
            $arr = func_get_args();

            $html[0] = " 共 {$this->total} {$this->config["head"]} ";
            $html[1] = " 本页 ".$this->disnum()." 条 ";
            $html[2] = " 本页从 {$this->start()}-{$this->end()} 条 ";
            $html[3] = " {$this->page}/{$this->pageNum}页 ";
            $html[4] = $this->firstprev();
            $html[5] = $this->pageList();
            $html[6] = $this->nextlast();
            $html[7] = $this->goPage();

            $fpage = '

';
            if(count($arr)                 $arr = array(0, 1,2,3,4,5,6,7);

            for($i = 0; $i                 $fpage .= $html[$arr[$i]];

            $fpage .= '

';
                return $fpage;
         }
                                                        /* The format is 1,5,*/
function getLimit(){
If($this->page > 0)
                   return ($this->page-1)*$this->listRows.",{$this->listRows}";
else Return 0;
         }

//Current page
function getPage(){
               return $this->page;
         }
//Start of paging
function getStart(){
$num1=$this->page-4;

                return $num1>0?$num1:1;

         }
//End of paging
function getEnd(){
$num1=$this->pageNum;
$num2=$this->page+5;

                 return $num1          }

              /* Private method used inside the object to automatically obtain the current URL visited */
         private function getUri($query){                                                         $request_uri = $_SERVER["REQUEST_URI"];
$url = strstr($request_uri,'?') ? $request_uri : $request_uri.'?';
                                                                    If(is_array($query))
                       $url .= http_build_query($query);
               else if($query != "")
                      $url .= "&".trim($query, "?&");
                                                                        $arr = parse_url($url);

If(isset($arr["query"])){
                    parse_str($arr["query"], $arrs);
                   unset($arrs["page"]);
$url = $arr["path"].'?'.http_build_query($arrs);
                                                                                                                                                                                                          If(strstr($url, '?')) {
If(substr($url, -1)!='?')
$url = $url.'&';
              }else{
$url = $url.'?';
                                                                                                                                                                                                                      return $url;
         }

                 /* 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;
         }

              /* Private method used inside the object to obtain the operation information of the next page and the last page */
private function nextlast(){
If($this->page != $this->pageNum) {
$str = " {$this->config["next"]} ";
$str .= " {$this->config["last"]}< ;/a> ";
                                   return $str;                                                                                                                                                                       }

/ * Private method used inside the object, used to display and process form jump pages * /
         private function goPage(){
If($this->pageNum > 1) {
return ' ';
                                                                                                                                               }

/* Private method used inside the object to obtain the number of records displayed on this page */
         private function disnum(){
If($this->total > 0){
Return $this->end()-$this->start()+1;
              }else{
Return 0;
                                                                                                                                               }
}

/**
file: page.class.php
Perfect paging type Page
@微 Cool QQ496928838
*/
class Page {
private $total; //Total number of records in the data table
private $listRows; //Display number of rows per page
private $limit; //SQL statement uses limit clause to limit the number of records obtained
private $uri; //Automatically obtain the request address of the url
private $pageNum; //Total number of pages
private $page; //Current page
private $config = array(
        'head' => "record",
        'prev' => "Previous page",
'next' => "Next page",
        'first'=> "Home",
        'last' => "Last page"
);        // Display content in paging information, you can set it yourself through the set() method
private $listNum = 10; //The number of items displayed in the default paging list

/**
Constructor method, you can set the attributes of the paging class
@param int $total Calculate the total number of paging records
@param int $listRows Optional, set the number of records to be displayed on each page, the default is 25
@param mixed $query Optional, in order to pass parameters to the target page, it can be an array or a 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);
/*The following judgments are used to set the current state*/
if(!empty($_GET["page"])) {
$page = $_GET["page"];
}else{
If($ord)
$page = 1;
else
$page = $this->pageNum;
}

if($total > 0) {
If(preg_match('/D/', $page) ){
$this->page = 1;
}else{
$this->page = $page;
}
}else{
$this->page = 0;
}

$this->limit = "LIMIT ".$this->getLimit();
}

  /**
   用于设置显示分页的信息，可以进行连贯操作
   @param string $param 是成员属性数组config的下标
   @param string $value 用于设置config下标对应的元素值
   @return object   返回本对象自己$this，用于连惯操作
   */
  function set($param, $value){
   if(array_key_exists($param, $this->config)){
    $this->config[$param] = $value;
   }
   return $this;
  }

  /* 不是直接去调用，通过该方法，可以使用在对象外部直接获取私有成员属性limit和page的值 */
  function __get($args){
   if($args == "limit" || $args == "page")
    return $this->$args;
   else
    return null;
  }

  /**
   按指定的格式输出分页
   @param int 0-7的数字分别作为参数，用于自定义输出分页结构和调整结构的顺序，默认输出全部结构
   @return string 分页信息内容
   */
  function fpage(){
   $arr = func_get_args();

   $html[0] = " 共 {$this->total} {$this->config["head"]} ";
   $html[1] = " 本页 ".$this->disnum()." 条 ";
   $html[2] = " 本页从 {$this->start()}-{$this->end()} 条 ";
   $html[3] = " {$this->page}/{$this->pageNum}页 ";
   $html[4] = $this->firstprev();
   $html[5] = $this->pageList();
   $html[6] = $this->nextlast();
   $html[7] = $this->goPage();

$fpage = '

';
   if(count($arr)     $arr = array(0, 1,2,3,4,5,6,7);

   for($i = 0; $i     $fpage .= $html[$arr[$i]];

   $fpage .= '

';
Return $fpage;
}

/* The format is 1,5,*/
function getLimit(){
If($this->page > 0)
Return ($this->page-1)*$this->listRows.",{$this->listRows}";
else
Return 0;
}

//Current page
function getPage(){
Return $this->page;
}
//Start of pagination
function getStart(){
$num1=$this->page-4;

return $num1>0?$num1:1;

}
//End of paging
function getEnd(){
$num1=$this->pageNum;
$num2=$this->page+5;

return $num1 }

/* Private method used inside the object to automatically obtain the current URL visited */
private function getUri($query){
$request_uri = $_SERVER["REQUEST_URI"];
$url = strstr($request_uri,'?') ? $request_uri : $request_uri.'?';

If(is_array($query))
$url .= http_build_query($query);
else if($query != "")
$url .= "&".trim($query, "?&");

$arr = parse_url($url);

if(isset($arr["query"])){
Parse_str($arr["query"], $arrs);
unset($arrs["page"]);
$url = $arr["path"].'?'.http_build_query($arrs);
}

if(strstr($url, '?')) {
If(substr($url, -1)!='?')
$url = $url.'&';
}else{
$url = $url.'?';
}

Return $url;
}

/* Private method used inside the object to obtain 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 obtain 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 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