linux下php 加装mssql模块

Question

linux下php 加装mssql模块

在linux 下的php连接mssql，就需要安装第三方的freetds了。
1、安装配置freetds

1. wget http://mirrors.xmu.edu.cn/ubuntu/archive/pool/main/f/freetds/freetds_0.82.orig.tar.gz
2. tar zxf freetds_0.82.orig.tar.gz
3. cd freetds_0.82
4. ./configure --prefix=/usr/local/freetds --with-tdsver=8.0 -–enable-msdblib -–enable-dbmfix -–with-gnu-ld -–enable-shared -–enable-static
5. make && make install

复制代码2、编译php的mssql模块

cd /path/to/php/source 进入PHP源码目录
cd ext/mssql 进入MSSQL模块源码目录
/usr/local/webserver/php/bin/phpize 生成编译配置文件
./configure –with-php-config=/usr/local/webserver/php/bin/php-config –with-mssql=/usr/local/freetds
make
make install

编译完成生成 mssql.so，修改php.ini，将该模块载入：

1. extension=”/path/to/extension/mssql.so”

复制代码3、配置mssql

2. cd /usr/local/freetds/etc
3. 编辑文件：
4. vi freetds.conf
5. [global]
6. # TDS protocol version
7. ; tds version = 4.2
8. # Whether to write a TDSDUMP file for diagnostic purposes
9. # (setting this to /tmp is insecure on a multi-user system)
10. ; dump file = /tmp/freetds.log
11. ; debug flags = 0xffff
12. # Command and connection timeouts
13. ; timeout = 10
14. ; connect timeout = 10
15. # If you get out-of-memory errors, it may mean that your client
16. # is trying to allocate a huge buffer for a TEXT field.
17. # Try setting ‘text size’ to a more reasonable limit
18. text size = 64512
19. client charset = UTF-8 #加入
20. #加入
21. [Server2005]
22. host = 192.168.x.x
23. port = 1433
24. tds version = 7.2

复制代码4、测试php连接mssql

2. <?php
4. try {
6. $hostname='218.x.x.x';//注意,这里和上面不同,要直接用IP地址或主机名
7. $port=1433;//端口
8. $dbname="user";//库名
9. $username="database";//用户
10. $pw="passwd";//密码
11. $dbh= new PDO("dblib:host=$hostname:$port;dbname=$dbname","$username","$pw");
12. } catch (PDOException $e) {
13. echo"Failed to get DB handle: ".$e->getMessage() ."n";
14. exit;
15. }
17. echo'connent MSSQL succeed';
19. $stmt=$dbh->prepare("select * from z_2010pinjiu_user");
20. $stmt->execute();
21. while ($row=$stmt->fetch()) {
22. print_r($row);
23. }
24. unset($dbh); unset($stmt);
26. ?>

复制代码