安装／配置

add a note

User Contributed Notes 6 notes

down

robyn at dcphp dot com ¶

8 years ago


http://www.apachefriends.org/en/xampp-macosx.html

This links to xampp works great on macs. I have put it only for PPC machines, but it claims to work properly on Intel as well. 

I also had success installing FreeTDS and PHP from source on an Intel Macbook, running Mac OS 10.6 (Snow Leopard). My steps were the following:

PREPARE SOURCE CODE
step 1: download latest php version
step 2: un-tar the php source code
step 3: download latest freetds version
step 4: un-tar the freetds source code

INSTALL THE FREETDS
step 5: make sure there is a writable directory at /usr/local/freetds
step 6: "cd" to the freetds source directory
step 7: run "sudo ./configure --prefix=/usr/local/freetds --enable-msdblib"
step 8: run "sudo make"
step 9: run "sudo make install"
step 10: run "touch /usr/local/freetds/include/tds.h" (add blank, but necessary files)
step 11: run "touch /usr/local/freetds/lib/libtds.a" (add blank, but necessary files)

INSTALL THE PHP
step 11: "cd" to the php source directory
step 12: run "sudo ./configure --disable-all --with-mssql=/usr/local/freetds"
step 13: run "sudo make"
step 14: run "sudo make install"

Of course, since I was disabling-all (step 12) that means that you have to explicitly add back those modules you want to configure php with.

down

Hiren Dave ¶

3 years ago


To install it on MAMP on OSX, please check my blog here.

http://davehiren.blogspot.in/2015/07/mamp-install-mssql-extension.html

down

-3

xmak at studioartlan dot com ¶

5 years ago


For the 64-bit architecture in some cases you need to link /usr/local/freetds/lib64 to /usr/local/freetds/lib.
See here:

http://forums.cpanel.net/f354/adding-mssql-support-php-66644-p2.html

down

-3

mark dot treble at marktreble dot co dot uk ¶

9 years ago


If anybody is looking for the api documentation now - (26 May 2010), it can be found at:

http://msdn.microsoft.com/en-us/library/cc296152%28SQL.90%29.aspx

down

-7

jklowden at freetds dot org ¶

11 years ago


The 30-character limitation  does not apply to the FreeTDS db-lib implementation.  FreeTDS returns column names of any length supported by the server (and protocol).

down

-14

dragos at rdss dot ro ¶

8 years ago


mssql install-setup as so on linux:

get freetds package 
1. wget ftp://ftp.ibiblio.org/pub/Linux/
ALPHA/freetds/stable/freetds-stable.tgz
2. uncompress and cd 2 sources folder
3. ./configure --enable-msdblib --prefix=/usr/local/freetds
4. make
5. make install
copy some supplementary files
6. cp include/tds.h /usr/local/freetds/include
7. cp src/tds/.libs/libtds.a /usr/local/freetds/lib

get php devel sources if you don't have it and install it
get php sourcers files, uncompress it, chdir
8. chdir ext/mssql
8. phpize
9. ./configure --with-mssql=/usr/local/freetds
10. make
11. cp modules/mssql.so phpextensionpath, or make install

12. echo "/usr/local/freetds/lib" >> /etc/ld.so.conf
and
echo "export FREETDSCONF=/usr/local/freetds/etc/freetds.conf" >> /etc/profile
add in extension section
13. extension=mssql.so to php.ini 
add in httpd.conf right above "Include /etc/httpd/mod_php.conf"
14.SetEnv FREETDSCONF /usr/local/freetds/etc/freetds.conf
15. set you server connection in /usr/local/freetds/etc/freetds.conf

for testing w/o reboot server:
16. export FREETDSCONF=/usr/local/freetds/etc/freetds.conf
17. restart apache
18. verify mssql enabled with phpinfo()
19. run your test script. 
20. other fine tunnigs and settings
 
pls. keep in mind:
- your ms SQL must be setup with socket listing ;)
- check windoze box firewall to accept TCP 1433 connection.

Enjoy!
Dragos

add a note

官方地址：https://www.php.net/manual/en/mssql.setup.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络数据库 JAVA 面试 NoSQL C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 PHP 8.1 ADORecordSet对象 adodb手册 opcache预加载 Composer的Packagist资源 array_multisort() 多字段排序 PHPMailer设置utf8 PHPMailer字符集CharSet PHP json解析（json_decode）页面工具 php中几种注释规范 mysql面试题 [原创]诡异的php-fpm超时问题 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式纯php实现DES以及TripleDES加密算法两千行PHP学习笔记 html转义/html编码/html解码

略微加速

PHP官方手册 - 互联网笔记

安装／配置

Table of Contents

User Contributed Notes 6 notes