TYPO3 CMS  TYPO3_6-2
•All Classes Namespaces Files Functions Variables Pages
adodb-sqlitepo.inc.php
Go to the documentation of this file.
1 <?php
2 /*
3 V5.19 23-Apr-2014 (c) 2000-2014 John Lim (jlim#natsoft.com). All rights reserved.
4  Released under both BSD license and Lesser GPL library license.
5  Whenever there is any discrepancy between the two licenses,
6  the BSD license will take precedence.
7 
8  Portable version of sqlite driver, to make it more similar to other database drivers.
9  The main differences are
10 
11  1. When selecting (joining) multiple tables, in assoc mode the table
12  names are included in the assoc keys in the "sqlite" driver.
13 
14  In "sqlitepo" driver, the table names are stripped from the returned column names.
15  When this results in a conflict, the first field get preference.
16 
17  Contributed by Herman Kuiper herman#ozuzo.net
18 */
19 
20 if (!defined('ADODB_DIR')) die();
21 
22 include_once(ADODB_DIR.'/drivers/adodb-sqlite.inc.php');
23 
24 class ADODB_sqlitepo extends ADODB_sqlite {
25  var $databaseType = 'sqlitepo';
26 
27  function ADODB_sqlitepo()
28  {
29  $this->ADODB_sqlite();
30  }
31 }
32 
33 /*--------------------------------------------------------------------------------------
34  Class Name: Recordset
35 --------------------------------------------------------------------------------------*/
36 
37 class ADORecordset_sqlitepo extends ADORecordset_sqlite {
38 
39  var $databaseType = 'sqlitepo';
40 
41  function ADORecordset_sqlitepo($queryID,$mode=false)
42  {
43  $this->ADORecordset_sqlite($queryID,$mode);
44  }
45 
46  // Modified to strip table names from returned fields
47  function _fetch($ignore_fields=false)
48  {
49  $this->fields = array();
50  $fields = @sqlite_fetch_array($this->_queryID,$this->fetchMode);
51  if(is_array($fields))
52  foreach($fields as $n => $v)
53  {
54  if(($p = strpos($n, ".")) !== false)
55  $n = substr($n, $p+1);
56  $this->fields[$n] = $v;
57  }
58 
59  return !empty($this->fields);
60  }
61 }
ADORecordset_sqlitepo
Definition: adodb-sqlitepo.inc.php:37
ADODB_sqlite\ADODB_sqlite
ADODB_sqlite()
Definition: adodb-sqlite.inc.php:34
die
die
Definition: index.php:6
ADODB_sqlitepo\$databaseType
$databaseType
Definition: adodb-sqlitepo.inc.php:25
ADORecordset_sqlite
Definition: adodb-sqlite.inc.php:317
ADODB_sqlite
Definition: adodb-sqlite.inc.php:21
ADODB_sqlitepo
Definition: adodb-sqlitepo.inc.php:24
ADORecordset_sqlitepo\ADORecordset_sqlitepo
ADORecordset_sqlitepo($queryID, $mode=false)
Definition: adodb-sqlitepo.inc.php:41
ADODB_sqlitepo\ADODB_sqlitepo
ADODB_sqlitepo()
Definition: adodb-sqlitepo.inc.php:27
ADORecordset_sqlitepo\_fetch
_fetch($ignore_fields=false)
Definition: adodb-sqlitepo.inc.php:47