File Explorer

<?php include("includes/db_config.php");
//error_reporting(E_ALL);
//ini_set('display_errors','1');
if (isset($_POST['buy_now'])){
extract($_POST);
date_default_timezone_set('Asia/Kolkata');
    $date = date('Y-m-d H:i:s');
$user_id=$_SESSION['id'];    
$sql_qryy="INSERT into addto_cart(prod_id,user_id,price,quantity,created_date) values ('$id','$user_id','$price','$size','$date')";
$result=mysqli_query($conn,$sql_qryy) or die(mysqli_error());
}
?>
<!DOCTYPE html>
<html lang="en">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content=" ">
    <meta name="author" content="">
    <title>Dr.Sadia Formulations</title>
    <?php include("includes/css.php");?>
    <style>
        .abtusvp p {
            color: #000;
            text-align: justify;
            font-size: 14px;
            letter-spacing: 1px;
        }.page-title-wrap{border-bottom: 1px solid #ccc;background-color: #fff;}
        .table tr th{background-color:#4c2812;color:#fff}.table tbody tr td{border: 1px solid #dee2e6;font-weight: 500!important;font-size: 16px;color: #000!important;}
   .shop-list .table tr td .form-control{width:150px} .page-title-wrap-inner {
    background-repeat: no-repeat;
    background-position: center center;
    background-size: cover;
    padding-top: 10px;
    padding-bottom: 5px;
} 
.breadcrumb { 
    padding: 0rem 1rem;
    margin-bottom: 0rem;}</style>
</head>

<div class="page-title-wrap">
        <div class="page-title-wrap-inner">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 text-left">
                        <div class="breadcrumb text-left">
                            <ul style="margin: 0px">
                                <li><a href="https://www.drsadiaformulations.com/">Home</a> </li>
                                <li><span class="mdi mdi-chevron-right"></span></li>
                                <li><a href="#">Clinical Coded </a></li>
                            </ul>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

<section class="shop-list section-padding">
        <div class="container">
            
                  <div class="row">
                    <div class="col-md-12"><h4>Clinical Coded/Specially Formulated Medicine</h4></div>
                    <div class="col-md-12 table-responsive">
                        <table class="table table-striped table-bordered">
                            <thead>
                                <tr>
                                    <th>S.No.</th>
                                    <th>Medicines</th>
                                    <th>Product Quantity</th>
                                    <th>Price</th>
                                    <th>Quantity</th>
                                    <th>Total</th>
                                    <th>Action</th>
                                </tr>
                            </thead>
                             <tbody>
                            <?php $page_name = str_replace(".php", "", basename($_SERVER['PHP_SELF']));
                                $Current_URL = basename(dirname(__FILE__));
                                $findid = (mysqli_query($conn, "SELECT * FROM category"));
                                while ($res2=mysqli_fetch_array($findid)) {
                                    if(strtolower(str_replace(" ", "-", $res2["cat_name"])) == $page_name){
                                        $scid = $res2["id"];
                                    }
                                } $i=1;
                            $sql_qrry="select category.cat_name,product.* from product join category on product.category_id=category.id where category.id='".$scid."'";
                            $resultss = mysqli_query($conn, $sql_qrry);
                            while($res= mysqli_fetch_array($resultss))
                            { $user_id=$_SESSION['id']; 
                           $prd_id=$res['id'];
                           $status='1';
                           $sql_equ=mysqli_fetch_array(mysqli_query($conn,"SELECT * from addto_cart where user_id='".$user_id."' and prod_id='".$prd_id."' and invoice_id='".$status."'")); ?>  
                          
                                 <tr>
                                  <td><?= $i; $i++; ?>.</td>
                                    <td><?= $res['prod_name']; ?></td>
                                    <form action="" method="post">
                                    <input type="hidden" name="id" value="<?php echo $res['id']; ?>">
                                    <td><?= $res['prod_quantity']; ?>
                                    <td><?= $res['prod_price']; ?>
                                    <input type="hidden" name="price" id="price" value="<?= $res['prod_price']; ?>"></td>
                                    <td><input type="text" name="size" id="qty" class="form-control" placeholder="Enter Quantity" value=""></td>
                                    <td><?php if(!empty($sql_equ['id'])){ echo $total = (int)$sql_equ['quantity'] * $sql_equ['price']; } else { ?><input type="text" id="total" name="total"  class="form-control " readonly style="background-color:transparent; color:#0091ae;text-align:center; border:0px solid #ccc; box-shadow: inset 0 0px 0px rgba(0,0,0,.075);"><?php } ?></td>
                                    <td><?php if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true){ ?>
                                    <input type="hidden"  name="user_id"  value="<?php echo $_SESSION['id']; ?>">
                                    <?php if(!empty($sql_equ['id'])){ ?>
                                    <a href="#" class="btn btn-success btn-sm" readonly="" style="color:#fff;" >Selected</a>
                                       <?php } else{ ?>
                                     <input type="submit" name="buy_now"  class="btn btn-primary" value="Buy Now">
                                    <?php } ?>
                                   <?php } else { ?>
                                    <a href="login.php" class="btn btn-primary" readonly="" style="color:#fff;">Buy Now</a><?php } ?>
                                   </td>
                                 </form>
                                </tr> 
                            <?php } ?>
                              </tbody>
                             <tfoot>
                                <tr> 
                                <?php $sql_equt="SELECT SUM(addto_cart.quantity * addto_cart.Price) as total_price from addto_cart join product on addto_cart.prod_id=product.id where addto_cart.user_id='".$user_id."' and invoice_id='1' and category_id='".$scid."'";
                                   $result_equt=mysqli_query($conn,$sql_equt);
                                   $res_equt= mysqli_fetch_array($result_equt); ?>
									<td colspan="6" class="text-right">Total : </td>
									<th colspan="2" class="text-center" style="color:#fff">Rs. <?php echo $res_equt['total_price']; ?>/-</th>
                                 </tr>
                            </tfoot>
                        </table>
                    </div> 
                                       <a href="cart.php" class="btn btn-success pull-right" readonly>Continue</a>

</div>
            </div>
        </div>
    </section>

<?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>

</script> 
</body> 
</html>

Editing File: clinical-coded.php