我使用了以下脚本,从WordPress上的USER表中检索用户ID.此脚本工作在本地服务器和所有其他服务器上.但这在Hostinger服务器中不起作用.
为什么这在Hostinger不起作用?
只有这是print_r($query);
,但找不到$userid=$query[0][ID];
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>