在cakephp中使用自定义查询时出错？

Question

I have using cakephp for my website. And i use sql server 2012 with it. I have confused that when i use:

$this->set('types',$this->Manager->query('select * from product_types'));

to get the array of all my product types the return array is:

Array
(

    [0] => Array
    (
        [0] => Array
        (
            [id] => 1
            [name] => hoa my pham
        )
    )

    [1] => Array
    (
        [0] => Array
        (
            [id] => 2
            [name] => hoa my
        )

    )

)

Why has the [0] instead of [product_types]????

Answer 1

This is from the CakePHP documentation:

To use the model name as the array key, and get a result consistent with that returned by the Find methods, the query can be rewritten:

$this->Picture->query("SELECT * FROM pictures AS Picture LIMIT 2;");

which returns:

Array
(
    [0] => Array
    (
        [Picture] => Array
        (
            [id] => 1304
            [user_id] => 759
        )
    )

    [1] => Array
    (
        [Picture] => Array
        (
            [id] => 1305
            [user_id] => 759
        )
    )
)

So you need:

$this->set('types',$this->Manager->query('select * from product_types as Product_Types'));

Source: http://book.cakephp.org/2.0/en/models/retrieving-your-data.html

P.S.:

This syntax and the corresponding array structure is valid for MySQL only. Cake does not provide any data abstraction when running queries manually, so exact results will vary between databases.