Connect PHP with MS SQL SERVER

Question

I am new to PHP and I am trying to connect my PHP with MS SQL SERVER. I have googled it but not found any good solution.

I am using PHP version : 7.0.6

I have downloaded the required extension and place it in xampp/php/ext folder and added these lines in php.ini file

extension=php_pdo_sqlsrv_7_nts_x64.dll
extension=php_sqlsrv_7_ts_x64.dll
extension=php_pdo_sqlsrv_7_ts_x64.dll
extension=php_sqlsrv_7_nts_x64.dll

and I m using this code to connect to my server.

$myServer = "SERVER_IP"; 
$myUser = "USER_NAME"; 
$myPass = "PASSWORD"; 
$myDB = "DB_NAME"; 

$dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer");

bu tit shows me this error:

Fatal error: Uncaught Error: Call to undefined function mssql_connect() in C:\xampp\htdocs\schedule\server.php:2 Stack trace: #0 {main} thrown in C:\xampp\htdocs\schedule\server.php on line 2

Any help in this would be highly appreciated !!

@JapanGuy NO, phpinfo() dont have any portion relating to mssql drivers — Bilal Zafar
– Bilal Zafar, Commented Sep 21, 2016 at 6:17
@Bilal Zafar .. see my answer below.. you can use PDO for that — Emz
– Emz, Commented Sep 21, 2016 at 6:18

Cobuz Alexandru · Accepted Answer · 2016-09-21 06:46:20Z

1

You have sqlsrv_connect not mssql_connect, try using this. If it doesn't work, that means you have problems with your extension ( you can also use function_exists to check ).

More info: sqlsrv_connect: http://php.net/manual/ro/function.sqlsrv-connect.php

$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"database_name", "UID"=>"mssql_username", "PWD"=>"mssql_password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

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

answered Sep 21, 2016 at 6:46

Cobuz Alexandru

3222 silver badges12 bronze badges

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

Comments

Emz · Accepted Answer · 2016-09-21 06:15:30Z

0

I believe you have to add that mssql extension in order to use that... but you can Use PDO if you want to.. follow the link here

http://php.net/manual/en/ref.pdo-dblib.php

answered Sep 21, 2016 at 6:15

Emz

5421 gold badge4 silver badges11 bronze badges

2 Comments

Bilal Zafar Over a year ago

I have added the extenion in the folder and also in php.ini file

Emz Over a year ago

The extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the MySQLi or PDO_MySQL extension should be used ---From PHP.NET

Bilal Zafar · Accepted Answer · 2016-09-21 07:50:16Z

0

Issue Solved:

I have used extension=php_odbc.dll

with this code:

$server = '****';
    $user = '****';
    $pass = '****';
    //Define Port
    $port='Port=1433';
    $database = 'cargo_web';

    $connection_string = "DRIVER={SQL Server};SERVER=$server;$port;DATABASE=$database";
    $conn = odbc_connect($connection_string,$user,$pass);
    if ($conn) {
        echo "Connection established.";
    } else{
        die("Connection could not be established.");
    }

edited Sep 21, 2016 at 7:50

answered Sep 21, 2016 at 7:08

Bilal Zafar

4577 silver badges20 bronze badges

Collectives™ on Stack Overflow

Connect PHP with MS SQL SERVER

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related