PHP SSP::complex方法代码示例

 public function server_side_wating()
 {
     $this->load->library('myencryption');
     //$this->db->sql( "SET NAMES 'utf8'" );
     $table = 'tbl_student_information';
     // Table's primary key
     $primaryKey = 'auto_id';
     // Array of database columns which should be read and sent back to DataTables.
     // The `db` parameter represents the column name in the database, while the `dt`
     // parameter represents the DataTables column identifier. In this case simple
     // indexes
     $columns = array(array('db' => 'studentID', 'dt' => 'StudentID'), array('db' => 'studentStatus', 'dt' => ''), array('db' => 'studentNameInKhmer', 'dt' => ''), array('db' => 'studentNameInEnglish', 'dt' => 'FullName', 'formatter' => function ($d, $row) {
         // Technically a DOM id cannot start with an integer, so we prefix
         // a string. This can also be useful if you have multiple tables
         // to ensure that the id is unique with a different prefix
         return $row['studentNameInKhmer'] . " / " . $row['studentNameInEnglish'];
     }), array('db' => 'studentGender', 'dt' => 'Gender'), array('db' => 'studentDateofbirth', 'dt' => 'DateOfBirth'), array('db' => 'studentEntryDate', 'dt' => 'EntryDate'), array('db' => 'studentenrollDate', 'dt' => 'EnrollDate'), array('db' => 'auto_id', 'dt' => 'auto_id', 'formatter' => function ($d, $row) {
         // Technically a DOM id cannot start with an integer, so we prefix
         // a string. This can also be useful if you have multiple tables
         // to ensure that the id is unique with a different prefix
         $vv = base_url() . "student/edit/" . $this->myencryption->encode($d);
         $view = base_url() . "student/profile/" . $this->myencryption->encode($d);
         return "<a href='{$view}'>View</a> | <a href='{$vv}'>Edit</a>";
     }));
     $CI =& get_instance();
     $CI->load->database();
     $sql_details = array('user' => $CI->db->username, 'pass' => $CI->db->password, 'db' => $CI->db->database, 'host' => $CI->db->hostname);
     /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
      * If you just want to use the basic configuration for DataTables with PHP
      * server-side, there is no need to edit below this line.
      */
     $this->load->helper('ssp_helper');
     echo json_encode(SSP::complex($_GET, $sql_details, $table, $primaryKey, $columns, null, "studentActive = '1'"));
 }

// DB table to use
$table = 'modx_activations';
// Table's primary key
$primaryKey = 'id';
// Array of database columns which should be read and sent back to DataTables.
// The `db` parameter represents the column name in the database, while the `dt`
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columns = array(array('db' => 'id', 'dt' => 'DT_RowId', 'formatter' => function ($d, $row) {
    // Technically a DOM id cannot start with an integer, so we prefix
    // a string. This can also be useful if you have multiple tables
    // to ensure that the id is unique with a different prefix
    return 'row_' . $d;
}), array('db' => 'act_date', 'dt' => 0, 'formatter' => function ($d, $row) {
    return !empty($d) ? date('d.m.Y', $d) : "";
}), array('db' => 'pc_id', 'dt' => 1, 'formatter' => function ($d, $row) {
    global $modx;
    return $modx->runSnippet('pdoField', array('id' => $d, 'field' => 'pagetitle'));
}), array('db' => 'abonent', 'dt' => 2), array('db' => 'bonus_set', 'dt' => 3, 'formatter' => function ($d, $row) {
    return !empty($d) ? $d . " руб." : "";
}));
// SQL server connection information
$sql_details = array('user' => 'mgmbee', 'pass' => 'mB915009', 'db' => 'mgm', 'host' => 'node100241-blogger.jelastic.regruhosting.ru');
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * If you just want to use the basic configuration for DataTables with PHP
 * server-side, there is no need to edit below this line.
 */
require MODX_CORE_PATH . 'components/datatables/server_side/scripts/ssp.class.php';
$beeWhere = array($_POST['beeWhere']);
echo json_encode(SSP::complex($_POST, $sql_details, $table, $primaryKey, $columns, null, $beeWhere));

        if (!$result_sql) {
            echo 'Invalid query: ' . mysql_error();
        } else {
            echo "success";
        }
    } else {
        echo 'Invalid query: ' . mysql_error();
    }
}
if ($type == 'get_button_list') {
    $table = 'share_buttons';
    $primaryKey = 'bid';
    $columns = array(array('db' => 'b_title', 'dt' => 'b_title'), array('db' => 'b_target_id', 'dt' => 'b_target_id'), array('db' => 'b_content', 'dt' => 'b_content'), array('db' => 'page_id', 'dt' => 'page_id'), array('db' => 'bid', 'dt' => 'bid'));
    $extraWhere = " shop='" . mysql_real_escape_string($shop) . "' ";
    require 'ssp.class.php';
    $arr = SSP::complex($_POST, $sql_details, $table, $primaryKey, $columns, null, $extraWhere);
    $json = $arr;
    print_r(json_encode($json));
}
if ($type == 'search_p') {
    $search_text = trim($_REQUEST['ss']);
    $search_collection_id = trim($_REQUEST['sc']);
    $search_type = trim($_REQUEST['st']);
    $page = trim($_REQUEST['page']);
    $limit_str = 10;
    if ($search_type == "all_coll") {
        $search_peram = "?limit=" . $limit_str . "&page=" . $page;
        $search_products_data = $sc->call('GET', '/admin/products.json?collection_id=' . $search_collection_id . $search_peram);
        $total_prod_count = $sc->call('GET', '/admin/products.json?collection_id=' . $search_collection_id);
        $total_prod_count = intval($total_prod_count);
    } else {

 */
// DB table to use
$table = 'sim_mview';
// Table's primary key
$primaryKey = 'song_ID_orig';
// Array of database columns which should be read and sent back to DataTables.
// The `db` parameter represents the column name in the database, while the `dt`
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columns = array(array('db' => 'song_ID_orig', 'dt' => 0), array('db' => 'name', 'dt' => 1), array('db' => 'artist', 'dt' => 2), array('db' => 'similarity', 'dt' => 3));
// SQL server connection information
$sql_details = array('user' => 'root', 'pass' => '', 'db' => 'test', 'host' => 'localhost');
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * If you just want to use the basic configuration for DataTables with PHP
 * server-side, there is no need to edit below this line.
 */
// VJ: added term, #wereAll, ['data']
require 'ssp.class.php';
// Validate the JSONP to make use it is an okay Javascript function to execute
$jsonp = preg_match('/^[$A-Z_][0-9A-Z_$]*$/i', $_GET['term']) ? $_GET['term'] : false;
//$whereAll = " song_ID_orig = ".$jsonp." limit 5";
$whereAll = " song_ID_orig = '" . urldecode($_GET['term']) . "' and name is not null order by similarity desc";
$v = SSP::complex($_GET, $sql_details, $table, $primaryKey, $columns, null, $whereAll);
//echo substr(substr(json_encode($v), 0,-1),1);
echo substr(substr(json_encode($v), 0, -1), 1);
/*
echo '[
{"id":"Nycticorax nycticorax","label":"label - Black-crowned Night Heron","value":"Black-crowned Night Heron"},
{"name":"Roze","label":"46", "value":"lele!"}
]';
*/

$primaryKey = 'id';
// Array of database columns which should be read and sent back to DataTables.
// The `db` parameter represents the column name in the database, while the `dt`
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columns = array(array('db' => 'title', 'dt' => 0), array('db' => 'date', 'dt' => 1, 'formatter' => function ($d, $row) {
    return date('Y-m-d', strtotime($d));
}));
// SQL server connection information
//TODO: make me elegant
$url = parse_url(getenv("CLEARDB_DATABASE_URL"));
$server = $url["host"];
file_put_contents('php://stderr', print_r("SERVER2222", TRUE));
file_put_contents('php://stderr', print_r($server, TRUE));
$username = $url["user"];
$password = $url["pass"];
$db = substr($url["path"], 1);
$sql_details = array('user' => $username, 'pass' => $password, 'db' => $db, 'host' => $server);
// user id
$id = $_SESSION['id'];
// where conditioning for sql query
// datatables will load data restrict by user id
$whereAll = "id={$id}";
$whereResult = null;
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * If you just want to use the basic configuration for DataTables with PHP
 * server-side, there is no need to edit below this line.
 */
require 'ssp.class.php';
echo json_encode(SSP::complex($_GET, $sql_details, $table, $primaryKey, $columns, null, "userID={$id}"));

<?php

header('Access-Control-Allow-Origin: *');
$table = 'alineacion';
$primaryKey = 'NombreUsuario';
$columns = array(array('db' => 'idJugadores', 'dt' => 'idJugadores'), array('db' => 'Posicion', 'dt' => 'Posicion'), array('db' => 'EquipoReal', 'dt' => 'EquipoReal'), array('db' => 'Nombre', 'dt' => 'Nombre'), array('db' => 'PuntosTotales', 'dt' => 'PuntosTotales'), array('db' => 'Valor', 'dt' => 'Valor'), array('db' => 'Alineado', 'dt' => 'Alineado'), array('db' => 'Vendible', 'dt' => 'Vendible'), array('db' => 'NombreUsuario', 'dt' => 'NombreUsuario'));
session_start();
$usuario = $_SESSION['usuarios'];
$sql_details = array('user' => 'root', 'pass' => '1234', 'db' => 'Comunio', 'host' => 'localhost');
require 'ssp.class.php';
$where = "NombreUsuario='" . $usuario . "'";
echo json_encode(SSP::complex($_GET, $sql_details, $table, $primaryKey, $columns, $where));

        break;
    case "returns.php":
        $table = 'loaned_hardware';
        $primaryKey = 'eagle_id';
        $where = 'checkout_auth = 1';
        break;
    default:
        $table = 'hardware';
        $primaryKey = 'hardware_id';
}
/*-----------------------END CONFIG-----------------------*/
//get table columns
// Array of database columns which should be read and sent back to DataTables.
// The `db` parameter represents the column name in the database, while the `dt`
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columnNames = get_column_heads($table);
$columns = array();
for ($i = 0; $i < count($columnNames); $i++) {
    $pushArray = array('db' => $columnNames[$i], 'dt' => $i);
    array_push($columns, $pushArray);
}
if (isset($joinQuery)) {
    $results = SSP::simple($_GET, $sqlDetails, $table, $primaryKey, $columns, $joinQuery);
} elseif (isset($where)) {
    $results = SSP::complex($_GET, $sqlDetails, $table, $primaryKey, $columns, $where);
} else {
    $results = SSP::simple($_GET, $sqlDetails, $table, $primaryKey, $columns);
}
//query and echo results
echo json_encode(linkDataTablesID($results, $url));