This is my first PHP page, and I've created an HTML form to insert
records into an Access 2000 database using PHP 4.3.3. I've been
looking online here and other places all week, and can't seem to
find a complete example of what I want to do (most DBs used
with PHP are MySQL).
PHP is working on our server, but my page doesn't work - just a
blank page comes up when I click SUBMIT on my form.
My PHP page code is below. Any help is greatly appreciated!!!
<?
$db = 'c:\Web\Data\test.mdb';
$conn = new COM('ADODB.Connection');
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db;");
$sql = "INSERT INTO tblSubmittals (EMAIL,DATE_ENTER,ADDRESS,CITY,ZIPCODE,COUNTY,ZONE,Y,X) VALUES('$POST["EMAIL"]', date(), '$POST["ADDRESS"]', '$POST["CITY"]', '$POST["ZIPCODE"]', '$POST["COUNTY"]', '$POST["ZONE"]', '$POST["Y"]', '$POST["X"]')";
?>
