12.5 The MSSQL Module

SQL Server is a powerful relational database system put out by the folks at Microsoft. Because of its speed and power, SQL Server is a popular choice among many Windows NT developers. It is used with PHP on large applications, such as Marriot's m3 extranet system.

 DB/mssql.php <?php include_once("DB/mssql.php"); function db_connect($args=array()) {     switch (count($args)) {         case 0:             return mssql_connect($args[0]);         case 1:             return mssql_connect($args[0], $args[1]);         case 2:             return mssql_connect($args[0], $args[1], $args[2]);     } } function db_pconnect($args=array()) {     switch (count($args)) {         case 0:             return @mssql_connect();         case 1:             return @mssql_connect($args[0]);         case 2:             return @mssql_connect($args[0], $args[1]);         default:             return @mssql_connect($args[0], $args[1], $args[2]);     } } function db_select_db($args=array()) {     if (isset($args[1])) {         return @mssql_select_db($args[0], $args[1]);     }     return @mssql_select_db($args[0]); } function db_close($args=array()) {     if (isset($args[1])) {         return @mssql_close ($args[0]);     }     return @mssql_close(); } function db_query($args=array()) {     if (isset($args[1])) {         return @mssql_query($args[0], $args[1]);     }     return @mssql_query($args[0]); } function db_db_query($args=array()) {     return db_query($args[0], $args[1]); } function &db_fetchrow($args=array()) {     return @mssql_fetch_array($args[0]); } function db_prepare($args=array()) {     return db_simulate_prepare($args); } function db_execute($args=array()) {     $stmt = db_simulate_execute(&$args);     return db_query(array($stmt, array_shift ($args))); } function db_num_rows($args=array()) {     return @mssql_num_rows($args[0]); } function db_free_result($args=array()) {     return @mssql_free_result($args[0]); } function db_commit($args=array()) {     return(true); } function db_rollback($args=array()) {     return(false); } function db_autoCommit($args=array()) {     return($args[1]); } ?>

Explanation

The MSSQL extension for PHP is about as straightforward as it gets. It's a simple wrapper for the mssql* functions, and is identical to the MySQL module.