doumaoao0182 2014-12-08 23:03
浏览 50


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.

  • 写回答

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_*.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?



    • ¥15 Google Chrome 所有页面崩溃,三种解决方案都没有解决,我崩溃了
    • ¥20 使用uni-app发起网络请求,获取重定向302返回的cookie
    • ¥20 手机外部浏览器拉起微信小程序支付 (相关搜索:微信小程序)
    • ¥20 怎样通过一个网址找到其他同样模版的网址
    • ¥30 XIAO esp32c3 读取FDC2214的数据
    • ¥15 在工控机(Ubuntu系统)上外接USB蓝牙硬件进行蓝牙通信
    • ¥100 webapi的部署(标签-服务器)
    • ¥20 怎么加快手机软件内部计时的时间(关键词-日期时间)
    • ¥15 C语言除0问题的检测方法