|
Server IP : 2a02:4780:11:1596:0:cbc:26e7:10 / Your IP : 216.73.217.7 Web Server : LiteSpeed System : Linux in-mum-web1496.main-hosting.eu 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64 User : u213657319 ( 213657319) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u213657319/domains/mutiyanglobal.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
include 'check.php';
if(empty($_SESSION['emailId'])){
header("Location: index.php");
}
include '../connection.php';
include 'constant_file.php';
?>
<!DOCTYPE html>
<html>
<head>
<?php
include 'includes/assets.php'
?>
</head>
<body class="skin-blue">
<div class="wrapper">
<?php
include 'includes/header.php';
?>
<!-- Left side column. contains the logo and sidebar -->
<?php
include 'includes/aside.php';
?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-xs-12">
<div class="box">
<div class="box-header">
</div><!-- /.box-header -->
<div class="box-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>Id</th>
<th>Product Name</th>
<th>User Name</th>
<th>Address</th>
<th>Amount</th>
<th>Date</th>
<th>Transaction Id</th>
<th>Status</th>
<th>Update</th>
</tr>
</thead>
<tbody>
<?php
$query = mysqli_query($con,'SELECT * FROM orders ORDER BY id DESC');
$x = 1;
while($row = mysqli_fetch_array($query)){
$usr = mysqli_query($con,'SELECT * FROM user WHERE id = "'.$row['userid'].'"');
$user = mysqli_fetch_array($usr);
$usr1 = mysqli_query($con,'SELECT * FROM address WHERE userid ="'.$row['userid'].'"');
$user1 = mysqli_fetch_array($usr1);
$sql = mysqli_query($con,'SELECT * FROM `products` WHERE `id` IN ('.$row["productid"].') ');
while($data = mysqli_fetch_array($sql)){
$orders .='<tr>
<td>'.$x.'</td>
<td>'.$data['name'].'</td>
<td>'.$user['name'].'</td>
<td>'.$user1['address'].' '.$user1['state'].' '.$user1['pin'].'</td>
<td>'.$data["t_price"].'</td>
<td>'.$row["date"].'</td>
<td>'.$row['transaction_id'].'</td>
<td>'.$row["status"].'</td>
<td><a href="update-order.php?orderid='.$row["id"].'" class="btn btn-danger">Update</a></td>
</tr>';
$x++;
}
}
echo $orders;
?>
</tbody>
</table>
</div><!-- /.box-body -->
</div><!-- /.box -->
</div><!-- /.col -->
</div><!-- /.row -->
</section><!-- /.content -->
</div><!-- /.content-wrapper -->
<?php
include 'includes/footer.php';
?>
</div><!-- ./wrapper -->
<!-- jQuery 2.1.3 -->
<script src="plugins/jQuery/jQuery-2.1.3.min.js"></script>
<!-- Bootstrap 3.3.2 JS -->
<script src="bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
<!-- DATA TABES SCRIPT -->
<script src="plugins/datatables/jquery.dataTables.js" type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.js" type="text/javascript"></script>
<!-- SlimScroll -->
<script src="plugins/slimScroll/jquery.slimscroll.min.js" type="text/javascript"></script>
<!-- FastClick -->
<script src='plugins/fastclick/fastclick.min.js'></script>
<!-- AdminLTE App -->
<script src="dist/js/app.min.js" type="text/javascript"></script>
<!-- AdminLTE for demo purposes -->
<script src="dist/js/demo.js" type="text/javascript"></script>
<script type="text/javascript">
$(function () {
$("#example1").dataTable();
$('#example2').dataTable({
"bPaginate": true,
"bLengthChange": false,
"bFilter": false,
"bSort": true,
"bInfo": true,
"bAutoWidth": false
});
});
</script>
<!-- page script -->
</body>
</html>