php-app/Main.php at main · CloudWave-Team1/php-app · 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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
<?php include "../inc/dbinfo.inc"; ?>

<html>
<head>
    <title>수강신청 시스템</title>
    <!-- Bootstrap v4.5 CSS CDN -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">

    <!-- jQuery CDN - Slim version (without AJAX) -->
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>

    <!-- Bootstrap v4.5 JS CDN (Popper.js included) -->
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.bundle.min.js"></script>
</head>
<body>
<div class="container mt-4">
<h1>수강신청 시스템</h1>
<?php

$connection = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD);
if (mysqli_connect_errno()) echo "Failed to connect to MySQL: " . mysqli_connect_error();

$database = mysqli_select_db($connection, DB_DATABASE);

VerifySubjectTable($connection, DB_DATABASE);
VerifyMySubTable($connection, DB_DATABASE);

if (isset($_POST['selected_subjects'])) {
    foreach ($_POST['selected_subjects'] as $subjectID) {
        $subjectID = mysqli_real_escape_string($connection, $subjectID);

        // Check if the SUBJECT_ID is already in MYSUB
        $checkDuplicate = mysqli_query($connection, "SELECT * FROM MYSUB WHERE SUBJECT_ID = '$subjectID'");
        if (mysqli_num_rows($checkDuplicate) > 0) {
            echo "<script>alert('이미 신청된 과목입니다.');</script>";
            continue;
        }

        $query = "INSERT INTO MYSUB (SUBJECT_ID) VALUES ('$subjectID')";
        mysqli_query($connection, $query);
    }
}

?>

<button onclick="location.href='Insert.php'" class="btn btn-secondary">과목 추가</button>
<button onclick="location.href='Admin.php'" class="btn btn-secondary">과목 삭제 및 더미데이터 추가</button>

<br><hr><br>

<h2>전체 과목 조회</h2>
<!-- Display SUBJECT table data. -->
<form method="POST">
<table  class="table table-bordered table-striped">
 <thead>
  <tr>
    <td>SELECT</td>
    <td>NAME</td>
    <td>PROFESSOR</td>
    <td>TIME</td>
    <td>MAX_NUM</td>
  </tr>
 </thead>
 <tbody>
<?php

$result = mysqli_query($connection, "SELECT * FROM SUBJECT");

while ($query_data = mysqli_fetch_row($result)) {
    echo "<tr>";
    echo "<td><input type='checkbox' name='selected_subjects[]' value='", $query_data[0], "' /></td>";
    for ($i = 1; $i < count($query_data); $i++) {
        echo "<td>", $query_data[$i], "</td>";
    }
    echo "</tr>";
}

?>
  <tr>
    <td colspan="5"><input type="submit" class="btn btn-primary"  value="신청하기"></td>
  </tr>
</tbody>
</table>
</form>

<br><hr><br>

<h2>신청 과목 조회</h2>
<!-- Display MYSUB JOINed with SUBJECT table data. -->
<table class="table table-bordered table-striped">
 <thead>
  <tr>
    <td>NAME</td>
    <td>PROFESSOR</td>
    <td>TIME</td>
    <td>MAX_NUM</td>
  </tr>
 </thead>
<tbody>
<?php

$result = mysqli_query($connection, "SELECT S.NAME, S.PROFESSOR, S.TIME, S.MAX_NUM FROM MYSUB M JOIN SUBJECT S ON M.SUBJECT_ID = S.ID");

while ($query_data = mysqli_fetch_row($result)) {
    echo "<tr>";
    for ($i = 0; $i < count($query_data); $i++) {
        echo "<td>", $query_data[$i], "</td>";
    }
    echo "</tr>";
}

mysqli_free_result($result);
mysqli_close($connection);
?>
</tbody>
</table>
<br><br>
</div>
</body>
</html>

<?php
/* Function definitions */

function VerifySubjectTable($connection, $dbName) {
    if (!TableExists("SUBJECT", $connection, $dbName)) {
        $query = "CREATE TABLE SUBJECT (
            ID int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
            NAME VARCHAR(45),
            PROFESSOR VARCHAR(45),
            TIME VARCHAR(45),
            MAX_NUM VARCHAR(45)
          )";

        if (!mysqli_query($connection, $query)) echo("<p>Error creating SUBJECT table.</p>");
    }
}

function VerifyMySubTable($connection, $dbName) {
    if (!TableExists("MYSUB", $connection, $dbName)) {
        $query = "CREATE TABLE MYSUB (
            MY_ID int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
            SUBJECT_ID int(11) UNSIGNED,
            FOREIGN KEY (SUBJECT_ID) REFERENCES SUBJECT(ID)
          )";

        if (!mysqli_query($connection, $query)) echo("<p>Error creating MYSUB table.</p>");
    }
}

function TableExists($tableName, $connection, $dbName) {
    $t = mysqli_real_escape_string($connection, $tableName);
    $d = mysqli_real_escape_string($connection, $dbName);

    $checktable = mysqli_query($connection,
        "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME = '$t' AND TABLE_SCHEMA = '$d'");

    if (mysqli_num_rows($checktable) > 0) return true;

    return false;
}
?>