File manager - Edit - /home/cipherteam/htdocs/cipherteam.in/yogi/AdminPanel/Order.php
Back
<?php require_once("Connection.php"); if(!isset($_SESSION['username'])) { header("location:AdminLogin.php"); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <!-- Tell the browser to be responsive to screen width --> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <!-- Favicon icon --> <link rel="icon" type="image/png" sizes="16x16" href="../assets/images/favicon.png"> <title>Elite Admin Template - The Ultimate Multipurpose admin template</title> <!-- This page CSS --> <!-- chartist CSS --> <link href="../assets/node_modules/morrisjs/morris.css" rel="stylesheet"> <!-- Vector CSS --> <link href="../assets/node_modules/vectormap/jquery-jvectormap-2.0.2.css" rel="stylesheet" /> <!--c3 CSS --> <link href="dist/css/pages/easy-pie-chart.css" rel="stylesheet"> <!-- Custom CSS --> <link href="dist/css/style.min.css" rel="stylesheet"> <!-- Dashboard 1 Page CSS --> <link href="dist/css/pages/dashboard2.css" rel="stylesheet"> <!-- 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/libs/html5shiv/3.7.0/html5shiv.js"></script> <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script> <![endif]--> </head> <body class="horizontal-nav skin-megna fixed-layout"> <!--Connection--> <?php $sql = "SELECT `order`.`o_id` AS 'ID',`order`.`ot_id` AS 'OT_ID',`order`.`c_id` AS 'C_ID',`order`.`s_date` AS 'S_DATE',`order`.`e_date` AS 'E_DATE' FROM `order`"; $rows = $con->query($sql); ?> <!-- ============================================================== --> <!-- Main wrapper - style you can find in pages.scss --> <!-- ============================================================== --> <div id="main-wrapper"> <!-- ============================================================== --> <!-- Topbar header - style you can find in pages.scss --> <!-- ============================================================== --> <header class="topbar"> <nav class="navbar top-navbar navbar-expand-md navbar-dark"> <!-- ============================================================== --> <!-- Logo --> <!-- ============================================================== --> <div class="navbar-header"> <a class="navbar-brand" href="index.php"> <h2><b>Yogi Mineral</b></h2> </a> </div> <!-- ============================================================== --> <!-- End Logo --> <!-- ============================================================== --> <div class="navbar-collapse"> <!-- ============================================================== --> <!-- toggle and nav items --> <!-- ============================================================== --> <ul class="navbar-nav mr-auto"> <!-- This is --> <li class="nav-item"> <a class="nav-link nav-toggler d-block d-md-none waves-effect waves-dark" href="javascript:void(0)"><i class="ti-menu"></i></a> </li> <li class="nav-item"> <a class="nav-link sidebartoggler d-none waves-effect waves-dark" href="javascript:void(0)"><i class="icon-menu"></i></a> </li> <!-- ============================================================== --> <!-- Search --> <!-- ============================================================== --> <li class="nav-item"> </li> </ul> <!-- ============================================================== --> <!-- User profile and search --> <!-- ============================================================== --> <ul class="navbar-nav my-lg-0"> <!-- ============================================================== --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- User Profile --> <!-- ============================================================== --> <li class="nav-item dropdown u-pro"> <a class="nav-link dropdown-toggle waves-effect waves-dark profile-pic" href="" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><img src="logo1.png" alt="user" class=""> <span class="hidden-md-down">Mark <i class="fa fa-angle-down"></i></span> </a> <div class="dropdown-menu dropdown-menu-right animated flipInY"> <!-- text--> <a href="javascript:void(0)" class="dropdown-item"><i class="ti-user"></i> My Profile</a> <!--text--> <div class="dropdown-divider"></div> <!-- text--> <a href="javascript:void(0)" class="dropdown-item"><i class="ti-settings"></i> Account Setting</a> <!-- text--> <div class="dropdown-divider"></div> <!-- text--> <a href="login.php" class="dropdown-item"><i class="fa fa-power-off"></i> Logout</a> <!-- text--> </div> </li> <!-- ============================================================== --> <!-- End User Profile --> <!-- ============================================================== --> </ul> </div> </nav> </header> <!-- ============================================================== --> <!-- End Topbar header --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- Left Sidebar - style you can find in sidebar.scss --> <!-- ============================================================== --> <aside class="left-sidebar"> <!-- Sidebar scroll--> <div class="scroll-sidebar"> <!-- Sidebar navigation--> <?php include("NavBarMenu.php"); ?> <!-- End Sidebar navigation --> </div> <!-- End Sidebar scroll--> </aside> <!-- ============================================================== --> <!-- End Left Sidebar - style you can find in sidebar.scss --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- Page wrapper --> <!-- ============================================================== --> <div class="page-wrapper"> <!-- ============================================================== --> <!-- Container fluid --> <!-- ============================================================== --> <div class="container-fluid"> <!-- ============================================================== --> <!-- Bread crumb and right sidebar toggle --> <!-- ============================================================== --> <div class="row page-titles"> <div class="col-md-5 align-self-center"> </div> <div class="col-md-7 align-self-center text-right"> <div class="d-flex justify-content-end align-items-center"> <a href="AddOrder.php"> </a> </div> </div> </div> <!-- ============================================================== --> <!-- End Bread crumb and right sidebar toggle --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- Info box --> <!-- ============================================================== --> <div class="row"> <div class="col-lg-12"> <div class="card"> <div class="card-body"> <h3 class="card-title">List of Order</h3> <div class="table-responsive"> <table class="table color-bordered-table info-bordered-table text-center"> <thead> <tr> <th>#ID</th> <th>ORDER TYPE</th> <th>NAME</th> <th>S_DATE</th> <th>E_DATE</th> <th>Action</th> </tr> </thead> <tbody> <?php while($row = $rows->fetch_assoc()) { ?> <tr> <td><?php echo $row['ID']; ?></td> <td><?php $sql = "SELECT `ord_typ_master`.`o_type` AS 'TYPE' FROM `ord_typ_master` WHERE `ord_typ_master`.`ot_id` = ".$row['OT_ID']; $Subrows = $con->query($sql); $Subrow = $Subrows->fetch_assoc(); echo $Subrow['TYPE']; ?></td> <td><?php $sql = "SELECT `customer`.`c_name` AS 'NAME' FROM `customer` WHERE `customer`.`c_id` = ".$row['C_ID']; $Subrows = $con->query($sql); $Subrow = $Subrows->fetch_assoc(); echo $Subrow['NAME']; ?></td> <td><?php echo $row['S_DATE']; ?></td> <td><?php echo $row['E_DATE']; ?></td> <td> <a href="ViewOrder.php?id=<?php echo $row['ID']; ?>"> </a> <a href="EditOrder.php?id=<?php echo $row['ID']; ?>"> <i class="icon-pencil text-warning"></i> </a> <a href="DeleteOrder.php?id=<?php echo $row['ID']; ?>"> <i class="icon-trash text-danger"></i> </a> </td> </tr> <?php } $con->close(); ?> </tbody> </table> </div> </div> </div> </div> </div> <!-- ============================================================== --> <!-- End Right sidebar --> <!-- ============================================================== --> </div> <!-- ============================================================== --> <!-- End Container fluid --> <!-- ============================================================== --> </div> <!-- ============================================================== --> <!-- End Page wrapper --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- footer --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- End footer --> <!-- ============================================================== --> </div> <!-- ============================================================== --> <!-- End Wrapper --> <!-- ============================================================== --> <!-- ============================================================== --> <!-- All Jquery --> <!-- ============================================================== --> <script src="../assets/node_modules/jquery/jquery-3.2.1.min.js"></script> <!-- Bootstrap popper Core JavaScript --> <script src="../assets/node_modules/popper/popper.min.js"></script> <script src="../assets/node_modules/bootstrap/dist/js/bootstrap.min.js"></script> <!-- slimscrollbar scrollbar JavaScript --> <script src="dist/js/perfect-scrollbar.jquery.min.js"></script> <!--Wave Effects --> <script src="dist/js/waves.js"></script> <!--Menu sidebar --> <script src="dist/js/sidebarmenu.js"></script> <!--Custom JavaScript --> <script src="dist/js/custom.min.js"></script> <!-- ============================================================== --> <!-- This page plugins --> <!-- ============================================================== --> <!-- Flot Charts JavaScript --> <script src="../assets/node_modules/flot/jquery.flot.js"></script> <script src="../assets/node_modules/flot.tooltip/js/jquery.flot.tooltip.min.js"></script> <!--sparkline JavaScript --> <script src="../assets/node_modules/sparkline/jquery.sparkline.min.js"></script> <!-- EASY PIE CHART JS --> <script src="../assets/node_modules/jquery.easy-pie-chart/dist/jquery.easypiechart.min.js"></script> <script src="../assets/node_modules/jquery.easy-pie-chart/easy-pie-chart.init.js"></script> <!-- Vector map JavaScript --> <script src="../assets/node_modules/vectormap/jquery-jvectormap-2.0.2.min.js"></script> <script src="../assets/node_modules/vectormap/jquery-jvectormap-world-mill-en.js"></script> <!-- Chart JS --> <script src="dist/js/dashboard2.js"></script> </body> </html>
| ver. 1.4 |
Github
|
.
| PHP 8.2.9 | Generation time: 0.05 |
proxy
|
phpinfo
|
Settings