PHP uses COM objects to access SQL Server, access_php basics

PHP4.0.6 above you can access COM and DCOM objects in the Win32 platform. Here borrow the ASP idea to visit SQL Server. Of course you can also use the MSSQL series functions. If it is an ASP coder, you will find the following code very familiar, habit----without him, but PHP Changl ~_~:
<?php
Author:erquan
Date:2003-3-4
City: Zhengzhou

$dbConn =new COM ("ADODB. Connection ") or Die (" Create COM Failed ");
$ADO = "Provider=sqloledb;data source=localhost;initial catalog=mytest; User Id=sa; Password=sa; ";
Access such as: $ADO = "Driver={microsoft access DRIVER (*.mdb)}; Dbq= ". Realpath ("Mydb.mdb");
$dbConn->open ($ADO);
if ($dbConn) echo "Create conn OK";
$rs =new COM ("ADODB. RecordSet ") or Die (" Create RS failed ");
echo "<br>";
if ($rs) echo "Create Rs OK";
$sql = "SELECT * from Tb_bs";
$rs->open ($sql, $dbConn, 1, 1);

while (! $rs->eof) {

echo $rs->fields["I_bsid"]->value. ":";
echo $rs->fields["Vc_bsname"]->value;
echo "<BR>";

$rs->movenext ();
}

$rs->close;
$rs =null;

$dbConn->close;
$dbConn =null;
?>

How is it, it's easy? For ASP coder, if suddenly your boss received a list of PHP projects, you do not have to panic, spend a little time you can also successfully developed ~

Accessing SQL Server's stored procedures is almost the same as the ASP's approach.