PHP GridConnector::render_table Examples

Example #1

File: DBController.php Project: AxelANGENAULT/CoreBundle

 public function filter_gridAction()
 {
     require_once '../vendor/dhtmlx/dhtmlxConnector/codebase/grid_connector.php';
     $database_host = $this->container->getParameter('database_host');
     $database_port = $this->container->getParameter('database_port');
     $database_name = $this->container->getParameter('database_name');
     $database_user = $this->container->getParameter('database_user');
     $database_password = $this->container->getParameter('database_password');
     $conn = mysql_connect($database_host, $database_user, $database_password);
     mysql_select_db($database_name);
     $data = new \GridConnector($conn);
     $data->render_table('arii_filter', "ID", "filter,title,spooler,job,job_chain,order_id,status");
 }

Example #2

File: xx_sample_postgresql_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = pg_connect($postrgre_connection);
require "../../codebase/grid_connector.php";
require "../../codebase/db_postgre.php";
$grid = new GridConnector($res, "Postgre");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #3

File: gridGenerators.php Project: neohusky/NMIS

<?php

require_once 'config.php';
require_once "../codebase/dhtmlx/grid_connector.php";
$conn = new GridConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_table("Generators", "generator_id", "generator_id,batch_number ,supplier_name ,arrival_date ,arrival_username,decommission_date,decommission_username");
?>

Example #4

File: excel.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
require "../../codebase/convert.php";
$convert = new ConvertService("http://dhtmlxgrid.appspot.com/export/excel");
$convert->excel();
$grid = new GridConnector($res);
$config = new GridConfiguration();
$grid = new GridConnector($res);
$grid->set_config($config);
$grid->render_table("grid50");

Example #5

File: 05_select_filter_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res, "PDO");
$grid->dynamic_loading(100);
$grid->render_table("countries", "item_id", "item_nm,item_cd");

Example #6

File: contacts.php Project: xgbj/share_platom_upload

<?php

require "../codebase/connector/grid_connector.php";
$res = mysql_connect("localhost", "root", "");
mysql_select_db("dhtmlx_tutorial");
$conn = new GridConnector($res, "MySQL");
$conn->render_table("contacts", "contact_id", "fname,lname,email");

Example #7

File: xx_sample_sasql_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = sasql_connect($sasql_conn);
require "../../codebase/grid_connector.php";
require "../../codebase/db_sasql.php";
$grid = new GridConnector($res, "SaSQL");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_table("Contacts", "ID", "Surname,GivenName,Title");

Example #8

File: 13_filesystem_grid_connector.php Project: quantrocket/planlogiq

<?php

require "../../codebase/db_filesystem.php";
require "../../codebase/grid_connector.php";
$grid = new GridConnector("c:/", "FileSystem");
$grid->render_table("../", "safe_name", "filename,full_filename,size,name,extention,date,is_folder");

Example #9

File: 05_live_update_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/treegrid_connector.php";
$treegrid = new GridConnector($res, "PDO");
$treegrid->enable_log("temp.log", true);
$treegrid->enable_live_update("actions_table");
$treegrid->render_table("tasks", "taskId", "taskName,duration,complete", "", "parentId");

Example #10

File: xx_sample_oracle_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = oci_connect($oci_dbuser, $oci_dbpass, $oci_dbname);
require "../../codebase/grid_connector.php";
require "../../codebase/db_oracle.php";
$grid = new GridConnector($res, "Oracle");
$grid->dynamic_loading(50);
$grid->sql->sequence("EMPLOYEES_INC.nextVal");
$grid->render_table("EMPLOYEES", "EMPLOYEE_ID", "FIRST_NAME,LAST_NAME");

Example #11

File: xx_sample_mysqli_connector.php Project: quantrocket/planlogiq

<?php

require "../config.php";
require "../../codebase/db_mysqli.php";
require "../../codebase/grid_connector.php";
$mysqli = new mysqli($server, $user, $pass, $mysql_db);
if (mysqli_connect_errno()) {
    printf("Подключение к серверу MySQL невозможно. Код ошибки: %s\n", mysqli_connect_error());
    exit;
}
$grid = new GridConnector($mysqli, "MySQLi");
$grid->enable_log("temp.log", true);
$grid->render_table("events", "event_id", "event_name,details");

Example #12

File: conector.php Project: elsonvinicius/framework

<?php

$oCon = new \core\pdo\Conexao(DRIVER, HOST, DBNAME, USERNAME, PASSWD);
require_once 'vendor/core/conector/codebase/grid_connector.php';
//debug(__FILE__, __LINE__, $oCon);
//$con = mysql_connect("localhost","root","312487");
$con = mysqli_connect("localhost", "root", "312487", "framework");
//mysql_select_db("framework");
$grid = new GridConnector($con, "MySQL");
//debug(__FILE__, __LINE__, $grid);
$grid->render_table("grid", "id", "nome, cidade");
debug(__FILE__, __LINE__, $grid);

Example #13

File: gridRISCodes.php Project: neohusky/NMIS

<?php

/**
 * Created by PhpStorm.
 * User: nucmed
 * Date: 19/06/15
 * Time: 9:36 AM
 */
require_once "../js/dhtmlx/grid_connector.php";
require_once 'config.php';
$conn = new GridConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_table("riscodes", "id", "id,RIScode, Show");