wordpress update query code example

Example 1: update query wordpress

global $wpdb;
$dbData = array();
$dbData['last_login_time'] = time();

$wpdb->update('table_name', $dbData, array('user_id' => 1));

Example 2: update wordpress query

$wpdb->query($wpdb->prepare("UPDATE $table_name SET time=$current_timestamp WHERE userid=$userid"));

Example 3: update wordpress query

$execut= $wpdb->query( $wpdb->prepare( "UPDATE $wpdb->users SET user_nicename = %d WHERE ID = %s", "Harde_Bande", 546 ) );
var_dump($execut);