Server : Apache System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64 User : apache ( 48) PHP Version : 8.0.28 Disable Function : NONE Directory :  /var/www/html/mmishra/indem/webbioexam/biomedical/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php
include "header.inc";
$tbl = 'tbl_registration';

$id = $_REQUEST["id"];
$no = $_POST["no"];

if ($_POST["submit"] == "OK") {
        //mysql_query("update $tbl set no=$no,status='Paid' where id=$id");
        $ps = mysql_query("update $tbl set no=$no,status='Paid', paidon=now() where id=$id");
	if (!$ps) {
	 	echo "<center><font color='red'><b>".mysql_error()."</b></font></center>";
	}
}

echo "
<table>
<tr><td>Type Application ID</td><td width=80%> <input type='text' name='id' size='20' maxlength='5' value='$id'>
<input type='submit' name='submit' value='FIND'></td></tr>
</table>
";


$rs = mysql_query("select * from $tbl where id='$id'");
echo "<table border='1' width='100%'><ttitle><b>Existing Application</b></ttitle>
<tr><th>Application ID</th><th>Applicant</th><th>Photo</th><th>DD/Receipt No.</th><th>XII Details</th><th>X Details</th><th>Action</th></tr>";
if (mysql_num_rows($rs)) {
        while ($o = mysql_fetch_object($rs)) {
		echo "<tr>
		<td><a href='find-mark-edit.php?id=$o->id'>$o->id</a></td>
		<td>$o->fullname</br>DOB: $o->dob<br>S/o. $o->fathername<br>$o->address</td>
		<td><img src='photos/$o->id.jpg' width='75' height='75'></td>
		<td>$o->txnnumber<br>$o->bankbranch<br>DOD: $o->depositdate</td>
		<td>$o->discipline12<br>$o->board12<br>$o->year12<br>$o->percentage12<br>$o->appearing12</td>
		<td>$o->discipline10<br>$o->board10<br>$o->year10<br>$o->percentage10<br>$o->appearing10</td>
		<th><input type='text' name='no' value='$o->no' size='5' maxlength='5'>
		<input type='submit' name='submit' value='OK'></th> 	
		</tr>";
	}
} else 
	echo "<tr><th colspan='5'>Record not found</th></tr>";
echo "</table>"; 	

$rs = mysql_query("select * from $tbl where status='Paid' and flag!=1");
echo "<b>Total processed: ".mysql_num_rows($rs)."</b><br><br>"; 

$total = 0;
$rs = mysql_query("select category,count(id) no from $tbl where flag='' group by category");
while ($o = mysql_fetch_object($rs)) {
        echo "[ $o->category: $o->no ] ";
	$total = $total + $o->no;
}
echo "Total: $total<br><br>";
$total = 0;
$rs = mysql_query("select gender,count(id) no from $tbl where flag='' group by gender");
while ($o = mysql_fetch_object($rs)) {
        echo "[ $o->gender: $o->no ] ";
	$total = $total + $o->no;
}
echo "Total: $total<br><br>";

include "footer.inc";
?>