/include/classes/sqlite_3.class.php

https://bitbucket.org/webinfopro/sqlitemanager · PHP · 311 lines · 302 code · 9 blank · 0 comment · 31 complexity · 4764eead67ec0ecb1cb568bf1d85ce9e MD5 · raw file 

    

  1. <?php

    2. 

  2. if( !defined('PDO_ATTR_TIMEOUT') ) 		define('PDO_ATTR_TIMEOUT', 		PDO::ATTR_TIMEOUT);

    3. 

  3. if( !defined('PDO_FETCH_ASSOC') ) 		define('PDO_FETCH_ASSOC', 		PDO::FETCH_ASSOC);

    4. 

  4. if( !defined('PDO_FETCH_NUM') ) 		define('PDO_FETCH_NUM', 		PDO::FETCH_NUM);

    5. 

  5. if( !defined('PDO_FETCH_BOTH') ) 		define('PDO_FETCH_BOTH', 		PDO::FETCH_BOTH);

    6. 

  6. if( !defined('PDO_ATTR_PERSISTENT') ) 	define('PDO_ATTR_PERSISTENT', 	PDO::ATTR_PERSISTENT);

    7. 

  7. if( !defined('PDO_ATTR_CASE') ) 		define('PDO_ATTR_CASE', 		PDO::ATTR_CASE);

    8. 

  8. if( !defined('PDO_CASE_NATURAL') ) 		define('PDO_CASE_NATURAL', 		PDO::CASE_NATURAL);

    9. 

  9. if( !defined('PDO_ATTR_AUTOCOMMIT') ) 	define('PDO_ATTR_AUTOCOMMIT', 	PDO::ATTR_AUTOCOMMIT);

    10. 

  10. if( !defined('PDO_ATTR_ERRMODE') ) 		define('PDO_ATTR_ERRMODE', 		PDO::ATTR_ERRMODE);

    11. 

  11. if( !defined('PDO_ERRMODE_EXCEPTION') ) define('PDO_ERRMODE_EXCEPTION', PDO::ERRMODE_EXCEPTION);

    12. 

  12. if( !defined('PDO_ERRMODE_SILENT') ) 	define('PDO_ERRMODE_SILENT', 	PDO::ERRMODE_SILENT);

    13. 

  13. 

    14. 

  14. if( !defined('SQLITE_BOTH') ) 	define('SQLITE_BOTH', 	PDO_FETCH_BOTH);

    15. 

  15. if( !defined('SQLITE_ASSOC') ) 	define('SQLITE_ASSOC', 	PDO_FETCH_ASSOC);

    16. 

  16. if( !defined('SQLITE_NUM') ) 	define('SQLITE_NUM', 	PDO_FETCH_NUM);

    17. 

  17. 

    18. 

  18. class sqlite_3 extends sqlite {

    19. 

  19. 

    20. 

  20. 

    21. 

  21.     function __construct($dbPath) {

    22. 

  22.      	$this->dbVersion = 3;

    23. 

  23.     	if($dbPath == ':memory:') {

    24. 

  24.     		$this->readOnly = false;

    25. 

  25.     	} else {

    26. 

  26.     		$this->readOnly = !is_writable($dbPath);

    27. 

  27.     	}

    28. 

  28.     	parent::__construct($dbPath);

    29. 

  29.     	if(class_exists('PDO') && $this->connect($dbPath)) {

    30. 

  30.     		return $this->connId;

    31. 

  31.     	} else {

    32. 

  32.     		$this->getError();

    33. 

  33.     		return false;

    34. 

  34.     	}

    35. 

  35.     }

    36. 

  36. 

    37. 

  37.     function connect($dbPath) {

    38. 

  38. 		try {

    39. 

  39. 			$user = '';

    40. 

  40. 			$password = '';

    41. 

  41. 			$arrayAttrib = array();

    42. 

  42. 			if($dbPath == ':memory:') $arrayAttrib[PDO_ATTR_PERSISTENT] = true;

    43. 

  43. 			$this->connId = new PDO('sqlite:'.$dbPath, $user, $password, $arrayAttrib);

    44. 

  44. 

    45. 

  45. 			$this->connId->setAttribute(PDO_ATTR_CASE, PDO_CASE_NATURAL);

    46. 

  46. 			$this->connId->query("PRAGMA count_changes=1;");

    47. 

  47. 		} catch (PDOException $e) {

    48. 

  48. 			$this->error = true;

    49. 

  49. 			$this->errorMessage = $e->getMessage();

    50. 

  50. 			return false;

    51. 

  51. 		}

    52. 

  52. 		if(DEBUG) {

    53. 

  53. 			$this->connId->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_EXCEPTION);

    54. 

  54. 		} else {

    55. 

  55. 			$this->connId->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_SILENT);

    56. 

  56. 		}

    57. 

  57.     	return $this->connId;

    58. 

  58.     }

    59. 

  59. 

    60. 

  60.     function getError($errorCode = null) {

    61. 

  61. 		if(is_resource($this->resId)) {

    62. 

  62. 			$errorInfo = $this->resId->errorInfo();

    63. 

  63. 		} else {

    64. 

  64. 			$errorInfo = $this->connId->errorInfo();

    65. 

  65. 		}

    66. 

  66. 		if(is_array($errorInfo) && isset($errorInfo[2])) {

    67. 

  67. 			$this->error = true;

    68. 

  68. 			$this->errorMessage = $errorInfo[2];

    69. 

  69. 		} else {

    70. 

  70. 			$this->errorMessage = 'not an error';

    71. 

  71. 		}

    72. 

  72.     	return $this->errorMessage;

    73. 

  73.     }

    74. 

  74. 

    75. 

  75.     function getErrorMessage() {

    76. 

  76.     	return $this->errorMessage;

    77. 

  77.     }

    78. 

  78. 

    79. 

  79.     function escape($string) {

    80. 

  80. 		if(function_exists('sqlite_escape_string')) {

    81. 

  81. 			$res = sqlite_escape_string($string);

    82. 

  82. 		} else {

    83. 

  83. 			$res = str_replace("'", "''", $string);

    84. 

  84. 		}

    85. 

  85. 		return $res;

    86. 

  86.     }

    87. 

  87. 

    88. 

  88.     function query($sqlString, $buffered = true, $assign = true) {

    89. 

  89.     	try {

    90. 

  90.     		if($assign && is_object($this->resId)) $this->resId->closeCursor();

    91. 

  91. 			if(substr(trim($sqlString), -1) != ';') $sqlString .= ';';

    92. 

  92. 	    	if(DEBUG) $resId = $this->connId->query($sqlString);

    93. 

  93. 	    	else $resId = @$this->connId->query($sqlString);

    94. 

  94. 	    	if($assign) $this->resId = $resId;

    95. 

  95.     	} catch(PDOException $e) {

    96. 

  96. 			$this->error = true;

    97. 

  97. 			$this->errorMessage = $e->getMessage();

    98. 

  98. 			return false;

    99. 

  99.     	}

    100. 

  100.     	$tempErrorInfo = $this->connId->errorInfo();

    101. 

  101.     	if(is_array($tempErrorInfo) && isset($tempErrorInfo[0]) && ($tempErrorInfo[0] != '00000')) {

    102. 

  102. 			$this->error = true;

    103. 

  103. 			$this->errorMessage = $tempErrorInfo[2];

    104. 

  104. 			return false;

    105. 

  105.     	}

    106. 

  106.     	return $resId;

    107. 

  107.     }

    108. 

  108. 

    109. 

  109.     function array_query($sqlString, $result_type=SQLITE_BOTH, $decode_binary=true) {

    110. 

  110.     	try {

    111. 

  111. 			$result_type = $this->convertResultType($result_type);

    112. 

  112. 			$q = $this->query($sqlString);

    113. 

  113. 			$rows = $q->fetchAll($result_type);

    114. 

  114.     	} catch(PDOException $e) {

    115. 

  115. 			$this->error = true;

    116. 

  116. 			$this->errorMessage = $e->getMessage();

    117. 

  117. 			return false;

    118. 

  118.     	}

    119. 

  119. 		return $rows;

    120. 

  120.     }

    121. 

  121. 

    122. 

  122.     function num_rows($resId = null) {

    123. 

  123.     	try {

    124. 

  124. 	    	if($resId == null) $resId = $this->resId;

    125. 

  125. 	    	if(DEBUG) $out = $resId->rowCount();

    126. 

  126. 	    	else $out =  @$resId->rowCount();

    127. 

  127.     	} catch(PDOException $e) {

    128. 

  128. 			$this->error = true;

    129. 

  129. 			$this->errorMessage = $e->getMessage();

    130. 

  130. 			return false;

    131. 

  131.     	}

    132. 

  132.     	return $out;

    133. 

  133.     }

    134. 

  134. 

    135. 

  135.     function fetch_single($resId=null, $result_type=SQLITE_BOTH) {

    136. 

  136.     	try {

    137. 

  137. 			$result_type = $this->convertResultType($result_type);

    138. 

  138. 	    	if($resId == null) $resId = $this->resId;

    139. 

  139. 	    	if(DEBUG) $out =  $resId->fetchColumn();

    140. 

  140. 	    	else $out =  @$resId->fetchColumn();

    141. 

  141.     	} catch(PDOException $e) {

    142. 

  142. 			$this->error = true;

    143. 

  143. 			$this->errorMessage = $e->getMessage();

    144. 

  144. 			return false;

    145. 

  145.     	}

    146. 

  146.     	return $out;

    147. 

  147.     }

    148. 

  148. 

    149. 

  149.     function fetch_array($resId=null, $result_type=SQLITE_BOTH, $decode_binary=true) {

    150. 

  150. 		try {

    151. 

  151. 			$result_type = $this->convertResultType($result_type);

    152. 

  152. 	    	if($resId == null) $resId = $this->resId;

    153. 

  153. 	    	if(DEBUG) $out =  $resId->fetch($result_type);

    154. 

  154. 	    	else $out =  @$resId->fetch($result_type);

    155. 

  155.     	} catch(PDOException $e) {

    156. 

  156. 			$this->error = true;

    157. 

  157. 			$this->errorMessage = $e->getMessage();

    158. 

  158. 			return false;

    159. 

  159.     	}

    160. 

  160.     	return $out;

    161. 

  161.     }

    162. 

  162. 

    163. 

  163.     function last_insert_id() {

    164. 

  164. 		try {

    165. 

  165. 	    	if(DEBUG) $out = $this->connId->lastInsertId();

    166. 

  166. 	    	else $out = @$this->connId->lastInsertId();

    167. 

  167.     	} catch(PDOException $e) {

    168. 

  168. 			$this->error = true;

    169. 

  169. 			$this->errorMessage = $e->getMessage();

    170. 

  170. 			return false;

    171. 

  171.     	}

    172. 

  172.     	return $out;

    173. 

  173.     }

    174. 

  174. 

    175. 

  175.     function changes($resId = null) {

    176. 

  176.     	try {

    177. 

  177. 			if($resId == null) $resId = $this->resId;

    178. 

  178.     		if(is_object($resId)) $out = $this->num_rows($resId);

    179. 

  179.     		else $out = 0;

    180. 

  180.     	} catch(PDOException $e) {

    181. 

  181. 			$this->error = true;

    182. 

  182. 			$this->errorMessage = $e->getMessage();

    183. 

  183. 			return false;

    184. 

  184.     	}

    185. 

  185.     	return $out;

    186. 

  186.     }

    187. 

  187. 

    188. 

  188.     function num_fields($resId = null) {

    189. 

  189.     	try {

    190. 

  190. 	    	if($resId == null) $resId = $this->resId;

    191. 

  191. 	    	if(DEBUG) $out =  $resId->columnCount();

    192. 

  192. 	    	else $out =  @$resId->columnCount();

    193. 

  193.     	} catch(PDOException $e) {

    194. 

  194. 			$this->error = true;

    195. 

  195. 			$this->errorMessage = $e->getMessage();

    196. 

  196. 			return false;

    197. 

  197.     	}

    198. 

  198.     	return $out;

    199. 

  199.     }

    200. 

  200. 

    201. 

  201.     function field_name($resId = null, $index) {

    202. 

  202. 		try {

    203. 

  203. 	    	if($resId == null) $resId = $this->resId;

    204. 

  204. 	    	if(DEBUG) $tempColInfo = $resId->getColumnMeta($index);

    205. 

  205. 	    	else $tempColInfo = @$resId->getColumnMeta($index);

    206. 

  206.     	} catch(PDOException $e) {

    207. 

  207. 			$this->error = true;

    208. 

  208. 			$this->errorMessage = $e->getMessage();

    209. 

  209. 			return false;

    210. 

  210.     	}

    211. 

  211. 		return $tempColInfo["name"];

    212. 

  212.     }

    213. 

  213. 

    214. 

  214. 	function create_function($function_name, $callback, $num_arg=null) {

    215. 

  215. 		try {

    216. 

  216. 			if(method_exists($this->connId, 'sqliteCreateFunction')) {

    217. 

  217. 				if(DEBUG) return $this->connId->sqliteCreateFunction($function_name, $callback, $num_arg);

    218. 

  218. 				else return @$this->connId->sqliteCreateFunction($function_name, $callback, $num_arg);

    219. 

  219. 			} else {

    220. 

  220. 				return false;

    221. 

  221. 			}

    222. 

  222.     	} catch(PDOException $e) {

    223. 

  223. 			$this->error = true;

    224. 

  224. 			$this->errorMessage = $e->getMessage();

    225. 

  225. 			return false;

    226. 

  226.     	}

    227. 

  227. 	}

    228. 

  228. 

    229. 

  229. 	function create_aggregate($function_name, $step_func, $finalize_func, $num_args=null) {

    230. 

  230. 		if(method_exists($this->connId, 'sqliteCreateAggregate')) {

    231. 

  231. 			try {

    232. 

  232. 				if(DEBUG) return $this->connId->sqliteCreateAggregate($function_name, $step_func, $finalize_func, $num_args);

    233. 

  233. 				else return @$this->connId->sqliteCreateAggregate($function_name, $step_func, $finalize_func, $num_args);

    234. 

  234. 	    	} catch(PDOException $e) {

    235. 

  235. 				$this->error = true;

    236. 

  236. 				$this->errorMessage = $e->getMessage();

    237. 

  237. 				return false;

    238. 

  238. 	    	}

    239. 

  239. 		} else {

    240. 

  240. 			return false;

    241. 

  241. 		}

    242. 

  242. 	}

    243. 

  243. 

    244. 

  244.     function sqlite_version() {

    245. 

  245. 		try {

    246. 

  246. 	    	$query = "SELECT sqlite_version();";

    247. 

  247. 	    	$res = $this->query($query, true, false);

    248. 

  248. 	    	$Result = $this->fetch_single($res, SQLITE_NUM);

    249. 

  249. 	    	if($Result) return $Result;

    250. 

  250. 	    	else return false;

    251. 

  251.     	} catch(PDOException $e) {

    252. 

  252. 			$this->error = true;

    253. 

  253. 			$this->errorMessage = $e->getMessage();

    254. 

  254. 			return false;

    255. 

  255.     	}

    256. 

  256.     }

    257. 

  257. 

    258. 

  258.     function close() {

    259. 

  259.     	// set obj to null

    260. 

  260.     }

    261. 

  261. 

    262. 

  262. 	function sqlitem_busy_timeout($milliseconds=0) {

    263. 

  263. 		try {

    264. 

  264. 			$this->connId->setAttribute(PDO_ATTR_TIMEOUT, $milliseconds);

    265. 

  265. 			return true;

    266. 

  266.     	} catch(PDOException $e) {

    267. 

  267. 			$this->error = true;

    268. 

  268. 			$this->errorMessage = $e->getMessage();

    269. 

  269. 			return false;

    270. 

  270.     	}

    271. 

  271. 	}

    272. 

  272. 

    273. 

  273. 	function convertResultType($type) {

    274. 

  274. 		$fetch_style = PDO_FETCH_BOTH;

    275. 

  275. 		if($type == SQLITE_ASSOC) 		$fetch_style = PDO_FETCH_ASSOC;

    276. 

  276. 		elseif($type == SQLITE_NUM) 	$fetch_style = PDO_FETCH_NUM;

    277. 

  277. 		elseif($type == SQLITE_BOTH)  	$fetch_style = PDO_FETCH_BOTH;

    278. 

  278. 		return 	$fetch_style;

    279. 

  279. 	}

    280. 

  280. 

    281. 

  281. 	function beginTransaction() {

    282. 

  282. 		try {

    283. 

  283. 			$this->connId->beginTransaction();

    284. 

  284.     	} catch(PDOException $e) {

    285. 

  285. 			$this->error = true;

    286. 

  286. 			$this->errorMessage = $e->getMessage();

    287. 

  287. 			return false;

    288. 

  288.     	}

    289. 

  289. 	}

    290. 

  290. 

    291. 

  291. 	function commitTransaction() {

    292. 

  292. 		try {

    293. 

  293. 			$this->connId->commit();

    294. 

  294.     	} catch(PDOException $e) {

    295. 

  295. 			$this->error = true;

    296. 

  296. 			$this->errorMessage = $e->getMessage();

    297. 

  297. 			return false;

    298. 

  298.     	}

    299. 

  299. 	}

    300. 

  300. 

    301. 

  301. 	function rollBackTransaction() {

    302. 

  302. 		try {

    303. 

  303. 			$this->connId->rollBack();

    304. 

  304.     	} catch(PDOException $e) {

    305. 

  305. 			$this->error = true;

    306. 

  306. 			$this->errorMessage = $e->getMessage();

    307. 

  307. 			return false;

    308. 

  308.     	}

    309. 

  309. 	}

    310. 

  310. }

    311. 

  311. ?>
    312.