Php+bootstrap+datatable+jquery List of pages

<! DOCTYPE html>

<meta http-equiv= "content-type" content= "text/html; Charset=utf-8 "/>

<script src= "jquery-1.8.3.min.js" type= "text/javascript" ></script>

<script>

$ (document). Ready (function () {

$ ("#table_local"). dataTable ({

"bsort": true,

"bautowidth": false,

"bfilter": true,

"binfo": true,

"bjqueryui": false,

When used with all true, turn on

"blengthchange": true,

"bpaginate": true,

Use together

"bscrollinfinite": true,

"bscrollcollapse": true,

"sscrolly": "",

Use together

"sscrollx": "100%",//disabled or 100% is actually only empty, even if 123 will also appear effect

"sscrollxinner": "100%",

Save client information in a cookie, understand

"bstatesave": true,

This is to select the number of entries per page, when using a two-dimensional array, the two-dimensional plane can only have two elements, the first is to display the number of entries per page option, The second is about these options explained

"alengthmenu": [5,10,20,50,100],

"alengthmenu": [[10, 25, 30, -1],[10, 25, "30", "all"]],

"icookieduration": 10,

Default number of page bars

Idisplaystart displaying data starting from the first few lines

"idisplaylength": 34,

' Full_numbers ' or ' Two_button ', default ' Two_button ' for specifying the pager style

"spaginationtype": ' Two_button ',

No. 0 Column descending order

"aasorting": [[0, "desc"]],

Hide some columns

/* "aocolumndefs": [{"bsearchable": false, "bvisible": false, "atargets": [2]},{"bvisible": false, "atargets": [3]} ], */

language: {

Lengthmenu: ' <select class= ' Form-control input-xsmall ' > ' + ' <option value= ' 1 ' >1</option> ' + ' < Option value= ">10</option> ' + ' <option value=" >20</option> ' + ' <option value= ">30" </option> ' + ' <option value= "+" >40</option> ' + ' <option value= ">50</option> ' + ' < /select> record ',//the top left corner of the paging size display.

Search: ' <span class= ' label label-success > search:</span> ',//the upper right corner of the text, you can write HTML tags

Paginate: {//pagination Style Content.

Previous: "previous page",

Next: "down",

First: "number one,"

Last: "final"

// },

Zerorecords: "no content",//table tbody content is empty, tbody content.

The following three constitute the contents of the overall lower left corner.

Info: "a total of _pages_ pages, showing the _start_ to the _end_, filtered to get _total_ bar, the initial _max_ bar",//the lower left corner of the information display, capitalized words are KEYWORDS.

Infoempty: "0 Records",//filter is empty when the lower left corner of the Display.

Infofiltered: ""//filter prompt at the bottom left after filtering,

// },

});

});

</script>

<link rel= "stylesheet" type= "text/css" href= "/km/media/css/datatables.bootstrap.min.css" >

<link rel= "stylesheet" type= "text/css" href= "/km/media/css/font-awesome.min.css" >

<link rel= "stylesheet" type= "text/css" href= "/km/media/css/bootstrap.min.css" >

<link rel= "stylesheet" type= "text/css" href= "/km/media/css/button.css" >

<!--[if IE 7]>

<link rel= "stylesheet" href= "path/to/font-awesome/css/font-awesome-ie7.min.css" >

<! [endif]-->

<script type= "text/javascript" src= "/km/media/js/jquery.datatables.min.js" ></script>

<script type= "text/javascript" src= "/km/media/js/datatables.bootstrap.js" ></script>

<div class= "panel panel-default" >

<div class= "panel-heading" >

<div class= "panel-title" >

<? echo iconv ("gb2312", "UTF-8", "performance transfer order query")?>

</div>

</div>

<div class= "panel-body" >

<table id= "table_local" class= "table table-bordered table-striped table-hover" >

<thead>

<tr align=center>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "application number")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "applicant")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "application department")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "application date")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "turn-out unit")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "transfer account")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "application amount")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "acknowledgment amount")?>

<th Align=center><font color=black><? echo iconv ("gb2312", "UTF-8", "signoff")?>

</tr>

</thead>

<tbody>

<?php

$sql = "select distinct a.exp_no,a.create_user,name (a.create_user), a.create_date,a.dept_no,a.acc_name,tot_amt1,tot _amt2,b.flow_code,a.form_key from Exp_main A,flow b

e a.form_key=b.form_key ORDER BY a.exp_no Desc ";

#echo "$sql";

$stmt = $dbh->prepare ("$sql");

$stmt->execute () | | Die ("error");

$i = 0;

While (list ($exp _no, $exp _man, $exp _man_name, $create _date, $dept _no, $acc _name, $tot _amt1, $tot _amt2, $flow _code, $form _key) = $stmt->fetch ()) {

List ($flow _code) =field ("select flow_code from It.flow where form_key= $form _key");

$current _user2= ';

If ($flow _code== ' Z ')

$current _user2=iconv ("gb2312", "UTF-8", "closed");

ElseIf ($flow _code== ' C ')

{

$child _sql= "select Form_key from Workflow_subflow where parent_key= ' $form _key ' and reply_flag= ' N '";

$chis = $dbh->prepare ("$child _sql");

$chis->execute () | | Die ("chile_err");

For ($j =0;list ($child _key) = $chis->fetch (); $j + +)

{

#if ($form _key== ' 100001245685 ') {echo "$child _key, $current _user2". <br> ';}

List ($current _user1) =fields ("select distinct current_user from It.subflow where form_key= ' $child _key '");

$current _n[$j]=iconv ("gb2312", "UTF-8", name ($current _user1));

$current _user2= $current _user2. " ($current _user1) ". $current _n[$j];

}

$current _user2=iconv ("gb2312", "UTF-8", ' sign in '). $current _user2;

}

Else

{

List ($current _user1, $current _user1name) =fields ("select current_user,name (current_user) from It.subflow where form_ key= $form _key ");

$current _user2= "($current _user1)". iconv ("gb2312", "UTF-8", $current _user1name);

}

$sel = "select get_depart_name (get_depart (' $exp _man ')), get_depart (' $exp _man ') from dual";

$STC = $dbh->prepare ("$sel");

$stc->execute () | | Die ("applicant Department error");

List ($depart _name, $getdepart) = $stc->fetch ();

$str 1= "select acc_depart_name from Acc_gl_depart where acc_depart_no= ' $dept _no '";

List ($DEP _name) =fields ("$str 1");

$ACC _name=iconv ("gb2312", "UTF-8", $ACC _name);

echo "<tr><td align=center id= $setcolor > $exp _no

<TD align=center id= $setcolor > $exp _man-". iconv (" gb2312 "," UTF-8 ", $exp _man_name)."

<TD align=center id= $setcolor > $getdepart-". iconv (" gb2312 "," UTF-8 ", $depart _name)."

<TD align=center id= $setcolor > $create _date

<TD align=center id= $setcolor > $dept _no-". iconv (" gb2312 "," UTF-8 ", $dep _name)."

<TD align=center id= $setcolor > $acc _name

<TD align=center id= $setcolor > $tot _amt1

<TD align=center id= $setcolor > $tot _amt2

<TD align=center id= $setcolor ><font size= $size > $current _user2</font> ";

Echo "</td>";

$i = $i +1;

}

?>

</div>

</div>

</body>

Php+bootstrap+datatable+jquery List of pages