adodb/tests/testdatabases.inc.php

71 	$db = &ADONewConnection('postgres');  variable
72 	print "<h1>Connecting $db->databaseType...</h1>";
73 	if ($db->Connect("localhost","tester","test","test")) {
74 		testdb($db,"create table ADOXYZ (id integer, firstname char(24), lastname varchar,created date)");
76 …greSQL requires a database called test on server, user tester, password test.<BR>".$db->ErrorMsg();
81 	$db = &ADONewConnection('odbc');  variable
82 	$db->hasTransactions = false;
83 	print "<h1>Connecting $db->databaseType...</h1>";
85 	if ($db->PConnect('Postgresql')) {
86 		$db->hasTransactions = true;
87 		testdb($db,
89 …greSQL requires a database called test on server, user tester, password test.<BR>".$db->ErrorMsg();
94 	$db = &ADONewConnection('firebird');  variable
95 	print "<h1>Connecting $db->databaseType...</h1>";
96 …if ($db->PConnect("localhost:d:\\firebird\\151\\examples\\EMPLOYEE.fdb", "sysdba", "masterkey", ""…
97 …testdb($db,"create table ADOXYZ (id integer, firstname char(24), lastname char(24),price numeric(1…
98 	 else print "ERROR: Interbase test requires a database called employee.gdb".'<BR>'.$db->ErrorMsg();
106 	$db = ADONewConnection($dsn);  variable
112 	if ($db && $db->PConnect("d:\\inetpub\\adodb\\sqlite.db", "", "", "")) {
113 		print "<h1>Connecting $db->databaseType...</h1>";
114 …testdb($db,"create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)");
123 	$db = &ADONewConnection('pdo');  variable
124 	print "<h1>Connecting $db->databaseType...</h1>";
125 	$db->Connect($connstr,$u,$p) || die("CONNECT FAILED");
126 	testdb($db,
133 	$db = &ADONewConnection('pdo');  variable
134 	print "<h1>Connecting $db->databaseType...</h1>";
135 	$db->Connect($connstr,$u,$p) || die("CONNECT FAILED");
137 	testdb($db,
144 	$db = &ADONewConnection('pdo');  variable
145 	print "<h1>Connecting $db->databaseType...</h1>";
146 	$db->Connect($connstr,$u,$p) || die("CONNECT FAILED");
148 	testdb($db,
155 	$db = &ADONewConnection('pdo');  variable
156 	$db->hasTransactions = false;
157 	print "<h1>Connecting $db->databaseType...</h1>";
158 	$db->Connect($connstr,$u,$p) || die("CONNECT FAILED");
159 	testdb($db,
166 	$db = &ADONewConnection('pdo');  variable
167 	$db->hasTransactions = false;
168 	print "<h1>Connecting $db->databaseType...</h1>";
169 	$db->Connect($connstr,$u,$p) || die("CONNECT FAILED");
170 	testdb($db,
177 	$db = &ADONewConnection('pdo');  variable
179 	print "<h1>Connecting $db->databaseType...</h1>";
180 	$db->Connect($connstr,$u,$p) || die("CONNECT FAILED");
181 	testdb($db,
187 	$db = &ADONewConnection('access');  variable
188 	print "<h1>Connecting $db->databaseType...</h1>";
194 	if ($db->PConnect($dsn, "", "", ""))
195 …testdb($db,"create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)");
202 	$db = &ADONewConnection("ado_access");  variable
203 	print "<h1>Connecting $db->databaseType...</h1>";
210 	if ($db->PConnect($myDSN, "", "", "")) {
211 		print "ADO version=".$db->_connectionID->version."<br>";
212 …testdb($db,"create table ADOXYZ (id int, firstname char(24), lastname char(24),created datetime)");
213 	} else print "ERROR: Access test requires a Access database $access".'<BR>'.$db->ErrorMsg();
218 	$db = &ADONewConnection('vfp');  variable
219 	print "<h1>Connecting $db->databaseType...</h1>";flush();
221 	if ( $db->PConnect("vfp-adoxyz")) {
222 …testdb($db,"create table d:\\inetpub\\adodb\\ADOXYZ (id int, firstname char(24), lastname char(24)…
226 	$db = &ADONewConnection('odbtp');  variable
228 …if ( $db->PConnect('localhost','DRIVER={Microsoft Visual FoxPro Driver};SOURCETYPE=DBF;SOURCEDB=d:…
229 	print "<h1>Connecting $db->databaseType...</h1>";flush();
230 …testdb($db,"create table d:\\inetpub\\adodb\\ADOXYZ (id int, firstname char(24), lastname char(24)…
243 	$db = &ADONewConnection("mysqlt://$user:$password@$server/$database?persist");  variable
244 	print "<h1>Connecting $db->databaseType...</h1>";
246 	if (true || $db->PConnect($server, "root", "", "northwind")) {
249 		testdb($db,
251 … a MySQL server on localhost, userid='admin', password='', database='test'".'<BR>'.$db->ErrorMsg();
257 	$db = &ADONewConnection('mysqli');  variable
258 	print "<h1>Connecting $db->databaseType...</h1>";
261 	if ($db->PConnect($server, "root", "", "northwind")) {
263 		testdb($db,
265 … a MySQL server on localhost, userid='admin', password='', database='test'".'<BR>'.$db->ErrorMsg();
272 	$db = &ADONewConnection('odbc');  variable
273 	$db->hasTransactions = false;
274 	print "<h1>Connecting $db->databaseType...</h1>";
277 	if ($db->PConnect('mysql', "root", ""))
278 		testdb($db,
280 … a MySQL server on localhost, userid='admin', password='', database='test'".'<BR>'.$db->ErrorMsg();
284 	$db = &ADONewConnection('proxy');  variable
285 	print "<h1>Connecting $db->databaseType...</h1>";
288 	if ($db->PConnect('http://localhost/php/phplens/adodb/server.php'))