microsoft sql server connection and configuration in php

Question

I’m trying to connect to a microsoft sql server database using php. The php version is:

PHP Version 5.6.3

and the error that gives is

Fatal error: Call to Undefined Function mssql_connect() in C: xampp htdocs Aloha.php on line 7**

I tried to use the command:

<?php  
$myServer = "server";
$myUser = "user";
$myPass = "senha";
$myDB = "mydb";

$conn = mssql_connect($myServer,$myUser,$myPass);
if (!$conn)
{ 
die('Not connected : ' . mssql_get_last_message());
} 
$db_selected = mssql_select_db($myDB, $conn);
if (!$db_selected) 
{
die ('Can\'t use db : ' . mssql_get_last_message());
} 
?>  

However it is a mistake, because it seems that my PHP is not configured to connect.

I went in php.ini and uncommented the

extension=php_mssql.dll

but it still didn’t work.

The data from phpinfo found too large to post here, so if you need any specific data ask here.

Answer 1

To documentation informs that this extension is no longer available since php5.3. The recommendation is to use other Apis such as PDO or sqlsrv.

This Extension is not available anymore on Windows with PHP 5.3 or later.

Example with sqlsrv:

<?php
$servidor = 'ip ou servidor\instancia';
$db = 'test';
$usuario = 'user';
$senha = 'pass';        

$conexao = sqlsrv_connect($servidor, array('Database' => $db, 'UID' => $usuario, 'PWD' => $senha));

Related:

PDO Drivers for SQL Server

SQLSRV documentation