how use sql query in Symfony

Question

how can i write native sql queries with doctrine in symfony ?

Answer 1

$connection = $this->getDoctrine()->getManager()->getConnection();

$connection is now a class Doctrine\DBAL\Connection check the docs http://www.doctrine-project.org/api/dbal/2.1/class-Doctrine.DBAL.Connection.html

This code should help you.

$connection = $this->getDoctrine()->getManager()->getConnection();
$query = "
  INSERT INTO data (
      name
    , age
  ) VALUES (
      ?
    , ?
  )
";
$connection->executeQuery(
   $query
 , array(
      'test'
    , 30
   )
 , array(
     \PDO::PARAM_INT   
    ,\PDO::PARAM_STR
  )
);

Or

$connection = $this->getDoctrine()->getManager()->getConnection();

$name = 'test';
$age = 31;

$query = "
  INSERT INTO data (
      name
    , age
  ) VALUES (
      :name
    , :age
  )
";

$statement = $connection->prepare($sql);
$statement->bindValue("name", $name, \PDO::PARAM_INT);
$statement->bindValue("age", $age, \PDO::PARAM_STR);
$statement->execute();