# tar zxvf freetds-stable.tgz
# cd freetds-0.82/
# ./configure --prefix=/usr/local/freetds --with-tdsver=7.1 --enable-msdblib
# make && make install
# cd ../
# echo "/usr/local/freetds/lib/" > /etc/ld.so.conf.d/freetds.conf
# ln -s /usr/local/freetds/lib/libsybdb.so.5.0.0 /usr/local/freetds/lib/libsybdb.so.4
# /sbin/ldconfig
# rm -f /usr/local/freetds/etc/freetds.conf
# vi /usr/local/freetds/etc/freetds.conf
[global]
text size = 64512
host = 192.168.16.101
port = 1433
tds version = 8.0
client charset = UTF-8
编译安装PHP自带MSSQL扩展
# cd /data/php-5.2.XX/ext/mssql/
# /usr/local/php/bin/phpize
# ./configure --with-php-config=/usr/local/php/bin/php-config --with-mssql=/usr/local/freetds/
# make && make install
这样就会在PHP的扩展目录中生成一个mssql.so文件
vi /usr/local/php/etc/php.ini
添加 extension = "mssql.so"
保存退出
/usr/local/php/sbin/php-fpm restart
测试:
$server = 'localhost';
$userid = 'sa';
$passwd = 'sa';
$dbName = 'hejian';
$query = "select * from jerry_test";
$db = mssql_connect($server, $userid, $passwd);
mssql_select_db($dbName, $db);
$res = mssql_query($query, $db);
while($row = mssql_fetch_array($res)){
print(implode(",",$row) . "<br>\n");
}
mssql_free_result($res);
mssql_close();