Solutions Open Source

Référence du fichier Z:/doxygen/typo3_src-4.1.2/typo3/sysext/adodb/adodb/tests/testdatabases.inc.php


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
else print	ERROR
	$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

Documentation des variables

$_GET['nolog'] = 1

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

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

$database = 'northwind'

$db = ADONewConnection('odbtp')

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

$db = &ADONewConnection('odbtp')

$db = ADONewConnection($dsn)

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

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

$dsn = "nwind"

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

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

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

Valeur initiale :

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

$myDSN

Valeur initiale :

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

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

$password = ''

$server = 'sherkhan'

else $server = "mangrove"

$user = 'root'

Database = northwind

else print database

Valeur initiale :

'ai'";

}


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

Database = northwind

else print database

Valeur initiale :

'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

else print database

Valeur initiale :

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

}

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

else print database

Valeur initiale :

'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

else print database

Valeur initiale :

'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

else print database

Valeur initiale :

'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