PHP config::sql_details Examples

Example #1

File: datatable.php Project: datadigicore/siprisdik

 function get_table_join($table, $table2, $primaryKey, $columns, $on, $where, $group, $dataArray)
 {
     $config = new config();
     $sql_details = $config->sql_details();
     require 'ssp.class.php';
     echo json_encode(SSP::complexjoin($_POST, $sql_details, $table, $table2, $primaryKey, $columns, $on, $where, $group, $dataArray));
 }

Example #2

File: datatable.php Project: datadigicore/admin_cat

 function get_table_group($table, $primaryKey, $columns, $where, $group)
 {
     $config = new config();
     $sql_details = $config->sql_details();
     require 'ssp.class.php';
     echo json_encode(SSP::simplewheregroup($_POST, $sql_details, $table, $primaryKey, $columns, $where, $group));
 }

Example #3

File: loaduser.php Project: sugiartha26/persediaan

<?php

#This code provided by:
#Yohanes Christomas Daimler(yohanes.christomas@gmail.com)
#Gunadarma University
// Table yang di load
$table = 'user';
// Primary Key table
$primaryKey = 'user_id';
// Load Data berdasarkan nama table nya
$columns = array(array('db' => 'user_id', 'dt' => 0), array('db' => 'user_email', 'dt' => 1), array('db' => 'kd_lokasi', 'dt' => 2));
// Settingan Koneksi Datatable
require '../../config/dbconf.php';
$config = new config();
$sql_details = $config->sql_details();
// Pengaturan Output Server Side Processing
require '../../config/ssp.class.php';
echo json_encode(SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns));