How to set up a database connection in Phalcon?

@dedrick 

Phalcon is a PHP framework that provides easy-to-use tools for building web applications. To set up a database connection in Phalcon, you can follow these steps:

1. In your Phalcon project, open the config/config.php file.
2. Define the database parameters, including the host, username, password, and database name:

1
2
3
4
5
6
7
8
9

return new PhalconConfig([
    'database' => [
        'adapter' => 'Mysql',
        'host' => 'localhost',
        'username' => 'your-username',
        'password' => 'your-password',
        'dbname' => 'your-database-name',
    ],
]);

1. In your controller or model, you can use the following code to establish a database connection:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

use PhalconDbAdapterPdoMysql as DbAdapter;

$di->set('db', function () {
    return new DbAdapter([
        'host'     => $this->config->database->host,
        'username' => $this->config->database->username,
        'password' => $this->config->database->password,
        'dbname'   => $this->config->database->dbname,
    ]);
});

Note that di is an instance of PhalconDiFactoryDefault().

With this code, you can now access the database in your controller or model using the $this->db object. For example, to retrieve data from a table, you can use the following code:

1

$results = $this->db->query("SELECT * FROM your-table")->fetchAll();

That's it! You have successfully set up a database connection in Phalcon.