bnmbnmbnmnbbtyutyutyutyutyutyu,nm,nmmnmm,bbbbbn

]nbmbmbnmbnmbytutytyutyutyutyumbnmjhkhjkhjkhjkhjkhjknnnnnnnn bnmbnmbnmnbbtyutyutyutyutyutyu,nm,nmmnmm,bbbbbn

<?php include("config.php") ?>
<?php include("function.php") ?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <meta name="description" content="">
        <meta name="author" content="">

<title>Admin | Services Detail</title>

<link href="css/bootstrap.min.css" rel="stylesheet" />

<link href="assets/font-awesome/css/font-awesome.min.css" rel="stylesheet" />
        <link href="assets/ionicon/css/ionicons.min.css" rel="stylesheet" />
        <link href="css/material-design-iconic-font.min.css" rel="stylesheet">

<link href="css/animate.css" rel="stylesheet" />

<link href="css/waves-effect.css" rel="stylesheet">

<link href="css/helper.css" rel="stylesheet" type="text/css" />
        <link href="css/style.css" rel="stylesheet" type="text/css" />

<div class="row">
                            <div class="col-sm-12">
                                <h4 class="pull-left page-title">Dental Crown and Bridges</h4>
                                <ol class="breadcrumb pull-right">
                                    <li><a href="dashboard.php">Dashboard</a></li>
                                    <li class="active">Services Detail</li>
                                </ol>
                            </div>
                        </div>
                         <?php 
                            if(isset($_GET['delete']))
                            {
                              $delete=$_GET['delete'];
                            }
                            else
                            {
                              $delete=0;
                              $slug="";
                            }
                              $sql="delete from parts2 where p_id='$delete'";
                              $res=mysqli_query($db,$sql);
                            ?>

<?php 
                            if(isset($_GET['slug']))
                            {
                              $slug=$_GET['slug'];
                            }
                            else
                            {
                              $slug=0;
                            }
                           $sql="select * from parts2 where p_id='$slug'";
                            $res=mysqli_query($db,$sql);
                            $row=mysqli_fetch_array($res);
                            @$img=$row['parts_image'];
                            @$short_desc=$row['short_desc'];
                            @$desc=$row['desc'];
                            ?>
                        <div class="row">
                            <div class="col-sm-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading"><h3 class="panel-title">Services </h3></div>
                                    <div class="panel-body">
                                        <form class="form-horizontal" role="form" method="post" enctype="multipart/form-data">                      
                                            <div class="form-group">
                                                <label class="col-md-2 control-label">Services Name</label>
                                                <div class="col-md-6"> 
                                                    <input type="text" class="form-control" name="editor11" value="<?php echo $short_desc ?>" placeholder="Services Title"> 
                                                </div>
                                            </div>
                                           
                                           
                                            <div class="form-group">
                                                <label class="col-md-2 control-label">Description</label>
                                                <div class="col-md-10"> 
                                                    <textarea class="wysihtml5 form-control" rows="5" name="editor2"><?php echo $desc ?></textarea> 
                                                </div>
                                            </div>

<div class="form-group">
                                                    <label class="col-md-2 control-label">Services Image</label>
                                                    <div class="col-md-3">
                                                        <div class="fileUpload btn btn-primary waves-effect waves-light">
                                                            <span>upload image here...</span>
                                                            <input type="file" name="image" class="upload">
                                                        </div>
                                                    </div>
                                                    <div class="col-md-4">
                                                        <img src="upload/<?php echo $img; ?>" style="width: 100px;">
                                                    </div>

</div>

<div class="form-group">
                                                <label class="col-md-2 control-label"></label>
                                                <div class="col-md-10">
                                                  <button type="submit" name="<?php if(isset($_GET['slug'])){ echo "Update"; }else { echo "Submit";} ?>" class="btn btn-purple waves-effect waves-light"><?php if(isset($_GET['slug'])){ echo "Update"; }else { echo "Submit";} ?></button>
                                                </div>
                                            </div>
                                        </form>
                                         <?php
                                            if(isset($_POST['Submit']))
                                            {
                                              
                                        
                                                $editor1=$_POST['editor11'];
                                                $editor2=$_POST['editor2'];
                                                /*$title_slug = strtolower(trim(preg_replace('/[^A-Za-z0-9-]+/', '-', $title)));*/

$image = $_FILES['image']['name'];
                                                if(!$image)
                                                {
                                                    $image=$img;
                                                }
                                                else
                                                {
                                                    $file_path = 'upload/';
                                                    $file_path = $file_path . basename( $_FILES['image']['name']);    
                                                    if(move_uploaded_file($_FILES['image']['tmp_name'], $file_path)) 
                                                    { 
                                                    }
                                                }

$sql="INSERT INTO `parts2` ( `short_desc`,`desc`,`parts_image`,`status`) VALUES ('$editor1','$editor2','$image','1')";
                                                $res=mysqli_query($db,$sql);
                                                if($res==1)
                                                {
                                                    echo ("<script LANGUAGE='JavaScript'>window.alert('Succesfully added.!!');window.location.href='dental_crown_and_bridges.php';</script>");
                                                    /*echo "data save";*/
                                                }
                                                else
                                                {
                                                    echo ("<script LANGUAGE='JavaScript'>window.alert('Product Not Added.!!');window.location.href='dental_crown_and_bridges.php';</script>");
                                                    /*echo "data Not save";*/
                                                }
                                            }
                                        ?>
                                        <?php
                                            if(isset($_POST['Update']))
                                            {
                                                $slug=$_GET['slug'];
                                               
                                                $editor1=$_POST['editor11'];
                                                $editor2=$_POST['editor2'];
                                               
                                                $image = $_FILES['image']['name'];
                                                if(!$image)
                                                {
                                                    $image=$img;
                                                }
                                                else
                                                {
                                                    $file_path = 'upload/';
                                                    $file_path = $file_path . basename( $_FILES['image']['name']);    
                                                    if(move_uploaded_file($_FILES['image']['tmp_name'], $file_path)) 
                                                    { 
                                                    }
                                                }
                                                $sql="update `parts2` set `short_desc`='$editor1',`desc`='$editor2',`parts_image`='$image',`status`='1' where `p_id` ='$slug'";
                                                $res=mysqli_query($db,$sql);
                                                if($res==1)
                                                {
                                                    /*echo ("<script LANGUAGE='JavaScript'>window.alert('Succesfully Updated');
                                                        window.location.href='services-detail.php';</script>");*/
                                                        echo "data update";
                                                }
                                                else
                                                {
                                                   echo ("<script LANGUAGE='JavaScript'>window.alert('Not Updated Data.!');
                                                        window.location.href='dental_crown_and_bridges.php';</script>");
                                                        /*echo "data not save";*/
                                                }
                                              }
                                            ?>
                                    </div> 
                                </div> 
                            </div> 
                        </div>

<div class="row">
                            <div class="col-md-12">
                                <div class="panel panel-default">
                                    <div class="panel-heading">
                                        <h3 class="panel-title">View Product</h3>
                                    </div>
                                    <div class="panel-body">
                                        <div class="row">
                                            <div class="col-md-12 col-sm-12 col-xs-12">
                                                <div class="table-responsive">
                                                <table id="datatable" class="table table-striped table-bordered">
                                                    <thead>
                                                        <tr>
                                                            <th>ID</th> 
                                                            <th>Title</th>
                                                            <th>sort</th>
                                                            <th>Image</th>
                                                            <th>Setting</th>
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        <?php
                                                          $sql="SELECT * FROM `parts2` WHERE p_id";
                                                            $res=mysqli_query($db,$sql);
                                                            while($row=mysqli_fetch_array($res))
                                                            {
                                                        ?>
                                                        <tr>
                                                            <td><?php echo $row['p_id']; ?></td>
                                                            <td><?php echo $row['short_desc']; ?></td>
                                                            <td><?php echo $row['desc']; ?></td>
                                                            <td><img style="width: 80px;" src="upload/<?php echo$row['parts_image']; ?>"></td>
                                                            <td>
                                                                <a href="dental_crown_and_bridges.php?slug=<?php echo $row['p_id']; ?>">
                                                                    <button class="btn btn-icon waves-effect waves-light btn-primary m-b-5"> <i class="fa fa-pencil"></i> </button>
                                                                </a>
                                                                <a href="dental_crown_and_bridges.php?delete=<?php echo $row['p_id']; ?>">
                                                                    <button class="btn btn-icon waves-effect waves-light btn-danger m-b-5" onclick="return confirm('Are you sure you want to delete this item?');"> <i class="fa fa-remove"></i> </button>
                                                                </a>
                                                            </td>
                                                        </tr>
                                                    <?php } ?>
                                                       
                                                    </tbody>
                                                </table>
                                            </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            
                        </div> 
                    </div> 
                               
                </div>

<?php include("footer.php") ?>

</div>

</div>
        
    
        <script>
            var resizefunc = [];
        </script>

<script src="js/jquery.min.js"></script>
        <script src="js/bootstrap.min.js"></script>
        <script src="js/waves.js"></script>
        <script src="js/wow.min.js"></script>
        <script src="js/jquery.nicescroll.js" type="text/javascript"></script>
        <script src="js/jquery.scrollTo.min.js"></script>
        <script src="assets/jquery-detectmobile/detect.js"></script>
        <script src="assets/fastclick/fastclick.js"></script>
        <script src="assets/jquery-slimscroll/jquery.slimscroll.js"></script>
        <script src="assets/jquery-blockui/jquery.blockUI.js"></script>

<script src="js/jquery.app.js"></script>
        <script src="assets/datatables/jquery.dataTables.min.js"></script>
        <script src="assets/datatables/dataTables.bootstrap.js"></script>
        <script type="text/javascript">
            $(document).ready(function() {
                $('#datatable').dataTable();
            } );
        </script>
         <script type="text/javascript">
            jQuery(document).ready(function() {
            jQuery(".select2").select2({
                    width: '100%'
                });
             });
        </script>
        <script src="assets/select2/select2.min.js" type="text/javascript"></script>
        <script>
            CKEDITOR.replace( 'editor1' );
        </script>
        <script>
            CKEDITOR.replace( 'editor2' );
        </script>
        
        <script src="assets/select2/select2.min.js" type="text/javascript"></script>
        <script type="text/javascript" src="assets/bootstrap-wysihtml5/wysihtml5-0.3.0.js"></script>
        <script type="text/javascript" src="assets/bootstrap-wysihtml5/bootstrap-wysihtml5.js"></script>
        
                         
        <script>
            $(document).on("change keyup blur", "#chDiscount", function() {
            var main = $('#cBalance').val();
            var disc = $('#chDiscount').val();
            var dec = (disc / 100).toFixed(2); //its convert 10 into 0.10
            var mult = main * dec; // gives the value for subtract from main value
            var discont = main - mult;
            $('#result').val(discont);
            });
        </script>
    </body>
</html>