The init code are similar for all components and DB types
MySQL ( php_mysql )
require("connector/grid_connector.php"); $res=mysql_connect("localhost","root",""); mysql_select_db("myDatabase"); $gridConn = new GridConnector($res,"MySQL");
MySQLi ( php_mysqli )
require("connector/grid_connector.php"); require("connector/db_mysqli.php"); $mysqli = new mysqli($server, $user, $pass, $mysql_db); $gridConn = new GridConnector($mysqli,"MySQLi");
PostgreSQL ( php_pg )
require("connector/grid_connector.php"); require("connector/db_postgre.php"); $res = pg_connect("host=localhost port=5432 dbname=mary"); $gridConn = new GridConnector($res,"Postgre");
Oracle ( php_oci )
require("connector/grid_connector.php"); require("connector/db_oracle.php"); $res = oci_connect("scott", "tiger", $db); $gridConn = new GridConnector($res,"Oracle");
MSSQL ( php_mssql )
require("connector/grid_connector.php"); require("connector/db_mssql.php"); $res=mssql_connect('.\SQLEXPRESS',"sa","1",false); mssql_select_db("sampleDB"); $gridConn = new GridConnector($res,"MsSQL");
PDO ( php_pdo )
require("connector/grid_connector.php"); require("connector/db_pdo.php"); $res = new PDO('mysql:host=localhost;dbname=test', $user, $pass); $gridConn = new GridConnector($res,"PDO");
File System
require("connector/grid_connector.php"); require("connector/db_pdo.php"); $gridConn = new GridConnector("/var/www/test","FileSystem"); $grid->render_table("./", "id", "A,B,C,D,E,F");
Excel file
require("connector/grid_connector.php"); require("connector/db_excel.php"); $res = new PDO('mysql:host=localhost;dbname=test', $user, $pass); $grid = new GridConnector("some.xls", "ExcelDBDataWrapper"); $grid->render_table("A18:F83", "id", "A,B,C,D,E,F");
For other components syntax of constructor exactly the same, except, the “Grid” in object name replaced with component's name
Grid
require("connector/grid_connector.php"); //... $gridConn = new GridConnector($res,"MySQL");
TreeGrid 1)
require("connector/treegrid_connector.php"); //... $treeGridConn = new TreeGridConnector($res,"MySQL");
Tree 2)
require("connector/tree_connector.php"); //... $treeConn = new TreeConnector($res,"MySQL");
Combo
require("connector/combo_connector.php"); //... $comboConn = new ComboConnector($res,"MySQL");
Scheduler
require("connector/scheduler_connector.php"); //... $schedulerConn = new SchedulerConnector($res,"MySQL");
Form
require("connector/form_connector.php"); //... $formConn = new FormConnector($res,"MySQL");
DataView
require("connector/dataview_connector.php"); //... $dataConn = new DataViewConnector($res,"MySQL");
Chart
require("connector/chart_connector.php"); //... $chartConn = new ChartConnector($res,"MySQL"); // (!!!)