1. 为php添加 sqlsrv 扩展
去微软官网 https://www.microsoft.com/en-us/download/ 搜索php ,
点击 Microsoft Drivers for PHP for SQL Server
下载最新版的 sqlsrvXX.exe( 我下载的是SQLSRV32.EXE )
运行解压, 得到一堆DLL, 选取适合自己php版本的dll, 放到php\ext\目录下;
在php.ini 增加并增加以下扩展(必须的):
extension=php_odbc.dll
extension=php_pdo_odbc.dll
extension=php_pdo_sqlsrv_7_nts_x86.dll
extension=php_sqlsrv_7_nts_x86.dll
client_buffer_max_kb_size = '102400'
sqlsrv.ClientBufferMaxKBSize = 102400
重启服务, 查看phpinfo(), 如果有sqlsrv项, 证明扩展以安装成功.
又因为 SQLSRV3.X.EXE 需要额外的驱动 Microsoft ODBC Driver 11 (或更高版本), 所以需要安装 Microsoft ODBC Driver 11
访问 https://msdn.microsoft.com/en-us/library/cc296170%28v=sql.105%29.aspx
找到这段话
Versions 3.2 and 3.1 require Microsoft ODBC Driver 11 (or higher) for SQL Server. To download the Microsoft ODBC Driver 11 for PHP for SQL Server, see Microsoft ODBC Driver 11 for SQL Server.
点击 Microsoft ODBC Driver 11 for SQL Server.
2. CI框架连接SQLserver 200R2
首先,你必须修改让你的SQLserver 允许使用ip连接!!! 这步至关重要!
其次, 那就是配置CI框架的config/database.php文件了
如下操作:
$db['default'] = [
'dsn' => '',
'hostname' => '192.168.1.110,1433', //端口号可写可不写
'username' => '用户名,一般默认是sa',
'password' => '用户密码',
'database' => '数据库名称',
'dbdriver' => 'sqlsrv',
'dbprefix' => '',
'pconnect' => FALSE,
'db_debug' => (ENVIRONMENT !== 'production'),
'cache_on' => FALSE,
'cachedir' => '',
'char_set' => 'utf8',
'dbcollat' => 'utf8_general_ci',
'swap_pre' => '',
'encrypt' => FALSE,
'compress' => FALSE,
'stricton' => FALSE,
'failover' => array(),
'save_queries' => TRUE
];
欧了......希望有用啊.....