summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--codebase/db_sqlite3.php33
-rw-r--r--samples/grid/xx_sample_sqlite3_connector.php12
2 files changed, 45 insertions, 0 deletions
diff --git a/codebase/db_sqlite3.php b/codebase/db_sqlite3.php
new file mode 100644
index 0000000..de284cf
--- /dev/null
+++ b/codebase/db_sqlite3.php
@@ -0,0 +1,33 @@
+<?php
+/*
+ @author dhtmlx.com
+ @license GPL, see license.txt
+*/
+require_once("db_common.php");
+/*! SQLite implementation of DataWrapper
+**/
+class SQLite3DBDataWrapper extends DBDataWrapper{
+
+ public function query($sql){
+ LogMaster::log($sql);
+
+ $res = $this->connection->query($sql);
+ if ($res === false)
+ throw new Exception("SQLLite - sql execution failed\n".$this->connection->lastErrorMsg());
+
+ return $res;
+ }
+
+ public function get_next($res){
+ return $res->fetchArray();
+ }
+
+ protected function get_new_id(){
+ return $this->connection->lastInsertRowID();
+ }
+
+ public function escape($data){
+ return $this->connection->escapeString($data);
+ }
+}
+?> \ No newline at end of file
diff --git a/samples/grid/xx_sample_sqlite3_connector.php b/samples/grid/xx_sample_sqlite3_connector.php
new file mode 100644
index 0000000..762dc87
--- /dev/null
+++ b/samples/grid/xx_sample_sqlite3_connector.php
@@ -0,0 +1,12 @@
+<?php
+ require_once("../config.php");
+
+ $db = new SQLite3('mysqlitedb.db');
+
+ require("../../codebase/grid_connector.php");
+ require("../../codebase/db_sqlite3.php");
+
+ $grid = new GridConnector($db,"SQLite3");
+ $grid->render_table("grid50000","item_id","item_nm,item_cd");
+
+?> \ No newline at end of file