/ var / www / html / temppayment / pg / [ HOME SHELL ]

Name	Size	Permission	Action
fees	[ DIR ]	drwxr-xr-x
fees-old	[ DIR ]	drwxr-xr-x
ldaplogin	[ DIR ]	drwxr-xr-x
studentsfee	[ DIR ]	drwxr-xr-x
FailedTRAN.php	4.52 KB	-rw-r--r--
ForgetPassword.php	3.09 KB	-rw-r--r--
GetHandleRES.php	11.12 KB	-rw-r--r--
StatusTRAN.php	4.89 KB	-rw-r--r--
donationmail.php	5.71 KB	-rw-r--r--
giveback.php	10.15 KB	-rw-r--r--
index.html	773 B	-rwxrwxrwx
info.php	33 B	-rw-r--r--
libraryfaq.html	16.56 KB	-rw-r--r--
misp.html	14.15 KB	-rw-r--r--
misptest.html	14.15 KB	-rw-r--r--
pay.php	2.46 KB	-rw-r--r--
paybilldesk.php	2.51 KB	-rw-r--r--
payhdfc.php	11.8 KB	-rw-r--r--
payhdfctest.php	8.42 KB	-rw-r--r--
pma.zip	6.17 MB	-rw-r--r--
policyterms.html	6.67 KB	-rw-r--r--
recounsiliation.php	5.52 KB	-rw-r--r--
studentsfee.tar	15.22 MB	-rw-r--r--
test.php	131 B	-rw-r--r--
vendor.php	10.63 KB	-rw-r--r--

Code Editor : recounsiliation.php

<?php include_once "database.php";
if((isset($_POST['from'])) || (isset($_POST['to'])) || (isset($_POST['status'])) ){?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="shortcut icon" href="http://iiitd.ac.in/sites/default/files/images/site/favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome</title>
</head>
<body bgcolor="#f2f5fc">
<form action="#" method="post">
From <input type="date" value="<?php $_POST['from']?>" name="from" />
To <input type="date" value="<?php $_POST['to']?>" name="to" />
<select name="status">
<?php if(isset($_POST['status'])){ echo "<option>".$_POST['status']."</option>"; }?>
<option>-Select Status-</option>
<option>Initiated</option>
<option>Success</option>
<option>CAPTURED</option>
<option>CANCELED</option>
<option>Invalid Authentication at Bank</option>
<option>BillDesk is waiting for Response from Bank</option>
<option>Error at BillDesk</option>
<option>Invalid Input in the Request Message</option>
<option>!ERROR!-PY20014-Invalid User Defined Field.</option>
</select>
<select name="course">
<?php if(isset($_POST['course'])){ echo "<option>".$_POST['course']."</option>"; }?>
<option>-Select Course-</option>
    <option>B.Tech.</option>
    <option>M.Tech.</option>
    <option>Ph.D.</option>
     <option>Winter school only</option>
     <option>Winter school plus Workshop</option>
     <option>Donator</option>
    <option>Other</option>
</select>
<input type="submit" name="submit" value="Search">
</form>
<input type="button" onclick="tableToExcel('datareport', 'IIITD-Report')" value=" Export to Excel " style="float:right;" />
<?php 
//filter for if from to and status
$sql = "Select * from payment where 1=1 ";
if($_POST['from']!='')
{
	$sql .= " and date >='".$_POST['from']."'";
}
if($_POST['to']!='')
{
	$sql .= " and date <='".$_POST['to']."'";
}
if($_POST['status']!='-Select Status-')
{
	$sql .= " and Status like '".$_POST['status']."%'";
}

//echo $sql;
$result = mysql_query($sql,$db_connection);
	?>
<table border="2" cellpadding="3" cellspacing="1" id="datareport"><thead>
<tr>
<td><strong>Id</strong></td>
<td><strong>Name</strong></td>
<td><strong>Course</strong></td>
<td><strong>Enroll no</strong></td>
<td><strong>Roll No</strong></td>
<td><strong>Date & Time</strong></td>
<?php if($_POST['course'] != 'Winter school only' && $_POST['course'] !='Winter school plus Workshop' && $_POST['course'] !='Donator'){ 
echo "<td><strong>Tution</strong></td>
<td><strong>Campus</strong></td>
<td><strong>Hostel</strong></td>
<td><strong>Mess</strong></td>
<td><strong>Caution</strong></td>
<td><strong>Hostel Security</strong></td>
<td><strong>Fine</strong></td>
<td><strong>Other</strong></td>";
 }else{
	 echo "<td><strong>Email</strong></td>
<td><strong>Mobile</strong></td>
<td><strong>Address</strong></td>
";
	 } ?>
<td><strong>Amount</strong></td>
<td><strong>Status</strong></td>
<td><strong>Remark</strong></td>
<td><strong>Print Recipt</strong></td>
</tr></thead><tbody>
<?php while($row = mysql_fetch_array($result)) { ?>

<?php $user = "Select * from user where Email = '".$row['email']."'";
if($_POST['course']!='-Select Course-')
{
	$user.= " and Course like '".$_POST['course']."'";
}
$ur = mysql_query($user,$db_connection);
$userrow=mysql_fetch_array($ur);
if($userrow){
 echo "<tr><td>".$row['id']."</td>"; 
  echo "<td>".$userrow['Name']."</td>";
  echo "<td>".$userrow['Course']."</td>";
  echo "<td>".$userrow['ENo']."</td>";
  echo "<td>".$userrow['RNo']."</td>";
  echo "<td>".$row['date']."</td>";
  if($_POST['course'] != 'Winter school only' && $_POST['course'] !='Winter school plus Workshop' && $_POST['course'] !='Donator'){
  echo "<td>".$row['Tution']."</td>";
  echo "<td>".$row['Campus']."</td>";
  echo "<td>".$row['Hostel']."</td>";
  echo "<td>".$row['Mess']."</td>";
  echo "<td>".$row['Caution']."</td>";
  echo "<td>".$row['Hostelseq']."</td>";
  echo "<td>".$row['Fine']."</td>";
  echo "<td>".$row['Other']."</td>"; }
  else{
	 echo "<td>".$userrow['Email']."</td>
<td>".$userrow['Mobile']."</td>
<td>".$userrow['Adress']."</td>
"; } 
  echo "<td>".$row['Amount']."</td>";
  echo "<td>".$row['Status']."</td>";
  echo "<td>".$row['remark']."</td>";
  echo "<td><a href='Reciept.php?id=".$row['id']."'> Print Recipt </a></td></tr>";
}?>
<?php } ?>
  </tbody></table>
  <script type="application/javascript">
  var tableToExcel = (function() {
      var uri = 'data:application/vnd.ms-excel;base64,'
        , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head></head><body><table>{table}</table></body></html>'
        , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
        , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
   return function(table, name) {
        if (!table.nodeType) table = document.getElementById(table)
        var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
        window.location.href = uri + base64(format(template, ctx))
      }
    })()
    </script>
</body>
</html><?php }else {echo "<h1>UNAUTHORISED ENTRY !! <br /><br />You are not authorised!</h2>";}?>

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.