How to database connect in Codeigniter

Today we’re going to be learning how to connect and then query a database in CodeIgniter. Knowing how to manipulate and read databases is an essential tool for creating any dynamic web application. Let’s get started.

Code (application/config/database.php)

$db['default'] = array( 'dsn'	=> '', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'hd_project3', 'dbdriver' => 'mysqli', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE
);

Related Posts