条令加入给了我不同的数组，而不是代码点火器中的一个数组 - Doctrine join give me different different array instead of one array in codeigniter

Doctrine join give me different different array instead of one array in codeigniter

本文关键字：数组点火器代码一个 | 更新日期: 2023-09-27

你好，盖伊的《我是新学说》。我只是试着加入像这样的学说中的查询

 $query = $this->em->createQuery('SELECT sub, cat FROM Entity'Zi_subcategory sub JOIN Entity'Zi_category cat WHERE sub.cat_id = cat.id');
 $arrData['subcategories'] = $query->execute();
 echo "<pre>"; print_r($arrData['subcategories']); exit;

但它给了我不同的数组结果，而不是一个数组，我的输出是

 Array
(
    [0] => Entity'Zi_subcategory Object
        (
            [id:protected] => 1
            [name:protected] => cricket
            [cat_id:protected] => 11
            [description:protected] => testing
            [created_at:protected] => DateTime Object
                (
                    [date] => 2014-10-02 00:00:00.000000
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )
            [updated_at:protected] => DateTime Object
                (
                    [date] => 2014-10-02 00:00:00.000000
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )
        )
    [1] => Entity'Zi_category Object
        (
            [id:protected] => 11
            [name:protected] => testing2
            [description:protected] => testing
            [created_at:protected] => DateTime Object
                (
                    [date] => 2014-10-06 17:54:15.000000
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )
            [updated_at:protected] => DateTime Object
                (
                    [date] => 2014-10-06 17:54:15.000000
                    [timezone_type] => 3
                    [timezone] => Asia/Kolkata
                )
        )
)

我的问题是，如果它是正确的，那么我们将如何在表中显示数据，因为当我尝试运行foreach时，由于2个数组，它运行了2次。

我更改了代码，将此代码用于数组

$arrData['subcategories'] = $this->qb->select(array('sub.id', 'sub.name as subcat_name','cat.name as category_name'))
                                    ->from('Entity'Zi_subcategory','sub')
                                    ->join('Entity'Zi_category', 'cat')
                                    ->where('sub.cat_id = cat.id')
                                    ->orderBy('sub.id','DESC')
                                    ->setFirstResult( $offset )
                                    ->setMaxResults( $config['per_page'] )
                                    ->getQuery()
                                    ->getresult();
 echo "<pre>"; print_r($arrData['subcategories']); exit;

它对我有效……thax所有的…