//一个显示数据的例子,其它类似。
<?php
$cn=mssql_connect("192.168.0.9","sa","");
mssql_select_db("Northwind",$cn);
$sql="select * from Products";
$rs=mssql_query($sql,$cn);
$numrows=mssql_num_rows($rs);
?>
<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<$numrows;$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>
<?php
$cn=mssql_connect("192.168.0.9","sa","");
mssql_select_db("Northwind",$cn);
$sql="select * from Products";
$rs=mssql_query($sql,$cn);
$numrows=mssql_num_rows($rs);
?>
<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<$numrows;$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>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货