Working With Multiple Databases

$users = $this->db->get('id', 'users'); $stats = $this->analytics->get('id', 'page_views'); $stock = $this->warehouse->get_where(42, 'items');

$this->module('tax'); $total = $this->tax->calculate($amount); $this->module('payment_processor'); $this->payment_processor->charge($customer, $amount);

<?php class Orders_model extends Model { public function process_order(int $order_id): bool { $order = $this->db->get_where($order_id, 'orders'); // primary database if (!$order) { return false; } $tax_amount = $this->calculate_tax($order); $total = $this->update_order_total($order_id, $order->subtotal, $tax_amount); $this->send_confirmation($order->customer_email, $total); $this->log_order($order_id, $total); // analytics database return true; } private function calculate_tax(object $order): float { $this->module('tax'); return $this->tax->calculate($order->subtotal, $order->state); } private function update_order_total(int $order_id, float $subtotal, float $tax_amount): float { $total = $subtotal + $tax_amount; $update_data = [ 'tax_amount' => $tax_amount, 'total' => $total, 'processed_at' => time() ]; $this->db->update($order_id, $update_data, 'orders'); // primary database return $total; } private function send_confirmation(string $email, float $total): void { $this->module('email_sender'); $recipient = $email; $subject = 'Order Confirmation'; $message = 'Thank you for your order. Your total is $' . number_format($total, 2); $this->email_sender->send($recipient, $subject, $message); } private function log_order(int $order_id, float $amount): void { $analytics_data = [ 'order_id' => $order_id, 'amount' => $amount, 'timestamp' => time() ]; $this->analytics->insert($analytics_data, 'order_events'); // secondary database } }

// Controller example - automatic and explicit both work: $this->module('tax'); // explicit $total = $this->tax->calculate($amount); // automatic (recommended in v2) $total = $this->tax->calculate($amount);