phpMyAdmin のストアド プロシージャを MVC アーキテクチャに統合するにはどうすればよいですか?

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

<code class="php"><?php

namespace MyApp\Controllers;

class CustomerController extends Controller
{
    public function getDetails($id)
    {
        // Call the stored procedure using a database connection
        // Replace 'my_database' with your database name
        $mysqli = new mysqli('localhost', 'username', 'password', 'my_database');
        $stmt = $mysqli->prepare("CALL get_customer_details(?)");
        $stmt->bind_param('i', $id);
        $stmt->execute();
        $result = $stmt->get_result();

        // Process the results
        $customer = $result->fetch_assoc();

        // Return the customer details as JSON
        return $this->jsonResponse($customer);
    }
}</code>