$bbs = new PDO("odbc:MSSQLServer",
   $username_bbs,
    $password_bbs
    

$bbs = new PDO('odbc:driver={SQL Server};Server=127.0.0.1;Database=qq;','sa','123'); 

 

$server='127.0.0.1';
$userid='sa';
$pw='123';
$dbname='test';
$constring='odbc:driver={SQL Server};Server='.$server.';Database='.$dbname.';';
$dbcon = new PDO($constring,$userid,$pw);


    
    
    $dbh = new PDO ("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");

 

pdo mysql

new PDO("mysql:host=localhost;dbname=db_demo","root","");
默认不是长连接,若要使用数据库长连接,需要在最后加如下参数:
new PDO("mysql:host=localhost;dbname=db_demo","root","","array(PDO::ATTR_PERSISTENT => true) "); 

 

注意:php.ini里的extension=php_pdo_odbc.dll去掉分号注释才可以用。

posted on 2015-12-20 13:20  lypzxy  阅读(1204)  评论(0编辑  收藏  举报