drslez4322 2014-03-25 08:30
浏览 164
已采纳

Yii createCommand()以不同的数组格式返回数据集

I'm a beginner in this framework. Though I have gone over the basics, there is one thing which is troubling me. As of now, I'm using

$group_sql = "SELECT uid FROM {$table}";
$group_users = Yii::app()->db->createCommand($group_sql)->queryAll();
print_r($group_users);

results in

Array
(
    [0] => Array
        (
            [uid] => 2
        )

    [1] => Array
        (
            [uid] => 3
        )

    [2] => Array
        (
            [uid] => 4
        )

    [3] => Array
        (
            [uid] => 5
        )

)

But I'd like to change the format in which the data is returned. What I'm looking for is something like

Array
(
    [0] => 2
    [1] => 3
    [2] => 4
    [3] => 5
)

OR

Array
(
    [uid] => Array
        (
            [0] => 2
            [1] => 3
            [2] => 4
            [3] => 5
        )
)

I'm aware that I can go through the documentation and get my answer, but due to time constraints, I'm taking the liberty to shamelessly ask this over here.

Thanks in advance.

  • 写回答

1条回答 默认 最新

  • drxm5014 2014-03-25 08:37
    关注

    Use queryColumn() method instead of queryAll()

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 ikuai客户端多拨vpn,重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题,如何解决?(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
  • ¥100 连续两帧图像高速减法
  • ¥15 如何绘制动力学系统的相图
  • ¥15 对接wps接口实现获取元数据