21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
$hostname = "192.168.10.25";
$dbname = "test";
$username = "web";
$pwd = "123456";
$connectionInfo = array("UID"=>$username, "PWD"=>$pwd, "Database"=>$dbname);
$conn = sqlsrv_connect( $hostname, $connectionInfo);
if( $conn == false){
echo "sqlsrv方式连接失败.";
} else {
echo "sqlsrv方式连接成功.";
}
?>
<?php
function connect($config=array()){
$dbhost = $config['dbhost'];
$dbname = $config['dbname'];
$dbuser = $config['username'];
$dbpasswd = $config['password'];
$pconnect = $config['pconnect'];
$charset = isset($config['charset'])? $config['charset'] : '';
$dsn = "mysql:host=$dbhost;dbname=$dbname;";
try {
$h_param = array(
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
);
if($charset!=''){
$h_param[PDO::MYSQL_ATTR_INIT_COMMAND] = 'SET NAMES '.$charset; #設置默認編碼
}
if ($pconnect){
$h_param[PDO::ATTR_PERSISTENT] = true;
}
$conn = new PDO($dsn, $dbuser, $dbpasswd, $h_param);
} catch (PDOException $e) {
throw new ErrorException('Unable to connect to db server. Error:'.$e->getMessage(), 31);
}
return $conn;
}
$confg = array(
'dbhost' => 'localhost',
'dbname' => 'dbname',
'username' => 'admin',
'password' => '123456',
'pconnect' => 0,
'charset' => ''
);
$dbh = connect($config);
?>
$dsn = "sqlsrv:server=localhost,1433;Database=bbb";
try {
$dbh = new PDO($dsn, 'sa', '123456'); //初始化一个PDO对象,就是创建了数据库连接对象$dbh
} catch (PDOException $e) {
die ("Error!: " . $e->getMessage() . "<br/>");
}
echo '<pre>';
print_r($dbh->query("select * from aaa where id=1")->fetchAll());
echo '</pre>';