php連接Access實例代碼

<?php
$connStr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("code.mdb");
$connId = odbc_connect($connStr,"","",SQL_CUR_USE_ODBC);
$odbc_exec = odbc_exec($connId, "insert into class1 (id,name) values('06','第六項')");

$query = odbc_do($connId, "select * from class1");
$odbc_result_all = odbc_result_all($query);
echo $odbc_result_all;
?>

運行方式：請修改相應參數。