php 数组取值

Question

YII的 queryAll() 返回的数组
Array
(
[0] => Array
(
[max(p_price)] => 68.00
[min(p_price)] => 2.00
[avg(p_price)] => 21.065231
)

)

把这个数组传递到页面上，值怎么取出来呢？
if($cat_value)
{
$connection = Yii::app()->db_pre;
$sql = "SELECT max(p_price) ,min(p_price),avg(p_price) FROM pre_item where p_cat_name='{$cat_value}'";
$command = $connection->createCommand($sql);
$price = $command->queryAll();
}
print_r($price);

Answer 1

看着括号不是很爽，select 语句里加一个as
if($cat_value)
{
$connection = Yii::app()->db_pre;
$sql = "SELECT max(p_price) as max_price,min(p_price) as min_price,avg(p_price) as avg_price FROM pre_item where p_cat_name='{$cat_value}'";
$command = $connection->createCommand($sql);
$price = $command->queryAll();
}

foreach($price as $k => $v){
echo "第".($k+1)."个商品："."<br>";
echo "最高价：".$v['max_price']."<br>";
echo "最低价：".$v['min_price']."<br>";
echo "平均价：".$v['avg_price']."<br>";
}追问

嗯， 谢谢啦

Answer 2

直接输出不行吗？比如echo $price[0]['p_price'];本回答被提问者采纳