Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.34.1.lve.el8.x86_64

PHP Version:

8.1.34

User:

u823300664

Directory:

/home/u823300664/domains/allspikes.in/public_html/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: managestock.php

<?php require'header.php';
 
    if(isset($_GET['stc']))
    {
        $stcid = base64_decode($_GET['stc']);
        $stk = mysqli_query($conn,"SELECT * FROM product WHERE id = '$stcid' ");
        $fetchstk = mysqli_fetch_array($stk);
    }
    
    if(isset($_POST['submit'])){
        $newsize = $_POST['size'];
        $newstock = $_POST['stock'];
        
        $newst = implode(',',$newstock);
        $newsz = implode(',',$newsize);
         
        $update = mysqli_query($conn,"UPDATE product SET size = '$newsz', stock = '$newst' WHERE id = '$stcid' ");
        if($update)
        {
             $msg = '<div class="alert alert-primary alert-dismissible fade show" role="alert">
                    Stock Updated for '.$fetchstk['name'].'
                    </div>';
             echo "<script>setTimeout(function(){ window.location = 'products.php'; },1000);</script>";
        }
        else
        {
            $msg = '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                        Error!! Please try again...
                     </div>';
             echo "<script>setTimeout(function(){ window.location = 'products.php'; },2000);</script>";
        }
    }
    
?>
<main role="main" class="main-content">
        <div class="container-fluid">
          <div class="row justify-content-center">
            <div class="col-12">
              <h2 class="page-title">Manage Stock</h2>
              
              <div class="row">
        
                <div class="col-md-12">
                  <div class="card shadow mb-4">
                    <div class="card-header">
                      <strong class="card-title" style="font-size:22px"><?php echo $fetchstk['name']; ?></strong>
                        <a href="products.php" class="btn btn-primary float-right ml-3" type="button"><i class="fe fe-arrow-left "></i>Product List</a>
                    </div>
                    <div class="card-body">
                      <form class="needs-validation" method="POST" enctype="multipart/form-data" novalidate>
                        <?php if(isset($msg)){ echo $msg; } ?> 
                        <div class="form-row"></div>
                          <div class="form-row">
                                <div class="col-md-8">
                                    <table class="table table-bordered text-center">
                                        <thead id="thead">
                                            <tr class="text-center">
                                                <td><h4>Size</h4></td>
                                                <td><h4>Stock</h4></td>
                                                <td><button class="btn btn-md btn-primary" id="addBtn" type="button">Add new Row</button></td>
                                            </tr>
                                            <?php 
                                            $stock = $fetchstk['stock'];
                                            $exst = explode(',',$stock);
                                            $size = $fetchstk['size'];
                                            $exsz = explode(',',$size);
                                            $i=1;
                                            foreach($exsz as $key => $sz)
                                            { 
                                            ?>
                                          <tr id="R<?php echo $i++; ?>">
                                            <td><input type="text" class="form-control" id="validationCustom01"
                                            name="size[]" placeholder="Size" value="<?php echo $sz; ?>" required></td>
                                             
                                             <td><input type="text" class="form-control" id="validationCustom01"
                                            name="stock[]" placeholder="Stock" value="<?php echo $exst[$key]; ?>" required></td>
                                            <td class="text-center">
                                                <button class="btn btn-danger remove" type="button" style="float:left !important;">Remove</button>
                                            </td>
                                          </tr>
                                           <?php  }?>
                                          
                                        </thead>
                                        <tbody id="tbody">
                                        </tbody>
                                      </table>
                                 </div>
                                 <div class="col-md-4">
                                    <?php 
                                        $image = explode(",",$fetchstk['image']);
                                        foreach($image as $img)
                                        { ?>
                                    <img src="image/<?php echo $img; ?>" width="150px">
                                    <?php } ?>
                                </div>
                             
                            </div>
              
                                    
                        <button class="btn btn-primary" name="submit" type="submit">Update Stock</button>
                      </form>
                    </div> 
                  </div> 
                </div> 
              </div> 
            </div> 
          </div> 
        </div> 
 
      </main>
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" type="text/javascript"></script>
       <script>
            $(document).ready(function () {
          
              // Denotes total number of rows
              var rowIdx = 0;
          
              // jQuery button click event to add a row
              $('#addBtn').on('click', function () {
          
                // Adding a row inside the tbody.
                $('#tbody').append(`<tr id="R${++rowIdx}">
                     <td><input type="text" class="form-control" id="validationCustom01"
                       name="size[]"  placeholder="Size"></td>
                     <td><input type="text" class="form-control" id="validationCustom01"
                                            name="stock[]" placeholder="Stock" required></td>
                 
                      <td class="text-center">
                        <button class="btn btn-danger remove"
                          type="button" style="float:left !important;">Remove</button>
                        </td>
                      </tr>`);
              });
              
            // jQuery button click event to remove a row.
              $('#thead').on('click', '.remove', function () {
         
                // Getting all the rows next to the row
                // containing the clicked button
                var child = $(this).closest('tr').nextAll();
          
                // Iterating across all the rows 
                // obtained to change the index
                child.each(function () {
          
                  // Getting <tr> id.
                  var id = $(this).attr('id');
          
                  // Getting the <p> inside the .row-index class.
                  var idx = $(this).children('.row-index').children('p');
          
                  // Gets the row number from <tr> id.
                  var dig = parseInt(id.substring(1));
          
                  // Modifying row index.
                  idx.html(`Row ${dig - 1}`);
          
                  // Modifying row id.
                  $(this).attr('id', `R${dig - 1}`);
                });
          
                // Removing the current row.
                $(this).closest('tr').remove();
          
                // Decreasing total number of rows by 1.
                rowIdx--;
              });
            });
          </script>
      <?php require'footer.php'; ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: managestock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation