//查询的语句是这样的
$query1="select saleno,paytype from d_sale_pay_123";
$stmt = $PDO->query( $query1);
$list = array();//定义数组
while ($row = $stmt->fetch() ){
$list[] = $row;
}
$nihao=var_dump($list);
echo "$nihao<br>";
//这个是输出的格式
array(13) { [0]=> array(4) { ["saleno"]=> string(22) "1021221119100319460212" [0]=> string(22) "1021221119100319460212" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [1]=> array(4) { ["saleno"]=> string(22) "1021221119102958623003" [0]=> string(22) "1021221119102958623003" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [2]=> array(4) { ["saleno"]=> string(22) "7021221119100651724145" [0]=> string(22) "7021221119100651724145" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [3]=> array(4) { ["saleno"]=> string(22) "7021221119120213764715" [0]=> string(22) "7021221119120213764715" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [4]=> array(4) { ["saleno"]=> string(22) "7021221119155927700252" [0]=> string(22) "7021221119155927700252" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [5]=> array(4) { ["saleno"]=> string(22) "7021221119172004884354" [0]=> string(22) "7021221119172004884354" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [6]=> array(4) { ["saleno"]=> string(22) "7021221119175602296223" [0]=> string(22) "7021221119175602296223" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [7]=> array(4) { ["saleno"]=> string(22) "7021221120090720142614" [0]=> string(22) "7021221120090720142614" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [8]=> array(4) { ["saleno"]=> string(22) "7021221120104259473435" [0]=> string(22) "7021221120104259473435" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [9]=> array(4) { ["saleno"]=> string(22) "7021221120142721677779" [0]=> string(22) "7021221120142721677779" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [10]=> array(4) { ["saleno"]=> string(22) "7021221120193519978896" [0]=> string(22) "7021221120193519978896" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [11]=> array(4) { ["saleno"]=> string(22) "7021221120204902600290" [0]=> string(22) "7021221120204902600290" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } [12]=> array(4) { ["saleno"]=> string(22) "7021221120210407418001" [0]=> string(22) "7021221120210407418001" ["paytype"]=> string(6) "809080" [1]=> string(6) "809080" } }
现在的数据是这样的，我想导出成Excel。需要输出的数据是下面的这种格式。这个应该怎么弄呢
$data = array(
array('1021221119100319460212','809080'),
array('1021221119102958623003','809080)
);
$query1="select saleno,paytype from d_sale_pay_123";
$stmt = $PDO->query( $query1 );
while ( $row = $stmt->fetch() ){
$data1[]=array( $row['saleno'],$row['paytype']);
}
print_r($data1);
mysql正常查询出来的就是二位数组的，你展示数据格式也是二维数组，你要是内容还是你输出的格式转excel