PHP info(): MSSQL Support

extension=php_mssql.dll

Example: Testing MSSQL Connection

<?php
$serverName = "localhost";
$connectionOptions = array("Database"=>"myDB", "Uid"=>"user", "PWD"=>"password");
$conn = sqlsrv_connect($serverName, $connectionOptions);
if($conn) {
    echo "Connected to MSSQL!";
} else {
    echo "Connection failed!";
}
?>

mssql_connect() connection ( < PHP 7 or old PHP )

$dbusername='username';

$dbpassword='password';
$servername='servername';
$link = mssql_connect ($servername,$dbusername,$dbpassword);

Example: Querying Data from MSSQL ( < PHP 7 or old PHP )

$dbusername='';
$dbpassword='';
$servername='';
$link= mssql_connect ($servername,$dbusername,$dbpassword);
$query="select * from emp_m ";
$qt=mssql_query($query);
while($nt=mssql_fetch_array($qt)){
echo "$nt[emp_no]"." $nt[name]";
echo "<br>";}

<?php
$query = "SELECT * FROM employees";
$stmt = sqlsrv_query($conn, $query);
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    print_r($row);
}
sqlsrv_close($conn);
?>

Difference Between sqlsrv_query() and mssql_query() in PHP

sqlsrv_query(): Part of the SQLSRV driver, designed to connect PHP to Microsoft SQL Server. It supports advanced features like prepared statements, parameterized queries, and error handling. Recommended for modern PHP versions.

$conn = sqlsrv_connect($serverName, $connectionOptions);
$query = "SELECT * FROM Users";
$result = sqlsrv_query($conn, $query);

mssql_query(): Part of the old mssql extension, deprecated in PHP 7. Limited functionality compared to sqlsrv_query(), and no longer recommended for new development.

$conn = mssql_connect($serverName, $username, $password);
$query = "SELECT * FROM Users";
$result = mssql_query($query, $conn);

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: