diff options
author | Stanislau Wolski <stanislau.wolski@gmail.com> | 2017-03-01 14:56:45 +0300 |
---|---|---|
committer | Stanislau Wolski <stanislau.wolski@gmail.com> | 2017-03-01 14:56:45 +0300 |
commit | 8b5f2010bbc463f362bd2e52e2c6625dd45c6861 (patch) | |
tree | 743a75a4bc796895c2bcd5809342691bb85b60d0 /samples/grid | |
parent | 2f82b184637189055abf3cda08abf084a433116e (diff) | |
download | connector-php-origin/HEAD.zip connector-php-origin/HEAD.tar.gz connector-php-origin/HEAD.tar.bz2 |
[update] connector uses PDO by defaultHEADorigin/masterorigin/HEADmaster
Diffstat (limited to 'samples/grid')
-rw-r--r-- | samples/grid/01_basic_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/01a_sql_basic_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/02_rendering_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/03_validation_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/04_custom_sql_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/05_select_filter_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/05a_select_filter_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/06_combo_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/09_server_side_configuration.php | 4 | ||||
-rw-r--r-- | samples/grid/10_auto_config.php | 1 | ||||
-rw-r--r-- | samples/grid/11_auto_config_filters.php | 1 | ||||
-rw-r--r-- | samples/grid/12_attach_header_server.php | 1 | ||||
-rw-r--r-- | samples/grid/some.txt | 178 | ||||
-rw-r--r-- | samples/grid/xx_sample_pdo_connector.php | 1 | ||||
-rw-r--r-- | samples/grid/xx_sample_pdo_pg_connector.php | 1 |
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"); |