mac中php安装sqlsrv扩展

 

安装php扩展

sudo pecl install sqlsrv-5.10.0
sudo pecl install pdo_sqlsrv-5.10.0

 

M系列芯片

sudo CXXFLAGS="-I/opt/homebrew/opt/unixodbc/include/" LDFLAGS="-L/opt/homebrew/lib/" pecl install sqlsrv-5.10.0
sudo CXXFLAGS="-I/opt/homebrew/opt/unixodbc/include/" LDFLAGS="-L/opt/homebrew/lib/" pecl install pdo_sqlsrv-5.10.0

 

温馨提示：

1、sqlsrv版本需要与php版本对应

2、需要使用源码编译安装php

3、需要安装odbc驱动（https://learn.microsoft.com/zh-cn/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver16）

 

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)" 
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release 
brew update 
HOMEBREW_ACCEPT_EULA=Y brew install msodbcsql18 mssql-tools18

 

参考链接

https://learn.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver16