Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
LibTest.php	3.37 KB	-rw-r--r--	2023-01-22 09:53
benchmark.php	2.41 KB	-rw-r--r--	2023-01-22 09:53
pdo.php	2.4 KB	-rw-r--r--	2023-01-22 09:53
test-active-record.php	5.23 KB	-rw-r--r--	2023-01-22 09:53
test-active-recs2.php	2.12 KB	-rw-r--r--	2023-01-22 09:53
test-active-relations.php	3.67 KB	-rw-r--r--	2023-01-22 09:53
test-active-relationsx.php	25.16 KB	-rw-r--r--	2023-01-22 09:53
test-datadict.php	7.84 KB	-rw-r--r--	2023-01-22 09:53
test-perf.php	1.58 KB	-rw-r--r--	2023-01-22 09:53
test-pgblob.php	2.69 KB	-rw-r--r--	2023-01-22 09:53
test-php5.php	2.91 KB	-rw-r--r--	2023-01-22 09:53
test-xmlschema.php	1.96 KB	-rw-r--r--	2023-01-22 09:53
test.php	54.87 KB	-rw-r--r--	2023-01-22 09:53
test2.php	1.26 KB	-rw-r--r--	2023-01-22 09:53
test3.php	1.3 KB	-rw-r--r--	2023-01-22 09:53
test4.php	4.84 KB	-rw-r--r--	2023-01-22 09:53
test5.php	1.7 KB	-rw-r--r--	2023-01-22 09:53
test_mssqlnative.php	5.33 KB	-rw-r--r--	2023-01-22 09:53
test_rs_array.php	1.37 KB	-rw-r--r--	2023-01-22 09:53
testcache.php	1.14 KB	-rw-r--r--	2023-01-22 09:53
testdatabases.inc.php	17.55 KB	-rw-r--r--	2023-01-22 09:53
testgenid.php	1.41 KB	-rw-r--r--	2023-01-22 09:53
testmssql.php	2.3 KB	-rw-r--r--	2023-01-22 09:53
testoci8.php	2.67 KB	-rw-r--r--	2023-01-22 09:53
testoci8cursor.php	3.21 KB	-rw-r--r--	2023-01-22 09:53
testpaging.php	2.62 KB	-rw-r--r--	2023-01-22 09:53
testpear.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
testsessions.php	2.83 KB	-rw-r--r--	2023-01-22 09:53
time.php	1.21 KB	-rw-r--r--	2023-01-22 09:53
tmssql.php	2.54 KB	-rw-r--r--	2023-01-22 09:53
xmlschema-mssql.xml	832 B	-rw-r--r--	2023-01-22 09:53
xmlschema.xml	961 B	-rw-r--r--	2023-01-22 09:53

Rename

<?php
/**
 * ADOdb tests.
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * @package ADOdb
 * @link https://adodb.org Project's web site and documentation
 * @link https://github.com/ADOdb/ADOdb Source code and issue tracker
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
 */

error_reporting(E_ALL);

$path = dirname(__FILE__);

include("$path/../adodb-exceptions.inc.php");
include("$path/../adodb.inc.php");

echo "<h3>PHP ".PHP_VERSION."</h3>\n";
try {

$dbt = 'oci8po';

try {
switch($dbt) {
case 'oci8po':
	$db = NewADOConnection("oci8po");

$db->Connect('localhost','scott','natsoft','sherkhan');
	break;
default:
case 'mysql':
	$db = NewADOConnection("mysql");
	$db->Connect('localhost','root','','northwind');
	break;

case 'mysqli':
	$db = NewADOConnection("mysqli://root:@localhost/northwind");
	//$db->Connect('localhost','root','','test');
	break;
}
} catch (exception $e){
	echo "Connect Failed";
	adodb_pr($e);
	die();
}

$db->debug=1;

$cnt = $db->GetOne("select count(*) from adoxyz where ?<id and id<?",array(10,20));
$stmt = $db->Prepare("select * from adoxyz where ?<id and id<?");
if (!$stmt) echo $db->ErrorMsg(),"\n";
$rs = $db->Execute($stmt,array(10,20));

echo  "<hr /> Foreach Iterator Test (rand=".rand().")<hr />";
$i = 0;
foreach($rs as $v) {
	$i += 1;
	echo "rec $i: "; $s1 = adodb_pr($v,true); $s2 = adodb_pr($rs->fields,true);
	if ($s1 != $s2 && !empty($v)) {adodb_pr($s1); adodb_pr($s2);}
	else echo "passed<br>";
	flush();
}

$rs = new ADORecordSet_empty();
foreach($rs as $v) {
	echo "<p>empty ";var_dump($v);
}

if ($i != $cnt) die("actual cnt is $i, cnt should be $cnt\n");
else echo "Count $i is correct<br>";

$rs = $db->Execute("select bad from badder");

} catch (exception $e) {
	adodb_pr($e);
	echo "<h3>adodb_backtrace:</h3>\n";
	$e = adodb_backtrace($e->gettrace());
}

$rs = $db->Execute("select distinct id, firstname,lastname from adoxyz order by id");
echo "Result=\n",$rs,"</p>";

echo "<h3>Active Record</h3>";

include_once("../adodb-active-record.inc.php");
	ADOdb_Active_Record::SetDatabaseAdapter($db);

try {
	class City extends ADOdb_Active_Record{};
	$a = new City();

} catch(exception $e){
	echo $e->getMessage();
}

try {

$a = new City();

echo "<p>Successfully created City()<br>";
	#var_dump($a->GetPrimaryKeys());
	$a->city = 'Kuala Lumpur';
	$a->Save();
	$a->Update();
	#$a->SetPrimaryKeys(array('city'));
	$a->country = "M'sia";
	$a->save();
	$a->Delete();
} catch(exception $e){
	echo $e->getMessage();
}

//include_once("test-active-record.php");