Detailed explanation of how to query the database with Symfony2

This article mainly introduces the method of obtaining data from the database in Symfony2, and summarizes and analyzes the commonly used Symfony database query techniques in the form of examples. Friends in need can refer to it. I hope it will be helpful to everyone.

Suppose there is a table: test, fields: name, color;
There are 2 records:
Tom blue
Lily red

Example 1:

$conn = $this->getDoctrine()->getConnection();
$data = $conn->fetchcolumn("SELECT name, color FROM test");
echo &#39;<pre class="brush:php;toolbar:false">&#39;; print_r($data);

The result is:

Tom

Example 2:

$conn = $this->getDoctrine()->getConnection();
$data = $conn->fetchArray("SELECT name, color FROM test");
echo &#39;<pre class="brush:php;toolbar:false">&#39;; print_r($data);

The result is:

Array
(
  [0]=>Tom
  [1]=>blue
)

Example 3:

$conn = $this->getDoctrine()->getConnection();
$data = $conn->fetchAssoc("SELECT name, color FROM test");
echo &#39;<pre class="brush:php;toolbar:false">&#39;; print_r($data);

The result is:

Array
(
  [name]=>Tom
  [color]=>blue
)

Example 4:

$conn = $this->getDoctrine()->getConnection();
$data = $conn->fetchAll("SELECT name, color FROM test");
echo &#39;<pre class="brush:php;toolbar:false">&#39;; print_r($data);

The result is:

Array
(
  [0] => Array
    (
      [name]=>Tom
      [color]=>blue
    )
  [1] => Array
    (
      [name]=>Lily
      [color]=>red
    )
)

Related recommendations:

Detailed explanation of the plug-in format of Symfony2

Detailed explanation of Symfony2 framework creation project and setting template

Detailed explanation of the usage of Symfony template shortcut variables

The above is the detailed content of Detailed explanation of how to query the database with Symfony2. For more information, please follow other related articles on the PHP Chinese website!