PHP MySQL::UpdateRows方法代码示例

function admin_cp_newpw()
{
    global $hmuser;
    $hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
    hook_action('newpw_checkkey');
    $key = hm_post('key');
    $password = hm_post('password');
    $password2 = hm_post('password2');
    if ($password == $password2) {
        $tableName = DB_PREFIX . "field";
        $whereArray = array('name' => MySQL::SQLValue('lostpw_key'), 'object_type' => MySQL::SQLValue('user'), 'val' => MySQL::SQLValue($key));
        $hmdb->SelectRows($tableName, $whereArray);
        $row = $hmdb->Row();
        $user_id = $row->object_id;
        $salt = rand(100000, 999999);
        $password_encode = hm_encode_str(md5($password . $salt));
        $tableName = DB_PREFIX . "users";
        $updateArray = array('user_pass' => MySQL::SQLValue($password_encode), 'salt' => MySQL::SQLValue($salt));
        $whereArray = array('id' => MySQL::SQLValue($user_id, MySQL::SQLVALUE_NUMBER));
        $hmdb->UpdateRows($tableName, $updateArray, $whereArray);
        return json_encode(array('status' => 'success', 'mes' => _('Đã đổi mật khẩu thành công')));
    } else {
        return json_encode(array('status' => 'error', 'mes' => _('Hai mật khẩu bạn nhập vào không khớp')));
    }
}

 /**
  * Metodo per inserire immagine al prodotto
  * 
  * @param String $img_1 Nome dell'immagine del file
  * @param int $position position immagine
  * @param int $id_product Id del prodotto
  */
 function insertProductImage2($img_1, $position, $id_product)
 {
     if (file_exists(FOLDER_UNZIP . $img_1)) {
         $values['id_product'] = MySQL::SQLValue($id_product);
         $values['position'] = MySQL::SQLValue($position);
         if ($position > 1) {
             $values['cover'] = MySQL::SQLValue(0);
         } else {
             $values['cover'] = MySQL::SQLValue(1);
         }
         $db = new MySQL();
         $first_img_id = $db->InsertRow("ps_image", $values);
         foreach ($this->ecommerce_lang_by_erp as $erp_lang => $ps_id_lang) {
             $values_img['id_image'] = MySQL::SQLValue($first_img_id);
             $values_img['id_lang'] = MySQL::SQLValue($ps_id_lang);
             $values_img['legend'] = MySQL::SQLValue(NULL);
             $db->InsertRow("ps_image_lang", $values_img);
         }
         $values_shop['id_image'] = MySQL::SQLValue($first_img_id);
         $values_shop['id_shop'] = MySQL::SQLValue(1);
         if ($position > 1) {
             $values_shop['cover'] = MySQL::SQLValue(0);
         } else {
             $values_shop['cover'] = MySQL::SQLValue(1);
         }
         $db->InsertRow("ps_image_shop", $values_shop);
         $char_1 = $this->addImageToFolder($first_img_id);
         @mkdir(FOLDER_PS_IMAGE . $char_1, 0777, TRUE);
         $array_extension = explode(".", $img_1);
         $this->unlinkImageProduct(FOLDER_PS_IMAGE . $char_1 . "/" . $first_img_id);
         copy(FOLDER_UNZIP . $img_1, FOLDER_PS_IMAGE . $char_1 . "/" . $first_img_id . ".jpg");
         if (defined('PRODUCTS_GROUP_BY_IMAGE') and PRODUCTS_GROUP_BY_IMAGE == 1) {
             if ($position == 1) {
                 $values_image_group = null;
                 $values_image_group['id_product'] = MySQL::SQLValue($id_product);
                 $values_image_group['image_name'] = MySQL::SQLValue($img_1);
                 $values_image_group['parent'] = MySQL::SQLValue($this->checkIfParentExits($img_1));
                 if ($this->checkIfAlreayExistsGroupPrID($id_product)) {
                     $where['id_product'] = MySQL::SQLValue($id_product_);
                     $values_update_image_group['image_name'] = MySQL::SQLValue($img_1);
                     $db_image_group = new MySQL();
                     $db_image_group->UpdateRows("erp_image_group", $values_update_image_group, $where);
                 } else {
                     $db_image_group = new MySQL();
                     $db_image_group->InsertRow("erp_image_group", $values_image_group);
                 }
             }
         }
     }
 }

/** Load template user box */
function ajax_ban_user()
{
    $id = hm_post('id');
    if (isset_user($id) == TRUE) {
        $hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
        $tableName = DB_PREFIX . "users";
        $whereArray = array('id' => $id);
        $values['user_role'] = MySQL::SQLValue(5, MySQL::SQLVALUE_NUMBER);
        $hmdb->UpdateRows($tableName, $values, $whereArray);
    }
}

function taxonomy_delete_permanently($id)
{
    $hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
    hook_action('taxonomy_delete_permanently');
    if (isset_taxonomy_id($id) == TRUE) {
        $tableName = DB_PREFIX . "taxonomy";
        /* update lại parent các sub taxonomy */
        $valuesArray = array('parent' => MySQL::SQLValue(0));
        $whereArray = array('parent' => MySQL::SQLValue($id));
        $hmdb->UpdateRows($tableName, $valuesArray, $whereArray);
        /* xóa bảng taxonomy */
        $whereArray = array('id' => MySQL::SQLValue($id));
        $hmdb->DeleteRows($tableName, $whereArray);
        /* xóa bảng field */
        $tableName = DB_PREFIX . "field";
        $whereArray = array('object_id' => MySQL::SQLValue($id), 'object_type' => MySQL::SQLValue('taxonomy'));
        $hmdb->DeleteRows($tableName, $whereArray);
        /* xóa bảng relationship */
        $tableName = DB_PREFIX . "relationship";
        $whereArray = array('object_id' => MySQL::SQLValue($id));
        $hmdb->DeleteRows($tableName, $whereArray);
        /* xóa bảng request uri */
        $tableName = DB_PREFIX . "request_uri";
        $whereArray = array('object_id' => MySQL::SQLValue($id), 'object_type' => MySQL::SQLValue('taxonomy'));
        $hmdb->DeleteRows($tableName, $whereArray);
    }
}

 /**
  * Metodo utilizzato per leggere le informazioni da ERP
  * e inserirle nella tabella vsecommerce_info
  */
 function readInfoEcommerce()
 {
     $content = $this->file_get_contents_utf8(FOLDER_UNZIP . FILE_INFO . ".txt");
     $array_field = explode("\n", $content);
     if ($this->checkInsertOrAppend(FILE_INFO) == 0) {
         $this->truncateTable("vsecommerce_info");
     }
     foreach ($array_field as $field_comb) {
         $data = explode("§", $field_comb);
         if (!$this->checkInfoExists(trim($data[0]))) {
             $values['field_name'] = MySQL::SQLValue(trim($data[0]));
             $values['value'] = MySQL::SQLValue(trim($data[1]));
             $db = new MySQL();
             $db->InsertRow("vsecommerce_info", $values);
         } else {
             $where['field_name'] = MySQL::SQLValue(trim($data[0]));
             $values['value'] = MySQL::SQLValue(trim($data[1]));
             $db = new MySQL();
             $db->UpdateRows("vsecommerce_info", $values, $where);
         }
     }
 }

 function refreshCustomer($id_cust, $firstname, $lastname, $company, $fido, $utilizzo)
 {
     $values = null;
     if (!empty($firstname)) {
         $values['firstname'] = MySQL::SQLValue($firstname);
     } else {
         $values['firstname'] = MySQL::SQLValue("-Senza Nome-");
     }
     if (!empty($lastname)) {
         $values['lastname'] = MySQL::SQLValue($lastname);
     } else {
         $values['lastname'] = MySQL::SQLValue(htmlentities("-Senza Cognome-"));
     }
     if (!empty($company)) {
         $values['company'] = MySQL::SQLValue($company);
     } else {
         $values['company'] = MySQL::SQLValue(htmlentities("-Senza Ragione Sociale-"));
     }
     if (!empty($utilizzo)) {
         $values['outstanding_allow_amount'] = MySQL::SQLValue(str_replace(",", ".", $fido) - str_replace(",", ".", $utilizzo));
     } else {
         $values['outstanding_allow_amount'] = MySQL::SQLValue(str_replace(",", ".", $fido));
     }
     $where['id_customer'] = MySQL::SQLValue($id_cust);
     $db = new MySQL();
     $db->UpdateRows("ps_customer", $values, $where);
 }

 /**
  * Metodo per aggiornare le etichette di una categoria già esistente
  * Parametri
  * @param $arraCat Array della categoria passato da ERP
  * @param $id_category Id della categoria già presente nel DB di Prestashop
  * @param $lang Array contenente le etichette per la categoria
  *
  */
 function updateCategoryLang($arraCat, $id_category, $lang)
 {
     foreach ($this->commerce_lang_by_erp as $erp_lang => $ps_id_lang) {
         $values = NULL;
         $values['id_shop'] = MySQL::SQLValue(1);
         $values['id_lang'] = MySQL::SQLValue($ps_id_lang);
         if (!empty($lang[$erp_lang])) {
             $values['name'] = MySQL::SQLValue(str_replace("’", "'", $lang[$erp_lang]));
         } else {
             // recupero il valore di default della lingua che deve essere usato
             if (!empty($lang[$this->ecommerce_lang_by_erp[$this->default_language_ecommerce]])) {
                 $values['name'] = MySQL::SQLValue(str_replace("’", "'", $lang[$this->ecommerce_lang_by_erp[$this->default_language_ecommerce]]));
             } else {
                 if (isset($arraCat[2]) and !empty($arraCat[2])) {
                     $values['name'] = MySQL::SQLValue(str_replace("’", "'", html_entity_decode(str_replace("à", "à", str_replace(" ", " ", str_replace("Ã", "à", htmlentities(str_replace("à", "à", $arraCat[2]))))))));
                 } else {
                     $values['name'] = MySQL::SQLValue("-Categoria Senza Nome-");
                 }
             }
         }
         if (isset($arraCat[12]) and !empty($arraCat[12])) {
             $values['description'] = MySQL::SQLValue(mb_convert_encoding($arraCat[12], "HTML-ENTITIES", "UTF-8"));
         } else {
             if (isset($arraCat[2]) and !empty($arraCat[2])) {
                 $values['description'] = MySQL::SQLValue($arraCat[2]);
             } else {
                 $values['description'] = MySQL::SQLValue("-Categoria Senza Descrizione-");
             }
         }
         $values['link_rewrite'] = MySQL::SQLValue($this->slugify($arraCat[2]));
         $values['meta_title'] = MySQL::SQLValue(html_entity_decode(str_replace(" ", " ", str_replace("Ã", "à", htmlentities($arraCat[2])))));
         $values['meta_keywords'] = MySQL::SQLValue(" ");
         $values['meta_description'] = MySQL::SQLValue(" ");
         $db = new MySQL();
         $where['id_category'] = MySQL::SQLValue($id_category);
         $db->UpdateRows("ps_category_lang", $values, $where);
     }
 }

// Example to delete a row (or rows) in a table matching a filter
// =========================================================================
// Now let's delete that record using the same array for the WHERE clause
$db->DeleteRows("Test", $values);
// =========================================================================
// Example to update an existing row into a table
// =========================================================================
// Create an array that holds the update information
// $arrayVariable["column name"] = formatted SQL value
$update["Color"] = MySQL::SQLValue("Red");
$update["Age"] = MySQL::SQLValue(123, MySQL::SQLVALUE_NUMBER);
// Create a filter array the detemrines which record(s) to process
// (you can specify more than one column if needed)
$where["TestID"] = MySQL::SQLValue(1, "integer");
// Execute the update
$result = $db->UpdateRows("test", $update, $where);
// If we have an error
if (!$result) {
    // Show the error and kill the script
    $db->Kill();
}
// --------------------------------------------------------------------------
// FYI: We can also shortcut and specify the "where" array in the call...
if (!$db->UpdateRow("test", $values, array("TestID" => 1))) {
    $db->Kill();
}
// =========================================================================
// Here's a standard SQL query INSERT
// =========================================================================
// Build the INSERT SQL statement...
// (this could also be an UPDATE or DELETE SQL statement)

/** Ajax đổi tên nhóm media */
function rename_media_group($args = array())
{
    if (!is_array($args)) {
        parse_str($args, $args);
    }
    $hmdb = new MySQL(true, DB_NAME, DB_HOST, DB_USER, DB_PASSWORD, DB_CHARSET);
    $group_name = $args['group_name'];
    $group_id = $args['group_id'];
    $tableName = DB_PREFIX . 'media_groups';
    $valuesArray = array('name' => MySQL::SQLValue($group_name));
    $whereArray = array('id' => MySQL::SQLValue($group_id));
    return $hmdb->UpdateRows($tableName, $valuesArray, $whereArray);
}

 public function update($data, $id)
 {
     $db = new MySQL(true, 'color64', 'localhost', 'color64', 'nu5Jc4JdtZK4RCHH');
     $db->UpdateRows('users', $data, 'id = ' . $id);
 }