Gecko [ nrupathungauniversityblr.ac.in ]

Name	Size	Permission	Action
mcverifydet.php	5.18 KB	-rwxr-xr-x
varification.php	218 B	-rwxr-xr-x

Code Editor : mcverifydet.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
 <link rel="stylesheet" type="text/css" href="../css/basic.css" /> 

<script type="text/javascript" src="../js/jquery-1.8.3.js"></script>
<script type="text/javascript" src="../js/jquery.corner.js"></script>
<script type="text/javascript" src="../js/jscript.js"></script>
<script type="text/javascript" src="../js/curve-min.js"></script>
<link rel="stylesheet" href="../jquery-ui-1.9/themes/base/jquery.ui.all.css">
<link rel="shortcut icon" type="image/jpg" href="../img/favicon.jpg" />

<?php

$v1 = $_GET['v1'];
$v2 = $_GET['v2'];
$v3 = $_GET['v3'];
$v3 = substr($v3, 0, -1); 
$servername = "72.167.46.92";
$username = "nehuuser";
$password = "nehu159";
$dbname = "resultsg_nehu";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$get_data="select FUNIVCODE,FUNIVNAME,FUNIVADD1,pdf_logo_path
			from control";
	$result=$conn->query($get_data); 
if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
       $FUNIVCODE=$row['FUNIVCODE'];
	$FUNIVNAME=$row['FUNIVNAME'];
	$FUNIVADD1=$row['FUNIVADD1'];
	$pdf_logo_path=$row['pdf_logo_path'];
    }
}	
	
	$query="select degree.FDESCPN, degree.FEXAMNAME, degree.FEXAMDATE, mcverify.FREGNO, mcverify.FNAME, mcverify.FTOTMARKS, 
	mcverify.FRESULT, mcverify.FMCNUMBER, mcverify.FENROLL, mcverify.FEXAMDATE from mcverify,degree
	where degree.FDEGREE = mcverify.FDEGREE and degree.FEXAMNO = mcverify.FEXAMNO
	and mcverify.FREGNO='{$v1}' and mcverify.FEXAMNO='{$v2}' and mcverify.FYEAR='{$v3}'";
	$rst=$conn->query($query); 
	
	if (mysqli_num_rows($rst) > 0) {
		// output data of each row
		while($row = mysqli_fetch_assoc($rst)) {
		$FDESCPN=$row['FDESCPN'];
		$FEXAMNAME=$row['FEXAMNAME'];
		$FEXAMDATE=$row['FEXAMDATE'];
		$FREGNO=$row['FREGNO'];
		$FNAME=$row['FNAME'];
		$FTOTMARKS=$row['FTOTMARKS'];
		$FRESULT=$row['FRESULT'];
		$FMCNUMBER=$row['FMCNUMBER'];
		$FENROLL=$row['FENROLL'];
		$FDESCPN=$row['FDESCPN'];
		}
	}

<div id='main_frame'>
	<div class='header_main_div'>
			<div class='header_left_div' >
		<div class='header_log_left_div'><img height=103 width=120 src="../<?php echo $pdf_logo_path?>"></div>
		</div>
		<div class='header_right_div'>
		<div class='header_right_txt_div'>
		<?php echo $FUNIVNAME?><br>
		<span  id='span_address'><?php echo $FUNIVADD1?><br></span>  
		</div>
		<div class='header_right_txt_div' style='margin-top:-15px;'>Marks Card Verification</div>
		</div> 
		<div style='clear:both;'>
		<div id='main_page_div' >	
		  <div id="index_main_page" style='margin-top:40px;margin-left:40px;font-size:18px;align:center;'>
			<div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Degree :</span>
				<span><?php echo $FDESCPN; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Semester :</span>
				<span><?php echo $FEXAMNAME; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Examination :</span>
				<span><?php echo $FEXAMDATE; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Roll No. :</span>
				<span><?php echo $FENROLL; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Registration No. :</span>
				<span><?php echo $FREGNO; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Name :</span>
				<span><?php echo $FNAME; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Total Marks :</span>
				<span><?php echo $FTOTMARKS; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>Result :</span>
				<span><?php echo $FRESULT; ?></span>
			 </div>
			 <div style='padding:5px 10px;'>
				<span style='width:200px;text-align:left;padding:20px 10px;'>M.C. Number :</span>
				<span><?php echo $FMCNUMBER; ?></span>
			 </div>
			</div>

</div>
	 
	<div id="Footer">
                    <div id="FooterInner">
                        <div id="FooterLink">
                            <div style="width: 350px; float: left; text-align: left; margin-left: 20px;">
                                
                            </div>
                            <div style="width: 220px; float: right;">
                                Powered by <a style="outline: 0;" target="_blank" href="http://www.logisys.org">Logisys</a>
                            </div>
                        </div>
                    </div>
</div>

</div>
</div>

${this.title}

Code Editor : mcverifydet.php