在php中,SQL查询数据库得到的是多行多列的数据,如何将查询结果转为二维数组,我的目的是把多行查询结果按行输出,有没有什么方法,求详细代码示例查询结果示例:reserv_idnametyper...
在php中,SQL查询数据库得到的是多行多列的数据,如何将查询结果转为二维数组,我的目的是把多行查询结果按行输出,有没有什么方法,求详细代码示例
查询结果示例:
reserv_id name type reserv_time
1 a x -4-14
2 b y -4-15
3 c z -4-16
想要将上述查询结果按行输出,请问查询结果怎么处理,求代码示例!
$order=array();
if($query_search_order){
while($row_order=mysql_fetch_array($query_search_order)){
print_r($row_order);
}
Array ( [0] => 30 [reserv_id] => 30 [1] => -04-09 [check_in_date] => -04-09 [2] => -04-16 [check_out_date] => -04-16 [3] => 3528 [amount] => 3528 [4] => 0 [reserv_status] => 0 ) Array ( [0] => 33 [reserv_id] => 33 [1] => -04-10 [check_in_date] => -04-10 [2] => -04-13 [check_out_date] => -04-13 [3] => 1242 [amount] => 1242 [4] => 0 [reserv_status] => 0 ) Array ( [0] => 34 [reserv_id] => 34 [1] => -04-09 [check_in_date] => -04-09 [2] => -04-12 [check_out_date] => -04-12 [3] => 1512 [amount] => 1512 [4] => 0 [reserv_status] => 0 )
结果是三个数组,怎么把它们存到二维数组里面
展开