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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: addquery.php

<?php
ob_start();
session_start();
include("includes/incall.php");
$editid=isset($_REQUEST['editid'])?$_REQUEST['editid']:'';	
$action=isset($_REQUEST['action'])?$_REQUEST['action']:'add';
if(isset($_POST['submfr']) && $_POST['submfr']=="Submit" && $action=="add") {
	$d=date("Y-m-d");
	$t=date("h:i:s A");
	$bdate=isset($_POST['bdate'])?$_POST['bdate']:'';
	$name=isset($_POST['name'])?addslashes(strtoupper(trim($_POST['name']))):'';
	$mobile=isset($_POST['mobile'])?addslashes(strtoupper(trim($_POST['mobile']))):'';
	$email=isset($_POST['email'])?addslashes(strtolower(trim($_POST['email']))):'';
	$address=isset($_POST['address'])?addslashes(strtoupper(trim($_POST['address']))):'';
	$kname=isset($_POST['kname'])?addslashes(strtoupper(trim($_POST['kname']))):'';
	$dob=isset($_POST['dob'])?$_POST['dob']:'';
	$noofprts=isset($_POST['noofprts'])?addslashes(trim($_POST['noofprts'])):'';
	$noofkids=isset($_POST['noofkids'])?addslashes(trim($_POST['noofkids'])):'';
	$notes=isset($_POST['notes'])?addslashes(trim($_POST['notes'])):'';
	$rowin=mysqli_fetch_array(mysqli_query($con,"select * from `admin` where `id`='".$_SESSION['sid']."'"));
	$monthname=strtoupper(date("M"));
	$stra="/".$monthname."/";
	$strb=$rowin['ini']."/".$monthname."/";
	$dt=date("Y-m-")."01";
	$ini="Q/";
	$res=mysqli_query($con,"select * from `bill` where `qrno`!='' and `qrno` like 'Q/%' and `qrno` like '%".$stra."%' and `date`>='".$dt."' order by `id` desc");
	if(mysqli_num_rows($res)<1) {
		$blno=$ini."001";
	} else {
		$row=mysqli_fetch_array($res);
		$varr=explode("/",$row['qrno']);
		$last=$varr[1]+1;
		$len=strlen($last);
		$lenzero=3-$len;
		$blno=$ini;
		for($i=1;$i<=$lenzero;$i++) {
			$blno.="0";
		}
		$blno.=$last;
	}
    $blno.="/".$rowin['ini']."/".$monthname."/".date("d")."/";
	$res=mysqli_query($con,"select * from `bill` where `qrno`!='' and `qrno` like 'Q/%' and `qrno` like '%".$strb."%' and `date`>='".$dt."' order by `id` desc");
	if(mysqli_num_rows($res)<1) {
		$blno.="001";
	} else {
		$row=mysqli_fetch_array($res);
		$varr=explode("/",$row['qrno']);
		$last=$varr[5]+1;
		$len=strlen($last);
		$lenzero=3-$len;
		for($i=1;$i<=$lenzero;$i++) {
			$blno.="0";
		}
		$blno.=$last;
	}
	$blno.="/".date("Y")."/".date("H:i");
	$insert_sql_data=array('date'=>$d,
	'time'=>$t,
	'aby'=>$_SESSION['sid'],
	'staff'=>$_SESSION['uid'],
	'queryno'=>$blno,
	'bdate'=>$bdate,
	'name'=>$name,
	'mobile'=>$mobile,
	'email'=>$email,
	'address'=>$address,
	'kname'=>$kname,
	'dob'=>$dob,
	'noofprts'=>$noofprts,
	'noofkids'=>$noofkids,
	'notes'=>$notes,
	'status'=>'0'
	);
	tep_db_perform("query",$insert_sql_data,"insert");
	$_SESSION['msgsu']="Query is successfully added, thank you.";
	header("location:addquery.php");
	exit();
}
if(isset($_POST['submfr']) && $_POST['submfr']!="" && $action=="edit") {
	$bdate=isset($_POST['bdate'])?$_POST['bdate']:'';
	$name=isset($_POST['name'])?addslashes(strtoupper(trim($_POST['name']))):'';
	$mobile=isset($_POST['mobile'])?addslashes(strtoupper(trim($_POST['mobile']))):'';
	$email=isset($_POST['email'])?addslashes(strtolower(trim($_POST['email']))):'';
	$address=isset($_POST['address'])?addslashes(strtoupper(trim($_POST['address']))):'';
	$kname=isset($_POST['kname'])?addslashes(strtoupper(trim($_POST['kname']))):'';
	$dob=isset($_POST['dob'])?$_POST['dob']:'';
	$noofprts=isset($_POST['noofprts'])?addslashes(trim($_POST['noofprts'])):'';
	$noofkids=isset($_POST['noofkids'])?addslashes(trim($_POST['noofkids'])):'';
	$notes=isset($_POST['notes'])?addslashes(trim($_POST['notes'])):'';
	$insert_sql_data=array('bdate'=>$bdate,
	'name'=>$name,
	'mobile'=>$mobile,
	'email'=>$email,
	'address'=>$address,
	'kname'=>$kname,
	'dob'=>$dob,
	'noofprts'=>$noofprts,
	'noofkids'=>$noofkids,
	'notes'=>$notes
	);
	tep_db_perform("query",$insert_sql_data,'update',"id='".$editid."'");
	$_SESSION['msgsu']="Updation is successful, thank you.";
	header("Location:viewqueries.php");
	exit();
}
if(!isset($_POST['submfr']) && $_POST['submfr']=="" && $action=="edit") {
	$row=mysqli_fetch_array(mysqli_query($con,"select * from `query` where `id`='".$editid."'"));
	$bdate=$row['bdate'];
}
include("includes/headermain.php"); 
?>
<body class="sticky-header left-side-collapsed">
    <section>
		<?php include("includes/leftpanel.php"); ?>
		<div class="main-content">
			<?php include("includes/header.php"); ?>
			<div id="page-wrapper">
				<div class="graphs">
					<div class="col_3">
						<h3 class="blank1">Birthday Query</h3>
						<div class="tabls">
							<div id="uform" class="bs-bg" data-example-id="contextual-table">
								<div class="msgerror"><?php print $_SESSION['msgerror']; $_SESSION['msgerror']=''; ?></div>
								<div class="success"><?php print $_SESSION['msgsu']; $_SESSION['msgsu']=''; ?></div>
								<form name="mform" action="#" method="POST">
								<input type="hidden" name="editid" value="<?php print $editid; ?>">
								<input type="hidden" name="action" value="<?php print $action; ?>">
								<table class="table">
									<tr>
										<td align="right"><span>*</span>Date:</td> 
										<td align="left">
											<?php if($bdate=="") { $bdate=date('Y-m-d'); } ?>
											<input type="date" name="bdate" id="bdate" class="largeinput" maxlength="10" required value="<?php print $bdate; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span>*</span>Contact No.:</td> 
										<td align="left">
											<input type="text" name="mobile" id="mobile" class="largeinput" maxlength="10" required value="<?php print $row['mobile']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span></span>Email-ID:</td> 
										<td align="left">
											<input type="email" name="email" id="email" class="largeinput" value="<?php print $row['email']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span>*</span>Name:</td> 
										<td align="left">
											<input type="text" name="name" id="name" class="largeinput" required value="<?php print $row['name']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right">Address:</td> 
										<td align="left">
											<input type="text" name="address" id="address" class="largeinput" value="<?php print $row['name']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span>*</span>Kid's Name:</td> 
										<td align="left">
											<input type="text" name="kname" id="kname" class="largeinput" required value="<?php print $row['kname']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span>*</span>Party Date:</td> 
										<td align="left">
											<input type="date" name="dob" id="dob" class="largeinput" maxlength="10" required value="<?php print $row['dob']; ?>">
										</td>
									</tr>
									<tr>
									<tr>
										<td align="right"><span></span>No. of Kids:</td> 
										<td align="left">
											<input type="text" name="noofkids" id="noofkids" class="largeinput" value="<?php print $row['noofkids']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span></span>No. of Parents:</td> 
										<td align="left">
											<input type="text" name="noofprts" id="noofprts" class="largeinput" value="<?php print $row['noofprts']; ?>">
										</td>
									</tr>
									<tr>
										<td align="right"><span></span>Notes:</td> 
										<td align="left">
											<textarea name="notes" class="largeinput"><?php print $row['notes']; ?></textarea>
										</td>
									</tr>
									<tr>
										<td align="right" colspan="2">
											<input type="reset" value="Reset" id="res">
											<input type="submit" value="Submit" id="submfr" name="submfr" class="subbut">
										</td>
									</tr>
								</table>
								</form>
							</div>
						</div>		 
						<div class="clearfix"></div>
					</div>
				</div>
			</div>
		</div>
		<?php include("includes/footer.php"); ?>
	</section>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: addquery.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation