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/srcp.in/public_html/system

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: fetchstudent.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$table="bookissue";
$status="status";
$pkey="id";
if($_REQUEST['stype']=="student") {
	$addpage="bookissuest.php";
	$resa=mysqli_query($con,"select * from `students` where `ucode`='".$_REQUEST['stid']."' and `status`='1'");
	if(mysqli_num_rows($resa)>=1) {
		$rowm=mysqli_fetch_object($resa);
		print "Name: ".$rowm->name;
?>
		<table class="table text-center">
			<thead class="text-uppercase bg-primary">
				<tr class="text-white">
					<td align="left">Sl.</td>
					<td align="left">Issue</td>
					<td align="left">Return</td>
					<td align="left">Book ID</td>
					<td align="left">Name</td>
					<td align="left">Course</td>
					<td align="left">Subject</td>
					<td align="left">Semester/Yr</td>
					<td align="left">Writer</td>
					<td align="left">Version</td>
					<td align="left">Option</td>
				</tr>
			</thead>
			<tbody>
				<?php
				if($lower==0) {
					$flag=0;
				} else {
					$flag=$lower;
				}
				$sql="select * from `".$table."` where `stid`='".$rowm->id."' and `retdate`='0000-00-00' and `".$status."`='1'";
				$sql.=" order by `".$pkey."` desc";
				$res=mysqli_query($con,$sql);
				if(mysqli_num_rows($res)>=1) {
					while($row=mysqli_fetch_assoc($res)) {
						$rowb=mysqli_fetch_assoc(mysqli_query($con,"select * from `books` where `id`='".$row['bkid']."'"));
						$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `courses` where `id`='".$rowb['course']."'"));
						$rowt=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `bcategory` where `id`='".$rowb['bcategory']."'"));
						$rows=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `semesters` where `id`='".$rowb['semester']."'"));
				?>
						<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['issuedate']); ?></td>
							<td align="left"><?php if($row['retdate']!="0000-00-00") { print dtconvert($row['retdate']); } ?></td>
							<td align="left"><?php print $row['bookid']; ?></td>
							<td align="left"><?php print $rowb['name']; ?></td>
							<td align="left"><?php print $rowc['name']; ?></td>
							<td align="left"><?php print $rowt['name']; ?></td>
							<td align="left"><?php print $rows['name']; ?></td>
							<td align="left"><?php print $rowb['writer']; ?></td>
							<td align="left"><?php print $rowb['version']; ?></td>
							<td align="left">
								<?php if($_SESSION['showmode']!="Yes") { ?>
									<?php if($row[$status]=="1") { ?>
										<a href="#" onClick="reject('<?php print $addpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['stid']; ?>');return false;">Delete</a>
									<?php } ?>	
								<?php } ?>	
							</td>
						</tr>
				<?php }  } else { ?>
					<tr>
						<td colspan="15">Sorry, nothing found.</td>
					</tr>
				<?php } ?>	
			</tbody>
		</table>
<?php	
	} 
} elseif($_REQUEST['stype']=="staff") {
	$addpage="bookissuesf.php";
	$resa=mysqli_query($con,"select * from `staffs` where `ucode`='".$_REQUEST['stid']."' and `status`='1'");
	if(mysqli_num_rows($resa)>=1) {
		$rowm=mysqli_fetch_object($resa);
		print "Name: ".$rowm->name;
?>
		<table class="table text-center">
			<thead class="text-uppercase bg-primary">
				<tr class="text-white">
					<td align="left">Sl.</td>
					<td align="left">Issue</td>
					<td align="left">Return</td>
					<td align="left">Book ID</td>
					<td align="left">Name</td>
					<td align="left">Course</td>
					<td align="left">Subject</td>
					<td align="left">Semester/Yr</td>
					<td align="left">Writer</td>
					<td align="left">Version</td>
					<td align="left">Option</td>
				</tr>
			</thead>
			<tbody>
				<?php
				if($lower==0) {
					$flag=0;
				} else {
					$flag=$lower;
				}
				$sql="select * from `".$table."` where `stid`='".$rowm->id."' and `retdate`='0000-00-00' and `".$status."`='1'";
				$sql.=" order by `".$pkey."` desc";
				$res=mysqli_query($con,$sql);
				if(mysqli_num_rows($res)>=1) {
					while($row=mysqli_fetch_assoc($res)) {
						$rowb=mysqli_fetch_assoc(mysqli_query($con,"select * from `books` where `id`='".$row['bkid']."'"));
						$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `courses` where `id`='".$rowb['course']."'"));
						$rowt=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `bcategory` where `id`='".$rowb['bcategory']."'"));
						$rows=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `semesters` where `id`='".$rowb['semester']."'"));
				?>
						<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['issuedate']); ?></td>
							<td align="left"><?php if($row['retdate']!="0000-00-00") { print dtconvert($row['retdate']); } ?></td>
							<td align="left"><?php print $row['bookid']; ?></td>
							<td align="left"><?php print $rowb['name']; ?></td>
							<td align="left"><?php print $rowc['name']; ?></td>
							<td align="left"><?php print $rowt['name']; ?></td>
							<td align="left"><?php print $rows['name']; ?></td>
							<td align="left"><?php print $rowb['writer']; ?></td>
							<td align="left"><?php print $rowb['version']; ?></td>
							<td align="left">
								<?php if($_SESSION['showmode']!="Yes") { ?>
									<?php if($row[$status]=="1") { ?>
										<a href="#" onClick="reject('<?php print $addpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['stid']; ?>');return false;">Delete</a>
									<?php } ?>	
								<?php } ?>	
							</td>
						</tr>
				<?php }  } else { ?>
					<tr>
						<td colspan="15">Sorry, nothing found.</td>
					</tr>
				<?php } ?>	
			</tbody>
		</table>
<?php	
 	}
} else { 
	$addpage="bookissuetr.php";
	$resa=mysqli_query($con,"select * from `managements` where `ucode`='".$_REQUEST['stid']."' and `status`='1'");
	if(mysqli_num_rows($resa)>=1) {
		$rowm=mysqli_fetch_object($resa);
		print "Name: ".$rowm->name;
?>
		<table class="table text-center">
			<thead class="text-uppercase bg-primary">
				<tr class="text-white">
					<td align="left">Sl.</td>
					<td align="left">Issue</td>
					<td align="left">Return</td>
					<td align="left">Book ID</td>
					<td align="left">Name</td>
					<td align="left">Course</td>
					<td align="left">Subject</td>
					<td align="left">Semester/Yr</td>
					<td align="left">Writer</td>
					<td align="left">Version</td>
					<td align="left">Option</td>
				</tr>
			</thead>
			<tbody>
				<?php
				if($lower==0) {
					$flag=0;
				} else {
					$flag=$lower;
				}
				$sql="select * from `".$table."` where `stid`='".$rowm->id."' and `retdate`='0000-00-00' and `".$status."`='1'";
				$sql.=" order by `".$pkey."` desc";
				$res=mysqli_query($con,$sql);
				if(mysqli_num_rows($res)>=1) {
					while($row=mysqli_fetch_assoc($res)) {
						$rowb=mysqli_fetch_assoc(mysqli_query($con,"select * from `books` where `id`='".$row['bkid']."'"));
						$rowc=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `courses` where `id`='".$rowb['course']."'"));
						$rowt=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `bcategory` where `id`='".$rowb['bcategory']."'"));
						$rows=mysqli_fetch_assoc(mysqli_query($con,"select `name` from `semesters` where `id`='".$rowb['semester']."'"));
				?>
						<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['issuedate']); ?></td>
							<td align="left"><?php if($row['retdate']!="0000-00-00") { print dtconvert($row['retdate']); } ?></td>
							<td align="left"><?php print $row['bookid']; ?></td>
							<td align="left"><?php print $rowb['name']; ?></td>
							<td align="left"><?php print $rowc['name']; ?></td>
							<td align="left"><?php print $rowt['name']; ?></td>
							<td align="left"><?php print $rows['name']; ?></td>
							<td align="left"><?php print $rowb['writer']; ?></td>
							<td align="left"><?php print $rowb['version']; ?></td>
							<td align="left">
								<?php if($_SESSION['showmode']!="Yes") { ?>
									<?php if($row[$status]=="1") { ?>
										<a href="#" onClick="reject('<?php print $addpage; ?>','<?php print $row[$pkey]; ?>','<?php print $flag; ?>','<?php print $_REQUEST['stid']; ?>');return false;">Delete</a>
									<?php } ?>	
								<?php } ?>	
							</td>
						</tr>
				<?php }  } else { ?>
					<tr>
						<td colspan="15">Sorry, nothing found.</td>
					</tr>
				<?php } ?>	
			</tbody>
		</table>
<?php	
	}
}
if(mysqli_num_rows($resa)<1) {
	print "Sorry, nothing found.";
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: fetchstudent.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation