如何上PHP支持ms sql2000

通过ODBC连接SQL Server行不行?

解决方案 »

  1.   

    应该支持吧要不PHP里面的SQLSERVER函数就没用了ODBC是肯定支持的，我用过
      

  2.   

    <?php 
    $cn=mssql_connect("ANDY","sa","");
    mssql_select_db("Northwind",$cn);
    $sql="select top 50 * from Products";
    $rs=mssql_query($sql,$cn);
    ?>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
    <title>无标题文档</title>
    </head><body>
    <table width="80%" height="25" border="1" cellpadding="0" cellspacing="0">
        <tr>
            <td width="8%" height="18">ProductID</td>
            <td width="10%">ProductName</td>
            <td width="10%">SupplierID</td>
            <td width="9%">CategoryID</td>
            <td width="13%">QuantityPerUnit</td>
            <td width="8%">UnitPrice</td>
            <td width="11%">UnitsInStock</td>
            <td width="12%">'UnitsOnOrder</td>
            <td width="10%">ReorderLevel</td>
            <td width="9%">'Discontinued</td>
        </tr><?php 
    for ($i=0;$i<50;$i++){
    $arr=mssql_fetch_array($rs);
    echo "<tr>";
    echo "<td>".$arr['ProductID']."</td>";
            echo "<td>".$arr['ProductName']."</td>";
            echo "<td>".$arr['SupplierID']."</td>";
    echo "<td>".$arr['CategoryID']."</td>";
            echo "<td>".$arr['QuantityPerUnit']."</td>";
    echo "<td>".$arr['UnitPrice']."</td>";
            echo "<td>".$arr['UnitsInStock']."</td>";
            echo "<td>".$arr['UnitsOnOrder']."</td>";
            echo "<td>".$arr['ReorderLevel']."</td>";
            echo "<td>".$arr['Discontinued']."</td>";
    echo "</tr>";
    }
    ?>
    </table>
    </body>
    </html>