Project-Pertama/add.php at main · Sembarang28/Project-Pertama · 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
93
94
95
96
97
98
99
100
101
102
103
<?php ob_start();?>
<!DOCTYPE html>
<head>
    <title>Add Games</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
    <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</head>
<body>
    <?php
        include_once("connect.php");
    ?>
    <div class="container-fluid p-5 bg-primary">
        <div class="col-md-12 text-center text-white">
            <h1>ADD GAMES</h1>
        </div>
    </div>
    <div class="container-fluid p-2 bg-dark text-white text-center">
            <h5>Isi Data Berikut!</h5>
    </div>
    <div class="container mt-5">
        <div class="row">
            <div class="col-md-12">
                <form action="add.php" method="post" name="form1">
                    <table width="100%" class="table-bordered" cellpadding="10">
                        <tr>
                            <td>id games</td>
                            <td><input type="text" class="form-control" name="id_games"></td>
                        </tr>
                        <tr>
                            <td>Title</td>
                            <td><input type="text" class="form-control" name="title"></td>
                        </tr>
                        <tr>
                            <td>Genre</td>
                            <td><input type="text" class="form-control" name="genre"></td>
                        </tr>
                        <tr>
                            <td>Developer</td>
                            <td><input type="text" class="form-control" name="developer"></td>
                        </tr>
                        <tr>
                            <td>Publisher</td>
                            <td><input type="text" class="form-control" name="publisher"></td>
                        </tr>
                        <tr>
                            <td>Release Date</td>
                            <td><input type="date" class="form-control" name="release_date"></td>
                        </tr>
                        <tr>
                            <td>File Size</td>
                            <td><input type="number" class="form-control" name="file_size"></td>
                        </tr>
                        <tr>
                            <td>Price</td>
                            <td><input type="number" class="form-control" name="price"></td>
                        </tr>
                        <tr>
                            <td>Link</td>
                            <td><input type="text" class="form-control" name="link"></td>
                        </tr>
                        <tr>
                            <td>Details</td>
                            <td><input type="text" class="form-control" name="details"></td>
                        </tr>
                        <tr>
                            <td>Image</td>
                            <td><input type="text" class="form-control" name="image"></td>
                        </tr>
                        <tr>
                            <td></td>
                            <td><input type="submit" class="form-control btn btn-primary" name="Submit" value="Add"></td>
                        </tr>
                    </table>
                </form>
            </div>
        </div>
    </div>
</body>
</html>

<?php
    if (isset($_POST['Submit'])){
        $id_games = $_POST['id_games'];
        $title = $_POST['title'];
        $genre = $_POST['genre'];
        $developer = $_POST['developer'];
        $publisher = $_POST['publisher'];
        $release_date = $_POST['release_date'];
        $file_size = $_POST['file_size'];
        $price = $_POST['price'];
        $link = $_POST['link'];
        $details = $_POST['details'];
        $image = $_POST['image'];

        $insert = mysqli_query($mysqli, "INSERT INTO games values('$id_games','$title','$genre',
        '$developer','$publisher','$release_date','$file_size','$price','$link','$details','$image');");

        header("Location:index.php");
        ob_end_flush();
    }
?>