Ultra File Manager

Edit: /home/u523034047/domains/rakeshfilms.in/public_html/admin/add_equipment.php

<?php
include('conn.php');
session_start();

if (!isset($_SESSION['username'])) {
    header('location:index.php');
    exit();
}

$msg = '';

if (isset($_POST['sub'])) {
    $a = trim($_POST['t1']);
    $image = $_FILES['file']['name'];
    $tmp = $_FILES['file']['tmp_name'];
    $size = $_FILES['file']['size'];

$allowedExts = ['jpg', 'jpeg', 'png'];
    $file_ext = strtolower(pathinfo($image, PATHINFO_EXTENSION));
    $mime_type = mime_content_type($tmp);

$allowedMimes = ['image/jpeg', 'image/png', 'image/jpg'];

// File validation
    if (in_array($file_ext, $allowedExts) && in_array($mime_type, $allowedMimes) && $size < 500000) {

if ($_FILES['file']['error'] > 0) {
            $msg = "File Error: " . $_FILES['file']['error'];
        } else {
            // Optional: create a unique filename
            $unique_name = time() . '_' . basename($image);
            $upload_path = 'equipment/' . $unique_name;

if (move_uploaded_file($tmp, $upload_path)) {
                $stmt = $connection->prepare("INSERT INTO tbl_equipment (title, equ_image) VALUES (?, ?)");
                $stmt->bind_param("ss", $a, $unique_name);
                if ($stmt->execute()) {
                    $msg = 'File uploaded successfully.';
                } else {
                    $msg = 'Database error: ' . $connection->error;
                }
                $stmt->close();
            } else {
                $msg = 'Failed to move uploaded file.';
            }
        }
    } else {
        $msg = 'Invalid file type or file too large (max 500KB). Allowed: jpg, jpeg, png.';
    }
}

// Delete logic
if (isset($_POST['del'])) {
    $id = $_POST['id'];
    $stmt = $connection->prepare("DELETE FROM tbl_equipment WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    header('location:add_equipment.php');
    exit();
}
?>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
      <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <title>Admin</title>
    
    <link href="assets/css/bootstrap.css" rel="stylesheet" />
     
    <link href="assets/css/font-awesome.css" rel="stylesheet" />
        
    <link href="assets/css/custom.css" rel="stylesheet" />
     
   <link href='http://fonts.googleapis.com/css?family=Open+Sans' rel='stylesheet' type='text/css' />
</head>
<body>
     
           
          
    <div id="wrapper">
         <div class="navbar navbar-inverse navbar-fixed-top">
           <?php include ('header.php');?>
        </div>
        
        <nav class="navbar-default navbar-side" role="navigation">
           <?php include ('menu.php');?>

</nav>
        
        <div id="page-wrapper" >
            <div id="page-inner">
                <div class="row">
                    <div class="col-md-12">
                     <h2>Add Equipment  </h2>   
                    </div>
                </div>              
                 
                  <hr />
              
                  
                  <div class="panel panel-primary" data-collapsed="0">
            <div class="panel-heading">
                <div class="panel-title" >
                    <i class="entypo-plus-circled"></i>
                   Gallery Entry
                </div>
            </div>
            <form method="post" action="" enctype="multipart/form-data">
            <div class="panel-body"> 
                  <div class="form-group">
                 <label for="field-1" class="col-sm-3 control-label"> Name</label>
                        
                  <div class="col-sm-5">
              <input type="text" class="form-control" name="t1"  data-validate="required" data-message-required="Value Required" value="Equipment" autofocus text="Equipment">
                        </div>
                    </div></br> 
                    <div class="form-group">
                        <label for="field-1" class="col-sm-3 control-label">Image</label>
                        
                        <div class="col-sm-5">
                        <input type="file" name="file" id="file" accept="image/*">
                            </div>
                        </div></br>  <?php if($msg !='') { ?>
                                <div style="width=100%"  class="row cvmsgok"><?php echo $msg; ?></div>
                                <?php } elseif($msgno !='') { ?>
                                <div style="width=100%"  class="row cvmsgno"><?php echo $msgno; ?></div>
                                <?php  } ?>
                      </br></br> 
                   </br> 
                     
                     
                     <div class="form-group" align="center"> 
                        <div class="col-sm-8">
                           <input type="submit" class="btn btn-info" name="sub"  value="Save">
                     <input type="Reset" class="btn btn-danger" name="sub1"  value="Reset">  
                        </div> 
                    </div></br>
                    </form>
                    </div>        
    </div>
    <div class="panel panel-primary" data-collapsed="0">
            <div class="panel-heading">
                <div class="panel-title" >
                    <i class="entypo-plus-circled"></i>
                   Status
                </div>
            </div>
            <div class="panel-body"> 
            
                         <div style="overflow-x:auto;">
                 <div class="col-lg-12 col-md-12">
                        <div class="table-responsive">
                            <table class="table">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th> Image</th>
                                        <th>Name</th>
                                     
                                           <th>Action</th>
                                    </tr>
                                </thead>
                                <?php
                                  $sql="select * from tbl_equipment order by id desc";
                                $query=mysqli_query($connection,$sql);
                                  $count=1;
                                 
                                  while($fetch = mysqli_fetch_array($query)){
                                  
                                ?>
                                <tbody>
                                    <tr class="info">
                                        <td><?php echo $count++;?></td>
                                        <td><img src="equipment/<?php echo $fetch[2]?>"height="50px" width="50px"; ></td>
                                        <td><?php echo $fetch[1];?></td>
                                       
                                         <td><form method='POST'>
                <input type=hidden name=id value="<?php echo $fetch[0];?>" >
                <input type=submit value=Delete class="btn btn-danger" name=del >
                </form></td>
                                    </tr> 
                                </tbody>
                                <?php } ?>
                            </table>
                        </div>
                    </div>
         </div>
                
                   
                    
                     
                    </div>        
    </div>
            </div>
            </div> 
            </div>
         
        </div>
    <div class="footer">
    <?php include ('footer.php');?>
        </div>

<script src="assets/js/jquery-1.10.2.js"></script>
      
    <script src="assets/js/bootstrap.min.js"></script>
      
    <script src="assets/js/custom.js"></script>
    
   
</body>
</html>

Ukuran: 8.3 KB