µ±Ç°Î»ÖãºLinux½Ì³Ì - Php - PHPÀûÓÃCOM¶ÔÏó·ÃÎÊSQLServer¡¢Access

PHPÀûÓÃCOM¶ÔÏó·ÃÎÊSQLServer¡¢Access

PHP4.0.6ÒÔÉÏ¿ÉÒÔÔÚ Win32 ƽ̨ÖзÃÎÊ COM ºÍ DCOM ¶ÔÏó¡£ÕâÀï½èÓÃASP˼Ïë·ÃÎÊÒ»ÏÂSQLServer¡£µ±È»ÄãÒ²¿ÉÒÔÓÃmssqlϵÁк¯Êý¡£Èç¹ûÊÇÒ»¸öASP Coder£¬Äã»á¾õµÃÏÂÃæ´úÂë·Ç³£ÑÛÊ죬ϰ¹ß----ÎÞËû£¬µ«PHPÇ¿¶û~_~£º
<?php
//Author:    erquan
//Date:        2003-3-4
//City:Ö£ÖÝ

    $dbConn=new COM ("ADODB.Connection") or die("´´½¨COMʧ°Ü");
    $ADO="Provider=sqloledb;Data Source=localhost;Initial Catalog=myTest;User Id=sa;Password=sa;";
         //AccessÈç:$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("´´½¨RSʧ°Ü");
    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;
?>

ÔõôÑù£¬ºÜ¼òµ¥°É£¿¶ÔÓÚASP Coder£¬ÍòһͻȻÄãµÄBOSS½Óµ½Ò»¸öPHPÏîÄ¿µÄµ¥×Ó£¬ÄãÒ²²»±Ø¾ª»Å£¬»¨Ò»µãʱºòÄãÒ²¿ÉÒÔ˳ÀûµØ½øÐпª·¢ÁË~

·ÃÎÊSQLServerµÄ´æ´¢¹ý³Ì£¬Ò²ºÍASPµÄ×ö·¨¼¸º