Skip to content
PHP Logo

What are some common methods for accessing and displaying data from an Access database on a website using PHP?

One common method for accessing and displaying data from an Access database on a website using PHP is to establish a connection to the database using the ODBC driver, execute a query to retrieve the desired data, and then display the data on the webpage using HTML and PHP.

php
<?php
// Connect to the Access database using ODBC
$dsn = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};Dbq=path/to/your/access/database.accdb";
$conn = odbc_connect($dsn, '', '');

// Execute a query to retrieve data
$query = "SELECT * FROM table_name";
$result = odbc_exec($conn, $query);

// Display the data on the webpage
echo "<table>";
while ($row = odbc_fetch_array($result)) {
    echo "<tr><td>" . $row['column1'] . "</td><td>" . $row['column2'] . "</td></tr>";
}
echo "</table>";

// Close the connection
odbc_close($conn);
?>