Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/udan.org.in/public_htmlbkp/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewvideos.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url = basename(__FILE__) . "?" . (isset($_SERVER['QUERY_STRING']) ? $_SERVER['QUERY_STRING'] : '');
$heading = "Video";
$addpage = "addvideo.php";
$listpage = "viewvideos.php";
$table = "videos";
$pkey = "v_id";
$status = "status";
if (isset($_REQUEST['delete']) && $_REQUEST['delete'] == "yes") {
	mysqli_query($con, "delete from `" . $table . "` where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
	$_SESSION['msg'] = "Entry is deleted successfully.";
	header("Location:" . $listpage);
	exit();
}
if (isset($_REQUEST['approve']) && $_REQUEST['approve'] == "yes") {
	$d = date("Y-m-d");
	mysqli_query($con, "update `" . $table . "` set `" . $status . "`='1' where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
	$got = "go" . $_REQUEST['got'];
	$_SESSION['msg'] = $heading . " is approved successfully.";
	header("Location:" . $listpage . "?topic=" . $_REQUEST['topic'] . "#" . $got);
	exit();
}
if (isset($_REQUEST['reject']) && $_REQUEST['reject'] == "yes") {
	mysqli_query($con, "update `" . $table . "` set `" . $status . "`='0' where `" . $pkey . "`='" . $_REQUEST['id'] . "'");
	$got = "go" . $_REQUEST['got'];
	$_SESSION['msg'] = $heading . " is rejected successfully.";
	header("Location:" . $listpage . "?topic=" . $_REQUEST['topic'] . "#" . $got);
	exit();
}
if ($_GET['pg']) {
	$pg = $_GET['pg'];
} else {
	$pg = 1;
}
$upper = 25;
$lower = $upper * ($pg - 1);
$sql = "select * from `" . $table . "` where 1";
if (isset($_REQUEST['name']) && $_REQUEST['name'] != "") {
	$sql .= " and `name` like '%" . $_REQUEST['name'] . "%'";
}
if (!empty($_REQUEST['subject'])) {
	$sql .= " and `subject`='" . intval($_REQUEST['subject']) . "'";
}
$res = mysqli_query($con, $sql);
$num = mysqli_num_rows($res);
$pgno = intval($num / $upper);
if ($num % $upper != 0) {
	$pgno = $pgno + 1;
}
include("includes/headermain.php");
?>
<script language="javascript" type="text/javascript">
	function del(page, id) {
		var fd = confirm("Are you sure to delete this entry?");
		if (fd == true) {
			location.href = page + "?id=" + id + "&delete=yes";
		}
	}

function approve(page, id, got, tpk) {
		location.href = page + "?id=" + id + "&got=" + got + "&approve=yes&topic=" + tpk;
	}

function reject(page, id, got) {
		location.href = page + "?id=" + id + "&got=" + got + "&reject=yes&topic=" + tpk;
	}
</script>
<style>
	#topic,
	#subject {
		height: 45px;
		/* same height */
		line-height: 45px;
	}
</style>

<body>
	
	
	<div id="preloader">
		<div class="loader"></div>
	</div>
	
	
	<div class="page-container">
		
		<?php include("includes/leftmenu.php"); ?>
		
		
		<div class="main-content">
			
			<?php include("includes/header.php"); ?>
			
			<div class="main-content-inner">
				
				<div> 
					<div class="col-lg-12 mt-4">
						<div class="card">
							<div class="card-body">
								<h4 class="header-title">List of <?php print $heading; ?>(s)</h4>
								<form action="#" method="post" class="row">
									<div class="form-group col-md-4">
										
										<input class="form-control" type="text" name="topic" id="topic" value="<?php print $_REQUEST['topic']; ?>" placeholder="By Topic">
									</div>
									<div class="form-group col-md-4">
										<select class="form-control" name="subject" id="subject">
											<option value="">-- Select Subject --</option>
											<?php
											$subres = mysqli_query($con, "SELECT * FROM `subjects` ORDER BY name ASC");

while ($sub = mysqli_fetch_assoc($subres)) { ?>
												<option value="<?php echo $sub['id']; ?>"
													<?php if (isset($_REQUEST['subject']) && $_REQUEST['subject'] == $sub['id']) echo "selected"; ?>>
													<?php echo htmlspecialchars($sub['name']); ?>
												</option>
											<?php } ?>
										</select>
									</div>

<div class="form-group col-md-4">
										<button type="submit" class="btn btn-primary pr-4 pl-4 floatleft">Search</button>
										<button type="button" class="btn btn-primary ml-2 pr-4 pl-4 floatleft"
											onClick="showall('<?php print basename(__FILE__); ?>');">Show All</button>
									</div>
									<div class="cleaner h20"></div>
									<?php if ($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr'];
																							$_SESSION['msgerr'] = ""; ?></span>
										<div class="cleaner h10"></div><?php } ?>
									<?php if ($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg'];
																						$_SESSION['msg'] = ""; ?></span>
										<div class="cleaner h10"></div><?php } ?>
									<table class="table text-center">
										<thead class="text-uppercase bg-primary">
											<tr class="text-white">
												<td align="left">Sl.</td>
												<td align="left">Date</td>
												<td align="left">Class</td>
												<td align="left">Course</td>
												<td align="left">Subject</td>
												<td align="left">Topic</td>
												<td align="left">Youtube Link</td>
												<td align="left">Added By</td>
												<td align="left">Options</td>
											</tr>
										</thead>
										<tbody>
											<?php
											if ($lower == 0) {
												$flag = 0;
											} else {
												$flag = $lower;
											}
											$sql = "select * from `" . $table . "` where 1";
											if (isset($_REQUEST['topic']) && $_REQUEST['topic'] != "") {
												$sql .= " and `topic` like '%" . $_REQUEST['topic'] . "%'";
											}
											if (!empty($_REQUEST['subject'])) {
												$sql .= " and `subject`='" . intval($_REQUEST['subject']) . "'";
											}
											$sql .= " order by `" . $pkey . "` desc limit $lower,$upper";
											//print $sql;
											$res = mysqli_query($con, $sql);
											if (mysqli_num_rows($res) >= 1) {
												while ($row = mysqli_fetch_assoc($res)) {
													$rowc = mysqli_fetch_array(mysqli_query($con, "select * from `categories` where `id`='" . $row['course'] . "'"));
													$rows = mysqli_fetch_array(mysqli_query($con, "select * from `subjects` where `id`='" . $row['subject'] . "'"));
											?>
													<tr <?php if ($row[$status] == "0") { ?>class="bg-red" <?php } ?> id="go<?php print $flag++; ?>">
														<td align="left"><?php print $flag; ?></td>
														<td align="left"><?php print dtconvert($row['date']); ?></td>
														<td align="left"><?php print $row['class']; ?></td>
														<td align="left"><?php print $rowc['name']; ?></td>
														<td align="left"><?php print $rows['name']; ?></td>
														<td align="left"><?php print $row['topic']; ?></td>
														<td align="left"><a href="<?php print $row['mainvideo']; ?>" target="_new"><?php print $row['mainvideo']; ?></a></td>

<td align="left">
															<?php
															// Fetch admin record for created_by ID
															$admin = mysqli_fetch_assoc(mysqli_query($con, "SELECT username, type, ref FROM `admin` WHERE id='" . $row['created_by'] . "'"));

if ($admin['type'] == "user") {
																// If admin type is 'user', fetch name from users table using ref
																$user = mysqli_fetch_assoc(mysqli_query($con, "SELECT name FROM `users` WHERE id='" . $admin['ref'] . "'"));
																echo htmlspecialchars($user['name']);
															} else {
																// Otherwise, just show admin username
																echo htmlspecialchars($admin['username']);
															}
															?>
														</td>

<td align="left">
															<?php if ($_SESSION['logtype'] == "superadmin" || $_SESSION['logtype'] == "user") { ?>
																
																<a href="<?php print $addpage; ?>?eid=<?php print $row[$pkey]; ?>&action=Update&name=<?php print $_REQUEST['name']; ?>&flag=<?php print $flag; ?>">Edit</a>

<?php if ($_SESSION['logtype'] == "superadmin") { ?>
																	
																	<br><a href="#" onClick="del('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>');return false;">Delete</a>
																<?php } ?>

<?php if ($row[$status] == "1") { ?>
																	<br><a href="#" onClick="reject('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['topic']; ?>');return false;">Deactivate</a>
																<?php } else { ?>
																	<br><a href="#" class="redtxt" onClick="approve('<?php print $listpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['topic']; ?>');return false;">Activate</a>
																<?php } ?>
															<?php } ?>
														</td>

</tr>
												<?php }
											} else { ?>
												<tr>
													<td colspan="10">Sorry, nothing found.</td>
												</tr>
											<?php } ?>
										</tbody>
									</table>
									<?php if ($num >= 1) { ?>
										<div class="cleaner h20"></div>
										
										<?php include("includes/pagination.php"); ?>
										
									<?php } ?>
							</div>
						</div>
					</div>
				</div>
				
			</div>
		</div>
		
		<?php include("includes/footer.php"); ?>
	</div>
	
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewvideos.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation