MVC アプリケーションの phpMyAdmin でストアド プロシージャを作成して呼び出す方法

<code class="sql">CREATE PROCEDURE get_customer_orders(IN customer_id INT)
BEGIN
    SELECT * FROM orders WHERE customer_id = customer_id;
END;</code>

<code class="php"><?php

use PDO;

class CustomerModel
{
    private $db;

    public function __construct()
    {
        $this->db = new PDO(...);
    }

    public function getOrders($customerId)
    {
        $stmt = $this->db->prepare("CALL get_customer_orders(?)");
        $stmt->bindParam(1, $customerId, PDO::PARAM_INT);
        $stmt->execute();

        return $stmt->fetchAll();
    }
}</code>

<code class="php">class CustomerController
{
    public function index($customerId)
    {
        $customerModel = new CustomerModel();
        $orders = $customerModel->getOrders($customerId);

        return view('customer/orders', ['orders' => $orders]);
    }
}</code>