ASP to PHP language problems
| From: | Alistair Hayward | Date: | Wed, 10 Mar 2004 22:26:03 +0000 |
| Subject: | ASP to PHP language problems | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-180056@lists.php.net to get a copy of this message | ||
Hi ,
What is the equavilant in PHP to creating a recordset in ASP using a query?
This is what I do in PHP:
..................................
dim Type
Type = CStr(Request.QueryString("action")) (getting parameter from URL)
Dim cnn ' ADO connection
Dim rst ' ADO recordset
Dim strDBPath ' path to my Access database (*.mdb) file
strDBPath = Server.MapPath("/_database/database.mdb")
Set cnn = Server.CreateObject("ADODB.Connection")
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & ";"
Set rst = cnn.Execute("SELECT * FROM table WHERE Type ='" & type & "' order by style")
..........................................
I can then call any field and display it in the html by using :
<%=rst.fields("whatever").value%>
..........................................
I can also create a loop:
<%Do While Not rstSimple.EOF%>
do something
<%
rstSimple.MoveNext
Loop
%>
............................................
Please can someone show me how to do the same thing in PHP?
Alistair