$serverName = "";
$database = "";
$uid = "";
$pwd = "";
$dsn="sqlsrv:server=$serverName ; Database = $database";
$hai = new PDO($dsn,$uid,$pwd);
$query1="select * from a where b='123' ";
php 想查询出总共的条数，并条数大于0输出正确，否则输出错误
sqlserver数据库
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "正确";
} else {
echo "错误";
}
//选择要连接的数据库
$dbName="sqlsrv:Server=127.0.0.1,1433;Database=home";
//SqlServer数据库⽤户登录名称
$dbUser="sa";
//SqlServer数据库⽤户登录密码
$dbPassword="sa";
//初始化⼀个PDO对象，判断是否连接成功
$db=new PDO($dbName,$dbUser,$dbPassword);
$query1="select * from a where b='123' ";
$stmt=$db->query($query1);
if($stmt->rowCount()>0){
echo '正确';
}
else{
echo '错误';
}