connect to SQL Server Database with PHP

Question

I want to connect to a specific database on SQL Server Through PHP. On WAMP Server, I have PHP 5.6 installed so I downloaded SQLSRV32.EXE (Microsoft Drivers for PHP for SQL Server) then I copied these files in C:\wamp64\bin\php\php5.6.25\ext

IN php.ini, I added

extension=php_sqlsrv_56_nts.dll

extension=php_sqlsrv_56_ts.dll

But when i check phpinfo() on browser i don't see the sqlsrv module listed.

When i try to connect to my SQL Server Database I get this error

Fatal error: Call to undefined function sqlsrv_connect()

Here is my code

<?php
$serverName = "PC0CFEP2\SQLEXPRESS"; //serverName\instanceName

// Since UID and PWD are not specified in the $connectionInfo array,
// The connection will be attempted using Windows Authentication.
$connectionInfo = array( "Database"=>"test");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

I was checking my solutions on different forums and I tried many but I still can't get it work. I am sure it's in some settings but i couldn't find out what could be the issue.

Any suggestion please ? Thank you very much.

Whatever initializes sqlsrv_connect() it's not loading and that's why you can't call that function. — James
– James, Commented Jul 26, 2017 at 16:12
You only need the Thread Safe extension in WAMPServer so thats php_sqlsrv_56_ts.dll The Non Thread Safe version wont run and will cause you issues — RiggsFolly
– RiggsFolly, Commented Jul 26, 2017 at 16:15
@RiggsFolly i removed the non thread safe version but still the same issue — JuniorDev
– JuniorDev, Commented Jul 26, 2017 at 18:51

MD. ABDUL Halim · Accepted Answer · 2017-07-26 16:40:24Z

2

At First, Please run MSSQL server database.

In php.ini file, Please added below code

extension=php_sqlsrv_56_ts.dll
extension=php_pdo_sqlsrv_56_ts.dll

and keep two dll file \ext folder

To connect database , try

$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}

edited Jul 26, 2017 at 16:40

answered Jul 26, 2017 at 16:25

MD. ABDUL Halim

7223 gold badges12 silver badges32 bronze badges

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

1 Comment

JuniorDev Over a year ago

thanks for your answer. I have done the same but still not working. The sqlsrv is still not showing on the php.info too. is there any other setting i need to change in the php.ini ?

Kamlesh · Accepted Answer · 2019-08-20 15:44:40Z

2

Remove "php_" prefix:

extension=sqlsrv_56_ts.dll
extension=pdo_sqlsrv_56_ts.dll

This worked for me. Thanks for asking this question.

answered Aug 20, 2019 at 15:44

Kamlesh

6,2591 gold badge51 silver badges55 bronze badges

Collectives™ on Stack Overflow

connect to SQL Server Database with PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related