sql query not working for doctrine 2

Question

$sql = "SELECT * FROM UserWfl ";
$query = $em->createQuery($sql);
$d = $query->getResult();
var_dump($d);

Reference link: http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/dql-doctrine-query-language.html

error is coming:

[Syntax Error] line 0, col 7: Error: Expected IdentificationVariable | ScalarExpression | AggregateExpression | FunctionDeclaration | PartialObjectExpression | "(" Subselect ")" | CaseExpression, got '*'

Possible duplicate of [Execute raw SQL using Doctrine 2](https://stackoverflow.com/questions/3325012/execute-raw-sql-using-doctrine-2) — iainn, Dec 20 '17 at 10:58

score 0 · Answer 1 · edited Dec 20 '17 at 11:37

0

Try this

$sql = "SELECT u FROM UserWfl u";
$query = $em->createQuery($sql);
$d = $query->getResult();
var_dump($d);

edited Dec 20 '17 at 11:37

Thomas Fritsch

9,639
33
37
49

answered Dec 20 '17 at 11:15

Nidhi Singhal

1
1

score 0 · Accepted Answer · answered Dec 21 '17 at 17:39

0

createQuery It is a function for DQL. SQL is different. Doctrine use createNativeQuery function for SQL.

http://www.doctrine-project.org/2009/08/15/doctrine2-native-queries.html for more detail

answered Dec 21 '17 at 17:39

Ashfaq Muhammad

780
5
10

sql query not working for doctrine 2

2 Answers2