MySQL with Symfony2

Question

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.

Why you would like to skip Doctrine? Doctrine does provide ways to run Native SQL directly (docs.doctrine-project.org/en/latest/reference/native-sql.html) - if you need performance. — luiges90
– luiges90, Commented Dec 26, 2012 at 14:02

Crozin · Accepted Answer · 2012-12-26 16:44:06Z

3

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

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>

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) { }
}

answered Dec 26, 2012 at 16:44

Crozin

44.5k13 gold badges92 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

iamdto · Accepted Answer · 2012-12-26 15:04:55Z

0

There's a cookbook about using Doctrine's DBAL Layer.

answered Dec 26, 2012 at 15:04

iamdto

1,37211 silver badges23 bronze badges

Collectives™ on Stack Overflow

MySQL with Symfony2

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related