summaryrefslogtreecommitdiffstats
path: root/samples/grid
diff options
context:
space:
mode:
authorStanislau Wolski <stanislau.wolski@gmail.com>2017-03-01 14:56:45 +0300
committerStanislau Wolski <stanislau.wolski@gmail.com>2017-03-01 14:56:45 +0300
commit8b5f2010bbc463f362bd2e52e2c6625dd45c6861 (patch)
tree743a75a4bc796895c2bcd5809342691bb85b60d0 /samples/grid
parent2f82b184637189055abf3cda08abf084a433116e (diff)
downloadconnector-php-master.zip
connector-php-master.tar.gz
connector-php-master.tar.bz2
[update] connector uses PDO by defaultHEADorigin/masterorigin/HEADmaster
Diffstat (limited to 'samples/grid')
-rw-r--r--samples/grid/01_basic_connector.php1
-rw-r--r--samples/grid/01a_sql_basic_connector.php1
-rw-r--r--samples/grid/02_rendering_connector.php1
-rw-r--r--samples/grid/03_validation_connector.php1
-rw-r--r--samples/grid/04_custom_sql_connector.php1
-rw-r--r--samples/grid/05_select_filter_connector.php1
-rw-r--r--samples/grid/05a_select_filter_connector.php1
-rw-r--r--samples/grid/06_combo_connector.php1
-rw-r--r--samples/grid/09_server_side_configuration.php4
-rw-r--r--samples/grid/10_auto_config.php1
-rw-r--r--samples/grid/11_auto_config_filters.php1
-rw-r--r--samples/grid/12_attach_header_server.php1
-rw-r--r--samples/grid/some.txt178
-rw-r--r--samples/grid/xx_sample_pdo_connector.php1
-rw-r--r--samples/grid/xx_sample_pdo_pg_connector.php1
15 files changed, 2 insertions, 193 deletions
diff --git a/samples/grid/01_basic_connector.php b/samples/grid/01_basic_connector.php
index 93d8007..72fdf2f 100644
--- a/samples/grid/01_basic_connector.php
+++ b/samples/grid/01_basic_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/01a_sql_basic_connector.php b/samples/grid/01a_sql_basic_connector.php
index 66e0a3e..2c2ed6e 100644
--- a/samples/grid/01a_sql_basic_connector.php
+++ b/samples/grid/01a_sql_basic_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
require("../../codebase/grid_connector.php");
diff --git a/samples/grid/02_rendering_connector.php b/samples/grid/02_rendering_connector.php
index 9c2ccb9..2c185df 100644
--- a/samples/grid/02_rendering_connector.php
+++ b/samples/grid/02_rendering_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/03_validation_connector.php b/samples/grid/03_validation_connector.php
index 87343b9..13f8cd0 100644
--- a/samples/grid/03_validation_connector.php
+++ b/samples/grid/03_validation_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/04_custom_sql_connector.php b/samples/grid/04_custom_sql_connector.php
index f0bed29..c1015be 100644
--- a/samples/grid/04_custom_sql_connector.php
+++ b/samples/grid/04_custom_sql_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/05_select_filter_connector.php b/samples/grid/05_select_filter_connector.php
index 63690a9..8a33a97 100644
--- a/samples/grid/05_select_filter_connector.php
+++ b/samples/grid/05_select_filter_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
require("../../codebase/grid_connector.php");
diff --git a/samples/grid/05a_select_filter_connector.php b/samples/grid/05a_select_filter_connector.php
index a21dad3..a8600b6 100644
--- a/samples/grid/05a_select_filter_connector.php
+++ b/samples/grid/05a_select_filter_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
require("../../codebase/grid_connector.php");
diff --git a/samples/grid/06_combo_connector.php b/samples/grid/06_combo_connector.php
index 9029730..3dac5ba 100644
--- a/samples/grid/06_combo_connector.php
+++ b/samples/grid/06_combo_connector.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
require("../../codebase/grid_connector.php");
diff --git a/samples/grid/09_server_side_configuration.php b/samples/grid/09_server_side_configuration.php
index 35d2304..f75d536 100644
--- a/samples/grid/09_server_side_configuration.php
+++ b/samples/grid/09_server_side_configuration.php
@@ -1,16 +1,16 @@
<?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->set_limit(100);
$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");
+ $grid->render_table("grid50000");
?> \ No newline at end of file
diff --git a/samples/grid/10_auto_config.php b/samples/grid/10_auto_config.php
index ea78e8f..a1dcf33 100644
--- a/samples/grid/10_auto_config.php
+++ b/samples/grid/10_auto_config.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/11_auto_config_filters.php b/samples/grid/11_auto_config_filters.php
index 63d7ed2..4eb8604 100644
--- a/samples/grid/11_auto_config_filters.php
+++ b/samples/grid/11_auto_config_filters.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/12_attach_header_server.php b/samples/grid/12_attach_header_server.php
index b26d06e..cf09458 100644
--- a/samples/grid/12_attach_header_server.php
+++ b/samples/grid/12_attach_header_server.php
@@ -1,6 +1,5 @@
<?php
require_once("../config.php");
- require("../../codebase/db_pdo.php");
$res= new PDO($mysql_server,$mysql_user,$mysql_pass);
diff --git a/samples/grid/some.txt b/samples/grid/some.txt
deleted file mode 100644
index fd5836e..0000000
--- a/samples/grid/some.txt
+++ /dev/null
@@ -1,178 +0,0 @@
-
-
-====================================
-Log started, 08/08/2014 02:11:30
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.0074200630187988s
-
-
-
-====================================
-Log started, 08/08/2014 02:13:34
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.0053791999816895s
-
-
-
-====================================
-Log started, 08/08/2014 02:17:52
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.0059990882873535s
-
-
-
-====================================
-Log started, 08/08/2014 02:17:54
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.0051469802856445s
-
-
-
-====================================
-Log started, 08/08/2014 02:29:44
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.004889965057373s
-
-
-
-====================================
-Log started, 08/08/2014 02:31:03
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.0049238204956055s
-
-
-
-====================================
-Log started, 18/08/2015 07:51:07
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.48602795600891s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:02
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.0069999694824219s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:03
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 1964,22
-
-Done in 0.004000186920166s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:05
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 3808,22
-
-Done in 0.0080001354217529s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:06
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 5376,22
-
-Done in 0.0070009231567383s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:06
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 6461,22
-
-Done in 0.0090007781982422s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:07
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 7323,22
-
-Done in 0.0090007781982422s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:08
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 3859,22
-
-Done in 0.0070011615753174s
-
-
-
-====================================
-Log started, 18/08/2015 08:01:09
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 1809,22
-
-Done in 0.0049998760223389s
-
-
-
-====================================
-Log started, 24/08/2015 07:19:36
-====================================
-
-SELECT item_id,item_nm,item_cd FROM grid50000 LIMIT 0,100
-
-SELECT COUNT(*) as DHX_COUNT FROM grid50000
-
-Done in 0.012634992599487s
-
diff --git a/samples/grid/xx_sample_pdo_connector.php b/samples/grid/xx_sample_pdo_connector.php
index 2b202ce..eed2f3c 100644
--- a/samples/grid/xx_sample_pdo_connector.php
+++ b/samples/grid/xx_sample_pdo_connector.php
@@ -3,7 +3,6 @@
$dbh = new PDO('mysql:host='.$mysql_server.';dbname='.$mysql_db, $mysql_user, $mysql_pass);
require("../../codebase/grid_connector.php");
- require("../../codebase/db_pdo.php");
$grid = new GridConnector($dbh,"PDO");
diff --git a/samples/grid/xx_sample_pdo_pg_connector.php b/samples/grid/xx_sample_pdo_pg_connector.php
index 674c6b0..d2c4bb8 100644
--- a/samples/grid/xx_sample_pdo_pg_connector.php
+++ b/samples/grid/xx_sample_pdo_pg_connector.php
@@ -3,7 +3,6 @@
$dbh = new PDO('pgsql:host=localhost;dbname='.$mysql_db.";user=root;password=1234");
require("../../codebase/grid_connector.php");
- require("../../codebase/db_pdo.php");
$grid = new GridConnector($dbh,"PDO");