summaryrefslogtreecommitdiffstats
path: root/samples/treegrid
diff options
context:
space:
mode:
Diffstat (limited to 'samples/treegrid')
-rw-r--r--samples/treegrid/01_basic.html2
-rw-r--r--samples/treegrid/01_basic_connector.php6
-rw-r--r--samples/treegrid/02_dynamic_loading.html2
-rw-r--r--samples/treegrid/02_dynamic_loading_connector.php6
-rw-r--r--samples/treegrid/03_sql_config.html2
-rw-r--r--samples/treegrid/03_sql_config_connector.php6
-rw-r--r--samples/treegrid/04_custom_styles.html2
-rw-r--r--samples/treegrid/04_custom_styles_connector.php6
-rw-r--r--samples/treegrid/05_live_update.html2
-rw-r--r--samples/treegrid/06_treegrid_group_connector.html2
-rw-r--r--samples/treegrid/06_treegrid_group_connector.php6
-rw-r--r--samples/treegrid/07_treegrid_multitable_connector.html2
-rw-r--r--samples/treegrid/07_treegrid_multitable_connector.php6
13 files changed, 25 insertions, 25 deletions
diff --git a/samples/treegrid/01_basic.html b/samples/treegrid/01_basic.html
index ae3e44c..9fd1b89 100644
--- a/samples/treegrid/01_basic.html
+++ b/samples/treegrid/01_basic.html
@@ -33,7 +33,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">);
diff --git a/samples/treegrid/01_basic_connector.php b/samples/treegrid/01_basic_connector.php
index c9c020f..de478cc 100644
--- a/samples/treegrid/01_basic_connector.php
+++ b/samples/treegrid/01_basic_connector.php
@@ -1,10 +1,10 @@
<?php
require_once("../config.php");
- $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
- mysql_select_db($mysql_db);
+ $res= new PDO($mysql_server,$mysql_user,$mysql_pass);
+
require("../../codebase/treegrid_connector.php");
- $tree = new TreeGridConnector($res);
+ $tree = new TreeGridConnector($res, "PDO");
$tree->render_table("tasks","taskId","taskName,duration,complete","","parentId");
?> \ No newline at end of file
diff --git a/samples/treegrid/02_dynamic_loading.html b/samples/treegrid/02_dynamic_loading.html
index 147b24f..f9cf867 100644
--- a/samples/treegrid/02_dynamic_loading.html
+++ b/samples/treegrid/02_dynamic_loading.html
@@ -30,7 +30,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">);
diff --git a/samples/treegrid/02_dynamic_loading_connector.php b/samples/treegrid/02_dynamic_loading_connector.php
index 9cecc77..0c0c8ae 100644
--- a/samples/treegrid/02_dynamic_loading_connector.php
+++ b/samples/treegrid/02_dynamic_loading_connector.php
@@ -1,10 +1,10 @@
<?php
require_once("../config.php");
- $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
- mysql_select_db($mysql_db);
+ $res= new PDO($mysql_server,$mysql_user,$mysql_pass);
+
require("../../codebase/treegrid_connector.php");
- $tree = new TreeGridConnector($res);
+ $tree = new TreeGridConnector($res, "PDO");
$tree->dynamic_loading(true);
$tree->render_table("tasks","taskId","taskName,duration,complete","","parentId");
diff --git a/samples/treegrid/03_sql_config.html b/samples/treegrid/03_sql_config.html
index a4235fe..cc7fc9b 100644
--- a/samples/treegrid/03_sql_config.html
+++ b/samples/treegrid/03_sql_config.html
@@ -30,7 +30,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">);
diff --git a/samples/treegrid/03_sql_config_connector.php b/samples/treegrid/03_sql_config_connector.php
index bfab649..f625a32 100644
--- a/samples/treegrid/03_sql_config_connector.php
+++ b/samples/treegrid/03_sql_config_connector.php
@@ -1,10 +1,10 @@
<?php
require_once("../config.php");
- $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
- mysql_select_db($mysql_db);
+ $res= new PDO($mysql_server,$mysql_user,$mysql_pass);
+
require("../../codebase/treegrid_connector.php");
- $tree = new TreeGridConnector($res);
+ $tree = new TreeGridConnector($res, "PDO");
$tree->render_sql("SELECT * from tasks WHERE complete>49","taskId","taskName,duration,complete","","parentId");
?> \ No newline at end of file
diff --git a/samples/treegrid/04_custom_styles.html b/samples/treegrid/04_custom_styles.html
index b017656..8c43c8c 100644
--- a/samples/treegrid/04_custom_styles.html
+++ b/samples/treegrid/04_custom_styles.html
@@ -30,7 +30,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;
<br />&nbsp;&nbsp;&nbsp;&nbsp;require_once(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">);
diff --git a/samples/treegrid/04_custom_styles_connector.php b/samples/treegrid/04_custom_styles_connector.php
index b10f033..d36b1e6 100644
--- a/samples/treegrid/04_custom_styles_connector.php
+++ b/samples/treegrid/04_custom_styles_connector.php
@@ -1,10 +1,10 @@
<?php
require_once("../config.php");
- $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
- mysql_select_db($mysql_db);
+ $res= new PDO($mysql_server,$mysql_user,$mysql_pass);
+
require_once("../../codebase/treegrid_connector.php");
- $tree = new TreeGridConnector($res);
+ $tree = new TreeGridConnector($res, "PDO");
function custom_format($item){
$item->set_row_color($item->get_value("complete")<75?"#AAFFFF":"#FFAAFF");
diff --git a/samples/treegrid/05_live_update.html b/samples/treegrid/05_live_update.html
index faca89a..35d7f01 100644
--- a/samples/treegrid/05_live_update.html
+++ b/samples/treegrid/05_live_update.html
@@ -38,7 +38,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;require(</span><span style="color: #DD0000">"../../codebase/treegrid_connector.php"</span><span style="color: #007700">);
diff --git a/samples/treegrid/06_treegrid_group_connector.html b/samples/treegrid/06_treegrid_group_connector.html
index 830256b..325055a 100644
--- a/samples/treegrid/06_treegrid_group_connector.html
+++ b/samples/treegrid/06_treegrid_group_connector.html
@@ -34,7 +34,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;require(</span><span style="color: #DD0000">"../../codebase/treegridgroup_connector.php"</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;
diff --git a/samples/treegrid/06_treegrid_group_connector.php b/samples/treegrid/06_treegrid_group_connector.php
index 5a70e3c..d6af98b 100644
--- a/samples/treegrid/06_treegrid_group_connector.php
+++ b/samples/treegrid/06_treegrid_group_connector.php
@@ -1,11 +1,11 @@
<?php
require_once("../config.php");
- $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
- mysql_select_db($mysql_db);
+ $res= new PDO($mysql_server,$mysql_user,$mysql_pass);
+
require_once('../../codebase/treegridgroup_connector.php');
- $treegrid = new TreeGridGroupConnector($res);
+ $treegrid = new TreeGridGroupConnector($res, "PDO");
$treegrid->render_table("products", "id", "product_name,scales,colour", "", "category");
diff --git a/samples/treegrid/07_treegrid_multitable_connector.html b/samples/treegrid/07_treegrid_multitable_connector.html
index e2538a8..6b27014 100644
--- a/samples/treegrid/07_treegrid_multitable_connector.html
+++ b/samples/treegrid/07_treegrid_multitable_connector.html
@@ -36,7 +36,7 @@ if (!window.eXcell_tree)
<div class='code'><code><span style="color: #000000">
<span style="color: #0000BB">&lt;?php
<br />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">require_once(</span><span style="color: #DD0000">"../config.php"</span><span style="color: #007700">);
-<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">$res</span><span style="color: #007700">=</span><span style="color: #0000BB"> new PDO</span><span style="color: #007700">(</span><span style="color: #0000BB">$mysql_server</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_user</span><span style="color: #007700">,</span><span style="color: #0000BB">$mysql_pass</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;</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 />&nbsp;&nbsp;&nbsp;&nbsp;require(</span><span style="color: #DD0000">"../../codebase/treegridmultitable_connector.php"</span><span style="color: #007700">);
<br />&nbsp;&nbsp;&nbsp;&nbsp;
diff --git a/samples/treegrid/07_treegrid_multitable_connector.php b/samples/treegrid/07_treegrid_multitable_connector.php
index 4ced2a2..d099f96 100644
--- a/samples/treegrid/07_treegrid_multitable_connector.php
+++ b/samples/treegrid/07_treegrid_multitable_connector.php
@@ -1,12 +1,12 @@
<?php
require_once("../config.php");
- $res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
- mysql_select_db($mysql_db);
+ $res= new PDO($mysql_server,$mysql_user,$mysql_pass);
+
require("../../codebase/treegridmultitable_connector.php");
- $treegrid = new TreeGridMultitableConnector($res);
+ $treegrid = new TreeGridMultitableConnector($res, "PDO");
$treegrid->setMaxLevel(3);
$level = $treegrid->get_level();
generated by cgit v1.1 at 2025-05-11 23:29:19 +0000