annotate DataTables-1.9.4/examples/examples_support/infiniteScroll.php @ 2:3c160414da2e default tip

initial upload
author shiltemann
date Thu, 26 Feb 2015 14:05:23 +0100
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
2
3c160414da2e initial upload
shiltemann
parents:
diff changeset
1 <?php
3c160414da2e initial upload
shiltemann
parents:
diff changeset
2 /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
3c160414da2e initial upload
shiltemann
parents:
diff changeset
3 * Easy set variables
3c160414da2e initial upload
shiltemann
parents:
diff changeset
4 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
5
3c160414da2e initial upload
shiltemann
parents:
diff changeset
6 /* Array of database columns which should be read and sent back to DataTables. Use a space where
3c160414da2e initial upload
shiltemann
parents:
diff changeset
7 * you want to insert a non-database field (for example a counter or static image)
3c160414da2e initial upload
shiltemann
parents:
diff changeset
8 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
9 $aColumns = array( 'name', 'phone', 'email', 'city', 'zip' );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
10
3c160414da2e initial upload
shiltemann
parents:
diff changeset
11 /* Indexed column (used for fast and accurate table cardinality) */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
12 $sIndexColumn = "id";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
13
3c160414da2e initial upload
shiltemann
parents:
diff changeset
14 /* DB table to use */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
15 $sTable = "testData";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
16
3c160414da2e initial upload
shiltemann
parents:
diff changeset
17 /* Database connection information */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
18 $gaSql['user'] = "";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
19 $gaSql['password'] = "";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
20 $gaSql['db'] = "";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
21 $gaSql['server'] = "localhost";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
22
3c160414da2e initial upload
shiltemann
parents:
diff changeset
23 /* REMOVE THIS LINE (it just includes my SQL connection user/pass) */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
24 include( $_SERVER['DOCUMENT_ROOT']."/datatables/mysql.php" );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
25
3c160414da2e initial upload
shiltemann
parents:
diff changeset
26
3c160414da2e initial upload
shiltemann
parents:
diff changeset
27 /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
3c160414da2e initial upload
shiltemann
parents:
diff changeset
28 * If you just want to use the basic configuration for DataTables with PHP server-side, there is
3c160414da2e initial upload
shiltemann
parents:
diff changeset
29 * no need to edit below this line
3c160414da2e initial upload
shiltemann
parents:
diff changeset
30 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
31
3c160414da2e initial upload
shiltemann
parents:
diff changeset
32 /*
3c160414da2e initial upload
shiltemann
parents:
diff changeset
33 * MySQL connection
3c160414da2e initial upload
shiltemann
parents:
diff changeset
34 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
35 $gaSql['link'] = mysql_pconnect( $gaSql['server'], $gaSql['user'], $gaSql['password'] ) or
3c160414da2e initial upload
shiltemann
parents:
diff changeset
36 die( 'Could not open connection to server' );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
37
3c160414da2e initial upload
shiltemann
parents:
diff changeset
38 mysql_select_db( $gaSql['db'], $gaSql['link'] ) or
3c160414da2e initial upload
shiltemann
parents:
diff changeset
39 die( 'Could not select database '. $gaSql['db'] );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
40
3c160414da2e initial upload
shiltemann
parents:
diff changeset
41
3c160414da2e initial upload
shiltemann
parents:
diff changeset
42 /*
3c160414da2e initial upload
shiltemann
parents:
diff changeset
43 * Paging
3c160414da2e initial upload
shiltemann
parents:
diff changeset
44 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
45 $sLimit = "";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
46 if ( isset( $_GET['iStart'] ) && isset( $_GET['iLength'] ) )
3c160414da2e initial upload
shiltemann
parents:
diff changeset
47 {
3c160414da2e initial upload
shiltemann
parents:
diff changeset
48 $sLimit = "LIMIT ".mysql_real_escape_string( $_GET['iStart'] ).", ".
3c160414da2e initial upload
shiltemann
parents:
diff changeset
49 mysql_real_escape_string( $_GET['iLength'] );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
50 }
3c160414da2e initial upload
shiltemann
parents:
diff changeset
51 else
3c160414da2e initial upload
shiltemann
parents:
diff changeset
52 {
3c160414da2e initial upload
shiltemann
parents:
diff changeset
53 echo '{ "aaData": [] }';
3c160414da2e initial upload
shiltemann
parents:
diff changeset
54 exit();
3c160414da2e initial upload
shiltemann
parents:
diff changeset
55 }
3c160414da2e initial upload
shiltemann
parents:
diff changeset
56
3c160414da2e initial upload
shiltemann
parents:
diff changeset
57 /*
3c160414da2e initial upload
shiltemann
parents:
diff changeset
58 * SQL queries
3c160414da2e initial upload
shiltemann
parents:
diff changeset
59 * Get data to display
3c160414da2e initial upload
shiltemann
parents:
diff changeset
60 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
61 $sQuery = "
3c160414da2e initial upload
shiltemann
parents:
diff changeset
62 SELECT ".str_replace(" , ", " ", implode(", ", $aColumns))."
3c160414da2e initial upload
shiltemann
parents:
diff changeset
63 FROM $sTable
3c160414da2e initial upload
shiltemann
parents:
diff changeset
64 ORDER BY name ASC
3c160414da2e initial upload
shiltemann
parents:
diff changeset
65 $sLimit
3c160414da2e initial upload
shiltemann
parents:
diff changeset
66 ";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
67 $rResult = mysql_query( $sQuery, $gaSql['link'] ) or die(mysql_error());
3c160414da2e initial upload
shiltemann
parents:
diff changeset
68
3c160414da2e initial upload
shiltemann
parents:
diff changeset
69 /*
3c160414da2e initial upload
shiltemann
parents:
diff changeset
70 * Output
3c160414da2e initial upload
shiltemann
parents:
diff changeset
71 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
72 $sOutput = '{';
3c160414da2e initial upload
shiltemann
parents:
diff changeset
73 $sOutput .= '"aaData": [ ';
3c160414da2e initial upload
shiltemann
parents:
diff changeset
74 while ( $aRow = mysql_fetch_array( $rResult ) )
3c160414da2e initial upload
shiltemann
parents:
diff changeset
75 {
3c160414da2e initial upload
shiltemann
parents:
diff changeset
76 $sOutput .= "[";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
77 for ( $i=0 ; $i<count($aColumns) ; $i++ )
3c160414da2e initial upload
shiltemann
parents:
diff changeset
78 {
3c160414da2e initial upload
shiltemann
parents:
diff changeset
79 /* General output */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
80 $sOutput .= '"'.str_replace('"', '\"', $aRow[ $aColumns[$i] ]).'",';
3c160414da2e initial upload
shiltemann
parents:
diff changeset
81 }
3c160414da2e initial upload
shiltemann
parents:
diff changeset
82
3c160414da2e initial upload
shiltemann
parents:
diff changeset
83 /*
3c160414da2e initial upload
shiltemann
parents:
diff changeset
84 * Optional Configuration:
3c160414da2e initial upload
shiltemann
parents:
diff changeset
85 * If you need to add any extra columns (add/edit/delete etc) to the table, that aren't in the
3c160414da2e initial upload
shiltemann
parents:
diff changeset
86 * database - you can do it here
3c160414da2e initial upload
shiltemann
parents:
diff changeset
87 */
3c160414da2e initial upload
shiltemann
parents:
diff changeset
88
3c160414da2e initial upload
shiltemann
parents:
diff changeset
89
3c160414da2e initial upload
shiltemann
parents:
diff changeset
90 $sOutput = substr_replace( $sOutput, "", -1 );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
91 $sOutput .= "],";
3c160414da2e initial upload
shiltemann
parents:
diff changeset
92 }
3c160414da2e initial upload
shiltemann
parents:
diff changeset
93 $sOutput = substr_replace( $sOutput, "", -1 );
3c160414da2e initial upload
shiltemann
parents:
diff changeset
94 $sOutput .= '] }';
3c160414da2e initial upload
shiltemann
parents:
diff changeset
95
3c160414da2e initial upload
shiltemann
parents:
diff changeset
96 echo $sOutput;
3c160414da2e initial upload
shiltemann
parents:
diff changeset
97 ?>