Database_Project/index.php at main · prijal21/Database_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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
<?php
require './Service.php';
$service = new Service();
$viewers = $service->fetchAllViewers();
?>

<!DOCTYPE html>
<html>

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title></title>
    <meta name="description" content="">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="style.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.2/css/all.min.css" integrity="sha512-HK5fgLBL+xu6dm/Ii3z4xhlSUyZgTT9tuc/hSrtw6uzJOvgRr2a9jyxxT1ely+B+xFAmJKVSTbpM/CuL7qxO8w==" crossorigin="anonymous" />
</head>

<body>
    <div class = "container">
    <div> <h1>Viewer Database Management</h1></div>

    <table>
        <thead>
            <tr class='header'>
                <th class='header'>ViewerId</th>
                <th>Name</th>
                <th>Sex</th>
                <th>Email</th>
                <th>Age</th>
                <th>City</th>
                <th>StateAb</th>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($viewers as $viewer) : ?>
                <tr>
                    <td><?= htmlspecialchars($viewer->ViewerId); ?></td>
                    <td><?= htmlspecialchars($viewer->Name); ?></td>
                    <td><?= htmlspecialchars($viewer->Sex); ?></td>
                    <td><?= htmlspecialchars($viewer->Email); ?></td>
                    <td><?= htmlspecialchars($viewer->Age); ?></td>
                    <td><?= htmlspecialchars($viewer->City); ?></td>
                    <td><?= htmlspecialchars($viewer->StateAb); ?></td>
                </tr>
            <?php endforeach; ?>
        </tbody>
    </table>

    <hr>
<!-- SEARCH FORM -->
<h3>Search Viewer</h3>
    <form action="searchViewer.php" method="post">
       <label> ViewerId or Name: </label> <input type="text" name="search_item"><br><br>
        <input type="submit" value="SearchViewer">
    </form>
<hr>
<br>
    <!-- INSERT FORM -->
    <h3>Insert Viewer</h3>
    <form action="insertViewer.php" method="post">
        <label>Name: </label> <input type="text" name="name" required><br>
        <label>Sex: </label> <input type="text" name="sex"><br>
        <label>Email: </label> <input type="email" name="email"><br>
        <label>Age: </label> <input type="text" name="age"><br>
        <label>City: </label> <input type="text" name="city"><br>
        <label> StateAb: </label> <input type="text" name="stateab"><br>
        <br>
        <input type="submit" value="insertViewer">
    </form>
<hr>
<br>
    <!-- UPDATE FORM -->
    <h3>Update Viewer Name</h3>
    <form action="updateViewer.php" method="post">
        <label>ViewerId: </label> <input type="text" name="viewerId" required>
        <label>NewName: </label> <input type="text" name="newname" required><br><br>
        <input type="submit" value="UpdateViewer">
    </form>
<hr>
<br>
    <!-- DELETE FORM -->
    <h3>Delete Viewer</h3>
    <form action="deleteViewer.php" method="post">
    <label>ViewerId or Name: </label> <input type="text" name="delete_item"><br><br>
        <input type="submit" value="DeleteViewer">
    </form>
    </div>
</body>

</html>