2014-12-08 23:03
浏览 43


I am just trying to convert some user id's to usernames in from an sql database. I know I shouldn't be using mySQl. I plan on switching over to PDO shortly...

  $getuseridsquery= "SELECT users.username FROM users WHERE IN(". implode( ",", $uids) .")";
  echo $getuseridsquery;
  $getuseridsresult = mysql_query($getuseridsquery);
  $getuseridsresult1 = mysql_fetch_assoc($getuseridsresult);
  echo $getuseridsresult1;

  print '<p>Conversation between ';
  print implode(', ', $getuseridresult1) . ' and ' . $last;
  echo '.</p>';

I am getting:

 array (size=1)
  'username' => string 'ambe5950' (length=8)

when I var dump, so I just need to figure out how to convert that to the sentence below.

Sincere thanks for any help. It is greatly appreciated.

图片转代码服务由CSDN问答提供 功能建议

我只是想从sql数据库中将一些用户id转换为用户名。 我知道我不应该使用mySQl。 我计划很快切换到PDO ...

  $ getuseridsquery =“SELECT users.username FROM users WHERE IN(”。implode(“,”,$  uids)。“)”; 
 echo $ getuseridsquery; 
 $ getuseridsresult = mysql_query($ getuseridsquery); 
 $ getuseridsresult1 = mysql_fetch_assoc($ getuseridsresult); 
 var_dump($ getuseridsresult1); 
 echo $ getuseridsresult1; \  n 
 print'&lt; p&gt;'; 
 print implode(',',$ getuseridresult1)之间的对话。  '和'。  $ last; 
 echo'。&lt; / p&gt;'; 


   array(size = 1)
'username'=&gt; 字符串'ambe5950'(长度= 8)


真诚地感谢您的帮助。 非常感谢。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dougou6213 2014-12-08 23:07

    The username part of that output is the index/key in your array. This is akin to what other languages call a Map or a Dictionary, but PHP allows for non-integer indexes in arrays. Simply put, you need to access the value via its index, which in this case is "username":

    $username = $getuseridsresult1['username'];
    echo $username; //prints "ambe5960"

    Also if you're not moving to PDO yet, then you should at the very least change mysql_* to mysqli_*.

    点赞 打赏 评论

相关推荐 更多相似问题