File Manager

Editing:ajax-search.php

<?php
require_once 'db.php';

if (isset($_POST['query'])) {
    $q = "%" . $_POST['query'] . "%";
    $sql = "SELECT j.*, e.company_name, e.logo 
            FROM jobs j 
            JOIN employers e ON j.employer_id = e.id 
            WHERE j.status = 'active' AND (j.title LIKE ? OR e.company_name LIKE ?) 
            LIMIT 5";
    $results = fetchAll($sql, [$q, $q]);

if (empty($results)) {
        echo '<div class="p-3 text-center text-muted">No results found</div>';
    } else {
        foreach ($results as $job) {
            $logo = $job['logo'] ? 'uploads/logos/'.$job['logo'] : 'assets/img/default-company.png';
            echo "
            <a href='job-details.php?id={$job['id']}' class='list-group-item list-group-item-action d-flex align-items-center gap-3 border-0 py-3'>
                <img src='{$logo}' style='width: 40px; height: 40px; object-fit: contain;'>
                <div>
                    <h6 class='mb-0 fw-bold'>{$job['title']}</h6>
                    <small class='text-muted'>{$job['company_name']} - {$job['location']}</small>
                </div>
            </a>";
        }
    }
}
?>

Cancel

🤩 File Manager - Mr.X

Editing:ajax-search.php