How to Execute UNION Queries Using CodeIgniter's Active Record?

UNION Queries in CodeIgniter's Active Record Pattern

While CodeIgniter's Active Record provides a convenient way to execute database queries, it lacks native support for UNION queries. However, this limitation can be overcome using a custom query approach.

Using Custom Queries

To perform a UNION query using CodeIgniter's Active Record, you must manually write the query string and then use the query method:

$this->db->query('SELECT column_name(s) FROM table_name1 UNION SELECT column_name(s) FROM table_name2');

This query will execute the UNION operation and return the combined results. Note that you need to adjust the column names and table names according to your specific database schema.

The above is the detailed content of How to Execute UNION Queries Using CodeIgniter's Active Record?. For more information, please follow other related articles on the PHP Chinese website!