将用户名和用户标识放入数组 [英] Making username and userid into an array

问题描述

我想要我的数组，像这样：

I want to my array, somthing like this:

array("userid"=>"username","1"=>"ganeshfriends","2"=>"tester")

mysql查询像这样的东西：

mysql query something like this:

$query = select username, userid from tbluser

$result = mysql_query($query);

while($row = mysql_fetch_array($result)){
    $items = array($row['userid']=>$row['username']);
}
print_r($items);

如何将userid作为键，将用户名设置为val？

How can I make userid as key and username as val?

推荐答案

尝试一下：

$query = "select username, userid from tbluser";

$result = mysql_query($query);
$items=array();
while($row = mysql_fetch_array($result)){
    $items[$row['userid']]=$row['username'];
}
print_r($items);

问题是您在while的每个循环中删除并重新分配结果数组（$ items）阻止

The problem is that you delete and reassign the result array ($items) in every loop of the while block

这篇关于将用户名和用户标识放入数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！