Detailed explanation of how to query the database with Symfony2-PHP Tutorial-php.cn

Detailed explanation of how to query the database with Symfony2

*文

Release： 2023-03-19 10:42:01

Original

2780 people have browsed it

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);

Copy after login

The result is:

Tom

Copy after login

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);

Copy after login

The result is:

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

Copy after login

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);

Copy after login

The result is:

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

Copy after login

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);

Copy after login

The result is:

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

Copy after login

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!