MySQL 与 Symfony2 [英] MySQL with Symfony2

问题描述

我不想使用 Symfony2 学说.而是想编写自己的数据类来处理 MySQL 查询.那么有什么方法可以直接执行sql查询.谷歌上的大多数文章都在谈论 Doctrine 或 MySQL+Doctrine.

I don't want to use Symfony2 doctrine. Instead want to write own data classes to handle MySQL queries. So is there any way that directly sql queries can be executed. Most article in google talks about Doctrine or MySQL+Doctrine.

推荐答案

如果你不想使用 Doctrine ORM 甚至 Doctrine DBAL，绝对没有什么能阻止你直接使用 PDO/MySQLi.

If you don't want to use Doctrine ORM or even Doctrine DBAL, absolutley nothing stopes you from using PDO/MySQLi directly.

1. 将 PDO 实例定义为 DIC 服务:

1. Define PDO instance as DIC service:

<service id="pdo" class="PDO">
    <argument>dns</argument>
    <argument>user</argument>
    <argument>password</argument>
    <call method="setAttribute">
        <argument>2</argument> <!-- use exception for error handling -->
    </call>
</service>

为每个需要数据库连接的服务传递 PDO 实例:

Pass PDO instance for each service that requires database connection:

<service id="my.custom.service" class="My\Custom\Service">
     <argument type="service" id="pdo" />
</serivce>

---

namespace My\Custom;

class Service {
    public function __construct(PDO $pdo) { }
}

这篇关于MySQL 与 Symfony2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！