原则2平原价值预期

问题描述：

我无法执行Doctrine DQL查询。这是它给我的错误。

I'm having trouble executing a Doctrine DQL Query. This is the error it gives me.

Doctrine\Common\Annotations\AnnotationException: [Syntax Error] Expected PlainValue, 
got 'integer' at position 13 in property Base\Session::$lifetime.

我的代码如下所示：

$query = $em->createQuery("SELECT s FROM Base\Session s WHERE s.session = \"$id\"");

其中$ id是当前session_id。我的模型看起来像：

Where $id is the current session_id. My Model looks like:

namespace Base;

/** @Entity @Table(name="session") */
class Session extends Skeleton {
/**
 * @Id @Column(type="integer")
 * @GeneratedValue(strategy="AUTO")
 */
protected $id;

/** @Column(length=32) */
protected $session;

/** @Column(type=integer) */
protected $lifetime;

/** @Column(type=integer) */
protected $modified;

/** @Column(type="text") */ 
protected $data;
}

答

您有两个错误

您必须引用您的注释，即@Column（type =integer）而不是@Colunn（type = integer）。当您的Mapping错误时，Doctrine\Common\Annotations\AnnotationException被抛出。这与查询无关。

您的查询应使用准备好的语句，即

You have to quote your annotations, i.e. @Column(type="integer") not @Colunn(type=integer). Doctrine\Common\Annotations\AnnotationException is thrown when your Mapping is wrong. This has nothing to do with the Query.
Your query should use prepared statements, i.e.

$ query = $ em-> createQuery（SELECT s FROM Base\Session s WHERE s.session =？1）;
$ query-> setParameter（1，$ id）;

$query = $em->createQuery("SELECT s FROM Base\Session s WHERE s.session = ?1"); $query->setParameter(1, $id);

原则2平原价值预期

相关推荐