Controller pulling database data from wrong place

Question

I have the application properly configured and running normally. But one detail is jamming.

This is my file . env:

APP_ENV=local
APP_DEBUG=true
APP_KEY=9FaEj6iJCBur1favtWQ88b8m1anbGbzP
DB_HOST=localhost
DB_DATABASE=laravel_blog
DB_USERNAME=root
DB_PASSWORD=
...

When I execute the command env('DB_DATABASE','forge') in Tinker, the value is returned laravel_blog, as it should be.

However when I do exactly the same operation inside a controller, the value is returned homestead, shouldn’t return that

Following as is the connection with the bank:

'mysql' => [
            'driver'    => 'mysql',
            'host'      => env('DB_HOST', 'localhost'),
            'database'  => env('DB_DATABASE', 'forge'),
            'username'  => env('DB_USERNAME', 'forge'),
            'password'  => env('DB_PASSWORD', ''),
            'charset'   => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix'    => '',
            'strict'    => false,
        ],

It ends up creating the situation that the database runs on Tinker, but the controller doesn’t work, because it takes the data from the wrong connection.

The problem is that I have no idea where the Variable is pulling the value of the constant inside the controller, since no . env the configured value is different.

Answer 1

Check your default connection in the database.php file, and see if it’s named after the connection you posted here, in this case "mysql"

'default' => env('DB_CONNECTION', 'mysql')

Change these lines from your database.php

'host'      => env('DB_HOST'),
'database'  => env('DB_DATABASE'),
'username'  => env('DB_USERNAME'),
'password'  => env('DB_PASSWORD'),

Take a look at the file ~/.homestead/Homestead.yaml in part:

databases:
    - homestead

Answer 2

I don’t know much about Laravel, I believe his example:

    'mysql' => [
        'driver'    => 'mysql',
        'host'      => env('DB_HOST', 'localhost'),
        'database'  => env('DB_DATABASE', 'forge'),
        'username'  => env('DB_USERNAME', 'forge'),
        'password'  => env('DB_PASSWORD', ''),
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

Be the default of Laravel, it’s just an example, I believe you can change the names easily by editing /config/database.php:

    'mysql' => [
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'laravel_blog',
        'username'  => 'root',
        'password'  => '',
        'charset'   => 'utf8',
        'collation' => 'utf8_unicode_ci',
        'prefix'    => '',
        'strict'    => false,
    ],

If you only have one database then you can edit your file .env, note that there are more than one file .env, sane:

• .env, .env.example and .env.production

You must change the .env the others not, because they are just examples, no . env there are these variables:

DB_HOST=localhost
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret

Just edit for something like in the example:

DB_HOST=localhost
DB_DATABASE=laravel_blog
DB_USERNAME=root
DB_PASSWORD=root

If you only have one bank, if the file . env doesn’t exist yet then read below:

Setting up the Laravel

• Before using the Laravel as I said in this answer it is necessary to create the file .env, note that in the Laravel folder there is a file called .env.example copy it and the name of .env if it does not exist.

• Then you will need to configure the APP_KEY, it must be a 32 character key, for example:

  APP_KEY=2XXjEeJYr2jO0lboHZPHLuN6eYmnxPvl
  

• I recommend you use the command key:generate to generate such key, note that to use the command artesian it is necessary to have configured by Poser and have added the environment variables, navigate to the folder of your project and then use the command:

  $ cd /home/user/laravel
  $ php artisan key:generate
  

• When moving the project to production (pro server online) you must change the line APP_DEBUG=true for APP_DEBUG=false, this will turn off errors that should only be displayed for the development environment and not for the end user and also change APP_ENV=local for APP_ENV=production.

O . env in Laravel in development environment:

APP_ENV=local
APP_DEBUG=true
APP_KEY=2XXjEeJYr2jO0lboHZPHLuN6eYmnxPvl

O . env in Laravel in production environment:

APP_ENV=production
APP_DEBUG=false
APP_KEY=2XXjEeJYr2jO0lboHZPHLuN6eYmnxPvl