SyllabiSync/Curriculum.php at master · CodeByAshuu/SyllabiSync · 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
<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "frontend&backend";

$conn = mysqli_connect($servername, $username, $password, $database);
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$stream = isset($_GET['stream']) ? $_GET['stream'] : '';
$subject = isset($_GET['subject_name']) ? $_GET['subject_name'] : '';

$query = "SELECT * FROM syllabus_approvals WHERE status='Approved'";
if (!empty($stream)) {
    $query .= " AND stream = '" . mysqli_real_escape_string($conn, $stream) . "'";
}
if (!empty($subject)) {
    $query .= " AND subject_name = '" . mysqli_real_escape_string($conn, $subject) . "'";
}
$result = mysqli_query($conn, $query);

$stream_options = mysqli_query($conn, "SELECT DISTINCT stream FROM syllabus_approvals WHERE status='Approved'");
$subject_options = mysqli_query($conn, "SELECT DISTINCT subject_name FROM syllabus_approvals WHERE status='Approved'");
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Student Curriculum Viewer</title>
    <link rel="stylesheet" href="/src/output.css">
    <script src="https://cdn.tailwindcss.com"></script>
    <link rel="stylesheet" href="/src/output.css">
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.0/css/all.min.css">
</head>
<body class="bg-gray-100 min-h-screen ">
    <nav class="fixed top-0 left-0 w-full bg-white shadow-md shadow-gray-400/50 z-50">
        <div class="max-w-7xl mx-auto flex items-center justify-between px-6 py-4">
            <div class="flex items-center space-x-2">
                <span class="text-2xl text-white bg-blue-600 px-2 py-1 rounded-md font-semibold">Syllabi</span>
                <span class="text-2xl text-blue-600 font-semibold">Sync</span>
            </div>

            <div class="hidden md:flex space-x-8">
                <a href="landing_page.php" class="relative text-lg text-gray-800 hover:text-blue-500 after:block after:h-[2px] after:w-0 after:bg-blue-500 after:transition-all after:duration-300 hover:after:w-full">Home</a>
                <a href="about.php" class="relative text-lg text-gray-800 hover:text-blue-500 after:block after:h-[2px] after:w-0 after:bg-blue-500 after:transition-all after:duration-300 hover:after:w-full">About</a>
                <a href="Curriculum.php" class="relative text-lg text-gray-800 hover:text-blue-500 after:block after:h-[2px] after:w-0 after:bg-blue-500 after:transition-all after:duration-300 hover:after:w-full">Curriculum</a>
                <a href="contact.php" class="relative text-lg text-gray-800 hover:text-blue-500 after:block after:h-[2px] after:w-0 after:bg-blue-500 after:transition-all after:duration-300 hover:after:w-full">Contact</a>
            </div>

            <button id="menu-toggle" class="md:hidden text-gray-800 focus:outline-none">
                <svg class="w-8 h-8" fill="none" stroke="currentColor" stroke-width="2" viewBox="0 0 24 24"
                    xmlns="http://www.w3.org/2000/svg">
                    <path stroke-linecap="round" stroke-linejoin="round" d="M4 6h16M4 12h16m-7 6h7"></path>
                </svg>
            </button>
        </div>

        <div id="mobile-menu" class="hidden md:hidden flex-col items-center bg-white shadow-lg p-4 space-y-4">
            <a href="landing_page.php" class="text-lg text-gray-800 hover:text-blue-500">Home</a>
            <a href="about.php" class="text-lg text-gray-800 hover:text-blue-500">About</a>
            <a href="studentInterface.php" class="text-lg text-gray-800 hover:text-blue-500">Curriculum</a>
            <a href="contact.php" class="text-lg text-gray-800 hover:text-blue-500">Contact</a>
        </div>
    </nav>


    <h1 class="text-4xl font-bold text-blue-800 mb-10 mt-32 text-center flex items-center justify-center gap-3">
        <i class="fas fa-book-open text-blue-700 text-3xl"></i>
        Curriculum Viewer
    </h1>

    <form method="GET" class="mb-12 flex justify-center gap-6 flex-wrap">
        <select name="stream" class="px-4 py-2 rounded-md border border-gray-300 w-60 focus:outline-none focus:ring-2 focus:ring-blue-400">
            <option value="">Select Stream</option>
            <?php while ($row = mysqli_fetch_assoc($stream_options)) { ?>
                <option value="<?php echo $row['stream']; ?>" <?php echo ($stream == $row['stream']) ? 'selected' : ''; ?>>
                    <?php echo $row['stream']; ?>
                </option>
            <?php } ?>
        </select>
        <select name="subject_name" class="px-4 py-2 rounded-md border border-gray-300 w-60 focus:outline-none focus:ring-2 focus:ring-blue-400">
            <option value="">Select Subject</option>
            <?php while ($row = mysqli_fetch_assoc($subject_options)) { ?>
                <option value="<?php echo $row['subject_name']; ?>" <?php echo ($subject == $row['subject_name']) ? 'selected' : ''; ?>>
                    <?php echo $row['subject_name']; ?>
                </option>
            <?php } ?>
        </select>
        <button type="submit" class="bg-blue-600 text-white px-6 py-2 rounded-md hover:bg-blue-700 transition duration-300 flex items-center gap-2">
            <i class="fas fa-filter"></i> Filter
        </button>
    </form>

    <div class="max-w-7xl mx-auto">
        <?php if (mysqli_num_rows($result) > 0) { ?>
            <div class="grid grid-cols-1 sm:grid-cols-2 lg:grid-cols-3 gap-10">
                <?php while ($row = mysqli_fetch_assoc($result)) { ?>
                    <div class="bg-white border border-gray-200 p-6 rounded-lg shadow-md hover:shadow-lg transition duration-300">
                        <h2 class="text-xl font-semibold text-blue-700 mb-2">
                            <?php echo $row['university_name']; ?>
                        </h2>
                        <p class="text-gray-700 mb-1"><span class="font-medium">Subject:</span> <?php echo $row['subject_name']; ?></p>
                        <p class="text-gray-700 mb-1"><span class="font-medium">Stream:</span> <?php echo $row['stream']; ?></p>
                        <p class="text-gray-700 mb-4"><span class="font-medium">Uploaded:</span> <?php echo date('Y-m-d', strtotime($row['uploaded_at'])); ?></p>
                        <a href="viewCurriculum.php?id=<?php echo $row['id']; ?>" target="_blank" class="inline-flex items-center bg-blue-600 hover:bg-blue-700 text-white px-4 py-2 rounded-md transition duration-300">
                            <i class="fas fa-file-pdf mr-2"></i> View PDF
                        </a>
                    </div>
                <?php } ?>
            </div>
        <?php } else { ?>
            <div class="text-center text-red-600 text-lg font-medium mt-10">No records found</div>
        <?php } ?>
    </div>

    <footer class="bg-gray-900 text-white pt-12 pb-12 mt-12">
        <div class="container mx-auto px-4 text-center text-gray-400">
            <p>&copy; <?php echo date('Y'); ?> CTRL+C. All rights reserved.</p>
        </div>
    </footer>
    <script>
        const menuToggle = document.getElementById('menu-toggle');
        const mobileMenu = document.getElementById('mobile-menu');

        menuToggle.addEventListener('click', () => {
            mobileMenu.classList.toggle('hidden');
        });
    </script>
</body>
</html>

<?php mysqli_close($conn); ?>