note 56339 added to function.dbase-delete-record

From: Date: Wed, 31 Aug 2005 06:06:57 +0000
Subject: note 56339 added to function.dbase-delete-record
Groups: php.notes 
Request: Send a blank email to php-notes+get-94479@lists.php.net to get a copy of this message
Hello, I Have a PHP script with a database. My php script is: <?php // Laat alle errors zien error_reporting(E_ALL); // Definities benodigt voor ADO-connectie define('adCmdStoredProc', 4); define('adOpenStatic', 3); define('adUseClient', 3); define('adLockOptimistic', 3); define('adLockreadOnly', 1); define('adOpenForwardOnly',0); // Database initialiseren $conn = new COM('ADODB.Connection'); $db = 'mdb.mdb'; $conn->CursorType = adOpenForwardOnly; $conn->CursorLocation = 3; $conn->LockType = 1; $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)};Persist Security info=false; DBQ=$db"); // Include de FormHandler libs include 'FH3/class.FormHandler.php'; // Functie welke wordt aangeroepen na het opslaan function FH_handle($id, $data) { header('location:index.php'); } // Toon lijst $sql = "SELECT * FROM mdb ORDER BY naam"; $rs = $conn->Execute($sql); ?> <table border="1"> <tr> <th>Naam</th> <th>Adres</th> <th>Woonplaats</th> <th>&nbsp;</th> <th>&nbsp;</th> </tr> <? while (!$rs->EOF) { ?> <tr> <td><?= $rs->Fields['naam']->Value; ?></td> <td><?= $rs->Fields['adres']->Value; ?></td> <td><?= $rs->Fields['woonplaats']->Value; ?></td> <td><a href="?id=<?=$rs->Fields['id']->Value;?>">Bewerk</a></td> <td><a href="?id=<?=$rs->Fields['id']->Value;?>">Delete</a></td> </tr> <? $rs->MoveNext(); } ?> </table> <? // Start een nieuw formulier gebaseerd op FormHandler $form = &new FormHandler(); // Gebruik de Access-database, tabel mdb $form->dbInfo('mdb.mdb', 'mdb', 'access'); $form->dbConnect('', '', ''); // De formuliervelden $form->TextField('Naam', 'naam', FH_STRING); $form->TextField('Adres', 'adres', FH_STRING); $form->TextField('Woonplaats', 'woonplaats', FH_STRING); $form->SubmitButton('Opslaan'); // Wat gebeurt er na het opslaan? $form->onSaved('FH_handle'); // Zet het formulier op het scherm $form->Flush(); ?> ---------------------------------------------- I can fill in data and than is it in de Database. My Question is: How can I Delete a record from my page, what are the codes exactly? Also thnx, Eva ---- Manual Page -- http://www.php.net/manual/en/function.dbase-delete-record.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+56339 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+56339&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+56339&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+56339&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+56339&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+56339&report=yes&reason=non-english Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+56339&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+56339&report=yes Search -- http://master.php.net/manage/user-notes.php

« previous php.notes (#94479) next »