database_final_project/Number6.php at main · ZachDevore/database_final_project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
    ini_set('error_reporting', 1);

    try {
        require_once('/pdo_connect.php');

        $result = $dbc->query("CALL CSC355SP26Movies.GetMovieCast(8802)");

    } catch (PDOException $e) {
        echo $e->getMessage();
    }
?>
<!DOCTYPE html>
<html>
<head>
    <title>One Stored Procedure</title>
</head>
<body>

    <h2>One Stored Procedure</h2>
        <table>
            <tr>
                <th>Actor</th>
                <th>Role</th>
            </tr>
            <?php foreach ($result as $row) {
                echo "<tr>";
            echo "<td>" . $row['Actor'] . "</td>";
            echo "<td>" . $row['Role'] . "</td>";
            echo "</tr>";
        }
        ?>
    </table>

</body>

</body>
</html>