1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / home / earnlouq / jeffautomobileinc.com /
Filename : payment_success.php
back
<?php
session_start();
if(!isset($_SESSION['userid'])){
  echo "<script>window.location.href='login_form.php';</script>";

}
$uid=$_SESSION['userid'];

if (isset($_GET["amt"])) {
#WE WILL GET following variables from the payment_sucess.php page's URL after order completion.
$trx_id=$_GET['tx'];//transaction id returnerd by generated id
$ref=$_GET['ref'];//transaction reference returnerd by paystack

$p_st="Pending";//payment status 
$amt=$_GET['amt'];//total amt which we have paid
$dt = date('Y-m-d');


if(isset($_COOKIE["ta"]) == $amt){
 // echo "everything is okey";

  include_once "../config/jaconfig.php";
  include('includes/settings.php');

  $query="SELECT * FROM `user_info` WHERE `user_id`='$uid' ";
  $result=mysqli_query($con,$query);
  $data=mysqli_fetch_array($result);            

  $balance=$data['balance']; 
  $firstname=$data['first_name'];
  $lastname=$data['last_name'];
  $email=$data['email'];
  $phone=$data['mobile'];



  $sql="SELECT p_id,product_title,price,qty FROM cart WHERE user_id='$uid'";
  $result=mysqli_query($con,$sql);

  if(mysqli_num_rows($result)>0){
        while($row=mysqli_fetch_array($result)){
              $product_id[]=$row['p_id'];
              $qty[]=$row['qty'];
              $p_name[]=$row['product_title'];
              $p_price[]=$row['price'];
              
          }//end of while
  
    
       for($i=0;$i<count($product_id);$i++){
            $sql_customer_order="INSERT INTO `customer_order`(`pid`,`uid`, `p_name`, `p_price`, `p_qty`, `p_status`, `trx_id`,`ref`) 
            VALUES ('$product_id[$i]','".$uid."','".$p_name[$i]."','".$p_price[$i]."','".$qty[$i]."','".$p_st."','".$trx_id."','".$ref."')";
            $result1=mysqli_query($con,$sql_customer_order);
         //   echo"customer_order table is updated" ;
        }//end of for loop
        $sql3 = "INSERT INTO `received_payment`(`amount`, `trx_id`, `status`,date) VALUES ('$amt','$trx_id','Pending', '$dt' ) ";
        $result2=mysqli_query($con,$sql3);

        $sql2 = "DELETE FROM cart WHERE user_id = '$uid'";
        $result2=mysqli_query($con,$sql2);

                // Prepare the SQL statement
        $sql4 = "UPDATE `user_info` SET `balance`= balance - ?  WHERE user_id = ?";
        $stmt = mysqli_prepare($con, $sql4);

        // Bind the parameters
        mysqli_stmt_bind_param($stmt, "ss", $amt, $uid);

        // Execute the statement
        $result4 = mysqli_stmt_execute($stmt);

        if($result2){

// Compose email
$toEmail = $email;
$subject = "Order Successful";
$mailHeaders = "MIME-Version: 1.0" . "\r\n";
$mailHeaders .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
$mailHeaders .= 'From: Qarkt <' . $noreply_email . '>' . "\r\n";
$mailHeaders .= "Date: " . date('r') . " \r\n";
$mailHeaders .= "Return-Path: " . $site_email . "\r\n";
$mailHeaders .= "Errors-To: " . $site_email . "\r\n";
$mailHeaders .= "Reply-to: " . $site_email . " \r\n";
$mailHeaders .= "Organization: " . $site_title . " \r\n";
$mailHeaders .= "X-Sender: " . $site_email . " \r\n";
$mailHeaders .= "X-Priority: 3 \r\n";
$mailHeaders .= "X-MSMail-Priority: Normal \r\n";
$mailHeaders .= "X-Mailer: PHP/" . phpversion();

$content = '
<!DOCTYPE html>
<html>
<head>
  <meta charset="UTF-8">
  <title>Order Placed</title>
  <style>
    body {
      font-family: Arial, sans-serif;
      background-color: #f6f6f6;
      margin: 0;
      padding: 0;
    }
    .container {
      max-width: 600px;
      margin: 0 auto;
      padding: 20px;
      background-color: #ffffff;
    }
    h1 {
      font-size: 24px;
      font-weight: bold;
      color: #64001d;
      margin-top: 0;
    }
    p {
      font-size: 16px;
      line-height: 1.5;
      color: #000000;
    }
    .footer {
      font-size: 14px;
      color: #808080;
      margin-top: 20px;
    }
  </style>
</head>
<body>
  <div class="container">
    <h1>ORDER SUCCESSFUL</h1>
    <p>
      <b>Hi '.$firstname.' '.$lastname.',</b><br>
     Your recent purchase has been successfully processed. Please access your order history to view tracking details for your 
     shipment.
    </p>
    <p>
    We appreciate your choice of Qarkt for your automotive requirements
    </p>
    <p class="footer">
      If you did not create an account with Qarkt, please ignore this message.
    </p>
  </div>
</body>
</html>
';

if(mail($toEmail, $subject, $content, $mailHeaders)) {
            

echo '<script type="text/javascript"> alert("Your order has been placed successfully and have been sent an email with your transaction ID") </script>';				
}
else
{
echo '<script type="text/javascript"> alert("Your order has been placed successfully but we could not send you an email.") </script>';
}




        //  echo "products deleted from the cart sucessfully.";
include 'includes/header.php';  
?>
  <!--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="">Checkout</a> <span></span>
                    Order Complete
                </div>
            </div>
        </div>


        <div class="page-content pt-50 pb-150">
          

                <div class="container">


                <div class="login-form" style="margin-bottom:50px;">

<h4>Thank You </h4>

    <p class="card-text">Hello, <?php echo $_SESSION['name']; ?> Your Payment Process is successfully Completed.
                 Your Transaction ID is <?php echo $trx_id; ?>. Details of your order has been sent to your email.</p><br/>
                 <br>
                <a href="dashboard.php" class="btn btn-primary" style="border:none;">See Orders</a>


    </div>
    </div>








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

<?php
    }//end of if($result2)----data deleted from cart
}//end of if(mysqli_num_rows($result)>0) statement
else{
  header("Location:index.php");
  }
}//end of isset cookie['ta'] && p-st==Completed
}//end of if (isset($_GET["st"])) {
?>