How To Update row in custom wordpress table
18,900
Solution 1
Try this code.
$current_user = wp_get_current_user();
$johnny = $current_user->user_login;
$subs = 'illinois';
global $wpdb;
$table_name = $wpdb->prefix."Customers";
$wpdb->query( $wpdb->prepare("UPDATE $table_name
SET BuyersAddress = %s
WHERE UserName = %s",$subs, $johnny)
);
Solution 2
Try this code
A simple WordPress Update query
$current_user = wp_get_current_user();
$johnny = array('UserName' => $current_user->user_login);
$subs = array('BuyersAddress' => 'illinois');
global $wpdb;
$table_name = $wpdb->prefix."Customers";
$wpdb->update($table_name, $subs, $johnny);
Hope this will help you
Author by
Charles Houser Junior
Updated on June 07, 2022Comments
-
Charles Houser Junior almost 2 years
Ive Tried And Tried Looking Up How To Approach Editing/Updating Rows In Custom Wordpress Tables I Have It Set To Grab Current logged in user's username which then compares to a custom wp_ table With UserNAme As The Primary Key Which Then I Would Like To Edit A Particular Column/Field On That Particular Row By Passing The Value Of A Variable Over After It Confirms Current Logged In User Matches The Primary Key UserName In My Custom Table"wp_customers" What Am I Doing Wrong With This Line Of Code Or Do You Have A Better Solution
$current_user = wp_get_current_user(); $johnny = $current_user->user_login; $subs = 'illinois'; global $wpdb; $wpdb->query( " UPDATE $wpdb->wp_Customers SET BuyersAddress = $subs WHERE UserName = $johnny ");