File manager - Edit - /home/monara/public_html/BenHoldings_web/assets/php/fetch_jobs.php
Back
<?php include 'config.php'; $category = isset($_POST['category']) ? $_POST['category'] : ""; $sql = $category ? "SELECT * FROM jobs WHERE category='$category'" : "SELECT * FROM jobs"; $jobs = $conn->query($sql); if ($jobs->num_rows > 0): ?> <div class="accordion" id="jobAccordion"> <?php while ($job = $jobs->fetch_assoc()): ?> <div class="accordion-item"> <h2 class="accordion-header" id="heading<?= $job['id'] ?>"> <button class="accordion-button" type="button" data-bs-toggle="collapse" data-bs-target="#collapse<?= $job['id'] ?>" aria-expanded="true" aria-controls="collapse<?= $job['id'] ?>"> <strong><?= htmlspecialchars($job['title']) ?></strong> </button> </h2> <div id="collapse<?= $job['id'] ?>" class="accordion-collapse collapse" aria-labelledby="heading<?= $job['id'] ?>" data-bs-parent="#jobAccordion"> <div class="accordion-body"> <p class="text-center"> <img src="uploads/<?= htmlspecialchars($job['image']) ?>" class="img-fluid" alt="Job Image"> </p> <p><?= htmlspecialchars($job['description']) ?></p> <p class="text-muted"> <small>Posted on: <?= htmlspecialchars(date("F j, Y", strtotime($job['created_at']))) ?></small> </p> </div> </div> </div> <?php endwhile; ?> </div> <?php else: ?> <p class="text-center">No jobs available in this category.</p> <?php endif; ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings