lettura dal db con ODBC:

<?
$dbname="nome_database.mdb";
$query="SELECT * FROM utenti";
$connessione=new COM("ADODB.Connection");
$connessione->Open("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:/Programmi/EasyPHP/www/php e access /$dbname");
$rs=$connessione->execute($query);
if (!$rs->EOF)
{
while (!$rs->EOF)
{
$campo1=$rs->fields("nome");
$campo2=$rs->fields("cognome");
$campo3=$rs->fields("email");
echo $campo1->value."
";
echo $campo2->value."
";
echo $campo3->value."
";
$rs->movenext();
}
}
$rs->close;
?>


scrittura sul db con ODBC:


<?
$dbname="nome_database.mdb";
$query="insert into utenti (nome,cognome)
values ('Mario','Rossi')" ;
$connessione=new COM("ADODB.Connection");
$connessione->Open
("DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=C:/Programmi/EasyPHP/www/php e access /$dbname");
$rs=$connessione->execute($query);
?>


eliminare record



<?
$dbname="nome_database.mdb";
$query="DELETE FROM guestbook where id = $ID ";
$connessione=new COM("ADODB.Connection");
$connessione->Open
("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:/Programmi/EasyPHP/www/php e access/$dbname");
$rs=$connessione->execute($query);
?>


la variabile $ID la assegni tu tramite form (è il record che vuoi eliminare)

spassiadì