php7.2链接sqlserver数据库 通达OAv12链接sqlserver数据库

<?
$dbhost = '122.xx.124.250,1433'; 
$dbuser ='sa'; //你的mssql用户名 
$dbpass = '2022'; //你的mssql密码 
$dbname = 'sun'; //你的mssql库名 

$dbName = "sqlsrv:Server=122.xx.124.250;Database=sun";

$dbUser = "sa";  

$dbPassword = "2022";  

$db = new PDO($dbName, $dbUser, $dbPassword);

if($db) {

echo "连接成功";

}else{

echo "连接失败";

}


$sql5="select * from table1";

$rs5=$db->query($sql5); 
while( $row =$rs5 ->fetch()) { 
   // print_r($row); 
} 

$sql5="select * from table1";
$rs5=$db->query($sql5); 
$rows = $rs5->fetchAll();
$rowCount = count($rows);
echo $rowCount."<br>";  //计数
// $q = $db->query("SELECT ..."); $rows = $q->fetchAll(); $rowCount = count($rows);
 
 /*
 $stmt=$dbh->prepare("SELECT * FROM CSDNUser");
$stmt->execute();
while ($row=$stmt->fetch()) {
  print_r($row);
}
unset($dbh);
unset($stmt);
*/
$sql2="INSERT INTO [sun1].[dbo].[table1] ( [name], [beizhu]) VALUES ( 'sun99', '5599')";
$stmt=$db->prepare($sql2); 
$stmt->execute(); 
echo $db->lastInsertId();   //返回新插入的id

//odbc_free_result($Result);


$sql3="UPDATE [sun1].[dbo].[table1] SET [name]='sun334999', [beizhu]='55399934' WHERE ([a_id]='40')";
$stmt=$db->prepare($sql3); 
$stmt->execute(); 
exit;
/*

$sql4="delete from  [sun1].[dbo].[table1]  WHERE ([a_id]='$NewID')";
odbc_exec($connect, $sql4);

$result=odbc_do($connect,$sql);  
$q=odbc_num_rows($result);
echo $q;//显示的行数
*/
//odbc_close($connect); 


unset($db);
unset($stmt);



?>