PHP 融合两个数组


PHP Fusing two arrays

如何连接 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);