Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.19.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u802471691

Directory:

/home/u802471691/domains/thetechnozone.in/public_html/stock

Free Space:

9.31 TB

🔧 Quick Actions

✏️ Editing: supplier.php

<?php include "header.php";

if($_SESSION['stype']=='2' || $_SESSION['stype']=='1'){

}else{

header("Location:index.php");
}

$action=$_REQUEST['action'];

if($action=='save'){

$s_name=$_POST['s_name'];
			$s_phone=$_POST['s_phone'];
			$s_addr=$_POST['s_addr'];
			$s_gstn=$_POST['s_gstn'];
			$s_email=$_POST['s_email'];

$res=mysqli_query($con,"INSERT INTO  tbl_suppl SET s_name='$s_name',s_phone='$s_phone',s_addr='$s_addr',s_gstn='$s_gstn',s_email='$s_email'");

echo "<script>alert('Data Saved Successfully')</script>";

}elseif($action=='update'){

$s_name=$_POST['s_name'];
				$cid=$_REQUEST['cid'];
				$s_phone=$_POST['s_phone'];
				$s_addr=$_POST['s_addr'];
				$s_gstn=$_POST['s_gstn'];
			  $s_email=$_POST['s_email'];

$res=mysqli_query($con,"UPDATE tbl_suppl SET s_name='$s_name',s_phone='$s_phone',s_addr='$s_addr',s_gstn='$s_gstn',s_email='$s_email' WHERE s_id='$cid'");

}elseif($action=='edit'){

$cid=$_REQUEST['cid'];

$edit=f(q("SELECT * FROM tbl_suppl WHERE s_id='$cid'"));

}elseif($action=='delete'){

$cid=$_REQUEST['cid'];

$edit=mysqli_query($con,"DELETE FROM tbl_suppl WHERE s_id='$cid'");

}

?>
		<link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.11.5/css/jquery.dataTables.min.css">

<h4>Suppliers</h4>
          		<form action="<?php echo $_SERVER['PHP_SELF']?>?action=<?php if($action=='edit'){?>update&cid=<?php echo $cid?><?php }else{?>save<?php } ?>" method="POST">
          		<div class="row">

<div class="input-group input-group-outline my-3">
			                    
			                    <input type="text" class="form-control" required name="s_name" placeholder="Enter Supplier Name" value="<?php echo $edit['s_name']?>">
			               </div>

</div>
          			<div class="col-md-4">

<div class="input-group input-group-outline my-3">
			                    
			                    <input type="text" class="form-control" name="s_phone" placeholder="Enter Phone" value="<?php echo $edit['s_phone']?>">
			               </div>

</div>
          			<div class="col-md-4">

<div class="input-group input-group-outline my-3">
			                    
			                     <input type="text" class="form-control" name="s_addr" placeholder="Enter Address" value="<?php echo $edit['s_addr']?>">
			               </div>

</div>
          			<div class="col-md-4">

<div class="input-group input-group-outline my-3">
			                    
			                     <input type="text" class="form-control" name="s_gstn" placeholder="Enter GSTN" value="<?php echo $edit['s_gstn']?>">
			               </div>

</div>
          			<div class="col-md-4">

<div class="input-group input-group-outline my-3">
			                    
			                     <input type="text" class="form-control" name="s_email" placeholder="Enter Email" value="<?php echo $edit['s_email']?>">
			               </div>

</div>
          			
          			<div class="col-md-3">

</div>

</form>

</div>
        </div>
      </div>
      <div class="row mb-4" style="margin-top: 1%;">
        
        <div class="col-lg-12 col-md-12">
        		<div class="card h-100" style="min-height: 300px;padding: 3%;">
        			<div class="card-body px-0 pb-2">
        				<h4>Supplier List</h4>
              <div class="table-responsive p-0">
                <table class="table align-items-center mb-0" id="myTable">
                  <thead>
                    <tr>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">#SL</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Name</th>
                      <th class="text-uppercase text-secondary text-xxs font-weight-bolder opacity-7 text-center">Phone</th>
                      <th class="text-secondary opacity-7"></th>
                    </tr>
                  </thead>
                  <tbody>
                  		<?php 
                  				$q=mysqli_query($con,"SELECT * FROM tbl_suppl ORDER BY s_name");
                  				while($arr=mysqli_fetch_array($q)){

?>
                  		<tr style="border-bottom: 1px solid gray;">
                  				<td>#<?php echo $arr['s_id']?></td>
                  				<td><?php echo $arr['s_name']?></td>
                  				<td><?php echo $arr['s_phone']?></td>
                  				<td>
                  						<a href="<?php echo $_SERVER['PHP_SELF']?>?action=edit&cid=<?php echo $arr['s_id']?>">Edit</a><br>
                  						<a  onclick="return confirm('Are you sure?')" href="<?php echo $_SERVER['PHP_SELF']?>?action=delete&cid=<?php echo $arr['s_id']?>">Delete</a><br>

</td>
                  		</tr>

<?php } ?>

</tbody>

</table>

</div>
            </div>
          </div>

</div>

</div>
      <script src="https://code.jquery.com/jquery-3.6.0.min.js" integrity="sha256-/xUj+3OJU5yExlq6GSYGSHk7tPXikynS7ogEvDej/m4=" crossorigin="anonymous"></script>
<script type="text/javascript" src="//cdn.datatables.net/1.11.5/js/jquery.dataTables.min.js"></script>
<script type="text/javascript">
	$(document).ready( function () {
    $('#myTable').DataTable();
} );
</script>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: supplier.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation