You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
58 lines
1.8 KiB
58 lines
1.8 KiB
<?php
|
|
/*
|
|
@version v5.20.9 21-Dec-2016
|
|
@copyright (c) 2000-2013 John Lim (jlim#natsoft.com). All rights reserved.
|
|
@copyright (c) 2014 Damien Regad, Mark Newnham and the ADOdb community
|
|
Released under both BSD license and Lesser GPL library license.
|
|
Whenever there is any discrepancy between the two licenses,
|
|
the BSD license will take precedence.
|
|
|
|
Portable version of sqlite driver, to make it more similar to other database drivers.
|
|
The main differences are
|
|
|
|
1. When selecting (joining) multiple tables, in assoc mode the table
|
|
names are included in the assoc keys in the "sqlite" driver.
|
|
|
|
In "sqlitepo" driver, the table names are stripped from the returned column names.
|
|
When this results in a conflict, the first field get preference.
|
|
|
|
Contributed by Herman Kuiper herman#ozuzo.net
|
|
*/
|
|
|
|
if (!defined('ADODB_DIR')) die();
|
|
|
|
include_once(ADODB_DIR.'/drivers/adodb-sqlite.inc.php');
|
|
|
|
class ADODB_sqlitepo extends ADODB_sqlite {
|
|
var $databaseType = 'sqlitepo';
|
|
}
|
|
|
|
/*--------------------------------------------------------------------------------------
|
|
Class Name: Recordset
|
|
--------------------------------------------------------------------------------------*/
|
|
|
|
class ADORecordset_sqlitepo extends ADORecordset_sqlite {
|
|
|
|
var $databaseType = 'sqlitepo';
|
|
|
|
function __construct($queryID,$mode=false)
|
|
{
|
|
parent::__construct($queryID,$mode);
|
|
}
|
|
|
|
// Modified to strip table names from returned fields
|
|
function _fetch($ignore_fields=false)
|
|
{
|
|
$this->fields = array();
|
|
$fields = @sqlite_fetch_array($this->_queryID,$this->fetchMode);
|
|
if(is_array($fields))
|
|
foreach($fields as $n => $v)
|
|
{
|
|
if(($p = strpos($n, ".")) !== false)
|
|
$n = substr($n, $p+1);
|
|
$this->fields[$n] = $v;
|
|
}
|
|
|
|
return !empty($this->fields);
|
|
}
|
|
}
|
|
|