PHP delete_data函数代码示例

 function del()
 {
     $ids = I('ids');
     if (is_array($ids)) {
         $map['id'] = array('in', $ids);
         $result = delete_data($this->table, $map);
         $ids = implode(',', $ids);
         if ($result) {
             //action_log($this->table,$ids);
             $this->success('操作成功', U('index'));
         } else {
             $this->error($result);
         }
     } else {
         $ids = intval($ids);
         $map['id'] = $ids;
         $result = delete_data($this->table, $map);
         if ($result) {
             //action_log($this->table,$ids);
             $this->success('操作成功', U('index'));
         } else {
             $this->error($result);
         }
     }
 }

 public function praise_get()
 {
     $this->check_token();
     $table = 'praise';
     $table_name = 'information';
     $catid = I('get.id', 0, 'intval');
     $uid = $this->uid;
     // 27192;
     // 检测此赞是否存在
     $map = array('table_name' => $table_name, 'member_id' => $uid, 'catid' => $catid);
     $res = get_info($table, $map);
     if ($res) {
         // 取消赞
         $result = delete_data($table, array('id' => $res['id']));
         if ($result) {
             // 更新赞的数量
             update_num($table_name, array('id' => $catid), 'praise_num', 1, false);
             $msg = array('praise_status' => 2, 'msg' => '取消成功');
         } else {
             $this->error(1500);
         }
     } else {
         // 添加赞
         $_POST = array('table_name' => $table_name, 'member_id' => $uid, 'catid' => $catid);
         $result = update_data($table);
         if ($result) {
             // 更新赞的数量
             update_num($table_name, array('id' => $catid), 'praise_num', 1, true);
             $msg = array('praise_status' => 1, 'msg' => '添加成功');
         } else {
             $this->error(1500);
         }
     }
     $this->success($msg);
 }

 public function testCanDeleteData()
 {
     _elgg_services()->db->addQuerySpec(['sql' => 'DELETE FROM A WHERE b = :b', 'params' => [':b' => 'b'], 'row_count' => 20]);
     _elgg_services()->db->addQuerySpec(['sql' => 'DELETE FROM A WHERE c = :c', 'params' => [':c' => 'c']]);
     $this->assertEquals(20, delete_data('DELETE FROM A WHERE b = :b', [':b' => 'b']));
     $this->assertEquals(0, delete_data('DELETE FROM A WHERE c = :c', [':c' => 'c']));
 }

function deleteAll($db)
{
    $DELETED_MANUFACTER_CATEGORY = 2;
    //подключение к БД
    $link = $db->connectToDb();
    $table_prefix = $db->getTablePrefix() . $db->getVMTablePrefix();
    $query_parent_categories = "select category_child_id from " . $table_prefix . "category_categories where category_parent_id=0";
    $result = mysql_query($query_parent_categories, $link);
    $rows_num = mysql_num_rows($result);
    //if record doesn't exist insert record in tables
    if ($rows_num > 0) {
        while ($row = mysql_fetch_row($result)) {
            $category_nums[] = $row[0];
        }
    }
    $table_delete = array($table_prefix . "categories", $table_prefix . "categories_ru_ru", $table_prefix . "category_medias");
    $table_error .= delete_data($table_delete, "virtuemart_category_id not in('" . implode("','", $category_nums) . "')", $link);
    $table_delete = array($table_prefix . "category_categories");
    $table_error .= delete_data($table_delete, "category_child_id not in('" . implode("','", $category_nums) . "')", $link);
    $table_delete = array($table_prefix . "manufacturers_ru_ru", $table_prefix . "manufacturer_medias");
    $table_error .= delete_data($table_delete, "virtuemart_manufacturer_id in (SELECT virtuemart_manufacturer_id from " . $table_prefix . "manufacturers \nWHERE virtuemart_manufacturercategories_id=2)", $link);
    $table_delete = array($table_prefix . "manufacturers");
    $table_error .= delete_data($table_delete, "virtuemart_manufacturercategories_id=" . $DELETED_MANUFACTER_CATEGORY, $link);
    $table_delete = array($table_prefix . "import", $table_prefix . "products", $table_prefix . "products_ru_ru", $table_prefix . "product_categories", $table_prefix . "product_manufacturers", $table_prefix . "product_medias", $table_prefix . "product_relations", $table_prefix . "product_prices", $table_prefix . "product_shoppergroups", $table_prefix . "product_customfields");
    $table_error .= delete_data($table_delete, '1', $link);
    if ($table_error != '') {
        echo "<p style='color:red;'>" . 'При удалении возникли ошибки, таблицы: ' . $table_error . "</p>";
    } else {
        echo "<p style='color:blue;'>" . 'Удаление прошло успешно!' . "</p>";
    }
}

 /**
  * Revoke an api user key.
  *
  * @param string $api_key   The API Key (public)
  * @return bool
  */
 public function revoke($api_key)
 {
     $user = $this->get($api_key);
     if ($user) {
         return delete_data("DELETE from {$this->dbprefix}api_users\n\t\t\t\t\t\t\t\t\tWHERE id={$user->id}");
     }
     return false;
 }

function openid_server_delete_entity($entity)
{
    global $CONFIG;
    $entity->clearMetadata();
    $entity->clearAnnotations();
    $guid = $entity->getGUID();
    delete_data("DELETE from {$CONFIG->dbprefix}entities where guid={$guid}");
}

/**
 * Removes all items relating to a particular entity being acted upon from the river
 *
 * @param int $object_guid The GUID of the entity
 * @return true|false Depending on success
 */
function remove_from_river_by_object($object_guid)
{
    // Sanitise
    $object_guid = (int) $object_guid;
    // Load config
    global $CONFIG;
    // Remove
    return delete_data("delete from {$CONFIG->dbprefix}river where object_guid = {$object_guid}");
}

/**
 * Revoke an api user key.
 *
 * @param string $api_key   The API Key (public).
 *
 * @return bool
 */
function remove_api_user($api_key)
{
    $dbprefix = elgg_get_config('dbprefix');
    $keypair = get_api_user($api_key);
    if ($keypair) {
        return delete_data("DELETE from {$dbprefix}api_users where id={$keypair->id}");
    }
    return false;
}

/**
 * Revoke an api user key.
 *
 * @param int    $site_guid The GUID of the site.
 * @param string $api_key   The API Key (public).
 *
 * @return bool
 */
function remove_api_user($site_guid, $api_key)
{
    global $CONFIG;
    $keypair = get_api_user($site_guid, $api_key);
    if ($keypair) {
        return delete_data("DELETE from {$CONFIG->dbprefix}api_users where id={$keypair->id}");
    }
    return false;
}

/**
 * Unset a config option.
 *
 * @param string $name The name of the field.
 * @param int $site_guid Optionally, the GUID of the site (current site is assumed by default).
 * @return mixed
 */
function unset_config($name, $site_guid = 0)
{
    global $CONFIG;
    $name = mysql_real_escape_string($name);
    $site_guid = (int) $site_guid;
    if ($site_guid == 0) {
        $site_guid = (int) $CONFIG->site_id;
    }
    return delete_data("delete from {$CONFIG->dbprefix}config where name='{$name}' and site_guid={$site_guid}");
}

function upgrade_izap_videos_to($version)
{
    global $CONFIG;
    $update_entity_subtype = "UPDATE {$CONFIG->dbprefix}entity_subtypes SET class = 'IzapVideos' WHERE subtype = 'izap_videos'";
    $del_entity_query = "DELETE FROM {$CONFIG->dbprefix}entities\n                WHERE subtype IN (SELECT id FROM {$CONFIG->dbprefix}entity_subtypes\n                                  WHERE subtype='izapVideoQueue')";
    $del_queue_object_query = "DELETE FROM {$CONFIG->dbprefix}entity_subtypes where subtype='izapVideoQueue'";
    if (update_data($update_entity_subtype) || (delete_data($del_entity_query) || delete_data($del_queue_object_query))) {
        datalist_set('izap_videos_version', $version);
    }
}

 /**
  * Remove expired tokens
  * @return bool
  */
 public function removeExpiredTokens()
 {
     $time = time();
     $result = delete_data("DELETE FROM {$this->dbprefix}users_apisessions\n\t\t\t\t\t\t\t\tWHERE expires < {$time}");
     if (elgg_in_context('cron')) {
         if ($result !== false) {
             return "{$result} expired user tokens were removed" . PHP_EOL;
         } else {
             return "ERROR: Expired user tokens could not be removed" . PHP_EOL;
         }
     }
     return $result;
 }

 /**
 * Data Add
 *
 * @access system
 * @return return;
 */
 public static function Data($query, $type)
 {
     global $CONFIG;
     $query = str_replace('prefixes_', $CONFIG->dbprefix, $query);
     if (!empty($query) && $type == 'get') {
         return get_data($query);
     }
     if (!empty($query) && $type == 'delete') {
         return delete_data($query);
     }
     if (!empty($query) && $type == 'add') {
         return insert_data($query);
     }
     if (!empty($query) && $type == 'run') {
         return run_sql_script($query);
     }
 }

function subsite_manager_upgrade_system_handler($event, $type, $entity)
{
    if (get_input("all") == "true") {
        // find subsites and do stuff
        $options = array("type" => "site", "subtype" => Subsite::SUBTYPE, "limit" => false);
        // this could take a while
        set_time_limit(0);
        $batch = new ElggBatch("elgg_get_entities", $options);
        $viewtypes = elgg_get_config("view_types");
        $dataroot = elgg_get_config("dataroot");
        foreach ($batch as $subsite) {
            // clear simplecache
            $dir = $dataroot . "views_simplecache/" . $subsite->getGUID() . "/";
            if (file_exists($dir) && ($handle = opendir($dir))) {
                // remove files
                while (false !== ($file = readdir($handle))) {
                    if (!is_dir($dir . $file)) {
                        unlink($dir . $file);
                    }
                }
                closedir($handle);
            }
            if (!empty($viewtypes) && is_array($viewtypes)) {
                foreach ($viewtypes as $viewtype) {
                    datalist_set("sc_lastupdate_" . $viewtype . "_" . $subsite->getGUID(), 0);
                    datalist_set("sc_lastcached_" . $viewtype . "_" . $subsite->getGUID(), 0);
                }
            }
            // clear system cache
            $system_cache = new ElggFileCache($dataroot . "system_cache/" . $subsite->getGUID() . "/");
            $system_cache->clear();
            // cleanup cron cache
            $cron_cache = $dataroot . "subsite_manager/" . $subsite->getGUID() . "/cron_cache.json";
            if (file_exists($cron_cache)) {
                unlink($cron_cache);
            }
            // reset translation editor cache
            // can't use remove_private_setting because of 'name like' not 'name ='
            $sql = "DELETE FROM " . get_config("dbprefix") . "private_settings";
            $sql .= " WHERE name LIKE 'te_last_update_%'";
            $sql .= " AND entity_guid = " . $subsite->getGUID();
            delete_data($sql);
        }
    }
}

 public function del()
 {
     //1、根据点击删除传递过来的ID获取相关数据
     $ids = I('ids');
     $map['id'] = array("in", $ids);
     $result = get_result($this->table, $map);
     //2、获取评论内容中的图片并删除
     foreach ($result as $key => $value) {
         //删除内容中的图片
         delStrImgs($value['content']);
         //3、统计评论删除后新闻的评论数量
         $_POST['id'] = $value['product_id'];
         $_POST['comment'] = count_data($this->table, array("product_id" => $value['product_id']));
         update_data("article");
     }
     //4、删除数据表中的数据
     delete_data($this->table, $map);
     $this->success("删除成功");
 }