Execute SQL query using second database in codeigniter

Asked Aug 06 '19 at 05:14

Active Aug 06 '19 at 06:01

Viewed 46 times

I want to get the data from the second database connected to Codeigniter using a SQL query.

Sample code :

$db2 = $this->load->database('second_db', true);
$product_id = implode(",", $product_id);
$query = $db2->prepare("SELECT * FROM rt_product_details WHERE id IN ($product_id)");

if ($query->execute()) {
    $result = $query->fetchall(PDO::FETCH_ASSOC);
    var_dump($result);die;
}

edited Aug 06 '19 at 06:01

marc_s

732,580
175
1,330
1,459

asked Aug 06 '19 at 05:14

odinson

2

So??? What is the issue you are facing? Any error? Please write something you are getting.. – Pathik Vejani Aug 06 '19 at 05:18
1

Possible duplicate of [Codeigniter - multiple database connections](https://stackoverflow.com/questions/8268853/codeigniter-multiple-database-connections) – sh1hab Aug 06 '19 at 05:29
In your code, I can see, CI Active Records + MySQLi . .. – Abdulla Nilam Aug 06 '19 at 05:41
what's your output/ error ? – Abdulla Nilam Aug 06 '19 at 05:56
1

Dont forget that if the connecting user has privileges you can connect to a second database by doing `second_db.rt_product_details` in your select query on your existing $db connection. – Antony Aug 06 '19 at 07:27

Execute SQL query using second database in codeigniter

0 Answers0