通过PHP连接到MSSQL Server

I have MSSQL 2008 installed on my production server. I want to operate on that data remotely via php. As I went through a lot of articles and installed 'php_sqlsrv_54_ts.dll' and 'php_sqlsrv_54_nts.dll' files in my ext folder and enable them in my php.ini file. But still I am getting following error:

Fatal error: Call to undefined function mssql_connect()...

Please help me out how could I do this?

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dsgni26260 2013-09-20 12:34
关注
php_sqlsrv_54_ts is not the extension files for the mssql extension, which is no longer supported when connecting from PHP hosted on Windows. php_sqlsrv_54_ts is for SQLSRV and you need to connect using sqlsrv_connect.

Just in case the above is less than clear... You have the right extension installed, meaning the one that is newer and preferred. You are using the wrong functions. You don't need to, nor should you, try to enable the mssql extension. You simple need to use the sqlsrv extension functions instead.

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

php通过mysqli连接mysql数据库 mysql php
2019-03-18 20:03

回答 2 已采纳 According to the help pages, database usernames for DomainFactory should start with "db": Den
PHP升级后无法连接到外部Mysql mysql php ubuntu
2017-11-01 22:50

回答 1 已采纳 Found it. php 7 does not support ip:port anymore, but port has to be set up separately. Changed th
PHP没有连接到远程MySQL mysql php
2017-02-07 17:12

回答 2 已采纳 Found this to be an issue with SELinux that is not allowing httpd network connections. Executing
PHP笔记-连接MySQL数据库及查询数据
2022-01-03 11:17

IT1995的博客我这是Windows的机器，修改php.ini 将此处放开即可。程序结构： list.html <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>列表</title&...
无法连接到MySQL db，PHP mysql php
2017-11-13 12:24

回答 1 已采纳 try this code write this way your code <?php define ("DB_USER", "root"); //use "" for DB_US
使用PDO从PHP无法连接到MySQL mysql php
2014-05-24 13:49

回答 1 已采纳 mysql:host=localhost;dbname=;pizzadb3 Needs to be: mysql:host=localhost;dbname=pizzadb3;
Android通过php连接到mysql android java mysql php
2012-10-24 13:18

回答 3 已采纳 You may use an AsyncTask class to carry out your network operations as strictmode does not allow i
13（PHP连接Mysql）
2021-11-18 14:34

承缘丶的博客一、PHP连接Mysql的步骤概述二、PHP连接Mysql服务器代码示例 1.mysqli_connect(string $server, [string $username,[string $password]])： 2.@错误控制符： 3.mysql_error([resource $link])：二、选择...
使用PHP通过SSL连接到MySQL mysql php ssl
2011-06-28 19:23

回答 1 已采纳 The MySQL server is on the same machine as the script. My SSL Certificate is installed. Is it
通过PHP从GoDaddy连接到远程AWS MySQL mysql php
2014-11-12 23:08

回答 1 已采纳 Based on the the information in the question and the comments, it is clear that GoDaddy's network
PHP连接MySQL错误 mysql php
2018-07-10 19:51

回答 1 已采纳 Hello @Steven in my experience xampp gives error on Mac (at least in my opinion) so i used MAMP. Y
3种PHP连接MYSQL数据库的常用方法
2022-04-11 23:15

戴维学长的博客对于PHP入门用户来说，我们只要掌握基本的数据库写入、读取...这里，班某人整理几种常用的PHPMySQL数据库的方法，我们可以参考。第一：常用普通方法 $mysql_server="localhost"; $mysql_username="数据库用户名...
通过PHP脚本隧道连接到MySQL c# mysql php
2012-04-11 11:27

回答 3 已采纳 I ended up with going for an SSH port tunnel and achieving what I needed to do that way.
php搭建mysql连接池
2020-08-08 14:47

祖传编码手艺人的博客对于并发较小的项目来说，长连接确实可以提高查询效率，php不用每次去与mysql服务器建立连接，只要某个php-cgi连接过mysql，那么本次访问结束后，php不会释放与mysql的连接。当下次请求过来的时候，php就可以复用...
PHP连接MYSQL数据库的3种常用方法
2022-09-10 16:03

莉莉可的博客在整个过程中，MySQL数据库的连接也是比较重要的，可以使用多种方法进行连接，对于新手来说我们就不要去分析哪种方式对于系统资源的优化程度，我们先能连接上就行。在提取数据的时候，我们使用mysql_fetch_row，还...
没有解决我的问题, 去提问

悬赏问题

¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场部分对应不上
¥15 如何在scanpy上做差异基因和通路富集？
¥20 关于#硬件工程#的问题，请各位专家解答！
¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
¥30 截图中的mathematics程序转换成matlab
¥15 动力学代码报错，维度不匹配
¥15 Power query添加列问题
¥50 Kubernetes&Fission&Eleasticsearch
¥15 報錯：Person is not mapped，如何解決？

通过PHP连接到MSSQL Server

2条回答 默认 最新

悬赏问题

2条回答默认最新