How do I get mssql_connect to work using PHP7?

Question

While porting a web app to a server using PHP7, I encounter one problem: I can't get mssql_connect to work. I found out that mssql doesn't work yet (or will never work) on PHP7.

What's the quickest way to connect to MSSQL using PHP7 on Ubuntu (Nginx, php-fpm)?

Answer 1

The connection function is not mssql_connect() anymore. Since php 5.3 it's been deprecated. Now on php 7 this old function vanishes. But don't worry ;) Nowadays you can use the sqlsrv_connect() function instead.

Keep in mind that in the new method you need to set up the parameters properly. There are some differences. Here comes a little example.

<?php
$serverName = "serverName\sqlexpress, 1542"; //serverName\instanceName, portNumber (1433 by default)
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if( $conn ) {
     echo "Successfuly connected.<br />";
}else{
     echo "Connection error.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

May be this answer comes a bit late for you but I hope it is not too late for someone.