1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com /
Filename : customer_order.php
back
<?php
session_start();
if(!isset($_SESSION['userid'])){
  header("Location:login_form.php");
}
include_once("../config/jaconfig.php");

$user_id=$_SESSION['userid'];
include 'includes/header.php';

if (isset($_SESSION['userid'])) {
  $uid = $_SESSION['userid'];

  // Prepare SQL statement to avoid SQL injection
  $stmt = $con->prepare("SELECT * FROM `user_info` WHERE `user_id` = ?");
  $stmt->bind_param('i', $uid); // Bind parameter as integer
  $stmt->execute();
  $result = $stmt->get_result();
  $row = $result->fetch_assoc();
  $first_name = $row['first_name'];
  $currency = $row['currency'];
  $stmt->close();
} else {
  // Default currency if user session is not set
  $currency = '£';
}

// Fallback to pounds if currency is not set or empty
if (empty($currency)) {
  $currency = '£';
}
?>

  <!--End header-->
  <main class="main">
        <div class="page-header breadcrumb-wrap">
            <div class="container">
                <div class="breadcrumb">
                    <a href="index.php" rel="nofollow"><i class="fi-rs-home mr-5"></i>Home</a>
                    <span></span> <a href="">My Account</a> <span></span>
                 My Orders
                </div>
            </div>
        </div>
        <div class="page-content pt-20 pb-150">
          

<!--Body Content-->
<div id="page-content">
    	<!--Page Title-->
    	<div class="page section-header text-center">
			<div class="page-title">
        		<div class="wrapper"><h4 class="page-width">My Orders</h4></div>
      		</div>
		  </div>
        <!--End Page Title-->
            <div class="Shopping-cart-area pt-60 pb-60">
                <div class="container">

  <div class="row">
    <div class="col">
      <div class="card" style='margin-bottom:25px;'>
        <div class="card-header" ><h5 style="font-size:15px;"><?php echo $_SESSION['name'];?>, Your Order Details</h5></div>
         <div class="card-body">
           <?php
           /*$orders_list = "SELECT o.order_id,o.user_id,o.product_id,o.qty,o.trx_id,o.p_status,p.product_title,p.product_price,p.product_image 
           FROM orders o,products p WHERE o.user_id='$user_id' AND o.product_id=p.product_id";*/
            $order_list="SELECT o.id,o.uid,o.pid,o.p_name,o.p_price,o.p_qty,o.p_status,o.trx_id,p.product_image
             FROM customer_order o,products p WHERE o.uid=$user_id AND o.pid=p.product_id";

            $result=mysqli_query($con,$order_list);
            if(mysqli_num_rows($result)>0){
              while($row=mysqli_fetch_array($result)){
           ?>
               <div class="row">
                 <div class="col-sm-12 col-md-6 col-xl-6 col-lg-6" style="text-align: center;">
                      <img src="admin/uploads/<?php echo $row['product_image']; ?>" class="img-thumbnail card-img img-fluid" style="width:50%; height: 85%; display:inline-block;" alt="">
                 </div>
                 <div class="col-sm-12 col-md-6 col-xl-6 col-lg-6">
                
                   <table class="table">
                     <tr><td>Product Name : <?php echo $row['p_name']; ?></td></tr>
                     <tr><td>Product Price : <?php echo $currency; ?><?php echo $row['p_price']; ?></td></tr>
                     <tr><td>Product Quantity :<?php echo $row['p_qty']; ?></td></tr>
                     <tr><td>Product Payment : <?php echo $row['p_status']; ?></td></tr>
                     <tr><td>Product Transaction Id : <?php echo $row['trx_id']; ?></td></tr>
                   </table>
                 </div>
               </div>
        <?php
            }//end of while loop
          }//end of if statement
          else {
?>
 <p style="text-align:center;font-size:17px;"> You have no order yet. </p>
<?php

          }

        ?>
         </div>
      </div>
    </div>
  </div>
</div>

<?php
include 'includes/footer.php';   
?>