D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home5
/
rakcha
/
www
/
user
/
Filename :
my_cards.php
back
Copy
<?php session_start(); if (!isset($_SESSION['distributor_id'])) { header("location: ../index.html"); } else { include("includes/database.php"); $page_user = $_SESSION['distributor_id']; $select_query = "select * from member where user_id='$page_user'"; $run = mysqli_query($con,$select_query); $serial = 1; while ($row = mysqli_fetch_array($run)) { $s_num = $serial++; $member_id = $row['member_id']; $title = $row['title']; $dob = $row['dob']; $name = $row['name']; $gender = $row['gender']; $address_1 = $row['address_1']; $address_2 = $row['address_2']; $town_area = $row['town_area']; $city_district = $row['city_district']; $state = $row['state']; $country = $row['country']; $pincode = $row['pincode']; $mobile_number = $row['mobile_number']; $email = $row['email']; $aadhaar_card = $row['aadhaar_card']; $pan_card = $row['pan_card']; $nominee_name = $row['nominee_name']; $nominee_relationship = $row['nominee_relationship']; $account_name = $row['account_name']; $account_number = $row['account_number']; $ifsc_code = $row['ifsc_code']; $bank_name = $row['bank_name']; $branch_name = $row['branch_name']; $member_no = $row['member_no']; $user_id = $row['user_id']; $password = $row['password']; $aadhaar_card_image = $row['aadhaar_card_image']; $pan_card_image = $row['pan_card_image']; $bank_proof_image = $row['bank_proof_image']; $document_status = $row['document_status']; $member_fess = $row['member_fess']; $activity_level = $row['activity_level']; $activity_referral = $row['activity_referral']; $activity_date = $row['activity_date']; $activity_month = $row['activity_month']; $aadhaar_card_image = $row['aadhaar_card_image']; $pan_card_image = $row['pan_card_image']; $bank_proof_image = $row['bank_proof_image']; $document_status = $row['document_status']; $date_of_join =$row['date_of_join']; $elite_board = $row['elite_board']; $select_query_1_cart = "select * from cart where member_no='$member_no'"; $run_1_cart = mysqli_query($con,$select_query_1_cart); $num_right_1_1_cart = mysqli_num_rows($run_1_cart); ?> <!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, maximum-scale=1, user-scalable=no"> <meta name="description" content=""> <meta name="author" content=""> <link rel="icon" href="images/fave.png"> <title>Welcome - <?= $title; ?><?= $name; ?></title> <!-- Bootstrap v4.0.0-beta --> <link rel="stylesheet" href="assets/vendor_components/bootstrap/dist/css/bootstrap.min.css"> <!-- Font Awesome --> <link rel="stylesheet" href="assets/vendor_components/font-awesome/css/font-awesome.min.css"> <!-- Ionicons --> <link rel="stylesheet" href="assets/vendor_components/Ionicons/css/ionicons.min.css"> <link rel="stylesheet" href="assets/vendor_components/select2/dist/css/select2.min.css"> <!-- Theme style --> <link rel="stylesheet" href="css/master_style.css"> <!-- maximum_admin Skins. Choose a skin from the css/skins folder instead of downloading all of them to reduce the load. --> <link rel="stylesheet" href="css/skins/_all-skins.css"> <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries --> <!-- WARNING: Respond.js doesn't work if you view the page via file:// --> <!--[if lt IE 9]> <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script> <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script> <![endif]--> <!-- google font --> <link href="https://fonts.googleapis.com/css?family=Poppins:300,400,500,600,700" rel="stylesheet"> </head> <body class="hold-transition skin-blue sidebar-mini"> <div class="wrapper"> <header class="main-header"> <!-- Logo --> <a href="main_home.php" class="logo"> <!-- mini logo for sidebar mini 50x50 pixels --> <span class="logo-mini"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span> <!-- logo for regular state and mobile devices --> <span class="logo-lg"><img src="../images/resources/logo.png" style="max-width: 47px;padding-top: 3px;"></span> </a> <!-- Header Navbar: style can be found in header.less --> <nav class="navbar navbar-static-top"> <!-- Sidebar toggle button--> <a href="#" class="sidebar-toggle" data-toggle="push-menu" role="button"> <span class="sr-only">Toggle navigation</span> </a> <div class="navbar-custom-menu"> <ul class="nav navbar-nav"> <li class="dropdown messages-menu"> <a href="my_cards.php" class="dropdown-toggle"> <i class="fa fa-shopping-cart" style="font-size: 18px;"></i> <span class="label label-success" style=" position: absolute;top: -1px;margin-left: 15px;text-align: center;font-size: 8px;padding: 2px 3px;line-height: 12px;width: 15px;height: 15px;border-radius: 100%;font-weight: 400;display: grid;"> <?php $select_query_1_cart = "select * from cart where member_no='$member_no'"; $run_1_cart = mysqli_query($con,$select_query_1_cart); $num_right_1_1_cart = mysqli_num_rows($run_1_cart); echo $num_right_1_1_cart; ?> </span> </a> </li> <!-- Notifications: style can be found in dropdown.less --> <li class="dropdown notifications-menu label-warning"> <a href="#" class="dropdown-toggle" data-toggle="dropdown" style="color: #000;font-weight: 700;"> <span class="d-sm-inline-block "><?= $title; ?><?= $name; ?> - <?= $user_id; ?> <i class="fa fa-angle-down pull-right" style="margin-top:8px;font-size:14px;"></i></span> </a> </li> <li> <a href="logout.php" class="link" data-toggle="tooltip" title="" data-original-title="Logout"><i class="fa fa-power-off"></i></a> </li> </ul> </div> </nav> </header> <!-- Left side column. contains the logo and sidebar --> <aside class="main-sidebar" style="background-image: url('img/bg.jpg');background-position: left;background-attachment: fixed;"> <!-- sidebar: style can be found in sidebar.less --> <section class="sidebar"> <!-- sidebar menu: : style can be found in sidebar.less --> <ul class="sidebar-menu" data-widget="tree"> <li><a href="main_home.php"><i class="fa fa-dashboard"></i> <span>DASHBOARD</span></a></li> <li><a href="new_registeration.php"><i class="fa fa-user-o"></i> <span>ADVANCE REGISTRATION</span></a></li> <li class="treeview"> <a href="#"> <i class="fa fa-user-o"></i> <span>MY PROFILE</span> <span class="pull-right-container"> <i class="fa fa-angle-left pull-right"></i> </span> </a> <ul class="treeview-menu"> <li><a href="member_view.php"><i class="fa fa-circle-o"></i> <span>VIEW / EDIT PROFILE</span></a></li> <li><a href="kyc_upload.php"><i class="fa fa-circle-o"></i> <span>KYC DOCUMENTS</span></a></li> <li><a href="change_password.php"><i class="fa fa-circle-o"></i> CHANGE PASSWORD</a></li> <li><a href="change_e_password.php"><i class="fa fa-circle-o"></i> CHANGE TRANS.PWD</a></li> <li><a href="welcome_letter.php"><i class="fa fa fa-circle-o"></i> WELCOME LETTER</a></li> </ul> </li> <li class="treeview"> <a href="#"> <i class="fa fa-users"></i> <span>GENEALOGY TREE</span> <span class="pull-right-container"> <i class="fa fa-angle-left pull-right"></i> </span> </a> <ul class="treeview-menu"> <li><a href="downline.php"><i class="fa fa-circle-o"></i> GENEALOGY TREE</a></li> <li><a href="direct_referrals.php"><i class="fa fa-circle-o"></i> DIRECT LEG</a></li> </ul> </li> <li class="treeview"> <a href="#"> <i class="fa fa-money"></i> <span>PAYMENTS</span> <span class="pull-right-container"> <i class="fa fa-angle-left pull-right"></i> </span> </a> <ul class="treeview-menu"> <li><a href="week_payout.php"><i class="fa fa-circle-o"></i>PAYOUT HISTORY </a></li> </ul> </li> <li class="treeview"> <a href="#"> <i class="fa fa-database"></i> <span>KIT BANK</span> <span class="pull-right-container"> <i class="fa fa-angle-left pull-right"></i> </span> </a> <ul class="treeview-menu"> <li><a href="eproduct_details.php"><i class="fa fa-circle-o"></i> NEW JOIN / VIEW KIT </a></li> <li><a href="eproduct_transfer.php"><i class="fa fa-circle-o"></i> KIT TRANSFER</a></li> <li><a href="eproduct_request.php"><i class="fa fa-circle-o"></i> BUY KITS/KIT REQ</a></li> <li><a href="eproduct_history.php"><i class="fa fa-circle-o"></i> KIT TRANSFER LOG</a></li> <li><a href="eproduct_wallet_history.php"><i class="fa fa-circle-o"></i> KIT REQ HISTORY</a></li> </ul> </li> <li class="treeview active"> <a href="#"> <i class="fa fa-shopping-cart"></i> <span>SHOP</span> <span class="pull-right-container"> <i class="fa fa-angle-left pull-right"></i> </span> </a> <ul class="treeview-menu"> <li class="active"><a href="products.php"><i class="fa fa-circle"></i> PRODUCTS</a></li> <li><a href="my_orders.php"><i class="fa fa-circle-o"></i> MY ORDERS</a></li> </ul> </li> <li><a href="logout.php"><i class="fa fa-sign-out"></i> <span>Logout</span></a></li> </ul> </section> </aside> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <!-- Content Header (Page header) --> <section class="content-header"> <h4> <?= $title; ?><?= $name; ?> </h4> <ol class="breadcrumb"> <li class="breadcrumb-item"><a href="main_home.php"><i class="fa fa-dashboard"></i> Home</a></li> <li class="breadcrumb-item active">My Carts</li> </ol> </section> <section class="content"> <div class="row"> <div class="col-md-12 col-lg-6"> <div class="box"> <div class="box-header"> <h3 class="box-title">My Carts</h3> </div> <!-- /.box-header --> <div class="box-body"> <table class="table table-responsive"> <tbody> <tr> <th style="width: 10px">S.No</th> <th>Product</th> <th>Qty</th> <th>BV</th> <th>Amount</th> <th style="width: 40px">Remove</th> </tr> <?php $select_query_1 = "select * from cart where member_no='$member_no'"; $run_1 = mysqli_query($con,$select_query_1); $num_right_1_1 = mysqli_num_rows($run_1); if ($num_right_1_1 > 0) { $serial_payment = 1; while ($row_1 = mysqli_fetch_array($run_1)) { $s_num_payment = $serial_payment++; $cart_id_1 = $row_1['cart_id']; $member_no_1 = $row_1['member_no']; $user_id_1 = $row_1['user_id']; $product_code_1 = $row_1['product_code']; $qty_1 = $row_1['qty']; $total_amount_1 = $row_1['total_amount']; $bv_1 = $row_1['bv']; $cp_1 = $row_1['cp']; $select_query_2 = "select * from products where product_id='$product_code_1'"; $run_2 = mysqli_query($con,$select_query_2); while ($row_2 = mysqli_fetch_array($run_2)) { $product_id_2 = $row_2['product_id']; $product_title_2 = $row_2['product_title']; $cp_2 = $row_2['cp']; $bv_2 = $row_2['bv']; $mrp_2 = $row_2['mrp']; $image_2 = $row_2['image']; } $select_query_total_team_pv_pro = "select SUM(total_amount), SUM(bv), SUM(cp) from cart where member_no='$member_no'"; $run_total_team_pv_pro = mysqli_query($con,$select_query_total_team_pv_pro); while($row_total_team_pv_pro = mysqli_fetch_array($run_total_team_pv_pro)){ $total_amount_cart = $row_total_team_pv_pro['SUM(total_amount)']; $total_bv_cart = $row_total_team_pv_pro['SUM(bv)']; $total_cp_cart = $row_total_team_pv_pro['SUM(cp)']; } ?> <tr> <td><?= $s_num_payment; ?></td> <td><?= $product_title_2; ?></td> <td> <?= $qty_1; ?> </td> <td> <?= $bv_1; ?> </td> <td>Rs. <?= $total_amount_1; ?></td> <td><a href="my_cards.php?cart_id=<?= $cart_id_1; ?>"><span class="badge bg-danger">Remove</span></a></td> </tr> <?php } }else { ?> <tr><td colspan="5"><b>Your Cart is Empty</b></td></tr> <?php } ?> </tbody></table> <?php if ($num_right_1_1 > 0) { ?> <div class="row"> <div class="col-sm-4"> <h3 style="text-align: left;">Total</h3> </div> <div class="col-sm-8"> <h3 style="text-align: right;"><b><b>BV. <?= $total_bv_cart; ?></b>, Rs. <?= $total_amount_cart; ?></b></h3> </div> </div> <?php } ?> </div> <!-- /.box-body --> </div> </div> <?php if ($num_right_1_1 > 0) { ?> <div class="col-md-12 col-lg-6"> <div class="box box-default"> <div class="box-body"> <form method="POST" action="my_cards.php" enctype="multipart/form-data"> <input type="hidden" name="member_no" value="<?= $member_no; ?>"> <input type="hidden" name="total_amount" value="<?= $total_amount_cart; ?>"> <input type="hidden" name="total_cp" value="<?= $total_cp_cart; ?>"> <input type="hidden" name="user_id" value="<?= $user_id; ?>"> <input type="hidden" name="total_bv" value="<?= $total_bv_cart; ?>"> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">Payment</label> <div class="col-sm-8"> <input class="form-control" type="text" id="total" name="amount" readonly value="<?= $total_amount_cart; ?>"> </div> </div> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">Bank Name</label> <div class="col-sm-8"> <input class="form-control" type="text" name="bank_name" placeholder="Enter Bank Name"> </div> </div> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">Date of deposit</label> <div class="col-sm-8"> <div class="input-group date"> <div class="input-group-addon"> <i class="fa fa-calendar"></i> </div> <input type="text" class="form-control pull-right" id="datepicker" name="date"> </div> </div> </div> <div class="bootstrap-timepicker"> <div class="form-group row "> <label for="example-text-input" class="col-sm-4 col-form-label">Time of deposit</label> <div class="col-sm-8"> <div class="input-group"> <input type="text" class="form-control timepicker" name="time"> <div class="input-group-addon"> <i class="fa fa-clock-o"></i> </div> </div> </div> </div> </div> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">Mode of payment</label> <div class="col-sm-8"> <select class="form-control" name="payment_method"> <option>-Select Payment Method-</option> <option value="IMPS">IMPS</option> <option value="NEFT">NEFT</option> <option value="BANK RECEIPIT">BANK RECEIPIT</option> <option value="ATM Deposit">ATM Deposit</option> </select> </div> </div> <div class="form-group row"> <label for="example-text-input" class="col-sm-4 col-form-label">Remarks</label> <div class="col-sm-8"> <textarea class="form-control" name="remark"> </textarea> </div> </div> <div class="form-group row"> <label class="col-sm-4">Payment Proof</label> <input type="file" name="bank_prof" class="form-control col-sm-8"> <input type="submit" name="submit" value="Checkout Now" class="btn btn-success"> </div> </form> </div> <!-- /.box-body --> </div> <!-- /.box --> </div> <?php } ?> <!-- /.col --> </div> </section> <div class="clearfix"></div> </div> <!-- /.content-wrapper --> <footer class="main-footer"> <div class="pull-right d-none d-sm-inline-block"> </div>Copyright © 2018. All Rights Reserved. </footer> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Create the tabs --> <ul class="nav nav-tabs nav-justified control-sidebar-tabs"> <li class="nav-item"><a href="#control-sidebar-home-tab" data-toggle="tab"><i class="fa fa-home"></i></a></li> <li class="nav-item"><a href="#control-sidebar-settings-tab" data-toggle="tab"><i class="fa fa-cog fa-spin"></i></a></li> </ul> <!-- Tab panes --> <div class="tab-content"> <!-- Home tab content --> <div class="tab-pane" id="control-sidebar-home-tab"> <h3 class="control-sidebar-heading">Recent Activity</h3> <ul class="control-sidebar-menu"> <li> <a href="javascript:void(0)"> <i class="menu-icon fa fa-birthday-cake bg-red"></i> <div class="menu-info"> <h4 class="control-sidebar-subheading">Admin Birthday</h4> <p>Will be July 24th</p> </div> </a> </li> <li> <a href="javascript:void(0)"> <i class="menu-icon fa fa-user bg-yellow"></i> <div class="menu-info"> <h4 class="control-sidebar-subheading">Jhone Updated His Profile</h4> <p>New Email : jhone_doe@demo.com</p> </div> </a> </li> <li> <a href="javascript:void(0)"> <i class="menu-icon fa fa-envelope-o bg-light-blue"></i> <div class="menu-info"> <h4 class="control-sidebar-subheading">Disha Joined Mailing List</h4> <p>disha@demo.com</p> </div> </a> </li> <li> <a href="javascript:void(0)"> <i class="menu-icon fa fa-file-code-o bg-green"></i> <div class="menu-info"> <h4 class="control-sidebar-subheading">Code Change</h4> <p>Execution time 15 Days</p> </div> </a> </li> </ul> <!-- /.control-sidebar-menu --> <h3 class="control-sidebar-heading">Tasks Progress</h3> <ul class="control-sidebar-menu"> <li> <a href="javascript:void(0)"> <h4 class="control-sidebar-subheading"> Web Design <span class="label label-danger pull-right">40%</span> </h4> <div class="progress progress-xxs"> <div class="progress-bar progress-bar-danger" style="width: 40%"></div> </div> </a> </li> <li> <a href="javascript:void(0)"> <h4 class="control-sidebar-subheading"> Update Data <span class="label label-success pull-right">75%</span> </h4> <div class="progress progress-xxs"> <div class="progress-bar progress-bar-success" style="width: 75%"></div> </div> </a> </li> <li> <a href="javascript:void(0)"> <h4 class="control-sidebar-subheading"> Order Process <span class="label label-warning pull-right">89%</span> </h4> <div class="progress progress-xxs"> <div class="progress-bar progress-bar-warning" style="width: 89%"></div> </div> </a> </li> <li> <a href="javascript:void(0)"> <h4 class="control-sidebar-subheading"> Development <span class="label label-primary pull-right">72%</span> </h4> <div class="progress progress-xxs"> <div class="progress-bar progress-bar-primary" style="width: 72%"></div> </div> </a> </li> </ul> <!-- /.control-sidebar-menu --> </div> <!-- /.tab-pane --> <!-- Stats tab content --> <div class="tab-pane" id="control-sidebar-stats-tab">Stats Tab Content</div> <!-- /.tab-pane --> <!-- Settings tab content --> <div class="tab-pane" id="control-sidebar-settings-tab"> <form method="post"> <h3 class="control-sidebar-heading">General Settings</h3> <div class="form-group"> <input type="checkbox" id="report_panel" class="chk-col-grey" > <label for="report_panel" class="control-sidebar-subheading ">Report panel usage</label> <p> general settings information </p> </div> <!-- /.form-group --> <div class="form-group"> <input type="checkbox" id="allow_mail" class="chk-col-grey" > <label for="allow_mail" class="control-sidebar-subheading ">Mail redirect</label> <p> Other sets of options are available </p> </div> <!-- /.form-group --> <div class="form-group"> <input type="checkbox" id="expose_author" class="chk-col-grey" > <label for="expose_author" class="control-sidebar-subheading ">Expose author name</label> <p> Allow the user to show his name in blog posts </p> </div> <!-- /.form-group --> <h3 class="control-sidebar-heading">Chat Settings</h3> <div class="form-group"> <input type="checkbox" id="show_me_online" class="chk-col-grey" > <label for="show_me_online" class="control-sidebar-subheading ">Show me as online</label> </div> <!-- /.form-group --> <div class="form-group"> <input type="checkbox" id="off_notifications" class="chk-col-grey" > <label for="off_notifications" class="control-sidebar-subheading ">Turn off notifications</label> </div> <!-- /.form-group --> <div class="form-group"> <label class="control-sidebar-subheading"> <a href="javascript:void(0)" class="text-red margin-r-5"><i class="fa fa-trash-o"></i></a> Delete chat history </label> </div> <!-- /.form-group --> </form> </div> <!-- /.tab-pane --> </div> </aside> <!-- /.control-sidebar --> <!-- Add the sidebar's background. This div must be placed immediately after the control sidebar --> <div class="control-sidebar-bg"></div> </div> <!-- ./wrapper --> <!-- jQuery 3 --> <script src="assets/vendor_components/jquery/dist/jquery.min.js"></script> <!-- popper --> <script src="assets/vendor_components/popper/dist/popper.min.js"></script> <!-- Bootstrap v4.0.0-beta --> <script src="assets/vendor_components/bootstrap/dist/js/bootstrap.min.js"></script> <!-- SlimScroll --> <script src="assets/vendor_components/jquery-slimscroll/jquery.slimscroll.min.js"></script> <!-- FastClick --> <script src="assets/vendor_components/fastclick/lib/fastclick.js"></script> <!-- maximum_admin App --> <script src="js/template.js"></script> <!-- maximum_admin for demo purposes --> <script src="js/demo.js"></script> <!-- This is data table --> <script src="assets/vendor_plugins/DataTables-1.10.15/media/js/jquery.dataTables.min.js"></script> <!-- start - This is for export functionality only --> <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/dataTables.buttons.min.js"></script> <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.flash.min.js"></script> <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/jszip.min.js"></script> <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/pdfmake.min.js"></script> <script src="assets/vendor_plugins/DataTables-1.10.15/ex-js/vfs_fonts.js"></script> <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.html5.min.js"></script> <script src="assets/vendor_plugins/DataTables-1.10.15/extensions/Buttons/js/buttons.print.min.js"></script> <!-- end - This is for export functionality only --> <!-- maximum_admin for Data Table --> <script src="js/pages/data-table.js"></script> </body> </html> <?php if (isset($_POST['submit'])) { $member_no = $_POST['member_no']; $user_id = $_POST['user_id']; $total_amount = $_POST['total_amount']; $total_bv = $_POST['total_bv']; $total_cp = $_POST['total_cp']; $bank_name = $_POST['bank_name']; $date = $_POST['date']; $time = $_POST['time']; $payment_method = $_POST['payment_method']; $remark = $_POST['remark']; $select_query_count = "select * from product_check"; $run_count = mysqli_query($con,$select_query_count); $user_count = mysqli_num_rows($run_count); $nominee_name_id1 = $user_count + 1; $member_no_1 = sprintf('%03d',$nominee_name_id1); $order_code = $member_no_1; $amount_proof_1 = $_FILES['bank_prof'] ['name']; $amount_proof_tmp = $_FILES['bank_prof'] ['tmp_name']; $bank_prof = $member_no."_".$amount_proof_1; $date_of_join = date("Y-m-d H:i:s"); $year = date("Y"); $month = date("m"); if($bank_prof == ''){ echo "<script>alert('some one feilds is empty please fill')</script>"; exit(); } else { move_uploaded_file($amount_proof_tmp, "../proof_doc/$bank_prof"); $insert_query = "insert into product_check(member_no, user_id, date, bank_prof, total_amount, bank_name, time, payment_method, remark, bv, year, month, cp, order_code) values('$member_no', '$user_id', '$date', '$bank_prof', '$total_amount', '$bank_name', '$time', '$payment_method', '$remark', '$total_bv', '$year', '$month', '$total_cp', '$order_code')"; if (mysqli_query($con,$insert_query)) { $select_query_1 = "select * from cart where member_no='$member_no'"; $run_1 = mysqli_query($con,$select_query_1); $num_right_1_1 = mysqli_num_rows($run_1); $serial_payment = 1; while ($row_1 = mysqli_fetch_array($run_1)) { $s_num_payment = $serial_payment++; $cart_id_1 = $row_1['cart_id']; $member_no_1 = $row_1['member_no']; $user_id_1 = $row_1['user_id']; $product_code_1 = $row_1['product_code']; $qty_1 = $row_1['qty']; $total_amount_1 = $row_1['total_amount']; $bv_1 = $row_1['bv']; $cp_1 = $row_1['cp']; mysqli_query($con,"insert into final_order(member_no, user_id, product_code, qty, total_amount, bv, cp, order_code) values('$member_no_1', '$user_id_1', '$product_code_1', '$qty_1', '$total_amount_1', '$bv_1', '$cp_1', '$order_code')"); mysqli_query($con,"delete from cart where cart_id = '$cart_id_1'"); } echo "<script>alert('Your Order is successfully Placed.')</script>"; echo "<script>window.open('my_orders.php','_self')</script>"; } } } if (isset($_GET['cart_id'])) { $cart_id = $_GET['cart_id']; mysqli_query($con,"delete from cart where cart_id = '$cart_id'"); echo "<script>alert('Product has been successfully Removed.')</script>"; echo "<script>window.open('my_cards.php','_self')</script>"; } ?> <?php } } ?>