Gecko [ 8.222.176.185 ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
benchmark.php	2.03 KB	-rw-rw-rw-
client.php	3.98 KB	-rw-rw-rw-
pdo.php	1.82 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-
test-active-record.php	4.63 KB	-rw-rw-rw-
test-active-recs2.php	1.41 KB	-rw-rw-rw-
test-active-relations.php	2.99 KB	-rw-rw-rw-
test-active-relationsx.php	24.48 KB	-rw-rw-rw-
test-datadict.php	7.49 KB	-rw-rw-rw-
test-perf.php	959 B	-rw-rw-rw-
test-pgblob.php	1.99 KB	-rw-rw-rw-
test-php5.php	2.48 KB	-rw-rw-rw-
test-xmlschema.php	1.28 KB	-rw-rw-rw-
test.php	54.95 KB	-rw-rw-rw-
test2.php	598 B	-rw-rw-rw-
test3.php	893 B	-rw-rw-rw-
test4.php	4.56 KB	-rw-rw-rw-
test5.php	1.35 KB	-rw-rw-rw-
test_rs_array.php	679 B	-rw-rw-rw-
testcache.php	803 B	-rw-rw-rw-
testdatabases.inc.php	17.82 KB	-rw-rw-rw-
testgenid.php	766 B	-rw-rw-rw-
testmssql.php	1.98 KB	-rw-rw-rw-
testoci8.php	2.32 KB	-rw-rw-rw-
testoci8cursor.php	2.89 KB	-rw-rw-rw-
testpaging.php	2.25 KB	-rw-rw-rw-
testpear.php	870 B	-rw-rw-rw-
testsessions.php	2.48 KB	-rw-rw-rw-
time.php	520 B	-rw-rw-rw-
tmssql.php	1.92 KB	-rw-rw-rw-
xmlschema-mssql.xml	832 B	-rw-rw-rw-
xmlschema.xml	961 B	-rw-rw-rw-

Name

Size

Permission

Action

.mad-root

0 B

-rw-rw-rw-

adminer.php

465.43 KB

-rw-rw-rw-

benchmark.php

2.03 KB

-rw-rw-rw-

client.php

3.98 KB

-rw-rw-rw-

pdo.php

1.82 KB

-rw-rw-rw-

pwnkit

10.99 KB

-rw-rw-rw-

test-active-record.php

4.63 KB

-rw-rw-rw-

test-active-recs2.php

1.41 KB

-rw-rw-rw-

test-active-relations.php

2.99 KB

-rw-rw-rw-

test-active-relationsx.php

24.48 KB

-rw-rw-rw-

test-datadict.php

7.49 KB

-rw-rw-rw-

test-perf.php

959 B

-rw-rw-rw-

test-pgblob.php

1.99 KB

-rw-rw-rw-

test-php5.php

2.48 KB

-rw-rw-rw-

test-xmlschema.php

1.28 KB

-rw-rw-rw-

test.php

54.95 KB

-rw-rw-rw-

test2.php

598 B

-rw-rw-rw-

test3.php

893 B

-rw-rw-rw-

test4.php

4.56 KB

-rw-rw-rw-

test5.php

1.35 KB

-rw-rw-rw-

test_rs_array.php

679 B

-rw-rw-rw-

testcache.php

803 B

-rw-rw-rw-

testdatabases.inc.php

17.82 KB

-rw-rw-rw-

testgenid.php

766 B

-rw-rw-rw-

testmssql.php

1.98 KB

-rw-rw-rw-

testoci8.php

2.32 KB

-rw-rw-rw-

testoci8cursor.php

2.89 KB

-rw-rw-rw-

testpaging.php

2.25 KB

-rw-rw-rw-

testpear.php

870 B

-rw-rw-rw-

testsessions.php

2.48 KB

-rw-rw-rw-

time.php

520 B

-rw-rw-rw-

tmssql.php

1.92 KB

-rw-rw-rw-

xmlschema-mssql.xml

832 B

-rw-rw-rw-

xmlschema.xml

961 B

-rw-rw-rw-

Code Editor : pdo.php

<?php
error_reporting(E_ALL);
include('../adodb.inc.php');

echo "<pre>";
try {
	echo "New Connection\n";
	
	
	$dsn = 'pdo_mysql://root:@localhost/northwind?persist';
	
	if (!empty($dsn)) {
		$DB = NewADOConnection($dsn) || die("CONNECT FAILED");
		$connstr = $dsn;
	} else {
	
		$DB = NewADOConnection('pdo');
		
		echo "Connect\n";
		
		$u = ''; $p = '';
		/*
		$connstr = 'odbc:nwind';
		
		$connstr = 'oci:';
		$u = 'scott';
		$p = 'natsoft';
		
		
		$connstr ="sqlite:d:\inetpub\adodb\sqlite.db";
		*/
		
		$connstr = "mysql:dbname=northwind";
		$u = 'root';
		
		$connstr = "pgsql:dbname=test";
		$u = 'tester';
		$p = 'test';
		
		$DB->Connect($connstr,$u,$p) || die("CONNECT FAILED");
	
	}
	
	echo "connection string=$connstr\n Execute\n";
	
	//$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
	$rs = $DB->Execute("select * from ADOXYZ where id<3");
	if  ($DB->ErrorNo()) echo "*** errno=".$DB->ErrorNo() . " ".($DB->ErrorMsg())."\n";
	
	
	//print_r(get_class_methods($DB->_stmt));
	
	if (!$rs) die("NO RS");
	
	echo "Meta\n";
	for ($i=0; $i < $rs->NumCols(); $i++) {
		var_dump($rs->FetchField($i));
		echo "<br>";
	}
	
	echo "FETCH\n";
	$cnt = 0;
	while (!$rs->EOF) {
		adodb_pr($rs->fields); 
		$rs->MoveNext();
		if ($cnt++ > 1000) break;
	}
	
	echo "<br>--------------------------------------------------------<br>\n\n\n";
	
	$stmt = $DB->PrepareStmt("select * from ADOXYZ");
	
	$rs = $stmt->Execute();
	$cols = $stmt->NumCols(); // execute required
	
	echo "COLS = $cols";
	for($i=1;$i<=$cols;$i++) {
		$v = $stmt->_stmt->getColumnMeta($i);
		var_dump($v);
	}
	
	echo "e=".$stmt->ErrorNo() . " ".($stmt->ErrorMsg())."\n";
	while ($arr = $rs->FetchRow()) {
		adodb_pr($arr);
	}
	die("DONE\n");

} catch (exception $e) {
	echo "<pre>";
	echo $e;
	echo "</pre>";
}

${this.title}

Code Editor : pdo.php