问题描述
我正在使用教义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();
这篇关于在原则中使用列值作为数组索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!