php原生连接sql server，Hyperf 连接sqlserver，Hyperf 封装查询

大得369

已于 2023-05-08 16:07:47 修改

阅读量330

点赞数

文章标签： php 数据库服务器

于 2023-05-08 14:20:05 首次发布

本文链接：https://blog.csdn.net/qq_34631220/article/details/130558051

版权

$dbms = 'sqlsrv';
$host = '172.31.44.91,1433';
$user = 'dcr';
$password = 'ph2#moe6';
$dbname = 'WyglDB2';
$dsn = "$dbms:Server=$host;Database=$dbname";
$db = new \PDO($dsn, $user, $password);
$sth = $db->query("select * from Wygl_Charge_CustomerChargeDetail where ID = 50073741");
$data = $sth->fetchAll(\PDO::FETCH_ASSOC);
var_dump($db);
//返回Object对象，代表连接成功。

// $datas = Db::connection('WyglDB2')->select("select * from Wygl_Charge_CustomerChargeDetail where id = 50073741");
return [
    'method' => $data,
     'message' => 66,
];

使用前先安装sqlserver扩展

宝塔php7.2安装sqlserver扩展_宝塔安装sqlserver_大得369的博客-CSDN博客

<?php
namespace App\Common;


class SqlServer
{

    /**
    * 查询方法封装
    */
    public static function query($dbnames,$sql)
    {
        $dbms = "sqlsrv";//驱动
        $host = "127.0.0.1,1433";//ip和端口
        $user = "sa";//账号
        $password = "";//密码
        $dbname = $dbnames;//库
        $dsn = "$dbms:Server=$host;Database=$dbname";
        try {
            $db = new \PDO($dsn,$user,$password);
            $sth = $db->query($sql);//查询语句
            $data = $sth->fetchAll(\PDO::FETCH_ASSOC);
        }catch (PDOException $e){
            $data = $e->getMessage();
            
        }
        $db = null;// 关闭数据库连接
        return $data;
    }
}

调用操作

<?php

namespace App\Controller;
use Hyperf\Utils\Parallel;
use Hyperf\Utils\Coroutine;
use Hyperf\DbConnection\Db;
use App\Common\SqlServer as dbs;

class IndexController extends AbstractController
{
    public function index()
    {
        $data = dbs::query("WyglDB2",'select * from Wygl_Charge_CustomerChargeDetail where ID = 50073741');
        return [
            'method' => $data,
            'message' => 66,
        ];
    }
    
 
}