我从选择数据库中得到了一组这样的数组,其中表中的[0]是ID,[1]是Item,[2]是Type:
Array
(
[0] => LO001
[1] => Fork
[2] => A
)
Array
(
[0] => LO002
[1] => Spoon
[2] => B
)
但我希望它是这样的:
Array
(
[0] => Array
(
[0] => LO001
[1] => Fork
[2] => A
)
[1] => Array
(
[0] => LO002
[1] => Spoon
[2] => B
)
)
*编辑,从数据库中选择数据的代码,$selected是一组来自复选框的数组形式的结果。:
$query = "SELECT ID, name, type FROM location WHERE loc_id = '$selected'";
$sqlcb = mysql_query($query);
$ccb = array();
while($ccb= mysql_fetch_array($sqlcb)) {
print_r($ccb);
}
$selected数组结构示例(此数组可以根据复选框表单中的用户输入进行更改。
Array
(
[0] => LO001
[1] => LO002
)
使用类似于的东西
while($ccb= mysql_fetch_array($sqlcb)) {
$finalArray[] = $ccb;
}
print_r($finalArray);
请注意,由于安全问题,mysql_*
现在已从PHP7
开始弃用。建议您切换到mysqli_*
或PDO
扩展。
您可以创建新的数组,如:
$arr1 = array('LO001','Fork','A');
$arr2 = array('LO002','Spoon','B');
$newArr = array();
$newArr[] = $arr1;
$newArr[] = $arr2;
输出:
Array
(
[0] => Array
(
[0] => LO001
[1] => Fork
[2] => A
)
[1] => Array
(
[0] => LO002
[1] => Spoon
[2] => B
)
)