connect dan call procedure php mysqli.

<?php
$mysqli = new mysqli(“localhost”,“**MyUser**”,“**MyPass**”,“**MyDB**”);

/* check connection */
if (mysqli_connect_errno()) {
    printf(“<br />Connect failed: %s\n”, mysqli_connect_error());
    exit();
}

/* Call my stored procedure the first time */
if ($mysqli->multi_query(“CALL Account_Balance(1,’2007-04-09′);”)) {
    do {
        /* store first result set */
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_row()) {
                printf(“%s\n”, $row[0]);
            }
            $result->close();
        }
        /* print divider */
        if ($mysqli->more_results()) {
            printf(“—————–\n”);
        }
    } while ($mysqli->next_result());
}
else {
    printf(“<br />First Error: %s\n”, $mysqli->error);
}

/* Call my stored procedure the second time */
/* THIS TIME IT WORKS!!! */
if ($mysqli->multi_query(“CALL Account_Balance(2,’2007-04-09′);”)) {
    do {
        /* store first result set */
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_row()) {
                printf(“%s\n”, $row[0]);
            }
            $result->close();
        }
        /* print divider */
        if ($mysqli->more_results()) {
            printf(“—————–\n”);
        }
    } while ($mysqli->next_result());
}
else {
    printf(“<br />Second Error: %s\n”, $mysqli->error);
}

$mysqli->close();
?>