Connecting Microsoft SQL Server using PHP

By SHIVAM KUMAR -
Throwing Steps Right away without wasting much time :
3 things you need to have:
  • WAMP/XAMPP installed on your system to run PHP.
  • SQL Server for creating and connecting to Databases etc.
  • PHP Drivers : For bridging SQL Server and PHP.
Latest version of PHP Drivers can be download from this Download link which now supports PHP version 7.x.

Steps for installing PHP drivers:
  • The file that you will download is a nothing but a zip containing some dll files which are nothing but PHP extensions.
  • Find the PHP extension folder for the version you are using and place the files inside that folder.
  • Next open the Php.ini files for the version in use and add the initialization for the dll/plugins files that you just placed in extensions folder cos without initialization those files are good for nothing.
  • Restart the wamp services.
  • Goto Php extension from wamp menu and select the options which are having the same name as those files.
This completes the installation part and now we are all ready to test the connection.

For testing the connection please use the following code where I have added self explanatory comments about what is being done where ,paste it into notepad and save the file with some name and .php extension  in www /http directory of your wamp/xampp setup.

<html>
<head>  
<title>TestConnection</title>  
</head>  
<body>  
<h1 align='center'>TestConnection</h1>  
<h5 align='center'>
This is a demonstration of Microsoft SQLSRV driver for PHP & SQL Server.
</h5>
<br/>  
<?php  
$serverName = "YourSQLServerName";  
$connectionOptions = array("Database"=>"master");  
/* Connect using windows Authentication. */  
$conn = sqlsrv_connect( $serverName, $connectionOptions);  
if( $conn === false )  
die( FormatErrors( sqlsrv_errors() ) );  
else
echo "<h1 align='center'>Connection Established</h1>  ";
/*Give a little bit formatted error messages in case of failure in connection */
function FormatErrors( $errors )  
{  
    /* Display errors. */  
    echo "<b>Connection Failed, Error information: <br/><br/></b>";  
    foreach ( $errors as $error )  
    {  
        echo "<b>SQLSTATE:</b>".$error['SQLSTATE']."<br/>";  
        echo "<b>Code:</b>".$error['code']."<br/>";  
        echo "<b>Message:</b>".$error['message']."<br/>";  
    }  
}
/* Free the connection resources. */  
sqlsrv_close( $conn );  
?>
</body>
</html>
Now launch your browser and visit the URL http:\\localhost\YourFileName.php
This should flash the connection established message which means your playground is ready and now what game you play on it depends on you.
I hope this helps !

Comments

Post a Comment

Note:Please be gentle while commenting and avoid spamming as comment are anyways moderated thank you.

Popular posts from this blog

Enabling fixed Sidebar for blogger Contempo template for screen sizes smaller than 1440px

By SHIVAM KUMAR -
Image
Here is how to do it : Add this code in your blogger template(where to add this code is mentioned before 2nd code snippet of this post) ,now the value 1300px is the screen size for which I want the sidebar to be always visible for, you can reduce this value as you like, but be aware that reducing this value to much smaller digit will result in showing the overlapped sidebar instead of content body for your blog readers who are using much smaller screen devices such as mobiles which you might not want to happen so be wise : @media screen and (max-width: 1300px) {   .sidebar-container {     bottom: 0;     position: fixed;     top: 0;   }   .sidebar-container {     left: 0;     right: auto;   }   .sidebar-container.sidebar-invisible {     -webkit-transition-timing-function: cubic-bezier(0.4,0.0,0.6,1);             tra...
Read more

Adding copy to clipboard button to every google code prettify pre blocks in blogger

By SHIVAM KUMAR -
Image
It's a 2 part process: The script part to find all the pre blocks having code in it and append a copy button to it dynamically. The style part to place our copy button at the specified location(on top right of every code block in this case) The script part: <script> var pre = document.getElementsByTagName('pre'); for (var i = 0; i < pre.length; i++) {             var button = document.createElement('button');                     button.className = 'copy-button';                     button.textContent = 'Copy';                     var s = pre[i].innerText;             ...
Read more

Adding Home Older Newer Post Buttons in new Blogger templates such as Contempo

By SHIVAM KUMAR -
Image
Requirement: Add Home, Older, Newer Post Buttons in new Blogger templates such as Contempo. Solution: Hi for this jump to Blog widget in HTML editor of your template and find and replace code in includables with respective id's with the ones given below also change the order of buttons as shown below in postPagination includable as per your needs. Code given below shows button in this order   Older Posts Home Newer Posts Demo: Can be seen by clicking here and scrolling to end of page. Screenshot: Note: First page will display only Older posts button as there is nothing to go back when we are on landing or home page and the last page will display Previous posts button and the Home button as there is nothing left to go forward. Displays buttons in order provided here in frontend ,ID to search postPagination: <b:includable id='postPagination'> <div class='blog-pager container' id='blog-pager'> <b:include cond='data:new...
Read more