$link = mysqli_connect('127.0.0.1', 'login', 'password', 'db');
    $sql = 'CALL procedure_name(1, 2)';
    $result = mysqli_query($link, $sql);
    while($row = mysqli_fetch_assoc($result)) {
        var_dump($row);
}

$sql = 'Call procedure_name(?, ?)';
$stmt = mysqli_prepare($link, $sql);
$p1 = 1;
$p2 = 2;
mysqli_stmt_bind_param($stmt, 'ii', $p1, $p2);
mysqli_stmt_execute($stmt);

$result = mysqli_stmt_result_metadata($stmt);
 $field = mysqli_fetch_field($result);

if (!($stmt = $mysqli->prepare("CALL p()"))) {
    echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
}

if (!$stmt->execute()) {
    echo "Execute failed: (" . $stmt->errno . ") " . $stmt->error;
}

do {
    if ($res = $stmt->get_result()) {
        printf("---n");
        var_dump(mysqli_fetch_all($res));
        mysqli_free_result($res);
    } else {
        if ($stmt->errno) {
            echo "Store failed: (" . $stmt->errno . ") " . $stmt->error;
        }
    }
} while ($stmt->more_results() && $stmt->next_result());

CREATE PROCEDURE p() READS SQL DATA BEGIN SELECT id FROM test; SELECT id + 1 FROM test; END;