在原则中使用列值作为数组索引

在原则中使用列值作为数组索引

本文介绍了在原则中使用列值作为数组索引的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在使用教义2.1,以便为设置表创建一个模型:

I am using doctrine 2.1 in order to create a model for settings table:

id |  arg  |  value  |  category
1  |  name |  foo    |  general_settings
2  |  desc |  bar    |  general_settings

假设我有很多不同类别的设置。为了获得特定类别的所有设置,我会这样做:

Suppose that I have a lot of setting for different categories. In order to get all the setting for a specific category I do something like this:

$q = Doctrine_Query::create()
    ->from('Setting p')
    ->where('p.category = ?', $category_name);

此时一切正常。嗯... $ 64,000的问题是:
确实存在一个数据访问的替代方法,让我读下面的结果?

Everything works fine at this point. Well.. the question of $64,000 is:Do exist a data access alternative that allow me to read the result as below?

$resultSet = $q->execute();

//the magic here could be use the -arg- column as index
$requested_setting = $resulSet['name']

//print the setting value
echo $requested_setting['value'];  //should prints "foo"

//another way
echo $resulSet['desc']['value']; //should prints "bar"


推荐答案

这里的诀窍是使用 INDEX BY 字。

导入Query类(不总是可选):

import the Query class (no always optional):

use \Doctrine\ORM\Query;

创建查询:

$query = $this->data->em->createQuery('
    SELECT s
    FROM models\Setting s
    INDEX BY s.arg //to set array custom key
    WHERE s.category = :category');
$query->setParameter('category', 'general');

设置隐藏模式以使用只读数组

set the hidration mode in order to work with read-only arrays

$settings = $query->getResult(Query::HYDRATE_ARRAY);

显示值:

echo $settings['desc']['value'];  // prints "bar"



QueryBuilder



使用 QueryBuilder 对象,您可以从语句中的设置索引:

QueryBuilder

With the QueryBuilder object you can set the index at the from statement:

$qb = $em->createQueryBuilder();
$qb->select('s');
$qb->from('models\Settings', 's', 's.arg');  // here the magic
$result = $qb->getQuery()->getResult();

然后,您可以访问该对象:

Then, you can access the object as:

$description = $result['desc'];
$value = $description->getValue();

这篇关于在原则中使用列值作为数组索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-18 18:40