如何连接 2 个数组?我想要那个$new[$code]=$color
,我该怎么做?下面是我的代码:
$sql = "SELECT user_id, user_color FROM dotp_users";
$result = mysql_query($sql) or die(mysql_error());
$code = $color = array();
while($row = mysql_fetch_assoc($result)) {
$code[] = $row['user_id'];
$color[] = $row['user_color'];
}
在 while 循环之外声明变量
$new = array();
然后在 while 循环内
$new[$row['user_id']] = $row['user_color'];
在 while 循环中...
$sql = "SELECT user_id, user_color FROM dotp_users";
$result = mysql_query($sql) or die(mysql_error());
$code = $color = array();
while($row = mysql_fetch_assoc($result)) {
$new[$row['user_id']] = $row['user_color'];
}
如果出于某种原因需要将数组分开,则可以稍后使用 array_combine、http://php.net/manual/en/function.array-combine.php 执行此操作。
$sql = "SELECT user_id, user_color FROM dotp_users";
$result = mysql_query($sql) or die(mysql_error());
$code = $color = array();
while($row = mysql_fetch_assoc($result)) {
$code[] = $row['user_id'];
$color[] = $row['user_color'];
}
...
$new = array_combine($code, $color);