Distributions
› Ubuntu
› Fedora
› CentOS
中文资源站
› 网易开源镜像站
745839
V2EX  ›  Linux

请大佬指点关于 PHP 链接 mssql 姿势!

  •  
  •   745839 · Apr 29, 2018 via Android · 5113 views
    This topic created in 3122 days ago, the information mentioned may be changed or developed.

    服务器:centos 环境:宝塔安装的 lamp,php5.4(可以改) 跑的 thinkphp 程序,需要链接 mssql 数据库,求姿势!

    22 replies  •  2018-05-02 16:09:33 +08:00
    fengyj
    fengyj
    Apr 29, 2018 via Android
    1
    MySQL 吧🤨
    汗,标题打错就算了,正文还打错一遍。汗
    l9rw
    l9rw
    Apr 29, 2018❤️1
    2
    @huiyifyj #1 楼主意思是 microsoft sql server
    bombless
    bombless
    Apr 29, 2018 via Android
    3
    745839
    745839
    OP
    Apr 29, 2018
    4
    @huiyifyj 没错就是 mssql

    @bombless 这个网页没有 linux 下的吧,我没找到
    fengyj
    fengyj
    Apr 29, 2018 via Android
    5
    @l9rw
    @745839
    Linux 还用 sql server。666
    除了学 c#用过,其他时候还真没碰过。😅
    jevonszmx
    jevonszmx
    Apr 29, 2018
    6
    unixODBC + freeTDS 了解一下
    2ME
    2ME
    Apr 29, 2018
    7
    https://github.com/Microsoft/msphpsql/releases/ 找老版本的装就可以了 往后多翻几页 现在都是 PHP7 你条件允许升 PHP7 用前面的那几个版本都可以
    zjqzxc
    zjqzxc
    Apr 29, 2018
    8
    搜索 thinkphp pdo 关键字
    剩下的事儿交给 pdo

    另外,是不是需要装扩展,楼主自行测试
    745839
    745839
    OP
    Apr 29, 2018
    9
    @2ME
    @zjqzxc 谢谢
    xia0chun
    xia0chun
    Apr 29, 2018
    10
    推荐使用 Medoo 框架,超级简单
    https://medoo.in/api/new
    kearone
    kearone
    Apr 29, 2018 via Android
    11
    上次我为了这个找了半天,centos7,php7 我安装成功了。
    tushankaka
    tushankaka
    Apr 29, 2018 via Android
    12
    要用 php 么。。。
    lsido
    lsido
    Apr 29, 2018 via iPhone
    13
    哼,我博客有解决办法,上次为了这个没少跳坑
    745839
    745839
    OP
    Apr 30, 2018
    14
    @kearone 老哥,你联系方式,指点一二可否
    745839
    745839
    OP
    Apr 30, 2018
    15
    @lsido 老哥,你联系方式,指点一二可否
    lsido
    lsido
    Apr 30, 2018 via iPhone
    16
    kearone
    kearone
    Apr 30, 2018 via Android
    17
    回去把笔记发给你
    aijie
    aijie
    Apr 30, 2018 via Android
    18
    745839
    745839
    OP
    May 1, 2018
    19
    @aijie 方便留个联系方式吗,我是 linux 菜鸟
    kearone
    kearone
    May 2, 2018
    20
    @745839 刚刚放假回来

    <!--markdown-->[github>安装步骤][1]

    [微软官方][2]

    [unixODBC][3]

    [PDF][4]

    ```
    > step1
    sudo su
    curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo
    [exit]
    sudo yum update
    sudo yum remove unixODBC-utf16-devel #to avoid conflicts
    sudo ACCEPT_EULA=Y yum install msodbcsql mssql-tools
    sudo yum install unixODBC-devel
    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
    echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
    source ~/.bashrc
    > step2
    sudo pecl install sqlsrv-devel
    sudo pecl install pdo_sqlsrv-devel
    ```

    [1]: https://github.com/Microsoft/msphpsql/tree/master#install-unix
    [2]: https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver
    [3]: http://www.unixodbc.org/
    [4]: https://download.microsoft.com/download/C/E/2/CE29C106-4C2D-4FBB-BB29-F34F91A8E478/Unix_4.3_Install_Instructions.pdf
    745839
    745839
    OP
    May 2, 2018 via Android
    21
    @kearone 老哥,可以留个 qq 吗
    kearone
    kearone
    May 2, 2018
    22
    MjAxMzg1NjA5
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1863 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 53ms · UTC 06:05 · PVG 14:05 · LAX 22:05 · JFK 01:05
    ♥ Do have faith in what you're doing.