function latest_jobs_shortcode() {

    global $wpdb;

    // External database connection
    $custom_db = new wpdb(
        'u923435796_jobdata',
        '1Pkinnovatives@',
        'u923435796_jobdata',
        'srv1333.hstgr.io'
    );

    // Fetch jobs
    $jobs = $custom_db->get_results(
        "SELECT * FROM jobs ORDER BY created_at DESC LIMIT 20",
        ARRAY_A
    );

    // No records
    if (empty($jobs)) {
        return '<p>No latest jobs found.</p>';
    }

    $output = '<div class="jobs-wrapper">';

    foreach ($jobs as $job) {

        $output .= '
        <div style="
            border:1px solid #ddd;
            padding:20px;
            margin-bottom:20px;
            border-radius:10px;
            background:#fff;
        ">

            <h2>' . esc_html($job['title']) . '</h2>

            <p>
                <strong>Company:</strong>
                ' . esc_html($job['companyName']) . '
            </p>

            <p>
                <strong>Location:</strong>
                ' . esc_html($job['location']) . '
            </p>

            <p>
                <strong>Posted Date:</strong>
                ' . esc_html($job['postedDate']) . '
            </p>

            <a href="' . esc_url($job['jobUrl']) . '" 
               target="_blank"
               style="
                    background:#0073aa;
                    color:#fff;
                    padding:10px 15px;
                    border-radius:5px;
                    text-decoration:none;
                    display:inline-block;
                    margin-top:10px;
               ">
               Apply Now
            </a>

        </div>';
    }

    $output .= '</div>';

    return $output;
}

add_shortcode('latest_jobs', 'latest_jobs_shortcode');