显示基于wordpress用户登录的自定义表格行 - Display custom table rows based on wordpress user login

Display custom table rows based on wordpress user login

我上传了一个本地团队的自定义比赛时间表。每一行都包括worpress用户ID。我可以显示一个人登录的表，但我只想显示用用户ID标记的行。这样，当他们登录时，他们只看到自己的时间。

以下是我必须显示的完整表格：

<?php
if (is_user_logged_in()):
    global $wpdb;
    $TIMES = $wpdb->get_results("SELECT * FROM TIMES;");

    echo "<table>";
    foreach($TIMES as $TIMES){
        echo "<tr>";
        echo "<td>".$TIMES->EVENT."</td>";
        echo "<td>".$TIMES->Race."</td>";
        echo "<td>".$TIMES->Time."</td>";
        echo "<td>".$TIMES->Meet."</td>";
        echo "<td>".$TIMES->Swimmer."</td>";
        echo "<td>".$TIMES->users_login."</td>";
        echo "</tr>";
    }
    echo "</table>";
else:
    echo "Sorry, only registered users can view this information";
endif;
?>

有没有一种简单的方法可以根据用户登录显示行？

尝试：

<?php
if (is_user_logged_in()):
    $userid = get_user_id();
    global $wpdb;
    $TIMES = $wpdb->get_results("SELECT * FROM TIMES WHERE userid = '$userid';");

    echo "<table>";
    foreach($TIMES as $TIMES){
        echo "<tr>";
        echo "<td>".$TIMES->EVENT."</td>";
        echo "<td>".$TIMES->Race."</td>";
        echo "<td>".$TIMES->Time."</td>";
        echo "<td>".$TIMES->Meet."</td>";
        echo "<td>".$TIMES->Swimmer."</td>";
        echo "<td>".$TIMES->users_login."</td>";
        echo "</tr>";
    }
    echo "</table>";
else:
    echo "Sorry, only registered users can view this information";
endif;
?>

其中

get_user_id（）将返回当前的用户id

例如

function get_user_id(){
    return $_SESSION['userid'];
}