php5 with msSQL

minglam

I am totally new to php. I just installed php on my Win2k/SQL server and tested it with some basic functions. They work fine. What I'm really interested in is interface with SQL. I found the example below and create user northwind for northwind database with no password and readonly. I create the ODBC link and it connected fine. I launch the code below but error results as described below. Why did connection fail?

<html>
<body><?php
$conn=odbc_connect('northwind','','');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);
if (!$rs)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while (odbc_fetch_row($rs))
{
$compname=odbc_result($rs,"CompanyName");
$conname=odbc_result($rs,"ContactName");
echo "<tr><td>$compname</td>";
echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?></body>
</html>

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'.
Reason: Not associated with a trusted SQL Server connection.,
SQL state 28000 in SQLConnect in c:\Inetpub\wwwroot\odbcTest.php on line 3
Connection Failed:

Blulagoon

This may not be the best way of doing things, but it works for me OK and a couple of fairly heavy duty apps I've written running under PHP 4.4 and IIS 6 on Windows 2003 Server 😃

To connect to the database, (I keep the values in an inc file outside of inetpub)
$link = @mssql_connect($dbHost, $dbUser, $dbPass);
$dbselect = @mssql_select_db($dbName);

To perform a query (copied from a rather long script .....)
$query6 = "Select max(benchid) as benchid from benchmarks where requestorid='".$userid."'";

$result6 = mssql_query($query6);
$row6 = mssql_fetch_array($result6);
$benchid = $row6['benchid'];

For looping through the array you also have
while($row = mssql_fetch_array($result)) {
$linenum = $row['linenum'];
echo $linenum;
echo "<br>";
}

Nice thing about coding it like this is that search and replace mssql with mysql and you've got code that works with mysql.

You do need to check phpinfo() that you have enabled support for mssql, you do this via the appropriate extensions dll.

Hope this helps,
Blu