PHP操作ACCESS和操作MySQL竟然完全不同
PHP操作ACCESS和操作MySQL竟然完全不同.操作ACCESS代码写法竟与ASP有极大的相似. 对比一下看: MySQL数据库: <?php $QUERY_SQL = mysql_query("select * From ClassName Order by ClassArray DESC"); $Class_All = mysql_num_rows($QUERY_SQL); if($Class_All>=0){ $Product = "yes";
print("<img src=\"images/pic01.gif\" ><span style=\"cursor:hand\"><span id=foldheader>"); print(" 产品展示 - 展开</span></span><span id=foldinglist style=\"DISPLAY: none\">");
while($Class_All2 = mysql_fetch_array($QUERY_SQL)){ print(" <img src=\"pic/pic01.gif\" width=9 height=11 border=0> "); print("<a href=\"products.php?ClassID=".$Class_All2["ClassID"]."&Class_name=".$Class_All2["Class_name"]."&season=".$Class_All2["seasonClass"]."\" target=_self>".$Class_All2["Class_name"]."</A>"); } mysql_free_result($QUERY_SQL); } ?>
ASP ACCESS数据库: <% set rs = server.CreateObject("adodb.RecordSet") rs.Open("Select * From ClassName order by ClassArray DESC"),conn,1,1 if rs.EOF then response.write"" rs.close else Product = "yes" Class_All=rs.recordcount ' end if
response.write"<img src=""images/pic01.gif"" ><span style=""cursor:hand""><span id=foldheader>" response.write" 产品展示 - 展开</span></span><span id=foldinglist style=""DISPLAY: none"">"
while not rs.eof
response.write" <img src=""pic/pic01.gif"" width=9 height=11 border=0>" response.write" <a href=""products.asp?ClassID="&rs("ClassID")&"&Class_name="&rs("Class_Name")&"&season="&rs("seasonClass")&""" target=_self>"&rs("Class_Name")&"</A>"
rs.movenext wend rs.close
%>
下面是PHP操作 ACCESS数据库 <?php $rs = NEW COM("adodb.RecordSet"); $rs->Open("Select * From ClassName order by ClassArray DESC",$conn,1,1); if ($rs->EOF) { //print"" $rs->close; } else { $Product = "yes"; $Class_All=rs.recordcount;// ' }
print"<img src=\"images/pic01.gif\" ><span style=\"cursor:hand\"><span id=foldheader>"; print" 产品展示 - 展开</span></span><span id=foldinglist style=\"DISPLAY: none\">";
while(!$rs->eof) {
print" <img src=\"pic/pic01.gif\" width=9 height=11 border=0>"; print" <a href=\"products.php?ClassID=".$rs["ClassID"]."&Class_name=".$rs["Class_Name"]."&season=".$rs["seasonClass"]."\" target=_self>".$rs["Class_Name"]."</A>";
$rs->movenext; } $rs->close; ?>
|