PDO连接常用数据库DSN大全

in PHP与其它Web技术
//MySQL
mysql:host=localhost;dbname=testdb
mysql:host=localhost;port=3307;dbname=testdb
mysql:unix_socket=/tmp/mysql.sock;dbname=testdb

//SQLite3
sqlite:/opt/databases/mydb.sq3
sqlite::memory:

//SQLite2
sqlite2:/opt/databases/mydb.sq2
sqlite2::memory:

//Microsoft Access
odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\\db.mdb;Uid=Admin

//Microsoft SQL Server
mssql:host=localhost;dbname=testdb
odbc:Driver={SQL Native Client};Server=250.156.0.1;Database=myDataBase; Uid=userName;Pwd=thePassword;

//PostgreSQL
pgsql:host=localhost;port=5432;dbname=testdb;user=bruce;password=mypass

//Oracle
oci:dbname=mydb  // Connect to a database defined in tnsnames.ora
'oci:dbname=//localhost:1521/mydb'  // Connect using the Oracle Instant Client

//IBM DB2
odbc:DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=localhost;PORT=50000;DATABASE=SAMPLE;PROTOCOL=TCPIP;UID=db2inst1;PWD=ibmdb2;
ibm:DSN=DB2_9
ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=testdb;HOSTNAME=11.22.33.444;PORT=56789;PROTOCOL=TCPIP;

//Sybase
sybase:host=localhost;dbname=testdb

//DB-lib
dblib:host=localhost;dbname=testdb

//Firebird / Interbase
firebird:dbname=DATABASE.GDE

//4D database
4D:host=localhost;charset=UTF-8

//Informix
informix:DSN=Infdrv33
informix:host=host.domain.com;service=9800;database=common_db;server=ids_server;protocol=onsoctcp;EnableScrollableCursors=1

应用举例:

 $db=new PDO('sqlite:data/mydata.db');
 $q=$db->query("select * from testtable");
 $r=$q->fetchArray();
 var_dump($r);
0 Comments

Leave a Reply

Using Gravatars in the comments - get your own and be recognized!

XHTML: These are some of the tags you can use: <a href=""> <b> <blockquote> <code> <em> <i> <strike> <strong>