dtvnbe1428 2018-07-19 13:44
浏览 148
已采纳

将数据添加到wp_users表中的自定义字段中

I have created boxes for users to insert an HRID and I am saving it in @_POST(user_hrid). I want to put this data in wp_users in a custom field I have created called user_hrid. The following function makes my website go blank... Any ideas?

/**
 * Updates the user data
 */
function update_my_custom_user_meta() {

$servername = "localhost";
$username = "databaseusername";
$password = "databasepassword";
$dbname = "databasename");

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$user = wp_get_current_user();

$sql = "UPDATE wp_users SET user_hrid =".$_POST['user_hrid']." WHERE id=".$user;

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$conn->close();

}

add_filter('wc_create_new_customer', 'update_my_custom_user_meta');
  • 写回答

1条回答 默认 最新

  • dttphb59319 2018-07-19 13:47
    关注

    Use update_user_meta to add it to wp_usersmeta table instead of adding it to wp_users, it is for these cases

    $user_id = 1;
    $new_value = 'some new value';
    
    // will return false if the previous value is the same as $new_value
    update_user_meta( $user_id, 'some_meta_key', $new_value );
    
    // so check and make sure the stored value matches $new_value
    if ( get_user_meta($user_id,  'some_meta_key', true ) != $new_value )
        wp_die('An error occurred');
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
  • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
  • ¥30 3天&7天&&15天&销量如何统计同一行
  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型