cannot connect to mysql using mysqli in php script

Question

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

<?php
$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.

Thanks

Where is the database server located? Is it on your computer? — tjg184
– tjg184, Commented Mar 19, 2015 at 17:43
I could be wrong but I think SQLEXPRESS is MSSQL not MySQL. I think you'll need this extension to work with the DB. — War10ck
– War10ck, Commented Mar 19, 2015 at 17:44
I think War10ck is correct, but also looking at the link below it looks like if you want to set the port in mysqli you need to use the port parameter to the connect method: php.net/manual/en/mysqli.construct.php — yoshiwaan
– yoshiwaan, Commented Mar 19, 2015 at 17:48

Matt Solarz · Accepted Answer · 2015-03-19 17:46:05Z

2

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/

answered Mar 19, 2015 at 17:46

Matt Solarz

1461 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

cannot connect to mysql using mysqli in php script

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related