Sign in to follow this  
hdigital

PHP and MSSQL

Recommended Posts

My "Connection_inc.php" file is formatted for MySQL.

Does anybody know the code to connect to a MSSQL Database using PHP.

or any other suggestions to connect to a MSSQL Database other than ASP

<?php

// In this page, we open the connection to the Database

// Our MySQL database (blueprintdb) for the Blueprint Application

// Function to connect to the DB

function connectToDB() {

  // These four parameters must be changed dependent on your MySQL settings

  $hostdb = 'localhost'; // MySQl host

  $userdb = 'username';   // MySQL username

  $passdb = 'password';   // MySQL password

  $namedb = 'blueprint'; // MySQL database name

  $link = mysql_connect ($hostdb, $userdb, $passdb);

  if (!$link) {

  // we should have connected, but if any of the above parameters

  // are incorrect or we can't access the DB for some reason,

  // then we will stop execution here

  die('Could not connect: ' . mysql_error());

  }

  $db_selected = mysql_select_db($namedb);

  if (!$db_selected) {

  die ('Can't use database : ' . mysql_error());

  }

  return $link;

}

?>

Regards,

Dan

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this