pdo 连接sql server
pdo 链接sqlserver
注意:需要根据PHP版本安装对应的依赖
<?php require_once __DIR__ . '/../config/_config.inc.php'; require_once __DIR__ . '/../api/src/autoload.php'; require_once __DIR__ . '/../api/v1/vendor/autoload.php'; use Shared\DB; $serverName = $host; $connectionInfo = array("Database" => $db_name, "UID" => $user, "PWD" => $pwd, "CharacterSet" => "UTF-8", "TrustServerCertificate" => "yes"); $conn = sqlsrv_connect($serverName, $connectionInfo); $DB = DB::connect([ 'host' => $PARAM_DB_host, 'dbname' => $cfg['db_name'], 'username' => $PARAM_DB_user, 'password' => $PARAM_DB_password, 'eamic_user' => 'Sync' ]); function getSpPrice(): array { global $conn, $log; $sql = " SELECT materialcode AS sp_code, bhsdj AS sp_unit_price, sl AS receipt_sp_tax_percentage, hsdj AS receipt_sp_unit_price_wtax FROM LC0019999.vw_movementpriceEAM "; $stmt = sqlsrv_query($conn, $sql); if ($stmt === false) { $log->write(sqlsrv_errors(), true); } $row_count = sqlsrv_num_rows($stmt); if ($row_count === false) { $log->write("Error al obtener datos"); } $data = []; while ($row = sqlsrv_fetch_array($stmt)) { $data[] = $row; } sqlsrv_close($conn); return $data; } function getSqlervSp(): array { global $log, $conn; $sql = "SELECT materialcode AS sp_code, materialname AS sp_name, specs AS sp_specification , unitname AS sp_unit FROM LC0019999.vw_materialEAM"; $stmt = sqlsrv_query($conn, $sql); if ($stmt === false) { $log->write(sqlsrv_errors(), true); } $row_count = sqlsrv_num_rows($stmt); if ($row_count === false) { $log->write("Error al obtener datos"); } $data = []; while ($row = sqlsrv_fetch_array($stmt)) { $data[] = $row; } sqlsrv_close($conn); return $data; }
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 分享一个免费、快速、无限量使用的满血 DeepSeek R1 模型,支持深度思考和联网搜索!
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· ollama系列01:轻松3步本地部署deepseek,普通电脑可用
· 25岁的心里话
· 按钮权限的设计及实现