CODEWITHSUNDEEP
phpdatabasefuelphp
AAron
AAron

Reputation: 368

FuelPHP can't setup database to work

I'm using FuelPHP and I can't set up my database so it would work. I know that i'm using right information but i'm not sure if I put it in right place.

<?php

return array(
'default' => array(
    'connection'  => array(
        'dsn'        => 'mysql:[email protected];dbname=modernt',
        'username'   => 'modernt',
        'password'   => 'pass',
    ),
),
);

This is my db.php in APP/config/db.php

Upvotes: 0

Views: 1803

Answers (4)

anhlc
anhlc

Reputation: 14439

First, check your environment configuration in app/bootstrap.php:

/**
* Your environment. Can be set to any of the following:
*
* Fuel::DEVELOPMENT
* Fuel::TEST
* Fuel::STAGING
* Fuel::PRODUCTION
*/
Fuel::$env = (isset($_SERVER['FUEL_ENV']) ? $_SERVER['FUEL_ENV'] : Fuel::DEVELOPMENT);

Then modify the db.php file accordingly (app/development/db.php, app/production/db.php, app/staging/db.php, app/test/db.php)

Upvotes: 0

WanWizard
WanWizard

Reputation: 2574

Environment configurations are merged, and the environment wins.

So if you have ./app/config/db.php containing return array('a'); and you'll have ./app/config/development/db.php containing return array('b');, then after reading your config, you'll end up with "b".

So if you use environment based config (like DB does by default), only add configuration to the global file that is truely global, otherwise it gets overwritten in the merge.

Upvotes: 2

Ferrakkem Bhuiyan
Ferrakkem Bhuiyan

Reputation: 2783

// a MySQL driver configuration
'development' => array(
    'type'           => 'mysqli',
    'connection'     => array(
        'hostname'       => 'localhost',
        'port'           => '3306',
        'database'       => 'fuel_db',
        'username'       => 'your_username',
        'password'       => 'y0uR_p@ssW0rd',
        'persistent'     => false,
        'compress'       => false,
    ),
    'identifier'     => '`',
    'table_prefix'   => '',
    'charset'        => 'utf8',
    'enable_cache'   => true,
    'profiling'      => false,
    'readonly'       => false,
),

// a PDO driver configuration, using PostgreSQL
'production' => array(
    'type'           => 'pdo',
    'connection'     => array(
        'dsn'            => 'pgsql:host=localhost;dbname=fuel_db',
        'username'       => 'your_username',
        'password'       => 'y0uR_p@ssW0rd',
        'persistent'     => false,
        'compress'       => false,
    ),
    'identifier'     => '"',
    'table_prefix'   => '',
    'charset'        => 'utf8',
    'enable_cache'   => true,
    'profiling'      => false,
    'readonly'       => array('slave1', 'slave2', 'slave3'),
),

'slave1' => array(
    // configuration of the first production readonly slave db
),

'slave2' => array(
    // configuration of the second production readonly slave db
),

'slave3' => array(
    // configuration of the third production readonly slave db
),

Basic procedure of setup FuelPHP..may be its help you .Thank you

Upvotes: 0

Alex
Alex

Reputation: 8072

Check this

'dsn' => 'mysql:host=moderntalking.lt;dbname=modernt',

Upvotes: 0

Related Questions