从用户表数据不会在 hostinger 中检索-解网

问：

我使用了以下脚本，从 WordPress 上的用户表中检索用户 ID。此脚本在本地服务器和所有其他服务器中工作。但这在 Hostinger 服务器中不起作用。

为什么这在 Hostinger 中不起作用？

只有这个是，但找不到 IDprint_r($query);$userid=$query[0][ID];

<?php
    if (sanitize_text_field($_GET['ven_search_title']) && sanitize_text_field ($_GET['ven_search_title']))
    {
        $ven_search_title = sanitize_text_field($_GET['ven_search_title']);
    }

    global $wpdb;
    $table = $wpdb->prefix . 'users'; 
    $query = $wpdb->get_results("SELECT * FROM $table WHERE user_nicename LIKE '%".$ven_search_title."%'", ARRAY_A);

    
    if($query){
 
    echo "<pre>";
    print_r ($query);
    echo "</pre>";  
 
    $userid=$query[0][ID];
    
    echo "<pre>";
    print_r ($query[0][ID]);
    echo "</pre>";  
?>     
<?php $user=get_userdata($userid)?>
    <a href="<?php echo bloginfo('url').'/store/'.$user->user_nicename; ?>">
    <div class="store-wrappers"> 
        <div class="seller-avatar"><?php echo get_avatar($userid) ?></div>
        <div class="storebody">
            <div class="search_title"><span>Store Name:</span> <?php echo $user->user_nicename; ?> </div> 
        </div>   
    <div style="clear:both;"></div>

php mysql 数组 wordpress 用户数据

if ( isset($_GET['ven_search_title']) && ! empty($_GET['ven_search_title']) ) {
    global $wpdb;

    $user_id = $wpdb->get_var( $wpdb->prepare("
        SELECT ID FROM {$wpdb->prefix}users WHERE user_nicename LIKE '%s' 
    ", '%'.sanitize_text_field($_GET['ven_search_title']).'%' ));

    if( $user_id > 0 ){
        $user     = new WP_User($user_id);
        $nicename = $user->user_nicename;
        ?>
        <a href="<?php echo site_url('/store/'.$nicename); ?>">
        <div class="store-wrappers"> 
            <div class="seller-avatar"><?php echo get_avatar($user_id) ?></div>
            <div class="storebody">
                <div class="search_title"><span><?php _e('Store Name'); ?>:</span> <?php echo $nicename; ?></div> 
            </div>   
            <div style="clear:both;"></div>
        <div><?php 
    } 
}

经过测试，轻量级，更安全，更有效。

从用户表数据不会在 hostinger 中检索

From user table data doesn't retrive in hostinger

评论

评论