One Hat Cyber Team

Edit File: home-edited.php

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="UTF-8">
	<meta name="keywords" content="Digital marketing agency, Digital marketing company, Digital marketing services">
	<meta name="description" content="Jobi is a beautiful website template designed for job board websites.">
    <meta property="og:site_name" content="Jano">
    <meta property="og:url" content="https://creativegigstf.com">
    <meta property="og:type" content="website">
    <meta property="og:title" content="Jobi - Responsive Job Board HTML Template">
	<meta name='og:image' content='../images/assets/ogg.png'>
	
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	
	
	<meta name="theme-color" content="#244034">
	
	<meta name="msapplication-navbutton-color" content="#244034">
	
	<meta name="apple-mobile-web-app-status-bar-style" content="#244034">
	<title>Edit</title>
	
	<link rel="icon" type="image/png" sizes="56x56" href="../style/images/fav-icon/icon.png">
	
	<link rel="stylesheet" type="text/css" href="../style/css/bootstrap.min.css" media="all">
	
	<link rel="stylesheet" type="text/css" href="../style/css/style.css" media="all">
	
	<link rel="stylesheet" type="text/css" href="../style/css/responsive.css" media="all">

</head>

<aside class="dash-aside-navbar">
			<div class="position-relative">
				<div class="logo text-md-center d-md-block d-flex align-items-center justify-content-between">
					<a href="candidate-dashboard-index.html">
						<img src="images/logo_01.png" alt="">
					</a>
					<button class="close-btn d-block d-md-none"><i class="bi bi-x-lg"></i></button>
				</div>
				<div class="user-data">
					<div class="user-avatar online position-relative rounded-circle">
						<img src="../images/lazy.svg" data-src="images/avatar_01.jpg" alt="" class="lazy-img">
					</div>
					
					<div class="user-name-data">
						<button class="user-name dropdown-toggle" type="button" id="profile-dropdown" data-bs-toggle="dropdown" data-bs-auto-close="outside" aria-expanded="false">
							Rashed Kabir
						</button>
						<ul class="dropdown-menu" aria-labelledby="profile-dropdown">
						    <li>
                                <a class="dropdown-item d-flex align-items-center" href="candidate-dashboard-profile.html"><img src="../images/lazy.svg" data-src="images/icon/icon_23.svg" alt="" class="lazy-img"><span class="ms-2 ps-1">Profile</span></a>
                            </li>
                            <li>
                                <a class="dropdown-item d-flex align-items-center" href="candidate-dashboard-settings.html"><img src="../images/lazy.svg" data-src="images/icon/icon_24.svg" alt="" class="lazy-img"><span class="ms-2 ps-1">Account Settings</span></a>
                            </li>
                            <li>
                                <a class="dropdown-item d-flex align-items-center" href="#"><img src="../images/lazy.svg" data-src="images/icon/icon_25.svg" alt="" class="lazy-img"><span class="ms-2 ps-1">Notification</span></a>
                            </li>
						</ul>
					</div>
				</div>
				
				<nav class="dasboard-main-nav">
					<ul class="style-none">
						<li><a href="candidate-dashboard-index.html" class="d-flex w-100 align-items-center">
							<img src="../images/lazy.svg" data-src="images/icon/icon_1.svg" alt="" class="lazy-img">
							<span>Dashboard</span>
						</a></li>
						<li><a href="candidate-dashboard-profile.html" class="d-flex w-100 align-items-center active">
							<img src="../images/lazy.svg" data-src="images/icon/icon_2_active.svg" alt="" class="lazy-img">
							<span>My Profile</span>
						</a></li>
						<li><a href="candidate-dashboard-resume.html" class="d-flex w-100 align-items-center">
							<img src="../images/lazy.svg" data-src="images/icon/icon_3.svg" alt="" class="lazy-img">
							<span>Resume</span>
						</a></li>
						<li><a href="candidate-dashboard-message.html" class="d-flex w-100 align-items-center">
							<img src="../images/lazy.svg" data-src="images/icon/icon_4.svg" alt="" class="lazy-img">
							<span>Messages</span>
						</a></li>
						<li><a href="candidate-dashboard-job-alert.html" class="d-flex w-100 align-items-center">
							<img src="../images/lazy.svg" data-src="images/icon/icon_5.svg" alt="" class="lazy-img">
							<span>Job Alert</span>
						</a></li>
						<li><a href="candidate-dashboard-saved-jobs.html" class="d-flex w-100 align-items-center">
							<img src="../images/lazy.svg" data-src="images/icon/icon_6.svg" alt="" class="lazy-img">
							<span>Saved Job</span>
						</a></li>
						<li><a href="candidate-dashboard-settings.html" class="d-flex w-100 align-items-center">
							<img src="../images/lazy.svg" data-src="images/icon/icon_7.svg" alt="" class="lazy-img">
							<span>Account Settings</span>
						</a></li>
						<li><a href="#" class="d-flex w-100 align-items-center" data-bs-toggle="modal" data-bs-target="#deleteModal">
							<img src="../images/lazy.svg" data-src="images/icon/icon_8.svg" alt="" class="lazy-img">
							<span>Delete Account</span>
						</a></li>
					</ul>
				</nav>
				
				<div class="profile-complete-status">
					<div class="progress-value fw-500">87%</div>
					<div class="progress-line position-relative">
						<div class="inner-line" style="width:80%;"></div>
					</div>
					<p>Profile Complete</p>
				</div>

<a href="#" class="d-flex w-100 align-items-center logout-btn">
					<img src="../images/lazy.svg" data-src="images/icon/icon_9.svg" alt="" class="lazy-img">
					<span>Logout</span>
				</a>
			</div>
		</aside>

<div class="dashboard-body">
			<div class="position-relative">
				
				<header class="dashboard-header">
					<div class="d-flex align-items-center justify-content-end">
						<button class="dash-mobile-nav-toggler d-block d-md-none me-auto">
							<span></span>
						</button>
						<form action="#" class="search-form">
							<input type="text" placeholder="Search here..">
							<button><img src="../style/images/lazy.svg" data-src="../style/images/icon/icon_10.svg" alt="" class="lazy-img m-auto"></button>
						</form>
						<div class="profile-notification ms-2 ms-md-5 me-4">
							<button class="noti-btn dropdown-toggle" type="button" id="notification-dropdown" data-bs-toggle="dropdown" data-bs-auto-close="outside" aria-expanded="false">
								<img src="../style/images/lazy.svg" data-src="../styleimages/icon/icon_11.svg" alt="" class="lazy-img">
								<div class="badge-pill"></div>
							</button>
							<ul class="dropdown-menu" aria-labelledby="notification-dropdown">
								<li>
									<h4>Notification</h4>
									<ul class="style-none notify-list">
										<li class="d-flex align-items-center unread">
											<img src="../images/lazy.svg" data-src="images/icon/icon_36.svg" alt="" class="lazy-img icon">
											<div class="flex-fill ps-2">
												<h6>You have 3 new mails</h6>
												<span class="time">3 hours ago</span>
											</div>
										</li>
										<li class="d-flex align-items-center">
											<img src="../images/lazy.svg" data-src="images/icon/icon_37.svg" alt="" class="lazy-img icon">
											<div class="flex-fill ps-2">
												<h6>Your job post has been approved</h6>
												<span class="time">1 day ago</span>
											</div>
										</li>
										<li class="d-flex align-items-center unread">
											<img src="../images/lazy.svg" data-src="images/icon/icon_38.svg" alt="" class="lazy-img icon">
											<div class="flex-fill ps-2">
												<h6>Your meeting is cancelled</h6>
												<span class="time">3 days ago</span>
											</div>
										</li>
									</ul>
								</li>
							</ul>
						</div>
						<div><a href="employer-dashboard-submit-job.html" class="job-post-btn tran3s">Post a Job</a></div>
					</div>
				</header>

<h2 class="main-title">edited</h2>

<?php
// Database connection
include '../mysql.php';

// Get record ID from the URL
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;

// Fetch data for the specific record
$sql = "SELECT urls, titles, logos, descriptions, keywordss, countrys, categoryss, statuss, created_at FROM url_entries WHERE id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

$stmt->close();
$conn->close();

// Check if the record exists
if (!$row) {
    echo "<script>alert('Record not found.'); window.location.href='home.php';</script>";
    exit;
}
?>

<form id="updateForm" action="update_record.php?id=<?php echo $id; ?>" method="post" enctype="multipart/form-data">
    <div class="bg-white card-box border-20">
        <div class="user-avatar-setting d-flex align-items-center mb-30">
            
            <img id="logoPreview" 
                 src="../<?php echo htmlspecialchars(isset($row['logos']) && !empty($row['logos']) ? $row['logos'] : 'default-logo.png'); ?>" 
                 alt="Logo" 
                 class="lazy-img user-img" 
                 style="width: 100px; height: 100px; object-fit: cover;">

<div class="upload-btn position-relative tran3s ms-4 me-3">
                Upload new logo
                <input type="file" id="uploadImg" name="uploadImg" onchange="previewImage(event)">
            </div>
            
            
            <a href="delete_record.php?id=<?php echo htmlspecialchars($id); ?>" 
               class="delete-btn tran3s text-danger ms-3">Delete</a>
        </div>

<input type="hidden" name="current_logo" value="<?php echo htmlspecialchars($row['logos']); ?>">

<div class="dash-input-wrapper mb-30">
            <label for="urls">URL*</label>
            <input type="text" name="urls" placeholder="URL..." value="<?php echo htmlspecialchars($row['urls']); ?>" required>
        </div>

<div class="dash-input-wrapper mb-30">
            <label for="titles">Title*</label>
            <input type="text" name="titles" placeholder="Title..." value="<?php echo htmlspecialchars($row['titles']); ?>" required>
        </div>

<div class="dash-input-wrapper mb-30">
            <label for="descriptions">Description*</label>
            <textarea name="descriptions" class="size-lg" placeholder="Description..." required><?php echo htmlspecialchars($row['descriptions']); ?></textarea>
        </div>

<div class="dash-input-wrapper mb-30">
            <label for="keywordss">Keywords*</label>
            <textarea name="keywordss" class="size-lg" placeholder="Keywords..." required><?php echo htmlspecialchars($row['keywordss']); ?></textarea>
            <div class="alert-text">Separate keywords with commas</div>
        </div>

<div class="dash-input-wrapper mb-30">
            <label for="countrys">Country*</label>
            <input type="text" name="countrys" placeholder="Country..." value="<?php echo htmlspecialchars($row['countrys']); ?>" required>
        </div>

<div class="dash-input-wrapper mb-30">
            <label for="categoryss">Category*</label>
            <select name="categoryss" class="nice-select" required>
                <option value="Designer" <?php echo (isset($row['categoryss']) && $row['categoryss'] == 'Designer') ? 'selected' : ''; ?>>Designer</option>
                <option value="IT & Development" <?php echo (isset($row['categoryss']) && $row['categoryss'] == 'IT & Development') ? 'selected' : ''; ?>>IT & Development</option>
                <option value="Web & Mobile Dev" <?php echo (isset($row['categoryss']) && $row['categoryss'] == 'Web & Mobile Dev') ? 'selected' : ''; ?>>Web & Mobile Dev</option>
                <option value="Writing" <?php echo (isset($row['categoryss']) && $row['categoryss'] == 'Writing') ? 'selected' : ''; ?>>Writing</option>
            </select>
        </div>

<div class="dash-input-wrapper mb-30">
            <label for="statuss">Status*</label>
            <select name="statuss" class="nice-select" required>
                <option value="Yes" <?php echo (isset($row['statuss']) && $row['statuss'] == 'Yes') ? 'selected' : ''; ?>>Yes</option>
                <option value="No" <?php echo (isset($row['statuss']) && $row['statuss'] == 'No') ? 'selected' : ''; ?>>No</option>
            </select>
        </div>
    </div>

<script>
    function previewImage(event) {
        const input = event.target;
        const reader = new FileReader();

reader.onload = function() {
            const logoPreview = document.getElementById('logoPreview');
            logoPreview.src = reader.result;
        };

if (input.files && input.files[0]) {
            reader.readAsDataURL(input.files[0]);
        }
    }
</script>

const formData = new FormData(form);

const response = await fetch(form.action, {
            method: 'POST',
            body: formData
        });

const result = await response.json();

if (result.success) {
            alert(result.message); // Optional: Notify user
            setTimeout(() => {
                window.location.href = result.redirect; // Redirect to home.php
            }, 3000); // 3 seconds delay
        } else {
            alert(result.message); // Show error message
        }
    });

</script>
				
				
			</div>
		</div>

<div class="modal fade" id="deleteModal" tabindex="-1" aria-hidden="true">
            <div class="modal-dialog modal-fullscreen modal-dialog-centered">
                <div class="container">
                    <div class="remove-account-popup text-center modal-content">
                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
						<img src="../images/lazy.svg" data-src="images/icon/icon_22.svg" alt="" class="lazy-img m-auto">
						<h2>Are you sure?</h2>
						<p>Are you sure to delete your account? All data will be lost.</p>
						<div class="button-group d-inline-flex justify-content-center align-items-center pt-15">
							<a href="#" class="confirm-btn fw-500 tran3s me-3">Yes</a>
							<button type="button" class="btn-close fw-500 ms-3" data-bs-dismiss="modal" aria-label="Close">Cancel</button>
						</div>
                    </div>
                    
                </div>
            </div>
        </div>

<script src="../style/vendor/jquery.min.js"></script>
		
		<script src="../style/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
		
		<script src="../style/vendor/wow/wow.min.js"></script>
		
		<script src="../style/vendor/slick/slick.min.js"></script>
		
		<script src="../style/vendor/fancybox/dist/jquery.fancybox.min.js"></script>
		
		<script src="../style/vendor/jquery.lazy.min.js"></script>
		
		<script src="../style/vendor/jquery.counterup.min.js"></script>
		<script src="../style/vendor/jquery.waypoints.min.js"></script>
		
		<script src="../style/vendor/nice-select/jquery.nice-select.min.js"></script>
		
		<script src="../style/vendor/validator.js"></script>

<script src="../style/js/theme.js"></script>
	</div> 
</body>

</html>