diff options
Diffstat (limited to 'samples/grid')
27 files changed, 138 insertions, 68 deletions
diff --git a/samples/grid/01_basic.html b/samples/grid/01_basic.html index 65ac772..ae3c1ff 100644 --- a/samples/grid/01_basic.html +++ b/samples/grid/01_basic.html @@ -8,13 +8,18 @@ <script src="../dhtmlx/dhtmlx.js" type="text/javascript" charset="utf-8"></script> -<script src="../dhtmlx/dhtmlxdataprocessor.js" type="text/javascript" charset="utf-8"></script> -<script src="../../codebase/connector.js" type="text/javascript" charset="utf-8"></script> <link rel="stylesheet" href="../dhtmlx/dhtmlx.css" type="text/css" charset="utf-8"> </head> <body> <div id="gridbox" width="350px" height="550px" style="background-color:white;overflow:hidden"></div> <script> + + function myErrorHandler(type, desc, erData){ + alert("GOT IT!"); + return false; + } + // dhtmlxError.catchError("LoadXML", myErrorHandler); + mygrid = new dhtmlXGridObject('gridbox'); mygrid.setImagePath("../dhtmlx/imgs/"); mygrid.setHeader("Column A, Column B"); @@ -34,7 +39,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> <br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">); diff --git a/samples/grid/01_basic_connector.php b/samples/grid/01_basic_connector.php index eff8ee7..52dcda5 100644 --- a/samples/grid/01_basic_connector.php +++ b/samples/grid/01_basic_connector.php @@ -1,11 +1,11 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); - + $grid = new GridConnector($res, "PDO"); + $grid->enable_log("some.txt", true); $grid->dynamic_loading(100); - $grid->render_table("grid50000","item_id","item_nm,item_cd"); + $grid->render_table("grida50000","item_id","item_nm,item_cd"); ?>
\ No newline at end of file diff --git a/samples/grid/01a_sql_basic.html b/samples/grid/01a_sql_basic.html index 601b833..9564e1e 100644 --- a/samples/grid/01a_sql_basic.html +++ b/samples/grid/01a_sql_basic.html @@ -31,8 +31,18 @@ </script>
<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);">
<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()">
-<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php
<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id(ID)"</span><span style="color: #007700">,</span><span style="color: #DD0000">"grid50000.item_id(ID),item_nm"</span><span style="color: #007700">);
<br /></span><span style="color: #0000BB">?></span> -</span> +<div class='code'><code><span style="color: #000000">
+<span style="color: #0000BB"><?php
+<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
+<br />
+<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id(ID)"</span><span style="color: #007700">,</span><span style="color: #DD0000">"grid50000.item_id(ID),item_nm"</span><span style="color: #007700">);
+<br /></span><span style="color: #0000BB">?></span>
+</span>
</code></div></body>
</html>
diff --git a/samples/grid/01a_sql_basic_connector.php b/samples/grid/01a_sql_basic_connector.php index a02e614..2c2ed6e 100644 --- a/samples/grid/01a_sql_basic_connector.php +++ b/samples/grid/01a_sql_basic_connector.php @@ -1,12 +1,11 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); require("../../codebase/grid_connector.php"); -$gridConn = new GridConnector($res); +$gridConn = new GridConnector($res, "PDO"); $sql = "SELECT * FROM grid50"; $gridConn->render_sql($sql,"item_id","item_nm,item_cd"); diff --git a/samples/grid/02_rendering.html b/samples/grid/02_rendering.html index e204922..537bad3 100644 --- a/samples/grid/02_rendering.html +++ b/samples/grid/02_rendering.html @@ -34,7 +34,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> <br /> function </span><span style="color: #0000BB">color_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">){ diff --git a/samples/grid/02_rendering_connector.php b/samples/grid/02_rendering_connector.php index e56d716..2c185df 100644 --- a/samples/grid/02_rendering_connector.php +++ b/samples/grid/02_rendering_connector.php @@ -1,7 +1,7 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + function color_rows($row){ if ($row->get_index()%2) { @@ -9,7 +9,7 @@ } } require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->dynamic_loading(100); $grid->event->attach("beforeRender","color_rows"); diff --git a/samples/grid/03_validation.html b/samples/grid/03_validation.html index b97cd62..9c7080f 100644 --- a/samples/grid/03_validation.html +++ b/samples/grid/03_validation.html @@ -34,7 +34,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> <br /> function </span><span style="color: #0000BB">check_data</span><span style="color: #007700">(</span><span style="color: #0000BB">$action</span><span style="color: #007700">){ diff --git a/samples/grid/03_validation_connector.php b/samples/grid/03_validation_connector.php index a703c13..13f8cd0 100644 --- a/samples/grid/03_validation_connector.php +++ b/samples/grid/03_validation_connector.php @@ -1,14 +1,14 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + function check_data($action){ if ($action->get_value("item_cd")=="" || $action->get_value("item_nm")=="") $action->invalid(); } require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->dynamic_loading(100); $grid->event->attach("beforeProcessing",check_data); diff --git a/samples/grid/04_custom_sql.html b/samples/grid/04_custom_sql.html index a1f9bf8..bcad539 100644 --- a/samples/grid/04_custom_sql.html +++ b/samples/grid/04_custom_sql.html @@ -31,8 +31,22 @@ </script>
<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);">
<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()">
-<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php
<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">sql</span><span style="color: #007700">-></span><span style="color: #0000BB">attach</span><span style="color: #007700">(</span><span style="color: #DD0000">"delete"</span><span style="color: #007700">,</span><span style="color: #DD0000">"update grid50000 set item_nm='deleted' where item_id='{item_id}'"</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm,item_cd"</span><span style="color: #007700">);
<br /></span><span style="color: #0000BB">?></span> -</span> +<div class='code'><code><span style="color: #000000">
+<span style="color: #0000BB"><?php
+<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
+<br />
+<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">sql</span><span style="color: #007700">-></span><span style="color: #0000BB">attach</span><span style="color: #007700">(</span><span style="color: #DD0000">"delete"</span><span style="color: #007700">,</span><span style="color: #DD0000">"update grid50000 set item_nm='deleted' where item_id='{item_id}'"</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm,item_cd"</span><span style="color: #007700">);
+<br /></span><span style="color: #0000BB">?></span>
+</span>
</code></div></body>
</html>
diff --git a/samples/grid/04_custom_sql_connector.php b/samples/grid/04_custom_sql_connector.php index ceced6f..c1015be 100644 --- a/samples/grid/04_custom_sql_connector.php +++ b/samples/grid/04_custom_sql_connector.php @@ -1,10 +1,10 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->sql->attach("delete","update grid50000 set item_nm='deleted' where item_id='{item_id}'"); diff --git a/samples/grid/05_select_filter.html b/samples/grid/05_select_filter.html index 0922c3a..ce56044 100644 --- a/samples/grid/05_select_filter.html +++ b/samples/grid/05_select_filter.html @@ -35,7 +35,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> <br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">); diff --git a/samples/grid/05_select_filter_connector.php b/samples/grid/05_select_filter_connector.php index 7fb0de8..8a33a97 100644 --- a/samples/grid/05_select_filter_connector.php +++ b/samples/grid/05_select_filter_connector.php @@ -1,10 +1,9 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->dynamic_loading(100); $grid->render_table("countries","item_id","item_nm,item_cd"); diff --git a/samples/grid/05a_select_filter.html b/samples/grid/05a_select_filter.html index 48fe719..2d1ddbd 100644 --- a/samples/grid/05a_select_filter.html +++ b/samples/grid/05a_select_filter.html @@ -31,8 +31,29 @@ </script>
<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);">
<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()">
-<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php
<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br />
<br />
<br />
<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #FF8000">/*$filter1 = new OptionsConnector($res);
<br /> $filter1->render_table("countries","item_id","item_id(value),item_nm(label)");
<br /> $grid->set_options("item_nm",$filter1);*/
<br />
<br /> </span><span style="color: #0000BB">$filter1 </span><span style="color: #007700">= new </span><span style="color: #0000BB">OptionsConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$filter1</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT DISTINCT SUBSTR(item_nm,1,2) as value from grid50"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm(value)"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">set_options</span><span style="color: #007700">(</span><span style="color: #DD0000">"item_nm"</span><span style="color: #007700">,</span><span style="color: #0000BB">$filter1</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm,item_cd"</span><span style="color: #007700">);
<br /></span><span style="color: #0000BB">?></span> -</span> +<div class='code'><code><span style="color: #000000">
+<span style="color: #0000BB"><?php
+<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
+<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
+<br />
+<br />
+<br />
+<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #FF8000">/*$filter1 = new OptionsConnector($res, "PDO");
+<br /> $filter1->render_table("countries","item_id","item_id(value),item_nm(label)");
+<br /> $grid->set_options("item_nm",$filter1);*/
+<br />
+<br /> </span><span style="color: #0000BB">$filter1 </span><span style="color: #007700">= new </span><span style="color: #0000BB">OptionsConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$filter1</span><span style="color: #007700">-></span><span style="color: #0000BB">render_sql</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT DISTINCT SUBSTR(item_nm,1,2) as value from grid50"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm(value)"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">set_options</span><span style="color: #007700">(</span><span style="color: #DD0000">"item_nm"</span><span style="color: #007700">,</span><span style="color: #0000BB">$filter1</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm,item_cd"</span><span style="color: #007700">);
+<br /></span><span style="color: #0000BB">?></span>
+</span>
</code></div></body>
</html>
diff --git a/samples/grid/05a_select_filter_connector.php b/samples/grid/05a_select_filter_connector.php index ef2c31b..a8600b6 100644 --- a/samples/grid/05a_select_filter_connector.php +++ b/samples/grid/05a_select_filter_connector.php @@ -1,20 +1,20 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->dynamic_loading(100); - /*$filter1 = new OptionsConnector($res); + /*$filter1 = new OptionsConnector($res, "PDO"); $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); $grid->set_options("item_nm",$filter1);*/ - $filter1 = new OptionsConnector($res); + $filter1 = new OptionsConnector($res, "PDO"); $filter1->render_sql("SELECT DISTINCT SUBSTR(item_nm,1,2) as value from grid50000","item_id","item_nm(value)"); $grid->set_options("item_nm",$filter1); diff --git a/samples/grid/06_combo.html b/samples/grid/06_combo.html index acabbad..86a5b96 100644 --- a/samples/grid/06_combo.html +++ b/samples/grid/06_combo.html @@ -31,8 +31,30 @@ </script>
<input type="button" name="add" value="add row" onclick="var id=mygrid.uid(); mygrid.addRow(id,'',0); mygrid.showRow(id);">
<input type="button" name="delete" value="delete row" onclick="mygrid.deleteSelectedRows()">
-<div class='code'><code><span style="color: #000000"> -<span style="color: #0000BB"><?php
<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br />
<br />
<br />
<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #FF8000">/*$filter1 = new OptionsConnector($res);
<br /> $filter1->render_table("countries","item_id","item_id(value),item_nm(label)");
<br /> $grid->set_options("item_nm",$filter1);*/
<br />
<br /> </span><span style="color: #0000BB">$filter1 </span><span style="color: #007700">= new </span><span style="color: #0000BB">OptionsConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$filter1</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"countries"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id(value),item_nm(label)"</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">set_options</span><span style="color: #007700">(</span><span style="color: #DD0000">"item_nm"</span><span style="color: #007700">,</span><span style="color: #0000BB">$filter1</span><span style="color: #007700">);
<br />
<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm,item_cd"</span><span style="color: #007700">);
<br />
<br /></span><span style="color: #0000BB">?></span> -</span> +<div class='code'><code><span style="color: #000000">
+<span style="color: #0000BB"><?php
+<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">);
+<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
+<br />
+<br />
+<br />
+<br /> </span><span style="color: #0000BB">$grid </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #FF8000">/*$filter1 = new OptionsConnector($res, "PDO");
+<br /> $filter1->render_table("countries","item_id","item_id(value),item_nm(label)");
+<br /> $grid->set_options("item_nm",$filter1);*/
+<br />
+<br /> </span><span style="color: #0000BB">$filter1 </span><span style="color: #007700">= new </span><span style="color: #0000BB">OptionsConnector</span><span style="color: #007700">(</span><span style="color: #0000BB">$res</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$filter1</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"countries"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id(value),item_nm(label)"</span><span style="color: #007700">);
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">set_options</span><span style="color: #007700">(</span><span style="color: #DD0000">"item_nm"</span><span style="color: #007700">,</span><span style="color: #0000BB">$filter1</span><span style="color: #007700">);
+<br />
+<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">render_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_id"</span><span style="color: #007700">,</span><span style="color: #DD0000">"item_nm,item_cd"</span><span style="color: #007700">);
+<br />
+<br /></span><span style="color: #0000BB">?></span>
+</span>
</code></div></body>
</html>
diff --git a/samples/grid/06_combo_connector.php b/samples/grid/06_combo_connector.php index a5f9f19..3dac5ba 100644 --- a/samples/grid/06_combo_connector.php +++ b/samples/grid/06_combo_connector.php @@ -1,20 +1,20 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->dynamic_loading(100); - /*$filter1 = new OptionsConnector($res); + /*$filter1 = new OptionsConnector($res, "PDO"); $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); $grid->set_options("item_nm",$filter1);*/ - $filter1 = new OptionsConnector($res); + $filter1 = new OptionsConnector($res, "PDO"); $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); $grid->set_options("item_nm",$filter1); diff --git a/samples/grid/06a_combo.html b/samples/grid/06a_combo.html index 79292f7..84a2b65 100644 --- a/samples/grid/06a_combo.html +++ b/samples/grid/06a_combo.html @@ -36,7 +36,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">); <br /> @@ -46,7 +46,7 @@ <br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">enable_log</span><span style="color: #007700">(</span><span style="color: #DD0000">"temp.log"</span><span style="color: #007700">,</span><span style="color: #0000BB">true</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">dynamic_loading</span><span style="color: #007700">(</span><span style="color: #0000BB">100</span><span style="color: #007700">); <br /> -<br /> </span><span style="color: #FF8000">/*$filter1 = new OptionsConnector($res); +<br /> </span><span style="color: #FF8000">/*$filter1 = new OptionsConnector($res, "PDO"); <br /> $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); <br /> $grid->set_options("item_nm",$filter1);*/ <br /> diff --git a/samples/grid/09_server_side_configuration.php b/samples/grid/09_server_side_configuration.php index 7d78476..ae07509 100644 --- a/samples/grid/09_server_side_configuration.php +++ b/samples/grid/09_server_side_configuration.php @@ -1,10 +1,10 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $config = new GridConfiguration(); $config->setHeader("ID,First Name,Last Name,Title,Office,Extn,Mobile,Email"); diff --git a/samples/grid/10_auto_config.php b/samples/grid/10_auto_config.php index 0d29788..a1dcf33 100644 --- a/samples/grid/10_auto_config.php +++ b/samples/grid/10_auto_config.php @@ -1,10 +1,10 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->set_config(false); $grid->dynamic_loading(100); $grid->render_table("grid50000","item_id","item_nm,item_cd"); diff --git a/samples/grid/11_auto_config_filters.php b/samples/grid/11_auto_config_filters.php index af63604..4eb8604 100644 --- a/samples/grid/11_auto_config_filters.php +++ b/samples/grid/11_auto_config_filters.php @@ -1,10 +1,10 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $grid->set_config(true); $grid->dynamic_loading(100); diff --git a/samples/grid/12_attach_header_server.html b/samples/grid/12_attach_header_server.html index 92af05e..59e9acc 100644 --- a/samples/grid/12_attach_header_server.html +++ b/samples/grid/12_attach_header_server.html @@ -29,7 +29,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> <br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">); diff --git a/samples/grid/12_attach_header_server.php b/samples/grid/12_attach_header_server.php index 873144d..cf09458 100644 --- a/samples/grid/12_attach_header_server.php +++ b/samples/grid/12_attach_header_server.php @@ -1,10 +1,10 @@ <?php require_once("../config.php"); - $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); - mysql_select_db($mysql_db); + $res= new PDO($mysql_server,$mysql_user,$mysql_pass); + require("../../codebase/grid_connector.php"); - $grid = new GridConnector($res); + $grid = new GridConnector($res, "PDO"); $config = new GridConfiguration(); diff --git a/samples/grid/xx_adodb.html b/samples/grid/xx_adodb.html index 041c0e6..a6226f5 100644 --- a/samples/grid/xx_adodb.html +++ b/samples/grid/xx_adodb.html @@ -34,7 +34,7 @@ <div class='code'><code><span style="color: #000000"> <span style="color: #0000BB"><?php <br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">); -<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">); <br /> </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">); <br /> <br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">); diff --git a/samples/grid/xx_sample_mssql_connector.php b/samples/grid/xx_sample_mssql_connector.php index 57d7b78..0aa0f39 100644 --- a/samples/grid/xx_sample_mssql_connector.php +++ b/samples/grid/xx_sample_mssql_connector.php @@ -6,7 +6,7 @@ require("../../codebase/grid_connector.php"); require("../../codebase/db_mssql.php"); - $grid = new GridConnector($res,"MsSQL"); + $grid = new GridConnector($res, "PDO","MsSQL"); $grid->dynamic_loading(100); $grid->render_table("grid50000","item_id","item_nm,item_cd"); diff --git a/samples/grid/xx_sample_oracle_connector.php b/samples/grid/xx_sample_oracle_connector.php index ef1ee04..ed1b258 100644 --- a/samples/grid/xx_sample_oracle_connector.php +++ b/samples/grid/xx_sample_oracle_connector.php @@ -7,7 +7,7 @@ require("../../codebase/grid_connector.php"); require("../../codebase/db_oracle.php"); - $grid = new GridConnector($res,"Oracle"); + $grid = new GridConnector($res, "PDO","Oracle"); $grid->dynamic_loading(50); $grid->sql->sequence("EMPLOYEES_INC.nextVal"); diff --git a/samples/grid/xx_sample_postgresql_connector.php b/samples/grid/xx_sample_postgresql_connector.php index b2e1bad..e86f4fd 100644 --- a/samples/grid/xx_sample_postgresql_connector.php +++ b/samples/grid/xx_sample_postgresql_connector.php @@ -6,7 +6,7 @@ require("../../codebase/grid_connector.php"); require("../../codebase/db_postgre.php"); - $grid = new GridConnector($res,"Postgre"); + $grid = new GridConnector($res, "PDO","Postgre"); $grid->dynamic_loading(100); $grid->render_table("grid50000","item_id","item_nm,item_cd"); diff --git a/samples/grid/xx_sample_sasql_connector.php b/samples/grid/xx_sample_sasql_connector.php index 798f84f..27b94b5 100644 --- a/samples/grid/xx_sample_sasql_connector.php +++ b/samples/grid/xx_sample_sasql_connector.php @@ -4,7 +4,7 @@ require("../../codebase/grid_connector.php"); require("../../codebase/db_sasql.php"); - $grid = new GridConnector($res, "SaSQL"); + $grid = new GridConnector($res, "PDO", "SaSQL"); $grid->enable_log("temp.log",true); $grid->dynamic_loading(100); $grid->render_table("Contacts","ID","Surname,GivenName,Title"); |