Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 5.14.0-570.60.1.el9_6.x86_64

PHP Version:

8.1.34

User:

jivandharaoldage

Directory:

/home/jivandharaoldage/public_html/donation/admin

Free Space:

26.69 GB

🔧 Quick Actions

✏️ Editing: donation_detail_add - Copy (2).php

<?php
error_reporting(0);
session_start();
ob_start();
if(!isset($_SESSION['admin']) || ($_SESSION['admin'] == "") )
{
	?>
	
	<script language="javascript">window.location.href="index.php";</script>
	
	 <?php  
} 
include "config.php";
?>
<!doctype html>
<html class="fixed">

<head>

<meta charset="UTF-8">
<title>Donation Add</title>
<meta name="keywords"  />
<meta name="donator_email">
<meta name="author">

<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />

<link rel="shortcut icon" href="img/favicon.ico" type="image/x-icon" />
<link href="https://fonts.googleapis.com/css?family=Open+Sans:300,400,600,700,800|Shadows+Into+Light" rel="stylesheet" type="text/css">

<link rel="stylesheet" href="vendor/bootstrap/css/bootstrap.css" />
<link rel="stylesheet" href="vendor/animate/animate.css">
<link rel="stylesheet" href="vendor/font-awesome/css/fontawesome-all.min.css" />
<link rel="stylesheet" href="vendor/magnific-popup/magnific-popup.css" />

<link rel="stylesheet" href="css/theme.css" />

<link rel="stylesheet" href="css/custom.css">

if(isset($_REQUEST['submit'])) 
{
	$dr_id=$_REQUEST['dr_id']; 
	$ure11133=mysqli_query($conn,"select * from  tbl_donation_requirment where dr_id='$dr_id'"); 
	$row11133=mysqli_fetch_array($ure11133); 
	$requirment_title = $row11133['requirment_title']; 
	$total_amount = $row11133['total_amount']; 
	
	$donation_id=$_REQUEST['donation_id']; 
	$ure11134=mysqli_query($conn,"select * from  tbl_group_name where donation_id='$donation_id'"); 
	$row11134=mysqli_fetch_array($ure11134); 
	$group_name = $row11134['group_name']; 
	
	$donator_name=$_REQUEST['donator_name'];	
	$donator_address=$_REQUEST['donator_address'];	
	$donator_mobile=$_REQUEST['donator_mobile'];	
	$donator_email=$_REQUEST['donator_email'];	
	$donator_amount=$_REQUEST['donator_amount'];	
	$voucher_no=$_REQUEST['voucher_no'];	
	$payment_type=$_REQUEST['payment_type'];
	
	
		
	
	$remaining_amount = $total_amount - $donator_amount;
	
	if($donator_amount > $total_amount)
	{
		echo "<script type='text/javascript'>alert('Donate Amount Is More Then The Total Amount')</script>";
		echo "<script>window.location.href='donation_detail_add.php';</script>";
		
	} else{	 
	
	
		 if($remaining_amount == '0'){
		
			
				 $sql=mysqli_query($conn,"INSERT INTO tbl_donation_detail(dr_id,requirment_title,total_amount,donation_id,group_name,donator_name,donator_mobile,donator_email,donator_address,donator_amount,remaining_amount,donation_status,status) VALUES ('$dr_id','$requirment_title','$total_amount','$donation_id','$group_name','$donator_name','$donator_mobile','$donator_email','$donator_address','$donator_amount','$remaining_amount','Paid','1')");	
				 $lastdonation_id= mysql_insert_id();
				$_SESSION['lastdonation_id']=$lastdonation_id;

mysqli_query($conn,"INSERT INTO tbl_donation_received(donation_id,donation_id,group_name,donator_name,donator_mobile,donator_amount,voucher_no,payment_date,total_amount,remaining_amount,donation_status,payment_type)	VALUES  ('$lastdonation_id','$donation_id','$group_name','$donator_name','$donator_mobile','$donator_amount','$voucher_no',Now(),'$total_amount','$remaining_amount','Paid','$payment_type')") 
	or die(mysql_error);
			
			} else {
			
			 $sql=mysqli_query($conn,"INSERT INTO tbl_donation_detail(dr_id,requirment_title,total_amount,donation_id,group_name,donator_name,donator_mobile,donator_email,donator_address,donator_amount,remaining_amount,donation_status,status) VALUES ('$dr_id','$requirment_title','$total_amount','$donation_id','$group_name','$donator_name','$donator_mobile','$donator_email','$donator_address','$donator_amount','$remaining_amount','Pending','1')");
			  $lastdonation_id= mysql_insert_id();
				$_SESSION['lastdonation_id']=$lastdonation_id; 	
			 
			 mysqli_query($conn,"INSERT INTO tbl_donation_received(donation_id,donation_id,group_name,donator_name,donator_mobile,donator_amount,voucher_no,payment_date,total_amount,remaining_amount,donation_status,payment_type) 	VALUES ('$lastdonation_id','$donation_id','$group_name','$donator_name','$addonator_mobiledress','$donator_amount','$voucher_no',Now(),'$total_amount','$remaining_amount','Pending','$payment_type')") 	or die(mysql_error);
	
			
			}
		
			
	}
	
				
				?>
	
	<script language="javascript">window.location.href="donation_detail_list.php";</script>
	
	 <?php  
} 
?>

<?php

$donationid = $_GET['donationid'];
						
						
 if(isset($_REQUEST['update'])) 
  {
  	$dr_id=$_REQUEST['dr_id']; 
	$ure11133=mysqli_query($conn,"select * from  tbl_donation_requirment where dr_id='$dr_id'"); 
	$row11133=mysqli_fetch_array($ure11133); 
	$requirment_title = $row11133['requirment_title']; 
	$total_amount = $row11133['total_amount']; 
	
	$donation_id=$_REQUEST['donation_id']; 
	$ure11134=mysqli_query($conn,"select * from  tbl_group_name where donation_id='$donation_id'"); 
	$row11134=mysqli_fetch_array($ure11134); 
	$group_name = $row11134['group_name']; 
	
	$donator_name=$_REQUEST['donator_name'];	
	$donator_address=$_REQUEST['donator_address'];	
	$donator_mobile=$_REQUEST['donator_mobile'];	
	$donator_email=$_REQUEST['donator_email'];	
	$donator_amount=$_REQUEST['donator_amount'];	
	
	
	$uupQry="UPDATE tbl_donation_detail1 SET dr_id='$dr_id',requirment_title='$requirment_title',total_amount='$total_amount',donation_id='$donation_id',group_name='$group_name', donator_name='$donator_name',donator_mobile='$donator_mobile',donator_email='$donator_email',donator_address='$donator_address',donator_amount='$donator_amount' WHERE donation_id='$donationid'";
	$uuresult=mysqli_query($conn,$uupQry);
	
	
	?>
      <script>  alert("Update"); </script>
      <script language="javascript">window.location.href="donation_detail_list.php";</script>
      
      <?PHP
  
  }
  
   ?>
      <div class="row">
        <div class="col">
          <section class="card">
		  <div class="row">
									<div class="col-sm-6">
										<div class="mb-3">
											<a href="donation_detail_list.php"><button id="addToTable" class="btn btn-primary"><i class="fas fa-list"></i>Donation Detail List </button></a>
										</div>
									</div>
								</div>
             <?php 
					$ure=mysqli_query($conn,"select * from  tbl_donation_detail1 WHERE donation_id='$donationid'");
					$urow=mysqli_fetch_array($ure); ?>
            <div class="card-body">
              <form class="form-horizontal form-bordered" method="post">
			  <?php
 			 						   					   $sql311="SELECT voucher_no FROM  tbl_donation_received  ORDER BY pay_id DESC  "; 
						        	   						$exe311=mysqli_query($conn,$sql311);
			    					  						 $rowitem1311=mysql_fetch_assoc($exe311);
			                         						  $voucher_no1=$rowitem1311['voucher_no'];
				                       							$voucher_no12 = $voucher_no1 + 1 ; ?>
															  <input type="hidden" name="voucher_no" value="<?php echo $voucher_no12; ?>">
                <div class="row form-group">
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Donation Requirment Title</label>
												<select class="form-control" name="dr_id" required onChange="getBoard(this.value)">
															<option value="">Select Group</option>
															 <?php $ure1=mysqli_query($conn,"select * from tbl_donation_requirment where status = '1'");
													while($urow1=mysqli_fetch_array($ure1)) {?>
                                                      <option value="<?php echo $urow1['dr_id']; ?>"<?php if($urow['dr_id'] == $urow1['dr_id']) echo 'selected="selected"' ?>><?php echo $urow1['requirment_title']; ?></option>
                               						 <?php }?>
															
													</select>
											</div>
										</div>
										<?php if($donationid) { ?>
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Total Donation Amount</label>
												<div id="streamid">
												<input type="text" class="form-control" name="total_amount" maxlength="30" value="<?php echo $urow1['requirment_title']; ?>" readonly>
												</div>
											</div>
										</div>
										<?php } else { ?>
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Total Donation Amount</label>
												<div id="streamid">
												<input type="text" class="form-control" name="total_amount" maxlength="30" value="" readonly>
												</div>
											</div>
										</div>
										
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Group Category</label>
												<select class="form-control" name="donation_id" required >
															<option value="">Select Group</option>
															 <?php $ure1=mysqli_query($conn,"select * from  tbl_group_name where status = '1'");
													while($urow1=mysqli_fetch_array($ure1)) {?>
                                                      <option value="<?php echo $urow1['donation_id']; ?>"<?php if($urow['donation_id'] == $urow1['donation_id']) echo 'selected="selected"' ?>><?php echo $urow1['group_name']; ?></option>
                               						 <?php }?>
															
													</select>
											</div>
										</div>
										
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Name of Donor</label>
												<input type="text" class="form-control" required name="donator_name" maxlength="30" value="<?php echo $urow['donator_name']; ?>" >
											</div>
										</div>
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Mobile</label>
												<input type="text" class="form-control" required name="donator_mobile" maxlength="15" value="<?php echo $urow['donator_mobile']; ?>" >
											</div>
										</div>
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Email</label>
												<input type="text" class="form-control" name="donator_email" value="<?php echo $urow['donator_email']; ?>" maxlength="50">
											</div>
										</div>
										
										<div class="col-lg-12">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Address</label>
												<textarea class="form-control" required maxlength="200" name="donator_address"><?php echo $urow['donator_address']; ?></textarea>
											</div>
										</div>
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Donate Amount</label>
												<input type="text" class="form-control" required name="donator_amount" value="<?php echo $urow['donator_amount']; ?>" >
											</div>
										</div>
										<div class="col-lg-6">
											<div class="form-group">
												<label class="col-form-label" for="formGroupExampleInput">Payment Type</label>
												<select class="form-control" name="payment_type" required >
															<option value="">Select Type</option>
															 <option value="Cash">Cash</option>
                               									<option value="Cheque">Cheque</option>
															
													</select>
											</div>
										</div>
									
									</div>
									<br>
										<footer class="card-footer text-right">
										<?php if($donationid){ ?>
										<button class="btn btn-primary" name="update">Update Donation Detail</button>
										<?php } else { ?>
										<button class="btn btn-primary" name="submit">Add Donation Detail</button>
										<button type="reset" class="btn btn-default">Reset</button>
										<?php } ?>
									</footer>
									
              </form>
            </div>
          </section>
        </div>
      </div>
     
    </section>
  </div>
  
</section>

<script src="vendor/jquery/jquery.js"></script>
<script src="vendor/jquery-browser-mobile/jquery.browser.mobile.js"></script>
<script src="vendor/jquery-cookie/jquery-cookie.js"></script>

<script src="vendor/jquery-ui/jquery-ui.js"></script>
<script src="vendor/select2/js/select2.js"></script>

<script src="js/theme.js"></script>

<script src="js/custom.js"></script>

<script src="js/theme.init.js"></script>

</body>

</html>
<script language="javascript" type="text/javascript">
function getXMLHTTP() { //fuction to return the xml http object
		var xmlhttp=false;	
		try{
			xmlhttp=new XMLHttpRequest();
		}
		catch(e)	{		
			try{			
				xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
			}
			catch(e){
				try{
				xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
				}
				catch(e1){
					xmlhttp=false;
				}
			}
		}
		 	
		return xmlhttp;
    }
	
		function getBoard(countryId) {		
		var strURL="find_amount.php?streamid="+countryId;
		var req = getXMLHTTP();
		if (req) {
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('streamid').innerHTML=req.responseText;						
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
	
	function getState(countryId,stateId) {		
		
		var strURL="find_property_detail.php?streamid="+countryId+"&sid="+stateId;
		var req = getXMLHTTP();
		
		if (req) {
			
			req.onreadystatechange = function() {
				if (req.readyState == 4) {
					// only if "OK"
					if (req.status == 200) {						
						document.getElementById('sid').innerHTML=req.responseText;
												
					} else {
						alert("There was a problem while using XMLHTTP:\n" + req.statusText);
					}
				}				
			}			
			req.open("GET", strURL, true);
			req.send(null);
		}		
	}
	
	
	
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: donation_detail_add - Copy (2).php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation