duanbi1983 2018-08-14 15:13
浏览 73
已采纳

写入数据库,并在同一PHP页面加载中检索更新的数据?

My website runs on WordPress, and includes an account activation system that works like this:

  1. User creates account, gets logged in immediately and is shown the home page.
  2. A function checks the database to see if the account is activated, and if not, displays a message on the home page asking to click the link in the verification email.
  3. User opens their email and clicks the activation link. (example: https://example.com/?action=activate&user=swen&key=1234)
  4. On opening this page, a function checks if an action argument is set and runs the account activation function, which then updates the account to 'activated'.
  5. The rest of WP is executed, but the function checking for account activation still shows that the account has not been activated.
  6. Upon browsing to https://example.com again without query vars, the message disappears, showing that the above example URL, did in fact work to activate the account.

Is it possible that the time between writing data to the database, and retrieving that same updated data is too short?


UPDATE:

Wondering if MySQL caches the data in the same pageload. I tried flushing the WordPress cache before retrieving the updated user role, no luck.

Action that checks URL and runs the activate_user function:

I tried doing this as early as possible with the setup_theme hook to ensure it's run before the theme is loaded.

add_action('setup_theme', 'ns_activate_user_action');
function ns_activate_user_action() {
    // Check if all action parameters are present
    if ( !ns_validate_action('activate', array('user', 'key')) ) {
        return;
    }

    // Activate user by key, runs the "activate_user" function
    $activate_user = activate_user_by_key($_GET['user'], $_GET['key']);

    // At this point the user role should have changed
    // and the account be activated
}

Function that activates account:

function activate_user($user) {
    // ...

    $user->add_role( 'member' );
    $user->remove_role( 'member_pending' );

    // ...

    return $user;       
}

Function that checks if account is activated:

function is_user_activated($user) {

    // ...

    if ( in_array( 'member_pending', (array) $user->roles ) ) {
        return false;
    }

    return true;
}

Custom action displays activation message, is called with do_action() in theme file:

add_action('ns_after_header', 'ns_activate_account_notice_front_page');
function ns_activate_account_notice_front_page() {
    if ( is_user_logged_in() && is_front_page() && !is_user_activated() ) {
        // ... Echos message asking user to click activation link in email
        // Checking the user role here with wp_get_current_user()->roles
        // still shows that the user is in the "member_pending" role (inactive)
    }
}
  • 写回答

2条回答 默认 最新

  • dongping9475 2018-08-15 10:26
    关注

    So as it turns out, it was an issue with WordPress, most likely something to do with cache. Check out this question on why it happens for more info.

    Updated user role inncorrect when using wp_get_current_user()

    And to answer my own question:

    Yes, you can write to the database, and retrieve the updated information in the same PHP page load.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 在线手电筒追加按钮JS
  • ¥15 调用函数时,无关变量的改变引起函数值的改变
  • ¥15 xy坐标转化为经纬度坐标
  • ¥15 一般三角模糊数的上界值和下届值取中值的多少比较合理?
  • ¥15 关于#python#的问题,请各位专家解答!
  • ¥20 Hbase启动失败,无法启动HMaster
  • ¥20 Lumerical FDTD solutions 中模型的相对阻抗,有效介电常数和有效磁导率的实部和虚部的数据如何获得?
  • ¥100 sql reporting service 远程smtp服务器配置支持
  • ¥15 ppyoloe_r带角度目标检测,loss_cls没法收敛
  • ¥15 淘宝交易指数如何解读,其关联的数据指标是什么