Gecko [ www.vortexaion.com ]

Name	Size	Permission	Date
benchmark.php	2.03 KB	-rw-rw-rw-	2012-01-19 07:44
client.php	3.98 KB	-rw-rw-rw-	2009-06-25 10:26
pdo.php	1.82 KB	-rw-rw-rw-	2009-06-25 10:26
test-active-record.php	4.63 KB	-rw-rw-rw-	2009-11-10 10:34
test-active-recs2.php	1.41 KB	-rw-rw-rw-	2010-05-06 12:24
test-active-relations.php	2.99 KB	-rw-rw-rw-	2009-06-25 10:26
test-active-relationsx.php	24.48 KB	-rw-rw-rw-	2009-06-25 10:26
test-datadict.php	7.49 KB	-rw-rw-rw-	2012-01-19 07:44
test-perf.php	959 B	-rw-rw-rw-	2009-06-25 10:26
test-pgblob.php	1.99 KB	-rw-rw-rw-	2009-06-25 10:26
test-php5.php	2.48 KB	-rw-rw-rw-	2012-01-19 07:44
test-xmlschema.php	1.28 KB	-rw-rw-rw-	2009-06-25 10:26
test.php	54.95 KB	-rw-rw-rw-	2012-09-03 08:14
test2.php	598 B	-rw-rw-rw-	2009-06-25 10:26
test3.php	893 B	-rw-rw-rw-	2012-01-19 07:44
test4.php	4.56 KB	-rw-rw-rw-	2012-01-19 07:44
test5.php	1.35 KB	-rw-rw-rw-	2012-01-19 07:44
test_rs_array.php	679 B	-rw-rw-rw-	2009-06-25 10:26
testcache.php	803 B	-rw-rw-rw-	2012-01-19 07:44
testdatabases.inc.php	17.82 KB	-rw-rw-rw-	2012-01-19 07:44
testgenid.php	766 B	-rw-rw-rw-	2009-06-25 10:26
testmssql.php	1.98 KB	-rw-rw-rw-	2012-01-19 07:44
testoci8.php	2.32 KB	-rw-rw-rw-	2012-01-19 07:44
testoci8cursor.php	2.89 KB	-rw-rw-rw-	2012-01-19 07:44
testpaging.php	2.25 KB	-rw-rw-rw-	2012-01-19 07:44
testpear.php	870 B	-rw-rw-rw-	2012-01-19 07:44
testsessions.php	2.48 KB	-rw-rw-rw-	2012-01-19 07:44
time.php	520 B	-rw-rw-rw-	2009-06-25 10:26
tmssql.php	1.92 KB	-rw-rw-rw-	2009-06-25 10:26
xmlschema-mssql.xml	832 B	-rw-rw-rw-	2009-06-25 10:26
xmlschema.xml	961 B	-rw-rw-rw-	2009-06-25 10:26

Rename

<html>
<body bgcolor=white>
<?php
/** 
 * V4.50 6 July 2004  (c) 2001-2002 John Lim (jlim#natsoft.com). All rights reserved.
 * 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. 
 * 
 * set tabs to 8
 */
 
 // documentation on usage is at http://php.weblogs.com/adodb_csv
 
 echo PHP_VERSION,'<br>';
 var_dump(parse_url('odbc_mssql://userserver/'));
 die();
 
include('../adodb.inc.php');
include('../tohtml.inc.php');

function send2server($url,$sql)
 {
	$url .= '?sql='.urlencode($sql);
	print "<p>$url</p>";
	$rs = csv2rs($url,$err);
	if ($err) print $err;
	return $rs;
 }
 
 function print_pre($s)
 {
 	print "<pre>";print_r($s);print "</pre>";
 }

$serverURL = 'http://localhost/php/phplens/adodb/server.php';
$testhttp = false;

$sql1 = "insertz into products (productname) values ('testprod 1')";
$sql2 = "insert into products (productname) values ('testprod 1')";
$sql3 = "insert into products (productname) values ('testprod 2')";
$sql4 = "delete from products where productid>80";
$sql5 = 'select * from products';
	
if ($testhttp) {
	print "<a href=#c>Client Driver Tests</a><p>";
	print "<h3>Test Error</h3>";
	$rs = send2server($serverURL,$sql1);
	print_pre($rs);
	print "<hr />";
	
	print "<h3>Test Insert</h3>";
	
	$rs = send2server($serverURL,$sql2);
	print_pre($rs);
	print "<hr />";
	
	print "<h3>Test Insert2</h3>";
	
	$rs = send2server($serverURL,$sql3);
	print_pre($rs);
	print "<hr />";
	
	print "<h3>Test Delete</h3>";
	
	$rs = send2server($serverURL,$sql4);
	print_pre($rs);
	print "<hr />";
	
	
	print "<h3>Test Select</h3>";
	$rs = send2server($serverURL,$sql5);
	if ($rs) rs2html($rs);
	
	print "<hr />";
}

print "<a name=c><h1>CLIENT Driver Tests</h1>";
$conn = ADONewConnection('csv');
$conn->Connect($serverURL);
$conn->debug = true;

print "<h3>Bad SQL</h3>";

$rs = $conn->Execute($sql1);

print "<h3>Insert SQL 1</h3>";
$rs = $conn->Execute($sql2);

print "<h3>Insert SQL 2</h3>";
$rs = $conn->Execute($sql3);

print "<h3>Select SQL</h3>";
$rs = $conn->Execute($sql5);
if ($rs) rs2html($rs);

print "<h3>Delete SQL</h3>";
$rs = $conn->Execute($sql4);

print "<h3>Select SQL</h3>";
$rs = $conn->Execute($sql5);
if ($rs) rs2html($rs);

/* EXPECTED RESULTS FOR HTTP TEST:

Test Insert
http://localhost/php/adodb/server.php?sql=insert+into+products+%28productname%29+values+%28%27testprod%27%29

adorecordset Object
(
	[dataProvider] => native
	[fields] => 
	[blobSize] => 64
	[canSeek] => 
	[EOF] => 1
	[emptyTimeStamp] =>  
	[emptyDate] =>  
	[debug] => 
	[timeToLive] => 0
	[bind] => 
	[_numOfRows] => -1
	[_numOfFields] => 0
	[_queryID] => 1
	[_currentRow] => -1
	[_closed] => 
	[_inited] => 
	[sql] => insert into products (productname) values ('testprod')
	[affectedrows] => 1
	[insertid] => 81
)

--------------------------------------------------------------------------------

Test Insert2
http://localhost/php/adodb/server.php?sql=insert+into+products+%28productname%29+values+%28%27testprod%27%29

--------------------------------------------------------------------------------

Test Delete
http://localhost/php/adodb/server.php?sql=delete+from+products+where+productid%3E80

adorecordset Object
(
	[dataProvider] => native
	[fields] => 
	[blobSize] => 64
	[canSeek] => 
	[EOF] => 1
	[emptyTimeStamp] =>  
	[emptyDate] =>  
	[debug] => 
	[timeToLive] => 0
	[bind] => 
	[_numOfRows] => -1
	[_numOfFields] => 0
	[_queryID] => 1
	[_currentRow] => -1
	[_closed] => 
	[_inited] => 
	[sql] => delete from products where productid>80
	[affectedrows] => 2
	[insertid] => 0
)

[more stuff deleted]
 .
 . 
 .
*/
?>