NinethSense

/* This example shows how to open and do operations on a Microsoft Access Database using PHP odbc functions */

$db_connection = odbc_connect("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=E:rootphpDataBase.mdb", "ADODB.Connection", "password", "SQL_CUR_USE_ODBC");

echo "

";
$result = odbc_tables($db_connection);

while (odbc_fetch_row($result)) {
if(odbc_result($result,"TABLE_TYPE")=="TABLE") {
echo "
" . odbc_result($result,"TABLE_NAME");
}
}
echo "

";

$res = odbc_exec($db_connection,"SELECT *FROM Degree");

$i = 0;
while (odbc_fetch_row($res)) {
$arr = odbc_fetch_array($res,$i);
echo "
" . $arr["code"] . ", ". $arr["comment"];
$i++;
}

echo "

Number of rows = $i

";

odbc_close($db_connection);
?>