typo3 » sysext » adodb » adodb » tests

testdatabases.inc.php File Reference

Go to the source code of this file.

Variables

else print ERROR
else print user tester
$db hasTransactions = false
else print ERROR
else print user tester
else print ERROR
 $dsn = "sqlite://$path/"
 $db = ADONewConnection($dsn)
else print ERROR
$db hasTransactions = false
$db hasTransactions = false
print< h1 > Connecting $db
databaseType</h1 > 		$access = 'd:\inetpub\wwwroot\php\NWIND.MDB'
 $dsn = "nwind"
 $dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=$access;Uid=Admin;Pwd=;"
else print ERROR
else print Access driver
print< h1 > Connecting $db
databaseType</h1 > 		$access = 'd:\inetpub\wwwroot\php\NWIND.MDB'
 $myDSN
 $_GET ['nolog'] = 1
else print ERROR
else print ERROR
else print VFP driver
 $db = &ADONewConnection('odbtp')
else print ERROR
else print VFP driver
else $server = "mangrove"
 $user = 'root'
 $password = ''
 $database = 'northwind'
 $db = &ADONewConnection("mysqlt://$user:$password@$server/$database?persist")
else print ERROR
else print userid = 'admin'
else print password = ''
else print database
else print userid = 'admin'
else print password = ''
else print database
else print userid = 'admin'
else print password = ''
else print database
else print userid = 'admin'
else print password = ''
else print database
else print ERROR
else print ERROR
print< h1 > Connecting $db
databaseType</h1 > 		$dsn = "db2_sample"
 $dsn = "driver={IBM db2 odbc DRIVER};Database=sample;hostname=localhost;port=50000;protocol=TCPIP; uid=root; pwd=natsoft"
 $dsn = "driver={IBM db2 odbc DRIVER};Database=sample;hostname=localhost;port=50000;protocol=TCPIP; uid=root; pwd=natsoft"
 $db = ADONewConnection('odbtp')
 $arr = $db->GetArray( "||SQLProcedureColumns|||GET_ROUTINE_SAR" )
 else
 $server = 'sherkhan'
print< h1 > Connecting $db
databaseType</h1 > 		$ok = $db->Connect('','adodb','natsoft','northwind')
else print ERROR
else print userid = 'adodb'
else print password = 'natsoft'
else print database
 Driver = {SQL Server}
 Server = $server
 Database = northwind
else print ERROR
print< h1 > Connecting DSN
less $db databaseType</h1 > 		$myDSN
else print ERROR
print< h1 > Connecting DSN
less OLEDB Provider $db databaseType<
/h1 > 		$myDSN = "SERVER=localhost;DATABASE=northwind;Trusted_Connection=yes"
else print ERROR
else print userid = 'sa'
else print password = ''
else print database
 Driver = {SQL Server}
 Server = $server
 Database = northwind
 uid = adodb

Variable Documentation

$_GET['nolog'] = 1
 

Definition at line 209 of file testdatabases.inc.php.

print<h1> Connecting $db databaseType</h1> $access = 'd:\inetpub\wwwroot\php\NWIND.MDB'
 

Definition at line 205 of file testdatabases.inc.php.

print<h1> Connecting $db databaseType</h1> $access = 'd:\inetpub\wwwroot\php\NWIND.MDB'
 

Definition at line 189 of file testdatabases.inc.php.

$arr = $db->GetArray( "||SQLProcedureColumns|||GET_ROUTINE_SAR" )
 

Definition at line 337 of file testdatabases.inc.php.

$database = 'northwind'
 

Definition at line 242 of file testdatabases.inc.php.

$db = ADONewConnection('odbtp')
 

Definition at line 332 of file testdatabases.inc.php.

$db = &ADONewConnection("mysqlt://$user:$password@$server/$database?persist")
 

Definition at line 243 of file testdatabases.inc.php.

$db = &ADONewConnection('odbtp')
 

Definition at line 226 of file testdatabases.inc.php.

$db = ADONewConnection($dsn)
 

Definition at line 106 of file testdatabases.inc.php.

$dsn = "driver={IBM db2 odbc DRIVER};Database=sample;hostname=localhost;port=50000;protocol=TCPIP; uid=root; pwd=natsoft"
 

Definition at line 330 of file testdatabases.inc.php.

$dsn = "driver={IBM db2 odbc DRIVER};Database=sample;hostname=localhost;port=50000;protocol=TCPIP; uid=root; pwd=natsoft"
 

Definition at line 323 of file testdatabases.inc.php.

print<h1> Connecting $db databaseType</h1> $dsn = "db2_sample"
 

Definition at line 322 of file testdatabases.inc.php.

$dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=$access;Uid=Admin;Pwd=;"
 

Definition at line 191 of file testdatabases.inc.php.

$dsn = "nwind"
 

Definition at line 190 of file testdatabases.inc.php.

$dsn = "sqlite://$path/"
 

Definition at line 105 of file testdatabases.inc.php.

print<h1> Connecting DSN less OLEDB Provider $db databaseType</h1> $myDSN = "SERVER=localhost;DATABASE=northwind;Trusted_Connection=yes"
 

Definition at line 403 of file testdatabases.inc.php.

print<h1> Connecting DSN less $db databaseType</h1> $myDSN
 

Initial value:

"PROVIDER=MSDASQL;DRIVER={SQL Server};"
                . "SERVER=$server;DATABASE=NorthWind;UID=adodb;PWD=natsoft;Trusted_Connection=No"

Definition at line 388 of file testdatabases.inc.php.

$myDSN
 

Initial value:

  'PROVIDER=Microsoft.Jet.OLEDB.4.0;'
                . 'DATA SOURCE=' . $access . ';'

Definition at line 206 of file testdatabases.inc.php.

print<h1> Connecting $db databaseType</h1> $ok = $db->Connect('','adodb','natsoft','northwind')
 

Definition at line 355 of file testdatabases.inc.php.

$password = ''
 

Definition at line 242 of file testdatabases.inc.php.

$server = 'sherkhan'
 

Definition at line 345 of file testdatabases.inc.php.

else $server = "mangrove"
 

Definition at line 241 of file testdatabases.inc.php.

$user = 'root'
 

Definition at line 242 of file testdatabases.inc.php.

Database = northwind
 

Definition at line 414 of file testdatabases.inc.php.

else print database
 

Initial value:

'ai'";

}


if (extension_loaded('odbtp') && !empty($testmssql)) { // MS SQL Server via ODBC
        $db = ADONewConnection('odbtp');
        
        $dsn = "PROVIDER=MSDASQL

Definition at line 406 of file testdatabases.inc.php.

Database = northwind
 

Definition at line 372 of file testdatabases.inc.php.

else print database
 

Initial value:

'ai'".'<BR>'.$db->ErrorMsg();
        
}


ADOLoadCode('odbc_mssql');
if (!empty($testmssql)) { // MS SQL Server via ODBC
        $db = ADONewConnection();
        
        print "<h1>Connecting $db->databaseType...</h1>";
        
        $dsn = "PROVIDER=MSDASQL

Definition at line 361 of file testdatabases.inc.php.

else print database
 

Initial value:

'test'".'<BR>'.$db->ErrorMsg();

}

ADOLoadCode('oci805');
ADOLoadCode("oci8po");
if (!empty($testoracle)) {
        $dsn = "oci8po:
        $db = ADONewConnection($dsn)

Definition at line 291 of file testdatabases.inc.php.

else print database
 

Initial value:

'test'".'<BR>'.$db->ErrorMsg();
}

if (!empty($testproxy)){
        $db = &ADONewConnection('proxy');
        print "<h1>Connecting $db->databaseType...</h1>";
        if ($_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';

        if ($db->PConnect('http://localhost/php/phplens/adodb/server.php'))
                testdb($db,
                "create table ADOXYZ (id int, firstname char(24), lastname char(24), created date) type=innodb");
        else print "ERROR: MySQL test requires a MySQL server on localhost

Definition at line 280 of file testdatabases.inc.php.

else print database
 

Initial value:

'test'".'<BR>'.$db->ErrorMsg();
}


// REQUIRES MySQL server at localhost with database 'test'
if (!empty($testmysqlodbc)) { // MYSQL
        
        $db = &ADONewConnection('odbc');
        $db->hasTransactions = false;
        print "<h1>Connecting $db->databaseType...</h1>";
        if ($_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';
        else $server = "mangrove";
        if ($db->PConnect('mysql', "root", ""))
                testdb($db,
                "create table ADOXYZ (id int, firstname char(24), lastname char(24), created date) type=innodb");
        else print "ERROR: MySQL test requires a MySQL server on localhost

Definition at line 265 of file testdatabases.inc.php.

else print database
 

Initial value:

'test'".'<BR>'.$db->ErrorMsg();
}

// REQUIRES MySQL server at localhost with database 'test'
if (!empty($testmysqli)) { // MYSQL

        $db = &ADONewConnection('mysqli');
        print "<h1>Connecting $db->databaseType...</h1>";
        if (PHP_VERSION >= 5 || $_SERVER['HTTP_HOST'] == 'localhost') $server = 'localhost';
        else $server = "mangrove";
        if ($db->PConnect($server, "root", "", "northwind")) {
                //$db->debug=1;$db->Execute('drop table ADOXYZ');
                testdb($db,
                "create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)");
        } else print "ERROR: MySQL test requires a MySQL server on localhost

Definition at line 251 of file testdatabases.inc.php.

Driver = {SQL Server}
 

Definition at line 414 of file testdatabases.inc.php.

Driver = {SQL Server}
 

Definition at line 372 of file testdatabases.inc.php.

else print VFP driver
 

Definition at line 231 of file testdatabases.inc.php.

else print VFP driver
 

Definition at line 223 of file testdatabases.inc.php.

else print Access driver
 

Definition at line 196 of file testdatabases.inc.php.

else
 

Definition at line 340 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 406 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 394 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 377 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 361 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 313 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 303 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 251 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 231 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 223 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 213 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 196 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 116 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 98 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 89 of file testdatabases.inc.php.

else print ERROR
 

Definition at line 76 of file testdatabases.inc.php.

$db hasTransactions = false
 

Definition at line 167 of file testdatabases.inc.php.

$db hasTransactions = false
 

Definition at line 156 of file testdatabases.inc.php.

$db hasTransactions = false
 

Definition at line 82 of file testdatabases.inc.php.

else print password = ''
 

Definition at line 406 of file testdatabases.inc.php.

else print password = 'natsoft'
 

Definition at line 361 of file testdatabases.inc.php.

else print password = ''
 

Definition at line 291 of file testdatabases.inc.php.

else print password = ''
 

Definition at line 280 of file testdatabases.inc.php.

else print password = ''
 

Definition at line 265 of file testdatabases.inc.php.

else print password = ''
 

Definition at line 251 of file testdatabases.inc.php.

Server = $server
 

Definition at line 414 of file testdatabases.inc.php.

Server = $server
 

Definition at line 372 of file testdatabases.inc.php.

else print user tester
 

Definition at line 89 of file testdatabases.inc.php.

else print user tester
 

Definition at line 76 of file testdatabases.inc.php.

uid = adodb
 

Definition at line 414 of file testdatabases.inc.php.

else print userid = 'sa'
 

Definition at line 406 of file testdatabases.inc.php.

else print userid = 'adodb'
 

Definition at line 361 of file testdatabases.inc.php.

else print userid = 'admin'
 

Definition at line 291 of file testdatabases.inc.php.

else print userid = 'admin'
 

Definition at line 280 of file testdatabases.inc.php.

else print userid = 'admin'
 

Definition at line 265 of file testdatabases.inc.php.

else print userid = 'admin'
 

Definition at line 251 of file testdatabases.inc.php.

Generated on Fri Apr 7 10:48:42 2006 for TYPO3 by  doxygen 1.4.6