2015-03-19 17:40
浏览 60


I am new to php. I am trying to connect to SQLEXPRESS server using mysqli from php script. Here is my code:

$servername = "localhost";

// Create connection
$conn = new mysqli($servername,"root","");

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
echo "Connected successfully";


I get an error that the target machine actively refuses the connection. My server is listening connections on port 63083. When I enter the port number in $servername:

 $servername = "localhost:63083";

then the script does not respond and after a few minutes I get an error that MySQL server has gone away. I would really appreciate some help in this regard.


图片转代码服务由CSDN问答提供 功能建议

我是php新手。 我正在尝试使用php脚本中的 mysqli 连接到 SQLEXPRESS 服务器。 这是我的代码:

 $ servername =“localhost”; 
 $ conn = new mysqli($ servername  ,“root”,“”); 
if($ conn-&gt; connect_error){
 die(“连接失败:”。$ conn-&gt; connect_error); 
} \  necho“已成功连接”; 

我收到目标计算机主动拒绝连接的错误。 我的服务器正在端口63083上侦听连接。当我在$ servername中输入端口号时:

  $ servername =“localhost:63083”; 

然后脚本没有响应,几分钟后我收到MySQL服务器已经消失的错误。 我真的很感激这方面的一些帮助。


  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • drpsrvu85668 2015-03-19 17:46

    You cannot connect to an SQLEXPRESS server using PHP's mysqli. SQLEXPRESS has its own method of connecting with PHP. mysqli is only for MySQL servers.

    Reference: http://www.sitepoint.com/sql-server-php/

    点赞 评论

相关推荐 更多相似问题