How to set env with laravel artisan to have two different database connections (local/remote)?

21,781

Solution 1

Here, how I solved my question:

First I didn't need the command php artisan migrate --env=local, I just need set on my virtualhost: SetEnv LARAVEL_ENV development.

Second, as William Cahill-Manley say, I need to work on application/paths.php, the $environments. I've used it before but the wrong way. In my case, I solve with that:

$environments = array(
    'development' => array('http://localhost/project*', '*project/*'),
    'production' => array('http://project.com', 'http://*.project.com')
);

My problem was because my code before was like that:

$environments = array(
    'development' => array('http://localhost/project*', '*project*'),
    'production' => array('http://project.com', 'http://*.project.com')
);

And because the second element of development array, in the production server always will be in development. Thats because the url on development be http://project/ and on production be http://project.com/ or http://user.project.com/

See, the project will force in all envonriments be development by the asterisk/wildcard.

Solution 2

"Foo" is whatever command you want to run. E.g. for migrations:

php artisan migrate --env=local

Another thing you can do is add your computers hostname to this array

For example, if my local computer name is 'Effinity.local' I could do

$environments = array(
    'local' => array('http://localhost*', 'Effinity.local'),
);

Then you do not need to specify the environment, just:

php artisan migrate

Hope that helps.

Share:
21,781
Lucas Serafim
Author by

Lucas Serafim

Brazilian currently living in Mexico. Full-stack PHP developer, working with PHP for the past 11 years. I am always learning new technologies and updating already known ones. In the past 5 years, I have been working remotely for several online businesses from Brazil. I have worked in a different range of sectors as a programmer; from business marketing to tourism and transport. Also, I'm always trying to help clients and co-worker, as much as learning what they too, have to teach.

Updated on July 15, 2020

Comments

  • Lucas Serafim
    Lucas Serafim almost 4 years

    I looking for setup a multi-environment project using Laravel3 but I dont understand the command to set the environment.

    I see here: http://laravel.com/docs/artisan/commands The command is:

    php artisan foo --env=local
    

    I already used artisan and bob with success, what I can't undertand the foo, I try to change to my project name but always the same output: "Sorry, I can't find that task."

    If I try: php artisan --env=local

    That will return: "You forgot to provide the task name."

    Anybody can help? Thanks for your time.

    [edit] With the answers now I can understand better and improve my question:

    I have a project with those folders created: http://d.pr/i/5nZS With that in mind, I need to set my local env as development and production as production. So, I can do that with any variation of the command "php artisan --env=local" or I need to add on my public/.htaccess "SetEnv LARAVEL_ENV development"?

    Thanks again.

  • Lucas Serafim
    Lucas Serafim over 11 years
    So, on my local I need set: "$ php artisan migrate --env=development" And on production server: "$ php artisan migrate --env=production" With that and my array like this: gist.github.com/4557659 And also with my config folders configured like that: d.pr/i/5nZS This will work? I tried but still seems not work, what I also tried is with "SetEnv LARAVEL_ENV development" what's almost working but I need a little more time to try again. Thanks for the answer.
  • Lucas Serafim
    Lucas Serafim over 11 years
    Yeah, thats what I imaginate before but with "php artisan foo --env=local" this will run the task just when the env is local, right? What I really need is set the whole project as a local or development and with that make my config folder (d.pr/i/5nZS) work and connect the correct database host.