MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.1
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/zugadu/AdminPanel/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/public_html/skyispatudyog/sym/Users/0-imyrqtmy/zugadu/AdminPanel/viewservice.php
<?php include"include/cookie.php"; ?>
<?php 
$Page_Title="View Service";

?>
<!DOCTYPE html>
<html lang="en">

    <head>
        <?php include"include/head.php"; ?>

        <!-- DataTables -->
        <link href="plugins/datatables/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
        <link href="plugins/datatables/buttons.bootstrap4.min.css" rel="stylesheet" type="text/css" />
        <!-- Responsive datatable examples -->
        <link href="plugins/datatables/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />

        
    </head>

    <body>

        <!-- Begin page -->
        <div id="wrapper">

            <!-- Top Bar Start -->
            <?php include"include/topbar.php"; ?>
            <!-- Top Bar End -->

            <!-- ========== Left Sidebar Start ========== -->
            <?php include"include/sidebar.php"; ?>
            <!-- Left Sidebar End -->

            <!-- ============================================================== -->
            <!-- Start right Content here -->
            <!-- ============================================================== -->
            <div class="content-page">
                <!-- Start content -->
                <div class="content">
                    <div class="container-fluid">

                        <div class="row">
                            <div class="col-sm-12">
                                <div class="page-title-box">
                                    <h4 class="page-title"><?php echo $Page_Title; ?></h4>
                                    <!-- <ol class="breadcrumb">
                                        <li class="breadcrumb-item"><a href="javascript:void(0);">Agroxa</a></li>
                                        <li class="breadcrumb-item"><a href="javascript:void(0);">Tables</a></li>
                                        <li class="breadcrumb-item active">Data Table</li>
                                    </ol> -->
            
                                    <!-- <div class="state-information d-none d-sm-block">
                                        <div class="state-graph">
                                            <div id="header-chart-1"></div>
                                            <div class="info">Balance $ 2,317</div>
                                        </div>
                                        <div class="state-graph">
                                            <div id="header-chart-2"></div>
                                            <div class="info">Item Sold 1230</div>
                                        </div>
                                    </div> -->
                                </div>
                            </div>
                        </div>
                        <!-- end row -->

                        <div class="page-content-wrapper">
                            <div class="row">
                                <div class="col-12">
                                    <div class="card m-b-20">
                                        <div class="card-body">
                                            <table id="datatable-buttons" class="table table-striped table-bordered dt-responsive nowrap" style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                                <thead>
                                                    <tr>
                                                        <th>Id</th>
                                                        <th>Title</th>
                                                        <th>Price</th>
                                                        <th>Attributes</th>
                                                        <th>Description</th>
                                                        <th>Image</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </thead>
                                                <tfoot>
                                                    <tr>
                                                        <th>Id</th>
                                                        <th>Title</th>
                                                        <th>Price</th>
                                                        <th>Attributes</th>
                                                        <th>Description</th>
                                                        <th>Image</th>
                                                        <th>Action</th>
                                                    </tr>
                                                </tfoot>
    
    
                                                <tbody>
                                                    <?php 
                                                        $trre=0;
                                                        $dis="select * from service_data";
                                                        $qq=mysqli_query($db,$dis) or die('error');
                                                        while($a = mysqli_fetch_assoc($qq))
                                                        {
                                                            $trre++;
                                                    ?>
                                                    <tr>
                                                        <td><?php echo $trre; ?></td>
                                                        <td><?php echo $a['Title']; ?></td>
                                                        <td><?php echo $a['Price']; ?></td>
                                                        <td><b>Brand:</b> <?php $bid= $a['Brand']; 
                                                            $dids="select * from brand where id='$bid'";
                                                            $qdq=mysqli_query($db,$dids) or die('error');
                                                            $asd = mysqli_fetch_assoc($qdq);
                                                            echo $asd['brand_name'];

                                                        ?>
                                                        <br><b>Model: </b>
                                                        <?php $mid= $a['Model']; 
                                                            $didds="select * from model where id='$mid'";
                                                            $qdqd=mysqli_query($db,$didds) or die('error');
                                                            $asdd = mysqli_fetch_assoc($qdqd);
                                                            echo $asdd['model_name'];
                                                        ?>
                                                        <br><b>Year: </b>
                                                        <?php $yid= $a['Year']; 
                                                            $diddsy="select * from year where id='$yid'";
                                                            $qdqdy=mysqli_query($db,$diddsy) or die('error');
                                                            $asddy = mysqli_fetch_assoc($qdqdy);
                                                            echo $asddy['year'];
                                                        ?>
                                                        <br><b>City: </b>
                                                        <?php $cid= $a['City']; 
                                                            $cdidds="select * from city where city_id='$cid'";
                                                            $cqdqd=mysqli_query($db,$cdidds) or die('error');
                                                            $casdd = mysqli_fetch_assoc($cqdqd);
                                                            echo $casdd['city_name'];
                                                        ?>
                                                        </td>
                                                        <td style="white-space: normal!important;">
                                                            <div style="width:150px;height:200px;overflow-y:auto;">
                                                                <?php echo $a['Description']; ?>
                                                            </div>
                                                            
                                                        </td>
                                                        <td><img src="<?php echo $a['Image']; ?>" width="100px"></td>
                                                        
                                                        <td>
                                                            <a href="deleteservice.php?id=<?php echo $a['Id']; ?>"><button class="btn btn-danger">Delete</button></a>
                                                            <a href="updateservice.php?id=<?php echo $a['Id']; ?>"><button class="btn btn-success">Update</button></a>
                                                        </td>
                                                    </tr>
                                                    <?php } ?>
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div> <!-- end col -->
                            </div> <!-- end row -->
    
                        </div>
                        <!-- end page content-->

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

                </div> <!-- content -->

                <?php include"include/footer.php"; ?>

            </div>


            <!-- ============================================================== -->
            <!-- End Right content here -->
            <!-- ============================================================== -->


        </div>
        <!-- END wrapper -->
            

        <!-- jQuery  -->
        <script src="assets/js/jquery.min.js"></script>
        <script src="assets/js/bootstrap.bundle.min.js"></script>
        <script src="assets/js/metisMenu.min.js"></script>
        <script src="assets/js/jquery.slimscroll.js"></script>
        <script src="assets/js/waves.min.js"></script>

        <script src="plugins/jquery-sparkline/jquery.sparkline.min.js"></script>

        <!-- Required datatable js -->
        <script src="plugins/datatables/jquery.dataTables.min.js"></script>
        <script src="plugins/datatables/dataTables.bootstrap4.min.js"></script>
        <!-- Buttons examples -->
        <script src="plugins/datatables/dataTables.buttons.min.js"></script>
        <script src="plugins/datatables/buttons.bootstrap4.min.js"></script>
        <script src="plugins/datatables/jszip.min.js"></script>
        <script src="plugins/datatables/pdfmake.min.js"></script>
        <script src="plugins/datatables/vfs_fonts.js"></script>
        <script src="plugins/datatables/buttons.html5.min.js"></script>
        <script src="plugins/datatables/buttons.print.min.js"></script>
        <script src="plugins/datatables/buttons.colVis.min.js"></script>
        <!-- Responsive examples -->
        <script src="plugins/datatables/dataTables.responsive.min.js"></script>
        <script src="plugins/datatables/responsive.bootstrap4.min.js"></script>

        <!-- Datatable init js -->
        <script src="assets/pages/datatables.init.js"></script>


        <!-- App js -->
        <script src="assets/js/app.js"></script>

    </body>

</html>

MMCT - 2023