[add] Adapter for SQLite3 connection type

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