Delete an item
| public delete ( string $table, array $where, array $where_format = null ) : array | boolean | mixed | null | void | ||
| $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 | (optional) An array of formats to be mapped to each of the values in $where. |
| return | array | boolean | mixed | null | void | |
/**
* @param null $id
*
* @return bool|mixed
*/
public function delete_bulk()
{
$this->do_hook('pre_delete_bulk');
if (1 != pods_var('deleted_bulk', 'get', 0)) {
$ids = $this->bulk;
$success = false;
if (!empty($ids)) {
$ids = (array) $ids;
foreach ($ids as $id) {
$id = pods_absint($id);
if (empty($id)) {
continue;
}
if (isset($this->actions_custom['delete']) && is_callable($this->actions_custom['delete'])) {
$check = call_user_func_array($this->actions_custom['delete'], array($id, &$this));
if (false !== $check) {
$check = true;
}
} elseif (is_object($this->pod)) {
$check = $this->pod->delete($id);
} else {
$check = $this->pods_data->delete($this->table, array($this->data->field_id => $id));
}
if ($check) {
$success = true;
}
}
}
if ($success) {
pods_redirect(pods_var_update(array('action_bulk' => 'delete', 'deleted_bulk' => 1), array('page', 'lang', 'action', 'id')));
} else {
$this->error(__("<strong>Error:</strong> {$this->item} has not been deleted.", 'pods'));
}
} else {
$this->message(__("<strong>Deleted:</strong> {$this->items} have been deleted.", 'pods'));
unset($_GET['deleted_bulk']);
}
$this->action_bulk = false;
unset($_GET['action_bulk']);
$this->do_hook('post_delete_bulk');
$this->manage();
}
/**
* @param null $id
*
* @return bool|mixed
*/
public function delete_bulk()
{
$this->do_hook('pre_delete_bulk');
if (1 != pods_var('deleted_bulk', 'get', 0)) {
$ids = $this->bulk;
$success = false;
if (!empty($ids)) {
$ids = (array) $ids;
foreach ($ids as $id) {
$id = pods_absint($id);
if (empty($id)) {
continue;
}
if ($callback = $this->callback('delete', $id)) {
$check = $callback;
} elseif (is_object($this->pod)) {
$check = $this->pod->delete($id);
} else {
$check = $this->pods_data->delete($this->sql['table'], array($this->sql['field_id'] => $id));
}
if ($check) {
$success = true;
}
}
}
if ($success) {
pods_redirect(pods_query_arg(array('action_bulk' => 'delete', 'deleted_bulk' => 1), array('page', 'lang', 'action', 'id')));
} else {
$this->error(sprintf(__("<strong>Error:</strong> %s has not been deleted.", 'pods'), $this->item));
}
} else {
$this->message(sprintf(__("<strong>Deleted:</strong> %s have been deleted.", 'pods'), $this->items));
unset($_GET['deleted_bulk']);
}
$this->action_bulk = false;
unset($_GET['action_bulk']);
$this->do_hook('post_delete_bulk');
$this->manage();
}