MS Access

Anon

I am very new to PHP. I have been building in ASP for some time now and most of my database applications run on Access.

What is wrong with this code that should just get the information from the database and write it into a table?

'----------------------Code------------------
<table cellpadding="5" border="1">
<?php
$dbh = dbmopen( "/databases/officelist.mdb", "r" ) or die ( "Couldn't open DBM" );

$key = dmbfirstkey( $dbm );

While ($key != "" )
{
$value = dbmfetch( $dbh, $key )
print "<tr><td> $key </td>";
print "<td align="right"> \$$value </td></tr>";
$key = dbmnextkey ( $dbh, $key );
}
dbmclose( #dbh );
?>
</table>

yyogev

Why not use ODBC with a simple SQL query ? ODBC is a general solution, so you could easily switch to a different type of database.

e.g.

// NOTE: DSN, SQL_USERNAME, SQL_PASSWORD are set using define(),
// in some PHP source file used to keep definitions
$conn = odbc_connect( DSN, SQL_USERNAME, SQL_PASSWORD );

$query = "SELECT storeNumber FROM stores" ;

$result = odbc_exec($conn,"$query")
or die("problems in SQL query execution<BR>$query");

$num = odbc_num_rows($result);

echo "
<TABLE>
<TR><TD>Store Number</TD></TR>
for ( $i=1 ; $i <= $num ; $i++ )
{
$row = odbc_fetch_row($result,$i);
$storeNumber = odbc_result($result,"storeNumber");
echo "<TR><TD>$storeNumber</TD></TR>" ;
}
echo "
</TABLE>" ;

Hope this helps

Yaron

Anon

Thank you. That is exactly what I needed, except I would need to use a DSN-less connection. How can I use a relative? In ASP I would write ..

& Server.MapPath("database/db1.mdb")

intead of..
c:\inetpub\wwwroot\database\db1.mdb

Thanks for any help.