<?php
/*
* include the ADODB library
*/
include('adodb.inc.php');
/*
* Make a new connection to DB
*/
$mydb = &ADONewConnection('access');
$mydb->PConnect('northwind');
/*
* filter input
*/
$shipto = $conn->qstr("John's Old Shoppe");
/*
* generate SQL
*/
$sql = "insert into orders (customerID,EmployeeID,OrderDate,ShipName) ";
$sql .= "values ('ANATR',2,".$mydb->FormatDate(time()).",?)";
/*
*
*
* PRINT THE SQL BEFORE EXECUTING THE QUERY
*
*
*/
$mydb->debug = true;
if ($mydb->Execute($sql, $shipto) === false) print 'error inserting';
?>