PHP ADODB Delete Record

PHP ADODB Delete Record

Delete multiple or single record.

Syntax ADODB

$sql = "DELETE FROM user_infor WHERE email=?";
$conn1->Execute($sql, array('[email protected]');

Example 1

<?php

include 'adodb5/adodb.inc.php';

$host = 'localhost';
$user = 'user2000';
$pass = 'password2000';
$dbname = 'w3cyberlearning';

$conn1 = &ADONewConnection('mysql');
$conn1->PConnect($host, $user, $pass, $dbname);

$sql = "DELETE FROM user_infor WHERE email=?";

$my_data = array(
	 array('[email protected]'),
	 array('[email protected]')
);

for ($i = 0; $i < count($my_data); $i++) {
	$d = $conn1->Execute($sql, $my_data[$i]);
	if (!$d) {
		print 'error' . $conn1->ErrorMsg() . '<br>';
	} else {
		echo 'Success! Delete';
		echo "<br/>";
	}
}
?>

Related Links

• PHP ADODB Example
• PHP Tutorial
• Tutorial Home

---

• PHP ADODB Tutorial
• PHP ADODB Connect
• PHP ADODB Create Table
• PHP ADODB Insert Records with Place Holder

• PHP ADODB Insert and Custom Function
• PHP ADODB Select Record
• PHP ADODB FETCH ASSOC
• PHP ADODB FETCH NUM

• PHP ADODB FETCH BOTH
• PHP ADODB Update with place holder
• PHP ADODB Update and Custom Function
• PHP ADODB RecordSet Filters

• PHP ADODB Export in CSV
• PHP ADODB Delete Record
• PHP ADODB Tutorial with HTML