Introduction to the use of database classes provided by CodeIgniter

In CodeIgniter, database usage is very frequent. You can use the database class that comes with the framework to perform database operations conveniently.

Initialize Database Class

Load and initialize the Database Class Based on your Database Configuration:

$this->load->database();

You can use it anywhere after it is loaded.

Returns the query result as an object.

$query = $this->db->query('SELECT name, title, email FROM my_table');foreach ($query->result() as $row){    echo $row->title;    echo $row->name;    echo $row->email;}echo 'Total Results: ' . $query->num_rows();

The result () function above returns an array of objects. Example: $ row-> title

Returns the query result in an array.

$query = $this->db->query('SELECT name, title, email FROM my_table');foreach ($query->result_array() as $row){    echo $row['title'];    echo $row['name'];    echo $row['email'];}

The above result_array () function returns an array with the lower mark. Example: $ row ['title']

Returns a data record.

Object format:

$query = $this->db->query('SELECT name FROM my_table LIMIT 1');$row = $query->row();echo $row->name;

The row () function above returns an object. Example: $ row-> name

Array format:

$query = $this->db->query('SELECT name FROM my_table LIMIT 1');$row = $query->row_array();echo $row['name'];

The row_array () function above returns an array. Example: $ row ['name']

Insert data

$sql = "INSERT INTO mytable (title, name)         VALUES (".$this->db->escape($title).", ".$this->db->escape($name).")";$this->db->query($sql);echo $this->db->affected_rows();

Quick insert method:

$data = array(               'title' => $title,               'name' => $name,               'date' => $date            );$this->db->insert('mytable', $data); // Produces: INSERT INTO mytable (title, name, date) VALUES ('{$title}', '{$name}', '{$date}')

Database Configuration

CodeIgniter has a configuration file for you to store database connection values (username: username, password: password, database name: database name, etc ..). the configuration file is located in the following path: application/config/database. php

The accessory file is stored in a multi-dimensional array in the following format:

$db['default']['hostname'] = "localhost";$db['default']['username'] = "root";$db['default']['password'] = "";$db['default']['database'] = "database_name";$db['default']['dbdriver'] = "mysql";$db['default']['dbprefix'] = "";$db['default']['pconnect'] = TRUE;$db['default']['db_debug'] = FALSE;$db['default']['cache_on'] = FALSE;$db['default']['cachedir'] = "";$db['default']['char_set'] = "utf8";$db['default']['dbcollat'] = "utf8_general_ci";

The reason for using multi-dimensional arrays is to allow you to store the setting of multiple connection values at will. For example, if you run multiple environments (development: development, production: production, test: Testing, etc ..), you can establish independent connection groups for each environment and switch between groups directly. For example, to set up a "test" environment, you can do this:

$db['test']['hostname'] = "localhost";$db['test']['username'] = "root";$db['test']['password'] = "";$db['test']['database'] = "database_name";$db['test']['dbdriver'] = "mysql";$db['test']['dbprefix'] = "";$db['test']['pconnect'] = TRUE;$db['test']['db_debug'] = FALSE;$db['test']['cache_on'] = FALSE;$db['test']['cachedir'] = "";$db['test']['char_set'] = "utf8";$db['test']['dbcollat'] = "utf8_general_ci";

Then, tell the system to use the "test" group. You can set the variables in the configuration file:

$active_group = "test";

Note: The name of "test" is arbitrary, which allows you to set it freely. Our main connection uses the name "default" by default. Of course, you can give it a more meaningful name based on your project.

Active Record

The Active Record class can be globally set using the $ active_record variable in the database configuration file (allow/disable TRUE/FALSE (boolean )). if you do not need this class, you can set this variable value to FALSE to reduce the consumption of computer resources during database class initialization. $ Active_record = TRUE;

Note: Some CodeIgniter classes, such as Sessions, require the support of Active Records when executing some functions.

Parameter Parsing:

• Hostname-the host name of the database, which is usually on the local machine and can be expressed as "localhost ".
• Username-username to connect to the database.
• Password-password used to log on to the database.
• Database-name of the database to be connected.
• Dbdriver-database type. Such as mysql, ipvs, and odbc. It must be a lowercase letter.
• Dbprefix-the data table prefix when an Active Record query is run. It allows multiple CodeIgniter programs to be installed in a database.
• Pconnect-TRUE/FALSE (boolean)-use persistent connection.
• Db_debug-TRUE/FALSE (boolean)-displays database error information.
• Cache_on-TRUE/FALSE (boolean)-whether the database query cache is enabled. For more information, see database cache.
• Cachedir-absolute path of the server where the cache directory is located in the database query.
• Char_set-character set used for communicating with the database.
• Dbcollat-character collation used to communicate with the database ).
• Port-database port number. Currently, it is only used for ipvs drivers. To use this value, you should add a line of code to the Database Configuration array.

Record it for easy access.