How Can I Perform UNION Queries Using CodeIgniter's Active Record?

Performing UNION Queries with CodeIgniter's Active Record Pattern

UNION queries allow you to combine the results of multiple SELECT statements into a single result set. While CodeIgniter's Active Record pattern doesn't natively support UNION queries, there's a straightforward workaround:

Solution:

Utilize the query() method to execute a custom UNION query. Here's an example:

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

This query will combine the results from the two specified SELECT statements into a single result set. You can then use CodeIgniter's regular methods to access and manipulate the data, such as result() to retrieve an array of results or row() to get a single result.

Note: It's essential to ensure that the column names and data types in the UNION query are compatible to avoid any errors.

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