Connecting to ODBC and PHP

# connect to a DSN "mydb" with a user and password "marin"
$connect = odbc_connect("mydb", "marin", "marin");


# query the users table for name and surname
$query = "SELECT name, surname FROM users";


# perform the query
$result = odbc_exec($connect, $query);


# fetch the data from the database
while(odbc_fetch_row($result)){
 $name = odbc_result($result, 1);
 $surname = odbc_result($result, 2);
 print("$name $surname\n");
}


# close the connection
odbc_close($connect);
?>

PHP Database ODBC Connection

ODBC is an Application Programming Interface (API) that allows you to connect to a data source (e.g. an MS Access database).

Create an ODBC Connection

With an ODBC connection, you can connect to any database, on any computer in your network, as long as an ODBC connection is available.

Here is how to create an ODBC connection to a MS Access Database:

1. Open the Administrative Tools icon in your Control Panel.
2. Double-click on the Data Sources (ODBC) icon inside.
3. Choose the System DSN tab.
4. Click on Add in the System DSN tab.
5. Select the Microsoft Access Driver. Click Finish.
6. In the next screen, click Select to locate the database.
7. Give the database a Data Source Name (DSN).
8. Click OK.