Step by step to making db connection in symfony1.4

Question

I'm new to symfony. My existing application is developed in symfony1.4. They didn't used any db connection. Now I want to create new MySQL database connection in this application.

How can I do that?

j0k · Accepted Answer · 2012-12-11 08:23:22Z

1

in settings.yml
```
all:
  use_database: true
```

from the console run this command

php symfony configure:database "mysql:host=dbhost;dbname=yourdbname" dbuser dbpassword

edited Dec 11, 2012 at 8:23

j0k

22.8k28 gold badges81 silver badges90 bronze badges

answered Dec 11, 2012 at 8:09

ilSavo

8461 gold badge8 silver badges28 bronze badges

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

3 Comments

Manivasagan Over a year ago

Yes Thanks for your advice. Then how i should call that in action class.

j0k Over a year ago

@Manivasagan Don't forget to read the doc please.

ilSavo Over a year ago

No, just run it once from the console and, as just said by jOk, don't forget to read the doc

Manivasagan · Accepted Answer · 2013-03-01 10:59:46Z

Please check all the steps to make db connection symfony1.4

Step 1 :

file : config/ProjectConfiguration.class.php

find what:
---------

public function setup()
  {
    $this->enablePlugins('owCorePlugin');
  }

Repalce with :
------------
public function setup()
  {
    $this->enablePlugins('owCorePlugin');
    $this->enablePlugins('sfDoctrinePlugin');    
  }
Step 2 :
config/databases.yml
You need to create this file and add below code.replace caps letter with your details.You need to maintain same space also.
all:

doctrine: class: sfDoctrineDatabase param: dsn: mysql:host=HOST_NAME;dbname=DB_NAME username: USERNAME password: PASSWORD Step 3: frontend/config/settings.yml

find what :
use_database:           false
Replace with
use_database:           true
Run the following command:
change the project configuration.Make sure you need to run this command in root folder of our project

php symfony configure:database --name=doctrine --class=sfDoctrineDatabase "mysql:host=HOST_NAME;dbname=DB_NAME" USERNAME PASSWORD

step 5: schema files
$ php symfony doctrine:build-schema
$ php symfony doctrine:build-model
$ php symfony doctrine:build-forms
$ php symfony doctrine:build-filters
$ ln -s lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/web web/sfDoctrinePlugin

Collectives™ on Stack Overflow

Step by step to making db connection in symfony1.4

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related