PHP DSN-Less equivalent to this:

Anon

Here is the code in ASP:

<BODY>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("pruebas.mdb")
MyConn.Open "Driver={Microsoft Access Driver (.mdb)}; DBQ=" & MdbFilePath & ";"
SQL_query = "SELECT FROM usuarios"
Set RS = MyConn.Execute(SQL_query)
WHILE NOT RS.EOF
%>
<LI><%=RS("nombre")%>: <A HREF="<%=RS("nombre")%>">Homepage</A>
<%
RS.MoveNext
WEND
%>
</BODY>

Could you give me the equivalent code in PHP

Anon

ooops....

Thank you

joaomc

I guess this is what you want:

$dbc = new COM("ADODB.Connection");
$dbc->Open("Driver={Microsoft Access Driver (*.mdb)}; DBQ=".$pathdomdbfile .";");

$rs = $dbc->Execute("select * from usuarios");

while(!$rs->EOF)
{
$nombre = $rs->Fields["nombre"];
print $nombre . ": <A HREF=\"" . $nombre . "\">Homepage</a>";

$rs->MoveNext();
}

Anon

I still have a problem with the path, I think, I get this kind of error:

Warning: Invoke() failed: Ocurrió una excepción. in C:\Softvision\pruebasPhp.php on line 4

How should I point to the DB path?

Thank you.

Pepe

joaomc

Maybe it's requiring the full path to the DB.

Try the realpath function
Eg: $realpathtodb = realpath($pathtodb);