index.php

<?php
    include 'connection/koneksi.php';

    $sql = "SELECT * FROM siswa ORDER BY nrp";
    $result = mysqli_query($conn, $sql);
?>

<?php 
    $pageTitle = "Input Data";
    include 'cdn.php';
    include 'layouts/header.php';
    include 'layouts/sidebar.php';
?>

<div class="sm:ml-64 mt-14">
    <div class="p-4">
        <div class="pb-4 text-2xl font-bold text-left rtl:text-right text-gray-900 bg-white dark:text-white dark:bg-gray-800">
            Daftar Tabel Mahasisawa 1 Teknik Informatika B
            <p class="mt-1 text-sm font-normal text-gray-500 dark:text-gray-400">This is a list of students in Informatics Engineering Class 1B, including names, student NRP, and other details. Use this list to get to know your classmates better.</p>
        </div>

        <div class="flex items-center justify-between flex-column flex-wrap md:flex-row space-y-4 md:space-y-0 pb-4 bg-white dark:bg-gray-900">
            <div><?php include 'create.php'; ?></div>
                
            <label for="table-search" class="sr-only">Search</label>
            <div class="relative">
                <div class="absolute inset-y-0 rtl:inset-r-0 start-0 flex items-center ps-3 pointer-events-none">
                    <svg class="w-4 h-4 text-gray-500 dark:text-gray-400" aria-hidden="true"
                        xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 20 20">
                        <path stroke="currentColor" stroke-linecap="round" stroke-linejoin="round" stroke-width="2"
                            d="m19 19-4-4m0-7A7 7 0 1 1 1 8a7 7 0 0 1 14 0Z" />
                    </svg>
                </div>
                <input type="text" id="table-search-users"
                    class="block p-2 ps-10 text-sm text-gray-900 border border-gray-300 rounded-lg w-60 bg-gray-50 focus:ring-blue-500 focus:border-blue-500 dark:bg-gray-700 dark:border-gray-600 dark:placeholder-gray-400 dark:text-white dark:focus:ring-blue-500 dark:focus:border-blue-500"
                    placeholder="Search for users">
            </div>
        </div>

            <!-- Student data table -->
        <div class="relative overflow-x-auto shadow-md sm:rounded-lg">
            <table class="w-full text-sm text-left rtl:text-right text-gray-500 dark:text-gray-400">
                <thead class="text-xs text-gray-700 uppercase bg-gray-50 dark:bg-gray-700 dark:text-gray-400">
                    <tr>
                        <!-- <th scope="col" class="px-6 py-3">ID</th> -->
                        <th scope="col" class="px-6 py-3">NRP</th>
                        <th scope="col" class="px-6 py-3">Name</th>
                        <th scope="col" class="px-6 py-3">Age</th>
                        <th scope="col" class="px-6 py-3">Gender</th>
                        <th scope="col" class="px-6 py-3">Address</th>
                        <th scope="col" class="px-6 py-3">Upload</th>
                        <th scope="col" class="px-6 py-3">Action</th>
                    </tr>
                </thead>
                <tbody>
                <?php
                if (mysqli_num_rows($result)>0) {
                    while ($row = mysqli_fetch_assoc($result)) {
                        $id = $row["id"];
                    ?>
                    <tr class="bg-white border-b dark:bg-gray-800 dark:border-gray-700 border-gray-200 hover:bg-gray-50 dark:hover:bg-gray-600">
                        <!-- <td class="px-6 py-4 font-medium text-gray-900 dark:text-white"><?php echo $row["id"]; ?></td> -->
                        <td class="px-6 py-4 font-medium text-gray-500 dark:text-white"><?php echo $row["nrp"]; ?></td>
                        <td class="px-6 py-4 font-medium text-gray-500 dark:text-white"><?php echo $row["name"]; ?></td>
                        <td class="px-6 py-4 font-medium text-gray-500 dark:text-white"><?php echo $row["age"]; ?></td>
                        <td class="px-6 py-4 font-medium text-gray-500 dark:text-white"><?php echo $row["gender"]; ?></td>
                        <td class="px-6 py-4 font-medium text-gray-500 dark:text-white"><?php echo $row["address"]; ?></td>
                        <td class="px-6 py-4 font-medium text-gray-500 dark:text-white">
                        <?php
                                $uploadQuery = "SELECT * FROM upload WHERE siswaid = '$id' LIMIT 1";
                                $uploadResult = mysqli_query($conn, $uploadQuery);
                                if ($uploadRow = mysqli_fetch_assoc($uploadResult)) {
                                    echo "<img src='" . $uploadRow['path'] . "' alt='Foto Profil' class='w-16 h-16 object-cover'>";
                                } 
                            ?>
                        </td>
                        <td class="flex items-center px-6 py-4">
                            <a href="update.php?id=<?php echo $row["id"]; ?>" class="font-medium text-blue-600 dark:text-blue-500 hover:underline">Update</a>
                            <a href="process/remove.php?id=<?php echo $row["id"]; ?>" class="font-medium text-red-600 dark:text-red-500 hover:underline ms-3">Delete</a>
                            <?php
                                $Downloadsql = "SELECT * FROM upload WHERE siswaid = '$id' ";
                                $Downloadresult = mysqli_query($conn, $Downloadsql);
                                while($file = mysqli_fetch_array($Downloadresult))
                                    echo "<a href='" . $file['path'] . "' download='IMG_{$row['nrp']}.jpg' class='font-medium text-green-600 dark:text-green-500 hover:underline ms-3'>Download</a>";
                            ?>
                        </td>
                    </tr>
                <?php
                    }
                } else {
                    echo "<tr><td colspan='5' class='px-4 py-2 border text-center'>No data found</td></tr>";
                }
                ?>
                </tbody>
            </table>
        </div>
    </div>
    <?php include 'layouts/footer.php'; ?>
</div>