CodeIgniter database connection, configuration, and usage
This document describes how to connect, configure, and use CodeIgniter to databases. We will share this with you for your reference. The details are as follows:
1. database:
create database test;create table users(id int not null,name varchar(10),pwd varchar(10),email varchar(20))insert into users values(1,'shunping','shunping','aa@163.com');insert into users values(2,'shunping2','shunping2','bb@163.com');
2. I use semi QL.
Configure the database parameters in the \ CodeIgniter \ system \ application \ config \ database. php file:
$active_group = "default";$db['default']['hostname'] = "localhost";$db['default']['username'] = "postgres";$db['default']['password'] = "admin";$db['default']['database'] = "test";$db['default']['dbdriver'] = "postgre";$db['default']['dbprefix'] = "";$db['default']['active_r'] = TRUE;$db['default']['pconnect'] = FALSE;$db['default']['db_debug'] = TRUE;$db['default']['cache_on'] = FALSE;$db['default']['cachedir'] = "";$db['default']['port'] = "5432";
The content of the test file db1.php in the \ CodeIgniter \ system \ application \ controllers directory is as follows:
<? Phpclass Db1 extends Controller {function index () {$ this-> load-> database (); $ query = $ this-> db-> query ("select name, pwd, email from users "); foreach ($ query-> result () as $ row) {// returns the object array echo $ row-> name; echo $ row-> pwd; echo $ row-> email. "<br>";} echo "Total Result = ". $ query-> num_rows () ;}}?>
Open the browser and enter the address:
Http: /localhost: 8888/index. php/MyController/db1
OK!
I think you must have encountered a problem that cannot connect to the database. I have spent a lot of time solving this problem. Now I want to help you learn about CodeIgniter, an excellent PHP framework.