I have a web site written in ASP utilizing Access databases and I want to convert it to PHP. My web server is a Windows 2000 server using IIS 5, and I installed PHP 5.1.2.
Here is sample code from a page that reads data from one of the databases and displays it in a table. How can I convert this to PHP?
I can make this code work in php using MySQL, but I can't wrap my head around how to get PHP to talk to the Access database.Code:<% set myconn = server.createobject("adodb.connection") dbpath = server.mappath("databases/Stables.mdb") MyConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & dbpath & ";" set result = server.createobject("adodb.recordset") sql = "SELECT * FROM Stables ORDER BY Stable_Name" set result = myconn.execute(sql) response.write("<p>") response.write("<table border=0 width='40%' cellpadding=3 cellspacing=0 align=center class=tbl1bgColor>") response.write("<tr>") response.write("<td width='55%' class=searchRHeadings align=left nowrap>") response.write("<p align=center><strong>Stable</strong>") response.write("<td width='10%' class=searchRHeadings align=center nowrap>") response.write("<p align=center><strong>Silks</strong>") response.write("<td width='25%' class=searchRHeadings align=left nowrap>") response.write("<p align=center><strong>Country</strong>") response.write("</tr><tr>") z=1 while not result.EOF if (z mod 2=0) then className="tdResultsRow1 " else className="tdResultsRow2 " end if If result("Web") then response.write("<td width='55%' class='" & classname & "' align=left nowrap><a href=" & result("Site") & ">" & result("Stable_Name")) Else response.write("<td width='55%' class='" & classname & "' align=left nowrap>" & result("Stable_Name")) End IF If result("Silks") then response.write("<td width='10%' class='" & classname & "' align=right nowrap><img src='images/Silks/" & result("Stable_ID") & ".gif'>") Else response.write("<td width='10%' class='" & classname & "' align=right nowrap>") End if response.write("<td width='25%' class='" & classname & "' align=left nowrap>" & result("Location")) response.write("</td>") result.movenext() response.write("</tr>") z=z+1 wend response.write("</table>") %>




Reply With Quote