Jim,
The table is very basic and query must be in SQL so no benefit or reason to use Access.
If you have access to phpMyAdmin I’d use that. Scholar and other materials available. Peter Liddle has set one up anyone can create an account and use http://highercomputingscience.org/
If you must use Access you still need a php webserver. Then configure php.ini to enable the PDO odbc driver. You put the .accdb file on server with .php pages. Can then use PDO to connect and query the database in php. It’s pretty similar to any MySQL examples just slightly different syntax. (The tough part is writing the php to process and validate the form, generate valid SQL then display results in a table )
here’s an example php script to display a simple table from an access database (single table called Pupils with Forename, Surname and House fields , any other fields in results are ignored)
Code:
$dbFile = realpath(“pupils.accdb”);
$sql = “SELECT * FROM pupils”;
$db = new PDO(“odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=$dbFile;”);
$result = $db->query($sql);
$rows = $result->fetchAll();
echo “
“;
echo “
| Forename |
Surname |
House |
“;
Foreach ($rows as $r){
$Forename = $r[“Forename”];
$Surname = $r[“Surname”];
$House = $r[“House”];
echo “
| “.$Forename.” |
“.$Surname.” |
“.$House.” |
“;
}
echo “
“;
$db = null;
PHP is horrible, good luck.
.
