Home > DeveloperSection > Blogs > Accessing SQL server database with PHP

Accessing SQL server database with PHP

0 Comment(s)
 2938  View(s)
Rate this:

Accessing SQL server database with PHP

The Microsoft SQL Server 2005 Driver for PHP allows PHP developers to access data in SQL Server databases. The driver includes support for Windows and SQL Server Authentication methods, transactions, parameter binding, streaming, metadata access, connection pooling, and error handling.

To access the data from SQL server database you have to perform some changes in php.ini file.

Change 1: Put the extension file (php_sqlsrv.dll or php_sqlsrv_ts.dll) in the PHP extension directory. If you are running the non-thread-safe version of PHP (php5.dll), you should use the non-thread-safe version of the driver (php_sqlsrv.dll).

Change 2:  Uncomment the extension=php_sqlsrv.dll or php_pdo_mssql.dll in php.ini file.

After performing these changes restart your web server.


Here I’m creating an example for connecting PHP script with SQL server. In this example, simply I’m retrieving data from MS-SQL table and print it.



               // SQL server connection string information

                $serverName = "XXXX";

                $userName = "XXXX";

                $password = "XXXX";

                $db_Name = "MyDatabase";

                // connect with SQL server database

                $conn = mssql_connect($serverName, $userName, $password)

                        or die ("Database cannot connected successfully");

           // Select SQL database

                $selectDB = mssql_select_db($db_Name, $conn)

                            or die("Database cannot be opended");

                 // SQL server query

                $qry  = "select Name, ContactNo, EmailId from tblLogin";

                // Execute Query

                $qry_result = mssql_query($qry);

      // exatract table value

                while($row = mssql_fetch_array($qry_result))


                    // print table value

                 echo $row['Name'].'\t\t';

                     echo $row['ContactNo'].'\t\t';

                     echo $row['EmailId'];


                // Close connection with SQL server database



Don't want to miss updates? Please click the below button!

Follow MindStick