CodeIgniter Join query function is used to fetch the result from one or more tables. The join types are normal join, inner join, left join and right join.
CodeIgniter Delete query will execute using following functions. They are delete, truncate, empty_table and also we can use delete functions with join query
CodeIgniter UPDATE query will execute using following functions. They are update, update string, and update batch
CodeIgniter update query will execute using following functions. They are query, query bindings, insert_string, insert_batch, affected_rows, and insert
This tutorial describe the following functions. They are query, get, get_where, group_by, order_by, limit, offset, select, from, max, min, result, result_array etc
This tutorial will help you to understand about codeigniter query function, table prefixes, escaping queries and query bindings etc.
To autoload resources, open the application/config/autoload.php file and add the item you want loaded to the autoload array.
The database.php file contains all the information to connect to a database. A Database is required for most web application programming. CodeIgniter supported databases are MySQL (4.1+), MySQLi, MS SQL, Postgres, Oracle, SQLite, and ODBC
This config.php file are located under application/config filder or your own custom configuration file. This class is initialized automatically by the system so there is no need to do it manually.