Below is a simple PHP script to demonstrate how to
connect to an MS Access database using ODBC DSN. For more information
on ODBC with PHP, please review the following:
| <html> |
| <head><title>PHP Access TEST</title></head> |
| <body> |
| <h2>Access Database / DSN Test</h2> |
| <table border="1"> |
| |
| <?php |
| $DSN="myODBC_DSN"; |
| $DSN_User=""; |
| $DSN_Passwd=""; |
| $QueryString="SELECT id, FirstName, LastName, Email FROM tblContact"; |
| |
| $Connect = odbc_connect( $DSN, $DSN_User, $DSN_Passwd ); |
| $Result = odbc_exec( $Connect, $QueryString ); |
| |
| echo "\t" . "<tr>\n"; |
| echo "\t\t" . "<td>id</td><td>FirstName</td><td>LastName></td><td>Email</td>" . "\n"; |
| |
| while( odbc_fetch_row( $Result ) ) |
| { |
| $id = odbc_result($Result,"id"); |
| $FirstName = odbc_result($Result,"FirstName"); |
| $LastName = odbc_result($Result,"LastName"); |
| $Email = odbc_result($Result,"Email"); |
| |
| echo "\t" . "<tr>\n"; |
| echo "\t\t" . "<td>" . $id . "</td><td>" . $FirstName . "</td><td>" . $LastName . "</td><td>" . $Email . "</td>\n"; |
| echo "\t" . "</tr>\n"; |
| } |
| |
| odbc_free_result( $Result ); |
| odbc_close( $Connect ); |
| ?> |
| </table> |
| </body> |
| </html> |
Article ID: 175, Created: July 25, 2012 at 12:45 AM, Modified: July 25, 2012 at 12:45 AM