📁 File Manager
Editing:
/home/wvl7mof7402e/public_html/sky/jobs.php
<?php /* ========================================================== SESSION START & DATABASE CONNECTION ========================================================== */ session_start(); include 'db.php'; // Database connection include karne ke liye if (!isset($conn) || !($conn instanceof mysqli)) { $conn = new mysqli('localhost', 'root', '', 'sky_brigade_db'); if ($conn->connect_error) { die('Database connection failed: ' . $conn->connect_error); } } /* ========================================================== ADMIN LOGIN & SESSION HANDLING ========================================================== */ if (!isset($_SESSION['admin_user'])) { $_SESSION['admin_user'] = 'admin'; $_SESSION['admin_pass'] = 'sky9311'; } if (isset($_GET['show_login']) && $_GET['show_login'] === 'true') { $_SESSION['show_admin_box'] = true; } if (isset($_POST['login_btn'])) { $input_user = trim($_POST['admin_username']); $input_pass = trim($_POST['admin_password']); $query = $conn->prepare("SELECT * FROM admin WHERE username = ? AND password = ?"); $query->bind_param("ss", $input_user, $input_pass); $query->execute(); $result = $query->get_result(); if ($result->num_rows > 0) { $_SESSION['admin_logged_in'] = true; echo "<script>alert('Login successful!'); window.location.href='jobs.php';</script>"; } else { echo "<script>alert('Galat Username ya Password!');</script>"; } $query->close(); } if (isset($_GET['logout'])) { unset($_SESSION['admin_logged_in']); unset($_SESSION['show_admin_box']); session_destroy(); header("Location: jobs.php"); exit(); } /* ========================================================== ADD JOB (ADMIN ONLY) ========================================================== */ if (isset($_POST['add_job_btn']) && isset($_SESSION['admin_logged_in'])) { $title = trim($_POST['job_title']); $country = trim($_POST['country']); $salary = trim($_POST['salary']); $desc = trim($_POST['description']); $last_date = trim($_POST['last_date']); // Last date input $stmt = $conn->prepare("INSERT INTO jobs (job_title, country, salary, description, last_date) VALUES (?, ?, ?, ?, ?)"); $stmt->bind_param("sssss", $title, $country, $salary, $desc, $last_date); $stmt->execute(); $stmt->close(); echo "<script>alert('Job post ho gayi!'); window.location.href='jobs.php';</script>"; } /* ========================================================== DELETE JOB (ADMIN ONLY) ========================================================== */ if (isset($_GET['delete_id']) && isset($_SESSION['admin_logged_in'])) { $del_id = intval($_GET['delete_id']); $conn->query("DELETE FROM jobs WHERE id = $del_id"); echo "<script>alert('Job delete ho gayi!'); window.location.href='jobs.php';</script>"; } ?> <!DOCTYPE html> <html lang="en"> <head> <!-- Meta Tags --> <meta charset="UTF-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>SKY BRIGADE MANPOWER SERVICE </title> <!-- Favicon --> <link rel="icon" type="image/x-icon" href="assets/img/logo/favicon.png"> <!-- CSS Links --> <link rel="stylesheet" href="assets/css/bootstrap.min.css"> <link rel="stylesheet" href="assets/css/all-fontawesome.min.css"> <link rel="stylesheet" href="assets/css/animate.min.css"> <link rel="stylesheet" href="assets/css/magnific-popup.min.css"> <link rel="stylesheet" href="assets/css/owl.carousel.min.css"> <link rel="stylesheet" href="assets/css/nice-select.min.css"> <link rel="stylesheet" href="assets/css/style.css"> </head> <body> <!-- ========================================================== HEADER AREA START (Navigation & Top Bar) ========================================================== --> <header class="header"> <!-- Header Top --> <div class="header-top"> <div class="container"> <div class="header-top-wrap"> <div class="header-top-left"> <div class="header-top-list"> <ul> <li><a href="mailto:skybrigadejobs@gmail.com"><i class="far fa-envelopes"></i> <span>skybrigadejobs@gmail.com</span></a></li> <li><a href="tel:+91-9311531390"><i class="far fa-phone-volume"></i> +91-9311531390/8178109244</a></li> <li><a href="#"><i class="far fa-alarm-clock"></i> Sun - Fri (10AM - 6PM)</a></li> </ul> </div> </div> <div class="header-top-right"> <div class="header-top-list"> <?php if (isset($_SESSION['admin_logged_in']) && $_SESSION['admin_logged_in'] === true): ?> <a href="jobs.php?logout=true" style="color: #ff4d4d; font-weight: bold;"><i class="far fa-sign-out"></i> Logout (Admin)</a> <?php else: ?> <a href="jobs.php?show_login=true" style="color: #fff; font-weight: bold; text-decoration: none;"><i class="far fa-lock"></i> Admin Login</a> <?php endif; ?> </div> <div class="header-top-social"> <span>Follow Us: </span> <a href="#"><i class="fab fa-facebook"></i></a> <a href="#"><i class="fab fa-x-twitter"></i></a> <a href="#"><i class="fab fa-instagram"></i></a> <a href="#"><i class="fab fa-linkedin"></i></a> </div> </div> </div> </div> </div> <!-- Navbar --> <div class="main-navigation"> <nav class="navbar navbar-expand-lg"> <div class="container position-relative"> <a class="navbar-brand" href="index.php"> <img src="assets/img/logo/logo.png" alt="logo"> </a> <div class="mobile-menu-right"> <button class="navbar-toggler" type="button" data-bs-toggle="offcanvas" data-bs-target="#offcanvasNavbar" aria-controls="offcanvasNavbar"> <span></span><span></span><span></span> </button> </div> <div class="offcanvas offcanvas-start" tabindex="-1" id="offcanvasNavbar"> <div class="offcanvas-header"> <a href="index.php" class="offcanvas-brand"><img src="assets/img/logo/logo.png" alt=""></a> <button type="button" class="btn-close" data-bs-dismiss="offcanvas" aria-label="Close"><i class="far fa-xmark"></i></button> </div> <div class="offcanvas-body"> <ul class="navbar-nav justify-content-end flex-grow-1"> <li class="nav-item"><a class="nav-link" href="index.php">Home</a></li> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" href="#" data-bs-toggle="dropdown">About</a> <ul class="dropdown-menu fade-down"> <li><a class="dropdown-item" href="profile.php">Company Profile</a></li> <li><a class="dropdown-item" href="vision.php">Vision & Mission</a></li> <li><a class="dropdown-item" href="team.php">Our Team</a></li> </ul> </li> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" href="#" data-bs-toggle="dropdown">Services</a> <ul class="dropdown-menu fade-down"> <li><a class="dropdown-item" href="recruitment.php">Recruitment Services</a></li> <li><a class="dropdown-item" href="saudi.php">Saudi Visa Stamping</a></li> <li><a class="dropdown-item" href="kuwait.php">Kuwait Visa Stamping</a></li> <li><a class="dropdown-item" href="air.php">Air Ticketing Services</a></li> <li><a class="dropdown-item" href="immigration.php">Immigration Services</a></li> <li><a class="dropdown-item" href="visast.php">Visa Stamping Services</a></li> <li><a class="dropdown-item" href="manpower.php">Manpower Services</a></li> <li><a class="dropdown-item" href="document.php">Document Attestation Services</a></li> <li><a class="dropdown-item" href="tour.php">Tour & Travel Services</a></li> </ul> </li> <li class="nav-item"><a class="nav-link" href="ind.php">Industries</a></li> <li class="nav-item"><a class="nav-link" href="rec.php">Recruitment Process</a></li> <li class="nav-item"><a class="nav-link" href="contact.php">Contact</a></li> <li class="nav-item"><a class="nav-link" href="gallery.php">Gallery</a></li> <li class="nav-item"><a class="nav-link active" href="jobs.php">Jobs</a></li> </ul> <div class="nav-right"> <div class="nav-btn"> <a href="contact.php" class="theme-btn">Let's Talk<i class="fas fa-circle-arrow-right"></i></a> </div> <button type="button" class="sidebar-btn nav-right-link" data-bs-toggle="offcanvas" data-bs-target="#sidebarPopup"> <span></span> <span></span> <span></span> </button> </div> </div> </div> </div> </nav> </div> </header> <!-- Header Area End --> <!-- sidebar-popup --> <div class="sidebar-popup offcanvas offcanvas-end" tabindex="-1" id="sidebarPopup"> <div class="offcanvas-header"> <a href="index.php" class="sidebar-popup-logo"> <img src="assets/img/logo/logo.png" alt=""> </a> <button type="button" class="btn-close" data-bs-dismiss="offcanvas" aria-label="Close"> <i class="far fa-xmark"></i> </button> </div> <div class="sidebar-popup-wrap offcanvas-body"> <div class="sidebar-popup-content"> <div class="sidebar-popup-about"> <h4>About Us</h4> <p>SKY BRIGADE MANPOWER SERVICE, introduces ourselves as professional Head-Hunters, International Recruitment Firms, Overseas Recruitment Agencies, and HR Consultants in India. We have an excellent track record of recruiting thousands of management professionals, technical and non-technical personnel, and skilled, semi-skilled, and unskilled workers for corporate giants in the Middle East and European countries. SKY BRIGADE MANPOWER SERVICE is your one-stop shop for all overseas manpower requirements.</p> </div> <div class="sidebar-popup-contact"> <h4>Contact Info</h4> <ul> <li> <div class="icon"> <i class="far fa-envelope"></i> </div> <div class="content"> <h6>Email</h6> <a href="mailto:skybrigadejobs@gmail.com">skybrigadejobs@gmail.com</a> </div> </li> <li> <div class="icon"> <i class="far fa-phone"></i> </div> <div class="content"> <h6>Phone</h6> <a href="tel:+91-9311531390">+91-9311531390/8178109244</a> </div> </li> <li> <div class="icon"> <i class="far fa-location-dot"></i> </div> <div class="content"> <h6>Address</h6> <a href="#">167/7 3rd Floor, Sarai Juliena, New Friends Colony, New Delhi - 110025</a> </div> </li> </ul> </div> <div class="sidebar-popup-social"> <h4>Follow Us</h4> <a href="#"><i class="fab fa-facebook"></i></a> <a href="#"><i class="fab fa-x-twitter"></i></a> <a href="#"><i class="fab fa-instagram"></i></a> <a href="#"><i class="fab fa-linkedin"></i></a> </div> </div> </div> </div> <!-- sidebar-popup end --> <!-- ========================================================== MAIN CONTENT AREA (Jobs Listing & Admin Form) ========================================================== --> <main class="main"> <!-- Breadcrumb --> <div class="site-breadcrumb" style="background: url(assets/img/breadcrumb/01.jpg)"> <div class="container"> <h2 class="breadcrumb-title">Current Job Vacancies</h2> <ul class="breadcrumb-menu"> <li><a href="index.php">Home</a></li> <li class="active">Jobs</li> </ul> </div> </div> <div class="container py-100"> <!-- Job Search Bar --> <div class="row mb-4"> <div class="col-lg-6 mx-auto"> <form method="GET" action="jobs.php" class="input-group"> <input type="text" name="search" class="form-control" placeholder="Search by Job Title or Country..." value="<?php echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : ''; ?>"> <button class="btn btn-primary" type="submit">Search</button> <?php if (isset($_GET['search'])): ?> <a href="jobs.php" class="btn btn-secondary">Reset</a> <?php endif; ?> </form> </div> </div> <!-- Job Search Bar end --> <!-- ADMIN LOGIN BOX (Agar ?show_login=true click ho) --> <?php if (isset($_SESSION['show_admin_box']) && $_SESSION['show_admin_box'] === true && !isset($_SESSION['admin_logged_in'])): ?> <div class="row mb-5"> <div class="col-lg-4 mx-auto"> <div class="card shadow p-3 text-center" style="background: #fff; border-radius: 8px;"> <h6 class="text-muted mb-2">Owner Restricted Area</h6> <form action="" method="POST"> <div class="mb-2"> <input type="text" name="admin_username" class="form-control form-control-sm" placeholder="Username" required> </div> <div class="input-group mb-2"> <input type="password" name="admin_password" class="form-control form-control-sm" placeholder="Password" required> <button type="submit" name="login_btn" class="btn btn-dark btn-sm">Login</button> </div> </form> </div> </div> </div> <?php endif; ?> <!-- ADMIN JOB POST FORM (Jab Admin Login ho) --> <?php if (isset($_SESSION['admin_logged_in']) && $_SESSION['admin_logged_in'] === true): ?> <div class="row mb-5"> <div class="col-lg-6 mx-auto"> <div class="card shadow p-4" style="background: #f8f9fa; border-left: 5px solid #000066;"> <h4 class="mb-3 text-dark">Post New Job Vacancy</h4> <form action="" method="POST"> <div class="mb-3"> <input type="text" name="job_title" class="form-control" placeholder="Job Title (e.g. Electrician, Driver)" required> </div> <div class="mb-3"> <input type="text" name="country" class="form-control" placeholder="Country (e.g. Saudi Arabia, Dubai)" required> </div> <div class="mb-3"> <input type="text" name="salary" class="form-control" placeholder="Salary Details (e.g. 2000 SAR)"> </div> <div class="mb-3"> <label class="form-label text-dark fw-bold">Last Date to Apply:</label> <input type="date" name="last_date" class="form-control" required> </div> <div class="mb-3"> <textarea name="description" class="form-control" rows="3" placeholder="Job Description / Requirements"></textarea> </div> <button type="submit" name="add_job_btn" class="btn btn-primary w-100">Post Job Now</button> </form> </div> </div> </div> <?php endif; ?> <?php // Search logic: agar user ne kuch search kiya hai toh filter karega, warna sabhi jobs dikhayega $search = isset($_GET['search']) ? trim($_GET['search']) : ''; if ($search !== '') { $stmt = $conn->prepare("SELECT * FROM jobs WHERE job_title LIKE ? OR country LIKE ? ORDER BY id DESC"); $searchTerm = "%" . $search . "%"; $stmt->bind_param("ss", $searchTerm, $searchTerm); $stmt->execute(); $result = $stmt->get_result(); } else { $result = $conn->query("SELECT * FROM jobs ORDER BY id DESC"); } echo '<div class="row g-4">'; // Row open ki taaki cards line mein aayein if ($result && $result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo '<div class="col-lg-4 col-md-6"> <div class="card p-4 shadow-sm h-100" style="border: 2px solid #000066; border-radius: 10px;"> <h4 class="text-dark mb-2">' . htmlspecialchars($row['job_title']) . '</h4> <p class="mb-1"><strong>Country:</strong> ' . htmlspecialchars($row['country']) . '</p> <p class="mb-1"><strong>Salary:</strong> ' . htmlspecialchars($row['salary']) . '</p> <p class="text-muted mb-3">' . htmlspecialchars($row['description']) . '</p> <div class="alert alert-secondary p-2 mb-3" style="font-size: 13px;"> <span class="d-block">📅 <strong>Posted:</strong> ' . date("d M Y", strtotime($row['posted_date'])) . '</span> <span class="d-block text-danger">⏳ <strong>Last Date:</strong> ' . date("d M Y", strtotime($row['last_date'])) . '</span> </div> <a href="https://wa.me/919311531390?text=I am interested in applying for ' . urlencode($row['job_title']) . ' in ' . urlencode($row['country']) . '" target="_blank" class="btn btn-success btn-sm w-100 mt-auto"><i class="fab fa-whatsapp"></i> Apply via WhatsApp</a>'; if (isset($_SESSION['admin_logged_in']) && $_SESSION['admin_logged_in'] === true) { echo '<a href="jobs.php?delete_id=' . $row['id'] . '" class="btn btn-danger btn-sm w-100 mt-2" onclick="return confirm(\'Kya aap sach mein is job ko delete karna chahte hain?\');"><i class="far fa-trash"></i> Delete Job</a>'; } echo '</div></div>'; } } else { echo '<div class="col-12 text-center py-5"><h4>No job vacancies found!</h4></div>'; } echo '</div>'; // Row close k ?> </div> </div> </main> <!-- Main Content Area End --> <!-- ========================================================== FOOTER AREA START ========================================================== --> <footer class="footer-area"> <div class="footer-shape"> <img src="assets/img/shape/01.png" alt=""> </div> <div class="footer-widget"> <div class="container"> <div class="footer-widget-wrap pt-100 pb-80"> <div class="row g-4"> <div class="col-lg-5"> <div class="footer-widget-box footer-form-box"> <h4 class="footer-form-title">Quick Inquiry</h4> <form onSubmit="sendFooterWhatsApp(); return false;"> <table class="footer-form-table"> <tr> <td>Name</td> <td><input type="text" id="f_name" placeholder="Your Name" required></td> </tr> <tr> <td>Mobile</td> <td><input type="tel" id="f_mobile" placeholder="Mobile Number" required></td> </tr> <tr> <td>Subject</td> <td><input type="text" id="f_subject" placeholder="Subject"></td> </tr> <tr> <td>Country</td> <td> <select id="f_country" required> <option value="">Select Country</option> <option>Saudi Arabia</option> <option>Malaysia</option> <option>Qatar</option> <option>Germany</option> <option>Turkey</option> <option>Russia</option> <option>South Africa</option> <option>UAE</option> <option>Oman</option> <option>Bahrain</option> <option>Romania</option> <option>Singapore</option> </select> </td> </tr> <tr> <td colspan="2" class="text-center"> <button type="submit" class="footer-submit-btn">Send on WhatsApp</button> </td> </tr> </table> </form> </div> </div> <!-- Yeh CSS style yahan add karni hai taaki box black aur sundar dikhe --> <style> .footer-form-box { background: #111 !important; padding: 25px !important; border-radius: 10px !important; box-shadow: 0 5px 15px rgba(0, 0, 0, 0.3); } .footer-form-title { color: #fff !important; margin-bottom: 15px; font-size: 20px; font-weight: 600; border-bottom: 2px solid #25D366; display: inline-block; padding-bottom: 5px; } .footer-form-table { width: 100%; } .footer-form-table td { padding: 8px 5px; color: #ccc; font-size: 14px; } .footer-form-table input, .footer-form-table select { width: 100%; padding: 9px 10px; border-radius: 6px; border: none; outline: none; background: #222 !important; color: #fff !important; } .footer-form-table input::placeholder { color: #aaa; } .footer-submit-btn { background: linear-gradient(135deg, #25D366, #1ebe5d); color: #fff; border: none; padding: 12px 25px; border-radius: 30px; font-weight: 600; cursor: pointer; margin-top: 10px; width: 100%; } .footer-submit-btn:hover { background: linear-gradient(135deg, #1ebe5d, #25D366); } </style> <div class="col-6 col-lg-2"> <div class="footer-widget-box list"> <h4 class="footer-widget-title">Company</h4> <ul class="footer-list"> <li><a href="profile.php"><i class="far fa-angle-double-right"></i>Company Profile</a></li> <li><a href="vision.php"><i class="far fa-angle-double-right"></i>Vision & Mission</a></li> <li><a href="team.php"><i class="far fa-angle-double-right"></i>Our Team</a></li> <li><a href="contact.php"><i class="far fa-angle-double-right"></i>Contact Us</a></li> <li><a href="ind.php"><i class="far fa-angle-double-right"></i>Industries</a></li> <li><a href="rec.php"><i class="far fa-angle-double-right"></i>Recruitment Process</a></li> </ul> </div> </div> <div class="col-6 col-lg-2"> <div class="footer-widget-box list"> <h4 class="footer-widget-title">Visa Type</h4> <ul class="footer-list"> <li><a href="air.php"><i class="far fa-angle-double-right"></i>Air Ticketing Services</a></li> <li><a href="immigration.php"><i class="far fa-angle-double-right"></i>Immigration Services</a></li> <li><a href="visast.php"><i class="far fa-angle-double-right"></i>Visa Stamping Services</a></li> <li><a href="manpower.php"><i class="far fa-angle-double-right"></i>Manpower Services</a></li> <li><a href="document.php"><i class="far fa-angle-double-right"></i>Document Attestation Services</a></li> <li><a href="tour.php"><i class="far fa-angle-double-right"></i>Tour & Travel Services</a></li> </ul> </div> </div> <div class="col-lg-3"> <div class="footer-widget-box"> <h4 class="footer-widget-title">Get In Touch</h4> <ul class="footer-contact"> <li> <div class="icon"><i class="far fa-location-dot"></i></div> <div class="content"> <h6>Our Address</h6> <p>167/7 3rd Floor, Sarai Juliena, New Friends Colony, New Delhi - 110025</p> </div> </li> <li> <div class="icon"><i class="far fa-phone"></i></div> <div class="content"> <h6>Call Us</h6> <a href="tel:+91-9311531390">+91-9311531390/8178109244</a> </div> </li> <li> <div class="icon"><i class="far fa-envelope"></i></div> <div class="content"> <h6>Mail Us</h6> <a href="mailto:skybrigadejobs@gmail.com">skybrigadejobs@gmail.com</a> </div> </li> </ul> </div> </div> </div> </div> </div> </div> <div class="container"> <div class="copyright"> <div class="row"> <div class="col-md-6 align-self-center"> <p class="copyright-text"> © Copyright <span id="date"></span> <a href="capapp.in"> CAPAPP IT SOLUTION PVT.LTD. </a> </p> </div> <div class="col-md-6 align-self-center"> <ul class="footer-social"> <li><a href="#"><i class="fab fa-facebook-f"></i></a></li> <li><a href="#"><i class="fab fa-x-twitter"></i></a></li> <li><a href="#"><i class="fab fa-linkedin-in"></i></a></li> <li><a href="#"><i class="fab fa-youtube"></i></a></li> </ul> </div> </div> </div> </div> </footer> <!-- Footer Area End --> <!-- Scroll Top --> <a href="#" id="scroll-top"><i class="far fa-arrow-up"></i></a> <!-- JavaScript Files --> <script src="assets/js/jquery-3.7.1.min.js"></script> <script src="assets/js/modernizr.min.js"></script> <script src="assets/js/bootstrap.bundle.min.js"></script> <script src="assets/js/imagesloaded.pkgd.min.js"></script> <script src="assets/js/jquery.magnific-popup.min.js"></script> <script src="assets/js/isotope.pkgd.min.js"></script> <script src="assets/js/jquery.appear.min.js"></script> <script src="assets/js/jquery.easing.min.js"></script> <script src="assets/js/owl.carousel.min.js"></script> <script src="assets/js/counter-up.js"></script> <script src="assets/js/jquery.nice-select.min.js"></script> <script src="assets/js/wow.min.js"></script> <script src="assets/js/main.js"></script> <script> function sendFooterWhatsApp() { var name = document.getElementById("f_name").value; var mobile = document.getElementById("f_mobile").value; var subject = document.getElementById("f_subject").value; var country = document.getElementById("f_country").value; var message = "📩 *Quick Inquiry* %0A%0A" + "*Name:* " + name + "%0A" + "*Mobile:* " + mobile + "%0A" + "*Subject:* " + subject + "%0A" + "*Country:* " + country; var whatsappURL = "https://wa.me/919311531390?text=" + message; window.open(whatsappURL, "_blank"); } </script> </body> </html>
Save
Cancel