diff options
| author | Maksim <max@dhtmlx.com> | 2011-07-18 18:21:10 +0300 |
|---|---|---|
| committer | Maksim <max@dhtmlx.com> | 2011-07-18 18:21:10 +0300 |
| commit | 5c2afae6cf595c981155ac68501ac2d1af77db54 (patch) | |
| tree | b07de6379fb3eb540df732a57061cafd05288599 /samples/grid | |
| download | connector-php-5c2afae6cf595c981155ac68501ac2d1af77db54.zip connector-php-5c2afae6cf595c981155ac68501ac2d1af77db54.tar.gz connector-php-5c2afae6cf595c981155ac68501ac2d1af77db54.tar.bz2 | |
* import of php connector v1.2
Diffstat (limited to 'samples/grid')
40 files changed, 1144 insertions, 0 deletions
diff --git a/samples/grid/01_basic.html b/samples/grid/01_basic.html new file mode 100644 index 0000000..9aa1e5b --- /dev/null +++ b/samples/grid/01_basic.html @@ -0,0 +1,48 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.setHeader("Column A, Column B"); + mygrid.attachHeader("#connector_text_filter,#connector_text_filter") + mygrid.setInitWidths("100,*") + mygrid.setColTypes("edtxt,ed"); + mygrid.setColSorting("connector,connector") + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + mygrid.loadXML("01_basic_connector.php"); + var dp = new dataProcessor("01_basic_connector.php"); + dp.init(mygrid); +</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_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/01_basic_connector.php b/samples/grid/01_basic_connector.php new file mode 100644 index 0000000..eff8ee7 --- /dev/null +++ b/samples/grid/01_basic_connector.php @@ -0,0 +1,11 @@ +<?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->dynamic_loading(100); + $grid->render_table("grid50000","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 new file mode 100644 index 0000000..1b4187a --- /dev/null +++ b/samples/grid/01a_sql_basic.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("01a_sql_basic_connector.php");
+ var dp = new dataProcessor("01a_sql_basic_connector.php");
+ dp.init(mygrid);
+</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> +</code></div></body>
+</html>
diff --git a/samples/grid/01a_sql_basic_connector.php b/samples/grid/01a_sql_basic_connector.php new file mode 100644 index 0000000..a02e614 --- /dev/null +++ b/samples/grid/01a_sql_basic_connector.php @@ -0,0 +1,13 @@ +<?php + require_once("../config.php"); + $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); + mysql_select_db($mysql_db); + + require("../../codebase/grid_connector.php"); + + +$gridConn = new GridConnector($res); +$sql = "SELECT * FROM grid50"; +$gridConn->render_sql($sql,"item_id","item_nm,item_cd"); + +?>
\ No newline at end of file diff --git a/samples/grid/02_rendering.html b/samples/grid/02_rendering.html new file mode 100644 index 0000000..f584607 --- /dev/null +++ b/samples/grid/02_rendering.html @@ -0,0 +1,52 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.setHeader("Column A, Column B"); + mygrid.attachHeader("#connector_text_filter,#connector_text_filter") + mygrid.setInitWidths("100,*") + mygrid.setColTypes("edtxt,ed"); + mygrid.setColSorting("connector,connector") + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + mygrid.loadXML("02_rendering_connector.php"); + var dp = new dataProcessor("02_rendering_connector.php"); + dp.init(mygrid); +</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 /> function </span><span style="color: #0000BB">color_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$row</span><span style="color: #007700">){ +<br /> if (</span><span style="color: #0000BB">$row</span><span style="color: #007700">-></span><span style="color: #0000BB">get_index</span><span style="color: #007700">()%</span><span style="color: #0000BB">2</span><span style="color: #007700">) </span><span style="color: #0000BB">$row</span><span style="color: #007700">-></span><span style="color: #0000BB">set_row_style</span><span style="color: #007700">(</span><span style="color: #DD0000">"background-color: red"</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">event</span><span style="color: #007700">-></span><span style="color: #0000BB">attach</span><span style="color: #007700">(</span><span style="color: #DD0000">"beforeRender"</span><span style="color: #007700">,</span><span style="color: #DD0000">"color_rows"</span><span style="color: #007700">); +<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/02_rendering_connector.php b/samples/grid/02_rendering_connector.php new file mode 100644 index 0000000..e56d716 --- /dev/null +++ b/samples/grid/02_rendering_connector.php @@ -0,0 +1,17 @@ +<?php + require_once("../config.php"); + $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); + mysql_select_db($mysql_db); + + function color_rows($row){ + if ($row->get_index()%2) { + $row->set_row_style("background-color: red"); + } + } + require("../../codebase/grid_connector.php"); + $grid = new GridConnector($res); + + $grid->dynamic_loading(100); + $grid->event->attach("beforeRender","color_rows"); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/03_validation.html b/samples/grid/03_validation.html new file mode 100644 index 0000000..67ebd32 --- /dev/null +++ b/samples/grid/03_validation.html @@ -0,0 +1,53 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.setHeader("Column A, Column B"); + mygrid.attachHeader("#connector_text_filter,#connector_text_filter") + mygrid.setInitWidths("100,*") + mygrid.setColTypes("edtxt,ed"); + mygrid.setColSorting("connector,connector") + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + mygrid.loadXML("03_validation_connector.php"); + var dp = new dataProcessor("03_validation_connector.php"); + dp.init(mygrid); +</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 /> function </span><span style="color: #0000BB">check_data</span><span style="color: #007700">(</span><span style="color: #0000BB">$action</span><span style="color: #007700">){ +<br /> if (</span><span style="color: #0000BB">$action</span><span style="color: #007700">-></span><span style="color: #0000BB">get_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"item_cd"</span><span style="color: #007700">)==</span><span style="color: #DD0000">"" </span><span style="color: #007700">|| </span><span style="color: #0000BB">$action</span><span style="color: #007700">-></span><span style="color: #0000BB">get_value</span><span style="color: #007700">(</span><span style="color: #DD0000">"item_nm"</span><span style="color: #007700">)==</span><span style="color: #DD0000">""</span><span style="color: #007700">) +<br /> </span><span style="color: #0000BB">$action</span><span style="color: #007700">-></span><span style="color: #0000BB">invalid</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">event</span><span style="color: #007700">-></span><span style="color: #0000BB">attach</span><span style="color: #007700">(</span><span style="color: #DD0000">"beforeProcessing"</span><span style="color: #007700">,</span><span style="color: #0000BB">check_data</span><span style="color: #007700">); +<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/03_validation_connector.php b/samples/grid/03_validation_connector.php new file mode 100644 index 0000000..a703c13 --- /dev/null +++ b/samples/grid/03_validation_connector.php @@ -0,0 +1,16 @@ +<?php + require_once("../config.php"); + $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass); + mysql_select_db($mysql_db); + + 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->dynamic_loading(100); + $grid->event->attach("beforeProcessing",check_data); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/04_custom_sql.html b/samples/grid/04_custom_sql.html new file mode 100644 index 0000000..c8d2d05 --- /dev/null +++ b/samples/grid/04_custom_sql.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("04_custom_sql_connector.php");
+ var dp = new dataProcessor("04_custom_sql_connector.php");
+ dp.init(mygrid);
+</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> +</code></div></body>
+</html>
diff --git a/samples/grid/04_custom_sql_connector.php b/samples/grid/04_custom_sql_connector.php new file mode 100644 index 0000000..ceced6f --- /dev/null +++ b/samples/grid/04_custom_sql_connector.php @@ -0,0 +1,15 @@ +<?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->sql->attach("delete","update grid50000 set item_nm='deleted' where item_id='{item_id}'"); + + $grid->dynamic_loading(100); + + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/05_select_filter.html b/samples/grid/05_select_filter.html new file mode 100644 index 0000000..9315f06 --- /dev/null +++ b/samples/grid/05_select_filter.html @@ -0,0 +1,49 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + + mygrid.setHeader("Column A, Column B"); + mygrid.attachHeader("#connector_select_filter,#connector_select_filter") + mygrid.setInitWidths("200,*") + mygrid.setColTypes("edtxt,ed"); + mygrid.setColSorting("connector,connector") + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + mygrid.loadXML("05_select_filter_connector.php"); + var dp = new dataProcessor("05_select_filter_connector.php"); + dp.init(mygrid); +</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_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_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/05_select_filter_connector.php b/samples/grid/05_select_filter_connector.php new file mode 100644 index 0000000..7fb0de8 --- /dev/null +++ b/samples/grid/05_select_filter_connector.php @@ -0,0 +1,11 @@ +<?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->dynamic_loading(100); + $grid->render_table("countries","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/05a_select_filter.html b/samples/grid/05a_select_filter.html new file mode 100644 index 0000000..608cb2c --- /dev/null +++ b/samples/grid/05a_select_filter.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_select_filter,#connector_select_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("05a_select_filter_connector.php");
+ var dp = new dataProcessor("05a_select_filter_connector.php");
+ dp.init(mygrid);
+</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> +</code></div></body>
+</html>
diff --git a/samples/grid/05a_select_filter_connector.php b/samples/grid/05a_select_filter_connector.php new file mode 100644 index 0000000..ef2c31b --- /dev/null +++ b/samples/grid/05a_select_filter_connector.php @@ -0,0 +1,22 @@ +<?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->dynamic_loading(100); + + /*$filter1 = new OptionsConnector($res); + $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); + $grid->set_options("item_nm",$filter1);*/ + + $filter1 = new OptionsConnector($res); + $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); + + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/06_combo.html b/samples/grid/06_combo.html new file mode 100644 index 0000000..6786a16 --- /dev/null +++ b/samples/grid/06_combo.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("co,co");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("06_combo_connector.php");
+ var dp = new dataProcessor("06_combo_connector.php");
+ dp.init(mygrid);
+</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> +</code></div></body>
+</html>
diff --git a/samples/grid/06_combo_connector.php b/samples/grid/06_combo_connector.php new file mode 100644 index 0000000..a5f9f19 --- /dev/null +++ b/samples/grid/06_combo_connector.php @@ -0,0 +1,23 @@ +<?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->dynamic_loading(100); + + /*$filter1 = new OptionsConnector($res); + $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); + $grid->set_options("item_nm",$filter1);*/ + + $filter1 = new OptionsConnector($res); + $filter1->render_table("countries","item_id","item_id(value),item_nm(label)"); + $grid->set_options("item_nm",$filter1); + + $grid->render_table("grid50000","item_id","item_nm,item_cd"); + +?>
\ No newline at end of file diff --git a/samples/grid/06a_combo.html b/samples/grid/06a_combo.html new file mode 100644 index 0000000..6c20752 --- /dev/null +++ b/samples/grid/06a_combo.html @@ -0,0 +1,65 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.setHeader("Column A, Column B"); + mygrid.attachHeader("#connector_text_filter,#connector_text_filter") + mygrid.setInitWidths("100,*") + mygrid.setColTypes("co,co"); + mygrid.setColSorting("connector,connector") + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + mygrid.loadXML("06a_combo_connector.php"); + var dp = new dataProcessor("06a_combo_connector.php"); + dp.setUpdateMode("off") + dp.init(mygrid); +</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()"> +<input type="button" name="update" value="update row" onclick="dp.sendData()"> +<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 /> +<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">,array(</span><span style="color: #DD0000">"1"</span><span style="color: #007700">,</span><span style="color: #DD0000">"two"</span><span style="color: #007700">,</span><span style="color: #DD0000">"3"</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_cd"</span><span style="color: #007700">,array(</span><span style="color: #DD0000">"91"</span><span style="color: #007700">=></span><span style="color: #DD0000">"one"</span><span style="color: #007700">, </span><span style="color: #DD0000">"75"</span><span style="color: #007700">=></span><span style="color: #DD0000">"two"</span><span style="color: #007700">)); +<br /> +<br /> +<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">set_transaction_mode</span><span style="color: #007700">(</span><span style="color: #DD0000">"record"</span><span style="color: #007700">); +<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/09_server_side_configuration.html b/samples/grid/09_server_side_configuration.html new file mode 100644 index 0000000..32f7508 --- /dev/null +++ b/samples/grid/09_server_side_configuration.html @@ -0,0 +1,32 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + + mygrid.loadXML("09_server_side_configuration.php"); + var dp = new dataProcessor("09_server_side_configuration.php"); + dp.init(mygrid); +</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()"> + +</body> +</html> diff --git a/samples/grid/09_server_side_configuration.php b/samples/grid/09_server_side_configuration.php new file mode 100644 index 0000000..7d78476 --- /dev/null +++ b/samples/grid/09_server_side_configuration.php @@ -0,0 +1,15 @@ +<?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"); +?>
\ No newline at end of file diff --git a/samples/grid/10_auto_config.html b/samples/grid/10_auto_config.html new file mode 100644 index 0000000..ac19f96 --- /dev/null +++ b/samples/grid/10_auto_config.html @@ -0,0 +1,32 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + + mygrid.loadXML("10_auto_config.php"); + var dp = new dataProcessor("10_auto_config.php"); + dp.init(mygrid); +</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()"> + +</body> +</html> diff --git a/samples/grid/10_auto_config.php b/samples/grid/10_auto_config.php new file mode 100644 index 0000000..0d29788 --- /dev/null +++ b/samples/grid/10_auto_config.php @@ -0,0 +1,11 @@ +<?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->set_config(false); + $grid->dynamic_loading(100); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/11_auto_config_filters.html b/samples/grid/11_auto_config_filters.html new file mode 100644 index 0000000..5965fba --- /dev/null +++ b/samples/grid/11_auto_config_filters.html @@ -0,0 +1,32 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + + mygrid.loadXML("11_auto_config_filters.php"); + var dp = new dataProcessor("11_auto_config_filters.php"); + dp.init(mygrid); +</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()"> + +</body> +</html> diff --git a/samples/grid/11_auto_config_filters.php b/samples/grid/11_auto_config_filters.php new file mode 100644 index 0000000..af63604 --- /dev/null +++ b/samples/grid/11_auto_config_filters.php @@ -0,0 +1,12 @@ +<?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->set_config(true); + $grid->dynamic_loading(100); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/12_attach_header_server.html b/samples/grid/12_attach_header_server.html new file mode 100644 index 0000000..305ede0 --- /dev/null +++ b/samples/grid/12_attach_header_server.html @@ -0,0 +1,57 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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> + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.enableSmartRendering(true) + mygrid.enableMultiselect(true) + mygrid.init(); + mygrid.loadXML("12_attach_header_server.php"); + var dp = new dataProcessor("12_attach_header_server.php"); + dp.init(mygrid); +</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">$config </span><span style="color: #007700">= new </span><span style="color: #0000BB">GridConfiguration</span><span style="color: #007700">(); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setHeader</span><span style="color: #007700">(</span><span style="color: #DD0000">"Item,#cspan"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">attachHeader</span><span style="color: #007700">(</span><span style="color: #DD0000">"Item Name,Item CD"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColIds</span><span style="color: #007700">(</span><span style="color: #DD0000">"col1,col2"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setInitWidths</span><span style="color: #007700">(</span><span style="color: #DD0000">"120,*"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColSorting</span><span style="color: #007700">(</span><span style="color: #DD0000">"connector,connector"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColColor</span><span style="color: #007700">(</span><span style="color: #DD0000">",#dddddd"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColHidden</span><span style="color: #007700">(</span><span style="color: #DD0000">"false,false"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColTypes</span><span style="color: #007700">(</span><span style="color: #DD0000">"ro,ed"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColAlign</span><span style="color: #007700">(</span><span style="color: #DD0000">"center,center"</span><span style="color: #007700">); +<br /> </span><span style="color: #0000BB">$config</span><span style="color: #007700">-></span><span style="color: #0000BB">setColVAlign</span><span style="color: #007700">(</span><span style="color: #DD0000">"bottom,middle"</span><span style="color: #007700">); +<br /> +<br /> </span><span style="color: #0000BB">$grid</span><span style="color: #007700">-></span><span style="color: #0000BB">set_config</span><span style="color: #007700">(</span><span style="color: #0000BB">$config</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_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/12_attach_header_server.php b/samples/grid/12_attach_header_server.php new file mode 100644 index 0000000..873144d --- /dev/null +++ b/samples/grid/12_attach_header_server.php @@ -0,0 +1,27 @@ +<?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"); +?>
\ No newline at end of file diff --git a/samples/grid/13_filesystem_grid_connector.html b/samples/grid/13_filesystem_grid_connector.html new file mode 100644 index 0000000..41540cd --- /dev/null +++ b/samples/grid/13_filesystem_grid_connector.html @@ -0,0 +1,40 @@ + +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>For demo purpose only :: &1</title> + + + + +<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="850px" height="350px" style="background-color:white;overflow:hidden"></div> + +<script> + + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("../common/imgs/"); + mygrid.setHeader("File name,Full file name,Size,Name,Extention,Date,Is folder"); + mygrid.setInitWidths("100,250,100,100,100,100,*"); + mygrid.init(); + mygrid.loadXML("13_filesystem_grid_connector.php"); + +</script> +<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">"../../codebase/db_filesystem.php"</span><span style="color: #007700">); +<br /> </span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">); +<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: #DD0000">"c:/"</span>, <span style="color: #DD0000">"FileSystem"</span><span style="color: #007700">); +<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">"../"</span><span style="color: #007700">,</span><span style="color: #DD0000">"safe_name"</span><span style="color: #007700">,</span><span style="color: #DD0000">"filename,full_filename,size,name,extention,date,is_folder"</span><span style="color: #007700">); +<br /></span><span style="color: #0000BB">?></span> +</span> +</code></div> +</body> +</html> diff --git a/samples/grid/13_filesystem_grid_connector.php b/samples/grid/13_filesystem_grid_connector.php new file mode 100644 index 0000000..692f101 --- /dev/null +++ b/samples/grid/13_filesystem_grid_connector.php @@ -0,0 +1,7 @@ +<?php + require("../../codebase/db_filesystem.php"); + require("../../codebase/grid_connector.php"); + + $grid = new GridConnector("c:/", "FileSystem"); + $grid->render_table("../","safe_name","filename,full_filename,size,name,extention,date,is_folder"); +?>
\ No newline at end of file diff --git a/samples/grid/index.html b/samples/grid/index.html new file mode 100644 index 0000000..b934842 --- /dev/null +++ b/samples/grid/index.html @@ -0,0 +1,35 @@ +<html> + <head></head> + <style type="text/css" media="screen"> + *{ + font-family:Tahoma; + } + div,li{ + font-size:10pt; + } + div{ + padding-bottom:20px; + } + li{ + padding-left:50px; + padding-bottom:10px; + } + </style> + <body> + <h2>dhtmlxConnector for PHP :: Samples</h2> + <li><a href="01_basic.html">Basic init</a></li> + <li><a href="01a_sql_basic.html">Basic init by sql string</a></li> + <li><a href="02_rendering.html">Rendering customization</a></li> + <li><a href="03_validation.html">Validation</a></li> + <li><a href="04_custom_sql.html">Custom update logic</a></li> + <li><a href="05_select_filter.html">Select filter in grid</a></li> + <li><a href="05a_select_filter.html">Select filter in grid ( different init )</a></li> + <li><a href="06_combo.html">Combo in grid (sub connector)</a></li> + <li><a href="06a_combo.html">Combo in grid (predefined list)</a></li> + <li><a href="09_server_side_configuration.html">Configuration on server side</a></li> + <li><a href="10_auto_config.html">Auto configuration</a></li> + <li><a href="11_auto_config_filters.html">Auto configuration with filters</a></li> + <li><a href="12_attach_header_server.html">Attaching header on the server side</a></li> + <li><a href="13_filesystem_grid_connector.html">File system connector</a></li> + </body> +</html>
\ No newline at end of file diff --git a/samples/grid/xx_sample_mssql.html b/samples/grid/xx_sample_mssql.html new file mode 100644 index 0000000..8889d3f --- /dev/null +++ b/samples/grid/xx_sample_mssql.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("xx_sample_mssql_connector.php");
+ var dp = new dataProcessor("xx_sample_mssql_connector.php");
+ dp.init(mygrid);
+</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">mssql_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">'.\SQLEXPRESS'</span><span style="color: #007700">,</span><span style="color: #DD0000">"sa"</span><span style="color: #007700">,</span><span style="color: #DD0000">"1"</span><span style="color: #007700">,</span><span style="color: #0000BB">false</span><span style="color: #007700">);
<br /> </span><span style="color: #0000BB">mssql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">"sampleDB"</span><span style="color: #007700">);
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/db_mssql.php"</span><span style="color: #007700">);
<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">,</span><span style="color: #DD0000">"MsSQL"</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_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/xx_sample_mssql_connector.php b/samples/grid/xx_sample_mssql_connector.php new file mode 100644 index 0000000..57d7b78 --- /dev/null +++ b/samples/grid/xx_sample_mssql_connector.php @@ -0,0 +1,13 @@ +<?php + require_once("../config.php"); + $res=mssql_connect('.\SQLEXPRESS',"sa","1",false); + mssql_select_db("sampleDB"); + + require("../../codebase/grid_connector.php"); + require("../../codebase/db_mssql.php"); + + $grid = new GridConnector($res,"MsSQL"); + + $grid->dynamic_loading(100); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/xx_sample_mysqli.html b/samples/grid/xx_sample_mysqli.html new file mode 100644 index 0000000..1e7891e --- /dev/null +++ b/samples/grid/xx_sample_mysqli.html @@ -0,0 +1,25 @@ +<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> +<html> +<head> + <title>MySQLi connector with dhtmlxGrid - read-only version</title> + <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"> + <script> + function doOnLoad() { + mygrid = new dhtmlXGridObject('gridbox'); + mygrid.setImagePath("./codebase/imgs/"); + mygrid.setSkin('dhx_skyblue'); + mygrid.setHeader("Event name, Details"); + mygrid.setInitWidths("300,*") + mygrid.setColTypes("ro,ro"); + mygrid.init(); + mygrid.loadXML("xx_sample_mysqli_connector.php"); + } + </script> +</head> +<body onload="doOnLoad();"> + <div id="gridbox" style="width: 700px; height: 300px; background-color:white;overflow:hidden; border: 1px solid #dfdfdf;"></div> +</body> +</html> diff --git a/samples/grid/xx_sample_mysqli_connector.php b/samples/grid/xx_sample_mysqli_connector.php new file mode 100644 index 0000000..726bd61 --- /dev/null +++ b/samples/grid/xx_sample_mysqli_connector.php @@ -0,0 +1,16 @@ +<?php + + require("../config.php"); + require("../../codebase/db_mysqli.php"); + require("../../codebase/grid_connector.php"); + + $mysqli = new mysqli($server, $user, $pass, $mysql_db); + if (mysqli_connect_errno()) { + printf("Подключение к серверу MySQL невозможно. Код ошибки: %s\n", mysqli_connect_error()); + exit; + } + + $grid = new GridConnector($mysqli, "MySQLi"); + + $grid->render_table("events","event_id","event_name,details"); +?>
\ No newline at end of file diff --git a/samples/grid/xx_sample_oracle.html b/samples/grid/xx_sample_oracle.html new file mode 100644 index 0000000..b2fa4b9 --- /dev/null +++ b/samples/grid/xx_sample_oracle.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("xx_sample_oracle_connector.php");
+ var dp = new dataProcessor("xx_sample_oracle_connector.php");
+ dp.init(mygrid);
+</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">oci_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$oci_dbuser</span><span style="color: #007700">,</span><span style="color: #0000BB">$oci_dbpass</span><span style="color: #007700">,</span><span style="color: #0000BB">$oci_dbname</span><span style="color: #007700">);
<br />
<br />
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/db_oracle.php"</span><span style="color: #007700">);
<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">,</span><span style="color: #DD0000">"Oracle"</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">50</span><span style="color: #007700">);
<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">sequence</span><span style="color: #007700">(</span><span style="color: #DD0000">"EMPLOYEES_INC.nextVal"</span><span style="color: #007700">);
<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">"EMPLOYEES"</span><span style="color: #007700">,</span><span style="color: #DD0000">"EMPLOYEE_ID"</span><span style="color: #007700">,</span><span style="color: #DD0000">"FIRST_NAME,LAST_NAME"</span><span style="color: #007700">);
<br />
<br /></span><span style="color: #0000BB">?></span> +</span> +</code></div></body>
+</html>
diff --git a/samples/grid/xx_sample_oracle_connector.php b/samples/grid/xx_sample_oracle_connector.php new file mode 100644 index 0000000..ef1ee04 --- /dev/null +++ b/samples/grid/xx_sample_oracle_connector.php @@ -0,0 +1,16 @@ +<?php + require_once("../config.php"); + $res = oci_connect($oci_dbuser,$oci_dbpass,$oci_dbname); + + + + require("../../codebase/grid_connector.php"); + require("../../codebase/db_oracle.php"); + + $grid = new GridConnector($res,"Oracle"); + + $grid->dynamic_loading(50); + $grid->sql->sequence("EMPLOYEES_INC.nextVal"); + $grid->render_table("EMPLOYEES","EMPLOYEE_ID","FIRST_NAME,LAST_NAME"); + +?>
\ No newline at end of file diff --git a/samples/grid/xx_sample_pdo.html b/samples/grid/xx_sample_pdo.html new file mode 100644 index 0000000..712100e --- /dev/null +++ b/samples/grid/xx_sample_pdo.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("xx_sample_pdo_connector.php");
+ var dp = new dataProcessor("xx_sample_pdo_connector.php");
+ dp.init(mygrid);
+</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">$dbh </span><span style="color: #007700">= new </span><span style="color: #0000BB">PDO</span><span style="color: #007700">(</span><span style="color: #DD0000">'mysql:host='</span><span style="color: #007700">.</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">.</span><span style="color: #DD0000">';dbname='</span><span style="color: #007700">.</span><span style="color: #0000BB">$mysql_db</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 />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/db_pdo.php"</span><span style="color: #007700">);
<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">$dbh</span><span style="color: #007700">,</span><span style="color: #DD0000">"PDO"</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_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/xx_sample_pdo_connector.php b/samples/grid/xx_sample_pdo_connector.php new file mode 100644 index 0000000..2b202ce --- /dev/null +++ b/samples/grid/xx_sample_pdo_connector.php @@ -0,0 +1,12 @@ +<?php + require_once("../config.php"); + $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"); + + $grid->dynamic_loading(100); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/xx_sample_pdo_pg.html b/samples/grid/xx_sample_pdo_pg.html new file mode 100644 index 0000000..ca2be1b --- /dev/null +++ b/samples/grid/xx_sample_pdo_pg.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("xx_sample_pdo_pg_connector.php");
+ var dp = new dataProcessor("xx_sample_pdo_pg_connector.php");
+ dp.init(mygrid);
+</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">$dbh </span><span style="color: #007700">= new </span><span style="color: #0000BB">PDO</span><span style="color: #007700">(</span><span style="color: #DD0000">'pgsql:host=localhost;dbname='</span><span style="color: #007700">.</span><span style="color: #0000BB">$mysql_db</span><span style="color: #007700">.</span><span style="color: #DD0000">";user=root;password=1234"</span><span style="color: #007700">);
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/db_pdo.php"</span><span style="color: #007700">);
<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">$dbh</span><span style="color: #007700">,</span><span style="color: #DD0000">"PDO"</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_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/xx_sample_pdo_pg_connector.php b/samples/grid/xx_sample_pdo_pg_connector.php new file mode 100644 index 0000000..674c6b0 --- /dev/null +++ b/samples/grid/xx_sample_pdo_pg_connector.php @@ -0,0 +1,12 @@ +<?php + require_once("../config.php"); + $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"); + + $grid->dynamic_loading(100); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file diff --git a/samples/grid/xx_sample_postgresql.html b/samples/grid/xx_sample_postgresql.html new file mode 100644 index 0000000..737849f --- /dev/null +++ b/samples/grid/xx_sample_postgresql.html @@ -0,0 +1,38 @@ +
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html>
+<head>
+ <title>For demo purpose only :: &1</title>
+
+
+
+
+<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>
+ mygrid = new dhtmlXGridObject('gridbox');
+ mygrid.setImagePath("../common/imgs/");
+ mygrid.setHeader("Column A, Column B");
+ mygrid.attachHeader("#connector_text_filter,#connector_text_filter")
+ mygrid.setInitWidths("100,*")
+ mygrid.setColTypes("edtxt,ed");
+ mygrid.setColSorting("connector,connector")
+ mygrid.enableSmartRendering(true)
+ mygrid.enableMultiselect(true)
+ mygrid.init();
+ mygrid.loadXML("xx_sample_postgresql_connector.php");
+ var dp = new dataProcessor("xx_sample_postgresql_connector.php");
+ dp.init(mygrid);
+</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">pg_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$postrgre_connection</span><span style="color: #007700">);
<br />
<br /> require(</span><span style="color: #DD0000">"../../codebase/grid_connector.php"</span><span style="color: #007700">);
<br /> require(</span><span style="color: #DD0000">"../../codebase/db_postgre.php"</span><span style="color: #007700">);
<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">,</span><span style="color: #DD0000">"Postgre"</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_table</span><span style="color: #007700">(</span><span style="color: #DD0000">"grid50000"</span><span style="color: #007700">,</span><span style="color: #DD0000">""</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/xx_sample_postgresql_connector.php b/samples/grid/xx_sample_postgresql_connector.php new file mode 100644 index 0000000..b2e1bad --- /dev/null +++ b/samples/grid/xx_sample_postgresql_connector.php @@ -0,0 +1,13 @@ +<?php + require_once("../config.php"); + $postrgre_connection = "host=192.168.1.251 port=5432 dbname=sampledb user=pguser password=pgpass"; + $res=pg_connect($postrgre_connection); + + require("../../codebase/grid_connector.php"); + require("../../codebase/db_postgre.php"); + + $grid = new GridConnector($res,"Postgre"); + + $grid->dynamic_loading(100); + $grid->render_table("grid50000","item_id","item_nm,item_cd"); +?>
\ No newline at end of file |