$query1="select * from u_sale_pay ";
$stmt = $PDO->query( $query1 );
while ( $row = $stmt->fetch() ){
$data1=print_r( $row );
}
是sql数据库
怎么才能将结果输出成。里面查询是表中有三个字段。但是这么才能输出成下面这样的呢。
字段分别是id，name，sex
array(
array('1','小王','男'),
array('2','小李','男'),
array('3','小张','女'),
array('4','小赵','女')
);
$query1="select * from u_sale_pay ";
$stmt = $PDO->query( $query1 );
while ( $row = $stmt->fetch() ){
$data1[]=array( $row['id'],$row['name'],$row['sex']);
}
print_r($data1);
$query1="select * from u_sale_pay ";
$stmt = $PDO->query( $query1);
$list = array();//定义数组
while ($row = $stmt->fetch() ){
$list[] = $row;
}
var_dump($list);