Server IP : 103.53.40.154 / Your IP : 52.14.100.101 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/ntimachinery.com/webpanel/ |
[ Home ] | [ C0mmand ] | [ Upload File ] |
---|
<?php include('config/function.php'); if(!isset($_SESSION['user_name']) || empty($_SESSION['user_name'])) { header('location:login.php'); exit(); } /* set variable */ $pagename = "Gallery"; $pagetaskname = " Add "; /* set var blank */ $id = ""; $msg = ""; $sess_msg = ""; $title = ""; $subtitle = ""; $image = ""; $status = ""; /* get id */ if(isset($_GET['id']) && $_GET['id']!="") { $id = $_GET['id']; } if(isset($_POST['submit']) && $_POST['submit']=="add") { $title = addslashes(trim($_POST['title'])); if(!empty($_POST['status'])) { $status=1; } else{ $status=0; } /* check title in database */ $checkDuplicate =""; if($id!="") { $checkDuplicate = "AND id!='$id'"; } $query_duplicate="SELECT * FROM sucess_story WHERE title='".$title."' $checkDuplicate"; if($sql_duplicate=$conn->query($query_duplicate)) { if($sql_duplicate->num_rows>0) { $msg = "This Title is already exist, please try another."; } else { if($id!="") { $query_update="UPDATE sucess_story SET title='".$title."',status='".$status."' WHERE id='".$id."'"; if($sql_update=$conn->prepare($query_update)) { $sql_update->execute(); $sess_msg = $pagename." Update Successfully."; } } else { $query_insert="INSERT INTO sucess_story SET title='".$title."',status='".$status."'"; if($sql_insert=$conn->prepare($query_insert)) { $sql_insert->execute(); $id = mysqli_insert_id($conn); $sess_msg = $pagename." Added Successfully."; } } if(isset($_FILES['image']) && $_FILES['image']['error']==0) { $array = explode('.', $_FILES['image']['name']); $galleryimage = $array[0]; $galleryimage1 = $array[1]; $time =time(); $galleryimage = $time.$galleryimage; $galleryimage = str_replace("---","-",preg_replace("/[^-a-zA-Z0-9s]/", "-", strtolower(trim($galleryimage)))); $galleryimage = $galleryimage.".".$galleryimage1; $galleryimagename = ""; if($id!="") { $queryinfo = "SELECT image FROM `sucess_story` WHERE id = '".$id."'"; if($sql_select = $conn->query($queryinfo)) { if($sql_select->num_rows>0) { $resultinfo = $sql_select->fetch_array(MYSQLI_ASSOC); $galleryimagename = trim($resultinfo['image']); } } } if($galleryimagename!="") { $unlkheaderfile = "uploads/gallery/".$galleryimagename; if (file_exists($unlkheaderfile)) { unlink($unlkheaderfile); } } $galleryfilename = "uploads/gallery/". $galleryimage; $mv =move_uploaded_file($_FILES['image']['tmp_name'],$galleryfilename); $query_imageup="UPDATE sucess_story SET image='".$galleryimage."' WHERE id='".$id."'"; if($sql_imageup=$conn->prepare($query_imageup)) $sql_imageup->execute(); } echo "<script>document.location.href='view-profile.php?msg=".$sess_msg."';</script>"; exit; } } } /* Listing */ if($id!="") { $query_select="SELECT * FROM sucess_story WHERE id='".$id."'"; if($sql_select=$conn->query($query_select)) { if($sql_select->num_rows>0) { $result=$sql_select->fetch_array(MYSQLI_ASSOC); $title = stripslashes($result['title']); $image = $result['image']; $status = $result['status']; $pagetaskname = " Update "; } else { echo "<script>document.location.href='view-profile.php';</script>"; exit; } } } ?> <!DOCTYPE html> <html> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> <title>Dashboard</title> <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css"> <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css"> <link rel="stylesheet" href="dist/css/AdminLTE.min.css"> <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script> <script src="dist/js/editor.js"></script> <script> $(document).ready(function() { $("#txtEditor").Editor(); }); </script> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.4.0/css/font-awesome.min.css"> <link href="dist/css/editor.css" type="text/css" rel="stylesheet"/> </head> <body class="hold-transition skin-blue sidebar-mini"> <div class="wrapper"> <?php include('header.php') ?> <?php include('left-menu.php') ?> <div class="content-wrapper"> <section class="content"> <div class="row"> <div class="col-md-12"> <?php if($msg!="") { ?><h5 class="h5-headn" style="color:red;"><?php echo $msg; ?></h5><?php } else { ?> <div class="main-title"> <h3>Add Gallery</h3> </div> <?php } ?> </div> <div class="col-md-12"> <div class="field-section"> <form method="post" enctype="multipart/form-data"> <div class="row"> <div class="col-md-4"> <label class="input-text">Title</label> <div class="form-group"> <input type="text" name="title" value="<?php echo $title; ?>" class="from-control custom-type"> </div> </div> <div class="col-md-4"> <label class="input-text">Image</label> <div class="form-group"> <?php if($image!="") { ?> <img src="uploads/gallery/<?php echo $result['image']?>" height="100" width="120" title="<?php echo $title; ?> Image"> <?php } ?> <input type="file" name="image" value="<?php echo $result['image']?>" class="from-control custom-type"> </div> </div> <div class="col-md-4"> <label class="input-text">Status</label> <br> <label class="switch"> <input type="checkbox" class="form-control" name="status[]" id="status" value="1" <?php if($status== 1) { echo "checked"; } ?>/> <div id="status_status"></div> </label> </div> </div> <div class="row"> <div class="col-md-12"> <button type="submit" name="submit" value="add" class="btn btn-submit">Add</button> </div> </div> </form> </div> </div> </div> </section> </div> <!-- /.content-wrapper --> <footer class="main-footer"> <strong>Copyright © <?php echo date("Y");?> <a href="#">Dashboard</a>.</strong> All rights reserved. </footer> </div> <script src="bower_components/jquery-ui/jquery-ui.min.js"></script> <script> $.widget.bridge('uibutton', $.ui.button); </script> <script src="bower_components/bootstrap/dist/js/bootstrap.min.js"></script> <script src="dist/js/adminlte.min.js"></script> <script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.12.0/jquery.validate.min.js" type="text/javascript"></script> <link rel="stylesheet" href="lib/ToggleSwitch.css"/> <script src="lib/ToggleSwitch.js"></script> <script> $(function(){ $("#status").toggleSwitch(); $("#myonoffswitch2").toggleSwitch(); }); </script> </body> </html>