PHP GridConfiguration Examples

Example #1

File: pdf.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require_once '../../codebase/db_pdo.php';
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/grid_connector.php";
require "../../codebase/convert.php";
$convert = new ConvertService("http://dhtmlxgrid.appspot.com/export/pdf");
$grid = new GridConnector($res, "PDO");
$config = new GridConfiguration();
$config->set_convert_mode(true);
$grid->set_config($config);
$grid->render_table("grid50");

Example #2

File: 12_attach_header_server_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->enable_log("temp.log", true);
$config = new GridConfiguration();
$config->setHeader("Item Name,Item CD");
$config->attachHeader("Item Name Test,#rspan");
$config->attachFooter("Item Name,Item CD", array("background-color: #ff0000;", "background-color: #00ff00;"));
$config->attachFooter("Item Name Test,#rspan", "background-color: #0000ff;color:white;");
$config->setColIds("col1,col2");
$config->setInitWidths('120,*');
$config->setColSorting("connector,connector");
$config->setColColor(",#dddddd");
$config->setColHidden("false,false");
$config->setColTypes("ro,ed");
$config->setColAlign('center,center');
$config->setColVAlign('bottom,middle');
$grid->set_config($config);
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #3

File: 09_server_side_configuration.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";
$grid = new GridConnector($res);
$config = new GridConfiguration();
$config->setHeader("ID,First Name,Last Name,Title,Office,Extn,Mobile,Email");
$config->setColTypes("ro,ed,ed,ed,ed,ed,ed,ed");
$grid->set_config($config);
$grid->render_table("grid50");

Example #4

File: 12_attach_header_server.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";
$grid = new GridConnector($res);
$config = new GridConfiguration();
$config->setHeader("Item,#cspan");
$config->attachHeader("Item Name,Item CD");
$config->setColIds("col1,col2");
$config->setInitWidths('120,*');
$config->setColSorting("connector,connector");
$config->setColColor(",#dddddd");
$config->setColHidden("false,false");
$config->setColTypes("ro,ed");
$config->setColAlign('center,center');
$config->setColVAlign('bottom,middle');
$grid->set_config($config);
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");