fghfgh
প্রোপাইটর: মালিকের নাম *
fdhgdfg
uhjkhkiuhyk
<?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$me...
uhjkhkiuhyk
<?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html><?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html><?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html><?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html> আরও পড়ুন
<?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html><?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html><?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html><?php
include '../includes/db.php';
mysqli_set_charset($conn, "utf8mb4");
$message = "";
// ১. ডাটা সেভ করার লজিক
if (isset($_POST['save_service'])) {
$shop_name = mysqli_real_escape_string($conn, $_POST['shop_name']);
$owner_name = mysqli_real_escape_string($conn, $_POST['owner_name']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$phone = mysqli_real_escape_string($conn, $_POST['phone']);
$description = mysqli_real_escape_string($conn, $_POST['description']);
// ব্যানার ইমেজ আপলোড
$banner = "";
if (!empty($_FILES['banner_img']['name'])) {
$banner = "banner_" . time() . "_" . $_FILES['banner_img']['name'];
move_uploaded_file($_FILES['banner_img']['tmp_name'], "../uploads/" . $banner);
}
// লোগো ইমেজ আপলোড
$logo = "";
if (!empty($_FILES['shop_logo']['name'])) {
$logo = "logo_" . time() . "_" . $_FILES['shop_logo']['name'];
move_uploaded_file($_FILES['shop_logo']['tmp_name'], "../uploads/" . $logo);
}
$sql = "INSERT INTO online_services (shop_name, owner_name, address, phone, description, banner_image, shop_logo)
VALUES ('$shop_name', '$owner_name', '$address', '$phone', '$description', '$banner', '$logo')";
if (mysqli_query($conn, $sql)) {
$message = "success|সফলভাবে শপ যুক্ত হয়েছে!";
} else {
$message = "error|ভুল হয়েছে: " . mysqli_error($conn);
}
}
// ২. ডাটা ডিলিট করার লজিক
if (isset($_GET['del_id'])) {
$id = intval($_GET['del_id']);
mysqli_query($conn, "DELETE FROM online_services WHERE id=$id");
header("Location: online_services_manage.php");
exit();
}
?>
<!DOCTYPE html>
<html lang="bn">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>অনলাইন সার্ভিস ম্যানেজমেন্ট</title>
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Bengali:wght@400;600;700&display=swap" rel="stylesheet">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
<style>
body { font-family: 'Noto Sans Bengali', sans-serif; background: #f0f2f5; margin: 0; }
.admin-container { max-width: 900px; margin: 40px auto; padding: 0 15px; }
.admin-form {
background: #fff; padding: 30px; border-radius: 20px;
box-shadow: 0 10px 25px rgba(0,0,0,0.05); margin-bottom: 40px;
}
.form-grid { display: grid; grid-template-columns: 1fr 1fr; gap: 20px; }
.form-group { margin-bottom: 20px; }
label { display: block; font-weight: 700; margin-bottom: 8px; color: #444; font-size: 14px; }
input, textarea {
width: 100%; padding: 12px; border: 1.5px solid #eee;
border-radius: 10px; box-sizing: border-box; transition: 0.3s;
}
input:focus { border-color: #00695c; outline: none; background: #f9fdfd; }
.file-upload-box {
display: grid; grid-template-columns: 1fr 1fr; gap: 15px;
background: #f8f9fa; padding: 15px; border-radius: 12px; border: 1px dashed #ccc;
}
.btn-save {
background: #00695c; color: white; border: none; padding: 15px;
border-radius: 12px; cursor: pointer; font-size: 16px; font-weight: 700; width: 100%;
transition: 0.3s; margin-top: 10px;
}
.btn-save:hover { background: #004d40; box-shadow: 0 5px 15px rgba(0,105,92,0.3); }
.data-table {
width: 100%; border-collapse: collapse; background: #fff;
border-radius: 15px; overflow: hidden; box-shadow: 0 4px 15px rgba(0,0,0,0.05);
}
th, td { padding: 15px; text-align: left; border-bottom: 1px solid #eee; font-size: 14px; }
th { background: #00695c; color: white; text-transform: uppercase; letter-spacing: 1px; }
.thumb-box { display: flex; gap: 8px; align-items: center; }
.img-preview { width: 45px; height: 45px; border-radius: 8px; object-fit: cover; border: 1px solid #ddd; }
.badge-logo { border-radius: 50%; } /* লোগো গোল দেখানোর জন্য */
.btn-del { color: #e74c3c; text-decoration: none; padding: 8px 12px; background: #fff5f5; border-radius: 8px; transition: 0.3s; }
.btn-del:hover { background: #e74c3c; color: #fff; }
.alert { padding: 15px; border-radius: 10px; margin-bottom: 25px; border-left: 5px solid #2ecc71; background: #e8f7ef; color: #155724; }
</style>
</head>
<body>
<?php include 'includes/header.php'; ?>
<?php include 'includes/sidebar.php'; ?>
<div class="admin-container">
<h2 style="color: #004d40;"><i class="fa-solid fa-shop"></i> অনলাইন সার্ভিস শপ ম্যানেজমেন্ট</h2>
<?php if($message): $msg = explode('|', $message); ?>
<div class="alert"><?= $msg[1] ?></div>
<?php endif; ?>
<div class="admin-form">
<form method="POST" enctype="multipart/form-data">
<div class="form-grid">
<div class="form-group">
<label>দোকানের নাম</label>
<input type="text" name="shop_name" placeholder="যেমন: বোরহান কম্পিউটার" required>
</div>
<div class="form-group">
<label>মালিকের নাম</label>
<input type="text" name="owner_name" placeholder="মালিকের নাম">
</div>
<div class="form-group">
<label>ঠিকানা</label>
<input type="text" name="address" placeholder="চুনতি বাজার, লোহাগাড়া">
</div>
<div class="form-group">
<label>ফোন নম্বর (WhatsApp)</label>
<input type="text" name="phone" placeholder="018XXXXXXXX">
</div>
</div>
<div class="form-group">
<label>মিডিয়া আপলোড (ব্যানার এবং লোগো)</label>
<div class="file-upload-box">
<div>
<span style="font-size: 12px; color: #666;">ব্যানার (চওড়া ছবি)</span>
<input type="file" name="banner_img" style="font-size: 12px; padding: 5px;">
</div>
<div>
<span style="font-size: 12px; color: #666;">লোগো (স্কয়ার ছবি)</span>
<input type="file" name="shop_logo" style="font-size: 12px; padding: 5px;">
</div>
</div>
</div>
<div class="form-group">
<label>সেবার বিবরণ</label>
<textarea name="description" rows="4" placeholder="এখানে কি কি অনলাইন কাজ করা হয় বিস্তারিত লিখুন..."></textarea>
</div>
<button type="submit" name="save_service" class="btn-save">নতুন শপ সেভ করুন</button>
</form>
</div>
<table class="data-table">
<thead>
<tr>
<th>মিডিয়া</th>
<th>শপের নাম</th>
<th>যোগাযোগ</th>
<th>অ্যাকশন</th>
</tr>
</thead>
<tbody>
<?php
$res = mysqli_query($conn, "SELECT * FROM online_services ORDER BY id DESC");
while($row = mysqli_fetch_assoc($res)): ?>
<tr>
<td>
<div class="thumb-box">
<img src="../uploads/<?= !empty($row['banner_image']) ? $row['banner_image'] : 'default_banner.jpg' ?>" class="img-preview" title="Banner">
<img src="../uploads/<?= !empty($row['shop_logo']) ? $row['shop_logo'] : 'default_logo.png' ?>" class="img-preview badge-logo" title="Logo">
</div>
</td>
<td><strong><?= htmlspecialchars($row['shop_name']) ?></strong></td>
<td><?= htmlspecialchars($row['phone']) ?></td>
<td>
<a href="?del_id=<?= $row['id'] ?>" class="btn-del" onclick="return confirm('ডিলিট করতে চান?')">
<i class="fa-solid fa-trash-can"></i>
</a>
</td>
</tr>
<?php endwhile; ?>
</tbody>
</table>
</div>
<?php include 'includes/footer.php'; ?>
</body>
</html> আরও পড়ুন