Page 1 of 1

Accessing MSSQL with PHP

Posted: Tue Aug 09, 2011 5:18 am
by phpjoy
Hi, I am trying to access the SQL Server 2005 with PHP. For that I have activated IIS 7 on the windows small business server, for PHP. Now I have the following code for local web hosting :

=====================================


<head>
<meta http-equiv="refresh" content="2";url="index.php";>
<title>Trial 1</title>

</head>
<h1>
:: B List ::
</h1>


<?php

$now = time();
echo $now;

$link = mssql_connect("SRVR name", "local host \ user name", "password");

if (!$link)
{
die('ERROR: Could not connect');
}


mssql_select_db('database name', $link);


$query = mssql_query('SELECT B_No, FROM dbo.B_LIST WHERE B_No = 000011', $link);

if (!$query)
{
die('MSSQL error');
}

$row = mssql_fetch_row ($query);


echo $row;


?>


<body>
</body>
</html>
=========================================

In this I am just trying to print one row from the database on the webpage
Correct me if I am wrong, as I am coding PHP for the first time with online help.

When I try to access the webpage on the explorer I only get the title and the page if refreshed every 2 seconds , and the time is displayed. Nothing is available from database.

Re: Accessing MSSQL with PHP

Posted: Tue Aug 09, 2011 12:37 pm
by califdon
http://www.php.net/manual/en/function.mssql-connect.php
Your connection command probably needs to look like this:

Code: Select all

$link = mssql_connect("localhost", "root", "abcxyz");
but you have to know what the username and password really are. "root" and "abcxyz" and "SRVR name" are just examples. Your MSSQL installation will surely have different names.