ceph/src/pybind/mgr/dashboard/static/AdminLTE-2.3.7/plugins/datatables/extensions/Scroller/examples/data/ssp.php

   1 <?php
   2
   3 /*
   4  * DataTables example server-side processing script.
   5  *
   6  * Please note that this script is intentionally extremely simply to show how
   7  * server-side processing can be implemented, and probably shouldn't be used as
   8  * the basis for a large complex system. It is suitable for simple use cases as
   9  * for learning.
  10  *
  11  * See http://datatables.net/usage/server-side for full details on the server-
  12  * side processing requirements of DataTables.
  13  *
  14  * @license MIT - http://datatables.net/license_mit
  15  */
  16
  17 /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  18  * Easy set variables
  19  */
  20
  21 // DB table to use
  22 $table = 'massive';
  23
  24 // Table's primary key
  25 $primaryKey = 'id';
  26
  27 // Array of database columns which should be read and sent back to DataTables.
  28 // The `db` parameter represents the column name in the database, while the `dt`
  29 // parameter represents the DataTables column identifier. In this case simple
  30 // indexes
  31 $columns = array(
  32         array( 'db' => 'id',         'dt' => 0 ),
  33         array( 'db' => 'firstname',  'dt' => 1 ),
  34         array( 'db' => 'surname',    'dt' => 2 ),
  35         array( 'db' => 'zip',        'dt' => 3 ),
  36         array( 'db' => 'country',    'dt' => 4 )
  37 );
  38
  39 // SQL server connection information
  40 $sql_details = array(
  41         'user' => '',
  42         'pass' => '',
  43         'db'   => '',
  44         'host' => ''
  45 );
  46
  47
  48 /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  49  * If you just want to use the basic configuration for DataTables with PHP
  50  * server-side, there is no need to edit below this line.
  51  */
  52
  53 require( '../../../../examples/server_side/scripts/ssp.class.php' );
  54
  55 echo json_encode(
  56         SSP::simple( $_GET, $sql_details, $table, $primaryKey, $columns )
  57 );
  58