ikan Uploader :
Directory : /home/ni05r7l36tus/www/poojajewellersbbsr.com/
Upload File : |
| Current File : //home/ni05r7l36tus/www/poojajewellersbbsr.com/profile.php |
<?php
session_start();
include 'connection/config.php';
include "cart-handler.php";
$customer_id = isset($_SESSION['customer_id']) ? intval($_SESSION['customer_id']) : 0;
// ✅ Fetch customer details
// ✅ Fetch all orders for the customer
$stmt = $pdo->prepare("SELECT * FROM customers WHERE customer_id = :customer_id ORDER BY created_at DESC");
$stmt->execute([':customer_id' => $customer_id]);
$customer = $stmt->fetchAll(PDO::FETCH_ASSOC);
// ✅ Fetch all orders for the customer
$stmt = $pdo->prepare("SELECT * FROM allorders WHERE customer_id = :customer_id ORDER BY created_at DESC");
$stmt->execute([':customer_id' => $customer_id]);
$allorders = $stmt->fetchAll(PDO::FETCH_ASSOC);
// ✅ Fetch store details
$stmt = $pdo->prepare("SELECT * FROM store_locations");
$stmt->execute();
$store_locations = $stmt->fetch(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width,initial-scale=1">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<title>Pooja Jewellers Bhubaneswar – Elegant Gold, Silver & Fancy Jewellery</title>
<meta name="description" content="Browse Pooja Jewellers in Bhubaneswar for a stunning range of gold, silver, and fancy jewellery—perfect for weddings, everyday elegance, and modern minimalism.">
<meta name="keywords" content="Pooja Jewellers Bhubaneswar, gold jewellery Bhubaneswar, silver jewellery Bhubaneswar, fancy jewellery Bhubaneswar, minimalist jewellery India, wedding jewellery Bhubaneswar">
<meta name="author" content="spacingtech_webify">
<!-- favicon -->
<link rel="shortcut icon" type="image/favicon" href="assets/image/fav.jpg">
<!-- plugin css -->
<link rel="stylesheet" type="text/css" href="assets/css/plugin.css">
<!-- theme css -->
<link rel="stylesheet" type="text/css" href="assets/css/theme3.css">
<!-- collection css -->
<link rel="stylesheet" type="text/css" href="assets/css/collection3.css">
<!-- blog css -->
<link rel="stylesheet" type="text/css" href="assets/css/blog3.css">
<!-- style css -->
<link rel="stylesheet" type="text/css" href="assets/css/style3.css">
<style>
.ap-detail-info{
background-color:white;
padding:20px;
box-shadow: 0 0 8px rgba(0, 0, 0, 0.1);
border-radius:10px;
}
</style>
</head>
<body>
<!-- preloader start -->
<div class="preloader position-fixed top-0 start-0 w-100 h-100 body-bg z-index-5">
<div class="loader-img position-absolute top-0 start-0 w-100 h-100 d-flex align-items-center justify-content-center">
<img src="assets/image/preloader.png" class="width-96 width-xl-144 img-fluid" alt="logo">
</div>
</div>
<!-- preloader end -->
<!-- header start -->
<header id="header" class="main-header">
<!-- header-top start -->
<div class="header-top-area">
<!-- notification-bar start -->
<div class="notification-bar ptb-10 dominant-bg">
<div class="container-fluid d-none d-xl-block">
<div class="text-center extra-color">First Order 20% Off on Fancy Jewellery <a href="product_category.php?slug=Fancy jewellery" class="extra-color text-uppercase text-decoration-underline blinking">Shop now</a>!</div>
</div>
</div>
<!-- notification-bar end -->
<!-- header-bar start -->
<div class="header-bar d-none d-xl-block ptb-11 extra-bg beb">
<div class="container-fluid">
<div class="row">
<div class="col">
<ul class="ul-mt30 justify-content-start">
<li>
<span class="d-inline-block body-secondary-color">
<a href="mailto:<?php echo $store_locations['email1']; ?>">
<i class="ri-mail-line icon-16 mer-5"></i><?php echo $store_locations['email1']; ?>
</a>
</span>
</li>
<li>
<span class="d-inline-block body-secondary-color">
<a href="tel:<?php echo $store_locations['phone1']; ?>">
<i class="ri-phone-line icon-16 mer-5"></i><?php echo $store_locations['phone1']; ?>
</a>
</span>
</li>
</ul>
</div>
<div class="col">
<ul class="ul-mt30 justify-content-end">
<li>
<span class="d-inline-block body-secondary-color">
<a href="calender.php">
<i class="ri-calendar-event-fill icon-16 mer-5"></i>Calender
</a>
</span>
</li>
<li>
<span class="d-inline-block body-secondary-color text-dark">
<a href="javascript:void(0)"
data-bs-toggle="modal"
data-bs-target="#goldCalculatorModal"
class="nav-link">
<i class="ri-calculator-line icon-16 mer-5"></i> Calculator
</a>
</span>
</li>
</ul>
</div>
</div>
</div>
</div>
<!-- header-bar end -->
<!-- header-top-first start -->
<div class="header-top-first ptb-15 ptb-xl-20 position-relative extra-bg">
<div class="container-fluid">
<div class="row align-items-center header-area">
<!-- header-logo start -->
<div class="col-6 col-xl-2 header-element header-logo">
<div class="header-theme-logo">
<a href="index.php" class="d-inline-block theme-logo">
<img src="assets/image/headerlogo.webp" class="width-96 width-xl-144 img-fluid" alt="logo">
</a>
</div>
</div>
<!-- header-logo end -->
<?php include "common/header.php"; ?>
<!-- header-icon start -->
<div class="col-6 col-xl-2 header-element header-icon">
<div class="header-icon-block d-flex justify-content-end">
<ul class="ul-mt30 flex-nowrap align-items-center header-icon-element">
<li class="header-icon-wrap toggler-wrap d-xl-none">
<div class="header-icon-wrapper">
<a href="javascript:void(0)" class="d-block header-icon-toggler toggler-btn" aria-label="Menu toggler button">
<span class="d-block header-block-icon dominant-link icon-16"><i class="ri-menu-line"></i></span>
</a>
</div>
</li>
<li class="header-icon-wrap search-wrap d-xl-none">
<div class="header-icon-wrapper">
<a href="#searchmodal" class="d-block header-icon-search" data-bs-toggle="modal" aria-label="Search modal">
<span class="d-block header-block-icon dominant-link icon-16"><i class="ri-search-line"></i></span>
</a>
</div>
</li>
<li class="header-icon-wrap user-wrap d-none d-md-block">
<div class="header-icon-wrapper">
<span class="header-block-icon-wrap dominant-link ul-mt5 flex-nowrap align-items-center">
<span class="header-block-icon icon-16"><i class="ri-user-3-line"></i></span>
<span class="d-none d-xl-block header-text-content">
<?php if ($customerName): ?>
<a href="dashboard.php"><b><?= htmlspecialchars($customerName) ?></b></a>
<?php else: ?>
<a href="login.php">Login</a>
<?php endif; ?>
</span>
</span>
</div>
</li>
<li class="header-icon-wrap cart-wrap d-none d-md-block">
<div class="header-icon-wrapper">
<a href="javascript:void(0)" class="d-block header-icon-cart js-cart-drawer">
<span class="header-block-icon-wrap dominant-link ul-mt5 flex-nowrap align-items-center">
<span class="header-block-icon icon-16"><i class="ri-shopping-bag-3-line"></i></span>
<span class="d-none d-xl-block header-text-content">Cart</span>
<?php
$cartCount = 0;
if (isset($_SESSION['cart'])) {
$cartCount += count($_SESSION['cart']);
}
if (isset($_SESSION['rentals'])) {
$cartCount += count($_SESSION['rentals']);
}
// Show the counter only if there’s something in cart
if ($cartCount > 0) {
echo '<span class="header-block-counter cart-counter dominant-color">' . $cartCount . '</span>';
}
?>
</span>
</a>
</div>
</li>
</ul>
</div>
</div>
<!-- header-icon end -->
</div>
</div>
</div>
<!-- header-top-first end -->
</div>
<!-- header-top end -->
</header>
<!-- header end -->
<!-- breadcrumb-area start -->
<div class="breadcrumb-area ptb-15" data-bgimg="assets/image/other/breadcrumb-bgimg.jpg">
<div class="container">
<span class="d-block extra-color"><a href="index.php" class="extra-color">Home</a> / Profile</span>
</div>
</div>
<!-- breadcrumb-area end -->
<!-- main start -->
<main id="main">
<!-- account-page strat -->
<section class="account-page section-ptb">
<div class="container">
<div class="row row-mtm align-items-lg-start">
<?php include "dashboardcommon/header.php" ?>
<div class="col-12 col-lg-8 col-xl-9">
<div class="ap-detail bg-white p-4 rounded">
<!-- Tabs Navigation -->
<ul class="nav nav-tabs" id="profileTabs" role="tablist">
<li class="nav-item" role="presentation">
<button class="nav-link active" id="profile-tab" data-bs-toggle="tab" data-bs-target="#profile" type="button" role="tab" aria-controls="profile" aria-selected="true">
Profile
</button>
</li>
<li class="nav-item" role="presentation">
<button class="nav-link" id="address-tab" data-bs-toggle="tab" data-bs-target="#address" type="button" role="tab" aria-controls="address" aria-selected="false">
Address
</button>
</li>
</ul>
<?php
// Fetch customer and default address
$customer = [];
$address = [];
if ($customer_id > 0) {
// 1️⃣ Fetch customer details
$stmt = $pdo->prepare("SELECT * FROM customers WHERE customer_id = :customer_id");
$stmt->execute([':customer_id' => $customer_id]);
$customer = $stmt->fetch(PDO::FETCH_ASSOC) ?: [];
// 2️⃣ Fetch default address
$stmtAddr = $pdo->prepare("SELECT * FROM customer_addresses WHERE customer_id = :customer_id AND is_default = 1 LIMIT 1");
$stmtAddr->execute([':customer_id' => $customer_id]);
$address = $stmtAddr->fetch(PDO::FETCH_ASSOC) ?: [];
}
?>
<form method="post" action="function.php" enctype="multipart/form-data">
<input type="hidden" name="customer_id" value="<?= $customer_id ?>">
<!-- Tabs Content -->
<div class="tab-content mt-4">
<!-- Profile Tab -->
<div class="tab-pane fade show active" id="profile" role="tabpanel" aria-labelledby="profile-tab">
<!-- Personal Information -->
<div class="mb-4">
<h6 class="font-18 mb-3">Personal Information</h6>
<div class="row g-3">
<div class="col-12 col-md-6">
<label class="form-label">First Name</label>
<input type="text" name="first_name" class="form-control" value="<?= htmlspecialchars($customer['first_name'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Last Name</label>
<input type="text" name="last_name" class="form-control" value="<?= htmlspecialchars($customer['last_name'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Email</label>
<input type="email" name="email" class="form-control" value="<?= htmlspecialchars($customer['email'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Phone</label>
<input type="text" name="phone" class="form-control" value="<?= htmlspecialchars($customer['phone'] ?? '') ?>">
</div>
<div class="col-12">
<label class="form-label">Upload Image</label>
<input type="file" class="form-control mt-1" name="profile_image">
<?php if (!empty($customer['profile_image'])): ?>
<img src="uploads/<?= htmlspecialchars($customer['profile_image']) ?>" class="img-fluid rounded mt-2" style="max-height:150px;">
<?php endif; ?>
</div>
</div>
</div>
<!-- Password -->
<div class="mb-4">
<h6 class="mb-3">Password</h6>
<div class="row g-3">
<div class="col-12 col-md-4">
<label class="form-label">Current Password</label>
<input type="password" name="current_password" class="form-control">
</div>
<div class="col-12 col-md-4">
<label class="form-label">New Password</label>
<input type="password" name="new_password" class="form-control">
</div>
<div class="col-12 col-md-4">
<label class="form-label">Confirm Password</label>
<input type="password" name="confirm_password" class="form-control">
</div>
</div>
</div>
</div>
<!-- Address Tab -->
<div class="tab-pane fade" id="address" role="tabpanel" aria-labelledby="address-tab">
<!-- Permanent Address -->
<div class="mb-4">
<h6 class="font-18 mb-3">Permanent Address</h6>
<div class="row g-3">
<div class="col-12">
<label class="form-label">Address Line 1</label>
<input type="text" name="perm_address_line1" class="form-control" value="<?= htmlspecialchars($address['perm_address_line1'] ?? '') ?>">
</div>
<div class="col-12">
<label class="form-label">Address Line 2</label>
<input type="text" name="perm_address_line2" class="form-control" value="<?= htmlspecialchars($address['perm_address_line2'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">City</label>
<input type="text" name="perm_city" class="form-control" value="<?= htmlspecialchars($address['perm_city'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">State</label>
<input type="text" name="perm_state" class="form-control" value="<?= htmlspecialchars($address['perm_state'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Postal Code</label>
<input type="text" name="perm_postal_code" class="form-control" value="<?= htmlspecialchars($address['perm_postal_code'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Country</label>
<input type="text" name="perm_country" class="form-control" value="<?= htmlspecialchars($address['perm_country'] ?? 'India') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Phone</label>
<input type="text" name="perm_phone" class="form-control" value="<?= htmlspecialchars($address['perm_phone'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Landmark</label>
<input type="text" name="perm_landmark" class="form-control" value="<?= htmlspecialchars($address['perm_landmark'] ?? '') ?>">
</div>
</div>
</div>
<!-- Delivery Address -->
<div class="mb-4">
<h6 class="font-18 mb-3">Delivery Address</h6>
<div class="row g-3">
<div class="col-12">
<label class="form-label">Address Line 1</label>
<input type="text" name="delivery_address_line1" class="form-control" value="<?= htmlspecialchars($address['delivery_address_line1'] ?? '') ?>">
</div>
<div class="col-12">
<label class="form-label">Address Line 2</label>
<input type="text" name="delivery_address_line2" class="form-control" value="<?= htmlspecialchars($address['delivery_address_line2'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">City</label>
<input type="text" name="delivery_city" class="form-control" value="<?= htmlspecialchars($address['delivery_city'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">State</label>
<input type="text" name="delivery_state" class="form-control" value="<?= htmlspecialchars($address['delivery_state'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Postal Code</label>
<input type="text" name="delivery_postal_code" class="form-control" value="<?= htmlspecialchars($address['delivery_postal_code'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Country</label>
<input type="text" name="delivery_country" class="form-control" value="<?= htmlspecialchars($address['delivery_country'] ?? 'India') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Phone</label>
<input type="text" name="delivery_phone" class="form-control" value="<?= htmlspecialchars($address['delivery_phone'] ?? '') ?>">
</div>
<div class="col-12 col-md-6">
<label class="form-label">Landmark</label>
<input type="text" name="delivery_landmark" class="form-control" value="<?= htmlspecialchars($address['delivery_landmark'] ?? '') ?>">
</div>
</div>
</div>
</div>
</div>
<!-- Save Buttons -->
<div class="d-flex flex-wrap gap-2 mt-3">
<button type="submit" name="customer_update" class="acc-save btn-style quaternary-btn">Save & Close</button>
<button type="reset" class="acc-cancel btn-style secondary-btn">Cancel</button>
</div>
</form>
</div>
</div>
<!-- delete-modal start -->
<div class="delete-modal modal fade" id="deletemodal" data-bs-backdrop="static">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content body-bg border-0 br-hidden">
<div class="modal-body ptb-30 plr-15 plr-sm-30">
<form method="post" action="javascript:void(0)">
<div class="delete-modal-header d-flex align-items-center justify-content-between meb-30">
<h6 class="font-18">Are you sure you want to delete account?</h6>
<button type="button" class="body-secondary-color icon-16" data-bs-dismiss="modal" aria-label="Close"><i class="ri-close-large-line d-block lh-1"></i></button>
</div>
<div class="delete-modal-text">Orders history and all data associated with your account will be removed.</div>
<div class="delete-modal-button mst-30">
<div class="row btn-row">
<div class="col-12 col-sm-6">
<a href="index.php" class="w-100 btn-style quaternary-btn">Delete</a>
</div>
<div class="col-12 col-sm-6">
<button type="submit" class="w-100 btn-style secondary-btn" data-bs-dismiss="modal">Cancel</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- delete-modal end -->
<!-- field-delete-modal start -->
<div class="field-deletemodal modal fade" id="field-deletemodal" data-bs-backdrop="static">
<div class="modal-dialog modal-dialog-centered">
<div class="modal-content body-bg border-0 br-hidden">
<div class="modal-body ptb-30 plr-15 plr-sm-30">
<form method="post" action="javascript:void(0)">
<div class="field-deletemodal-header d-flex align-items-center justify-content-between meb-30">
<h6 class="font-18"><i class="ri-error-warning-line text-danger icon-16"></i> Field delete!</h6>
<button type="button" class="body-secondary-color icon-16" data-bs-dismiss="modal" aria-label="Close"><i class="ri-close-large-line d-block lh-1"></i></button>
</div>
<div class="field-deletemodal-text">Are you sure you want to delete this field?</div>
<div class="field-deletemodal-button mst-30">
<div class="row btn-row">
<div class="col-12 col-sm-6">
<button type="button" class="w-100 btn-style quaternary-btn" data-bs-dismiss="modal">No</button>
</div>
<div class="col-12 col-sm-6">
<button type="submit" class="w-100 btn-style secondary-btn" id="fieldremove">Yes</button>
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!-- field-delete-modal end -->
</section>
<!-- account-page end -->
</main>
<!-- main end -->
<?php include "common/footer.php";?>
........