annotate DataTables-1.9.4/examples/examples_support/infiniteScroll.php @ 0:c73753f1606f draft

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