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.

Example:

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.

<?php
               // 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
                mssql_close();
        ?>