Connect to MsSQL Database using PHP
Connect to MsSQL Database using PHP, this is a simple article for connecting to MSSQL Database using PHP. Here we are using two functions one is mssql_connect and mssql_select_db functions. mssql_connect is used for connecting to database, and mssql_select_db is used for selecting db. Use this code for connecting to mssql database using php.
While connecting to Mssql database you need these credentials.
- Host Name
- Database User Name
- Database Password
While selecting database, you need to have database name.
// Create a link to MSSQL
$link = mssql_connect(‘hostname’, ‘dbuser’, ‘dbpass’);
// Select the database ‘php’
Just use this code for connecting to mssql database using php.