wpdb::delete( 'table', array( 'ID' => 1 ) )
wpdb::delete( 'table', array( 'ID' => 1 ), array( '%d' ) )
| public delete ( string $table, array $where, array | string $where_format = null ) : integer | false | ||
| $table | string | table name |
| $where | array | A named array of WHERE clauses (in column => value pairs). Multiple clauses will be joined with ANDs. Both $where columns and $where values should be "raw". |
| $where_format | array | string | Optional. An array of formats to be mapped to each of the values in $where. If string, that format will be used for all of the items in $where. A format is one of '%d', '%f', '%s' (integer, float, string). If omitted, all values in $where will be treated as strings unless otherwise specified in wpdb::$field_types. |
| return | integer | false | The number of rows updated, or false on error. |
/**
* Delete a specfic ruleset from database.
*
* @param int $rulesetId Primary key of the ruleset.
* @return bool True if ruleset was deleted or false otherwise.
*/
public function deleteRuleset($rulesetId)
{
if (empty($rulesetId)) {
return false;
}
$deleteResult = $this->wpdb->delete($this->wpdb->rulesets, array('id' => (int) $rulesetId));
return $deleteResult === false ? false : true;
}
/**
* Delete entity from database.
*
* @return int|false
*/
public function delete()
{
if ($this->values['id']) {
return $this->wpdb->delete($this->table_name, array('id' => $this->values['id']), array('%d'));
}
return false;
}
public function save()
{
$staff_id = $this->data['staff_id'];
if ($staff_id) {
$this->wpdb->delete(AB_StaffService::getTableName(), array('staff_id' => $staff_id), array('%d'));
if (isset($this->data['service'])) {
foreach ($this->data['service'] as $service_id) {
$staffService = new AB_StaffService();
$staffService->set('service_id', $service_id);
$staffService->set('staff_id', $staff_id);
$staffService->set('price', $this->data['price'][$service_id]);
$staffService->set('capacity', $this->data['capacity'][$service_id]);
$staffService->save();
}
}
}
}
/**
* Deletes the record of the passed ID
*
* @since 2.0.0
*
* @param int $id ID of the record to delete
*
* @return bool
* @throws Exception
*/
public function remove($id)
{
// Make sure the ID passed is an integer.
if (!is_int($id)) {
throw new Exception(__('A numerical ID must be passed.', 'optin-monster'));
}
// Setup the WHERE clause.
$where = array('lead_id' => $id);
// Delete the record.
if (false == $this->db->delete($this->table, $where)) {
throw new Exception(__('There was an error deleting the lead.', 'optin-monster'));
} else {
return true;
}
}
/**
* @param int $source_site_id
* @param int $target_site_id
* @param int $source_content_id post_id or term_taxonomy_id
* @param int $target_content_id
* @param string $type
* @return int Number of deleted rows
*/
public function delete_relation($source_site_id, $target_site_id, $source_content_id, $target_content_id = 0, $type = 'post')
{
$where = array('ml_source_blogid' => $source_site_id, 'ml_source_elementid' => $source_content_id, 'ml_type' => $type);
$where_format = array('%d', '%d', '%s');
if (0 < $target_site_id) {
$where['ml_blogid'] = $target_site_id;
$where_format[] = '%d';
}
if (0 < $target_content_id) {
$where['ml_elementid'] = $target_content_id;
$where_format[] = '%d';
}
$result = (int) $this->wpdb->delete($this->link_table, $where, $where_format);
do_action('mlp_debug', current_filter() . '/' . __METHOD__ . '/' . __LINE__ . " - {$this->wpdb->last_query}");
return $result;
}
public function drop_subscription($fromsub_id)
{
if (!apply_filters('pre_membership_drop_subscription', true, $fromsub_id, $this->ID) || !$this->on_sub($fromsub_id)) {
return false;
}
// Get the level for this subscription before removing it
$fromlevel_id = $this->get_level_for_sub($fromsub_id);
$this->_wpdb->delete(MEMBERSHIP_TABLE_RELATIONS, array('user_id' => $this->ID, 'sub_id' => $fromsub_id), array('%d', '%d'));
// Update users start and expiry meta
delete_user_meta($this->ID, 'start_current_' . $fromsub_id);
delete_user_meta($this->ID, 'expire_current_' . $fromsub_id);
delete_user_meta($this->ID, 'sent_msgs_' . $fromsub_id);
delete_user_meta($this->ID, 'using_gateway_' . $fromsub_id);
$expiring = get_user_meta($this->ID, '_membership_expire_next', true);
if ($expiring == $fromsub_id) {
delete_user_meta($this->ID, '_membership_expire_next');
}
$this->set_role(get_option('default_role'));
do_action('membership_drop_subscription', $fromsub_id, $fromlevel_id, $this->ID);
return true;
}
protected function actionUnlicenseSite($productSlug, $licenseKey = null, $token = null)
{
$this->requireRequestMethod('POST');
$license = $this->validateLicenseRequest($productSlug, $licenseKey, $token, $this->post);
$siteUrl = $this->sanitizeSiteUrl(isset($this->post['site_url']) ? strval($this->post['site_url']) : '');
$usingToken = !empty($token);
$response = array('license' => $this->prepareLicenseForOutput($license, $usingToken));
if (!$usingToken) {
$token = $this->wpdb->get_var($this->wpdb->prepare("SELECT token FROM `{$this->tablePrefix}tokens` WHERE site_url = %s AND license_id = %d", $siteUrl, $license['license_id']));
}
if (empty($token)) {
//The user tried to un-license a site that wasn't licensed in the first place. Still,
//the desired end state - site not licensed - has ben achieved, so treat it as a success.
$response['notice'] = "The specified site wasn't licensed in the first place.";
} else {
$this->wpdb->delete($this->tablePrefix . 'tokens', array('token' => $token, 'license_id' => $license['license_id']));
//Reload the license to ensure the site list is correct.
$license = $this->loadLicense($license['license_key']);
$response['license'] = $this->prepareLicenseForOutput($license, $usingToken);
$response = array_merge($response, array('site_token_removed' => $token, 'site_url' => $siteUrl));
}
$this->outputResponse($response);
}
/**
*
* @param string $email
* @param string $name
*
* @return false|int|void
*/
public function removeSubscriber($id)
{
return $this->wpdb->delete($this->table, ['id' => $id]);
}
/**
*
* @return $this
*/
public function delete()
{
$this->tm_records->icl_translation_status_by_translation_id($this->translation_id)->delete();
$this->wpdb->delete($this->wpdb->prefix . $this->table, $this->get_args());
return $this;
}
/**
* Delete a row in the table
*
* @see wpdb::delete()
*/
public function deleteRow($where, $where_format = null)
{
return $this->db->delete($this->schema->table_name, $where, $where_format);
}
function remove_level_members($id, $levels)
{
foreach ($levels as $level) {
$this->db->delete(MEMBERSHIP_TABLE_RELATIONS, array('sub_id' => $this->id, 'level_id' => $level->id), array('%d', '%d'));
}
}
/**
* Delete a form.
*
* @author Jeremy Pry
*
* @param int $form_id The form ID to delete.
*
* @return bool Whether the form was successfully deleted.
*/
public function delete_form($form_id)
{
return (bool) $this->wpdb->delete($this->prefixed_table_name, array('id' => $form_id), '%d');
}
function delete()
{
return $this->db->delete(MEMBERSHIP_TABLE_COMMUNICATIONS, array('id' => $this->id), array('%d'));
}
/**
* Delete taxonomy meta
*
* @param int $term_id
* @param string $key
* @return int
*/
public function delete($term_id, $key)
{
wp_cache_delete($this->_get_cache_key($term_id, $key), 'taxonomy-meta');
return $this->_db->delete($this->_table, ['term_id' => $term_id, 'meta_key' => $key]);
}
<h2>Star Citizen Ships</h2>
<p>Cool Ship Stuff!</p>
<?php
// saves data
$scdb = new wpdb(DB_USER, DB_PASSWORD, "uolttorg_sc_data", DB_HOST);
if (isset($_POST['delete_ship'])) {
foreach ($_POST['delete_ship'] as $id) {
$scdb->delete("ships", array("shipUID" => $id));
}
unset($_POST['delete_ship']);
}
if (isset($_POST['add_edit_ship'])) {
if ($_POST['add_edit_ship'] == "add") {
unset($_POST['add_edit_ship']);
$err_c = 0;
foreach ($_POST as $k => $v) {
if (empty($v)) {
echo '<div class="error notice"><p>Please set the "' . $k . '" field!</p></div>';
$err_c++;
}
}
if ($err_c == 0) {
$scdb->insert("ships", $_POST);
}
} elseif ($_POST['add_edit_ship'] != "add" && $_POST['add_edit_ship'] != "") {
$data = array();
foreach ($_POST as $k => $v) {
if ($v != "" && $k != "add_edit_ship") {
$data[$k] = $v;