<?php
/*
* Following code will list all the words
*/
// array for JSON response2
// include db connect class
require_once __DIR__ . '/db_connect.php';
// connecting to db
include("db_connect.php");
$con->set_charset ( "utf8" );
$con->query("SET NAMES 'utf8' COLLATE 'utf8_polish_ci'");
// initilize all variable
$params = $columns = $totalRecords = $data = $dataNew = array();
$params = $_REQUEST;
//define index of column
0 =>'word',
0 =>'id',
0 =>'id'
);
$where = $sqlTot = $sqlRec = "";
if( !empty($params['search']['value']) ) {
$where .=" AND ( not_allowet_words.word LIKE '".$params['search']['value']."%' ";
}
$sql="SELECT word FROM not_allowet_words";
$sqlRec .= $sql;
$sqlTot .= $sql;
if(isset($where) && $where != '') {
$sqlTot .= $where;
$sqlRec .= $where;
}
$sqlRec .= " GROUP BY not_allowet_words.id LIMIT ".$params['start']." ,".$params['length']." ";
$totalRecords = $row[0];
}
//iterate on results row and create new index array of data
$data[] = $row;
}
$dataNew[] = $row;
}
$i=0;
foreach($data as $d){
$data[$i][1] = '111';
$data[$i][2] = '222';
$i++;
}
"draw" => intval( $params['draw'] ),
"recordsTotal" => $totalRecords ,
"recordsFiltered" => $totalRecords,
"data" => $data // total data array
);
echo $json; // send data as json format
?>
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}