Viewing file:  certificateverify.php (13.08 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html lang="en-US">
<head>
<?php include 'header.php'; ?>
<body ">
<div id="page" class="site">
<?php include 'menubar.php'; ?>
<br>
<br><br>
<br>
<br>
<br>
<form action="" method="get" name="form">
<div style="text-align:center;">
<div style="box-sizing: border-box; vertical-align: top; border-radius: 9px; position:relative; display: inline-block; width:40%; min-height:80px; background-color:#BDBDBD; background: linear-gradient(to bottom, #F5F5F5, #BDBDBD); border: 1px solid #545454; " id="container_555429bd">
<div style="margin: 10px; display: block; " id="container_555429bd_padding" >
<div style="text-align:center;">
Enter Certificate No<input type="text" value="" title="" name="q" style="box-sizing: border-box; vertical-align: bottom; position:relative; display: inline-block; width:150px; height:30px; background-color:#FFFFFF; border: 1px solid #A0A0A0; font-size:12pt; font-family:Arial, Helvetica, sans-serif; color:#000000; " id="edit_46617e6a" >
<input type="submit" name="Submit" value="Search" /> </div>
<div style="text-align:left;">
<div style="position:absolute; left:2%; top:24%; background:none; " id="text_7d1752af">
</div>
</div>
<div style="clear:both"></div>
</div>
</div>
</div>
</form>
<?php
$var = @$_GET['q'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "itce_user", "rb!itc838", "itce_data");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$field = 'certificate_no';
// Attempt select query execution
$sql = "SELECT * FROM certificate where CertificateNo like \"$trimmed\" order by ID ";
if($result = mysqli_query($link, $sql)){
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_array($result)){
$photos=$row['photo'];
$replaced = str_replace(' ', '%20',$photos);
$image="<img border='1' width='100' height='100' src=http://itce.co.in/data/files/".$replaced.">";
$studentname=$row['Name'];
$fathers_name=$row['father_name'];
$address=$row['Add'];
$course_name=$row['Course'];
$CertificateNo=$row['CertificateNo'];
$Enrollment=$row['enrollment'];
$grade=$row['grade'];
$Date_Reg=$row['Date_Reg'];
$serial=$serial+1;
$pn1 =$row['pn1'];
$pn1_total_marks=$row['pn1_total_marks'];
$pn1_obtained_marks=$row['pn1_obtained_marks'];
$pn2 =$row['pn2'];
$pn2_total_marks=$row['pn2_total_marks'];
$pn2_obtained_marks=$row['pn2_obtained_marks'];
$pn3 =$row['pn3'];
$pn3_total_marks=$row['pn3_total_marks'];
$pn3_obtained_marks=$row['pn3_obtained_marks'];
$pn4 =$row['pn4'];
$pn4_total_marks=$row['pn4_total_marks'];
$pn4_obtained_marks=$row['pn4_obtained_marks'];
$pn5 =$row['pn5'];
$pn5_total_marks=$row['pn5_total_marks'];
$pn5_obtained_marks=$row['pn5_obtained_marks'];
$pn6 =$row['pn6'];
$pn6_total_marks=$row['pn6_total_marks'];
$pn6_obtained_marks=$row['pn6_obtained_marks'];
$pn7 =$row['pn7'];
$pn7_total_marks=$row['pn7_total_marks'];
$pn7_obtained_marks=$row['pn7_obtained_marks'];
$count++ ;
}
// Free result set
mysqli_free_result($result);
} else{
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$totalmarks=$pn1_total_marks+$pn2_total_marks+$pn3_total_marks+$pn4_total_marks+$pn5_total_marks+$pn6_total_marks+$pn7_total_marks+$pn8_total_marks+$pn9_total_marks+$pn10_total_marks;
$otainedmarks=$pn1_obtained_marks+$pn2_obtained_marks+$pn3_obtained_marks+$pn4_obtained_marks+$pn5_obtained_marks+$pn6_obtained_marks+$pn7_obtained_marks+$pn8_obtained_marks+$pn9_obtained_marks+$pn10_obtained_marks;
$percentage=round(($otainedmarks/ $totalmarks)*100);
if($percentage>79)
{
$grade='A+';
}
if($percentage<80 AND $percentage>59)
{
$grade='A';
}
if($percentage<60 AND $percentage>44)
{
$grade='B';
}
if($percentage<45 )
{
$grade='FAIL';
}
// Close connection
mysqli_close($link);
?>
<br>
<!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>
<!--page generated by WebAcappella-->
<!-- 2022-05-10T06:50:43 ***************-->
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7;IE=EmulateIE9" />
<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>
<meta name="generator" content="WebAcappella 4.6.9 ecommerce (WIN) #0"/>
<title></title>
<meta name="keywords" content=""/>
<meta name="description" content=""/>
<style type="text/css">
body{margin-left:0px;margin-top:0px;margin-right:0px;margin-bottom:0px;background-color:#ffffff;}
</style>
<link rel="stylesheet" type="text/css" href="wa_global_style.css"/>
<script type="text/javascript" src="jquery.js?v=86c"></script>
<script type="text/javascript">
var waJSQuery = jQuery.noConflict();
</script>
<script type="text/javascript" src="webacappella_core.js?v=1ups"></script>
<!--[if lte IE 8]><script type="text/javascript" src="excanvas.js?v=1f2a"></script>
<![endif]-->
<!--[if lte IE 8]><script type="text/javascript" src="webacappella_patch_ie8.js?v=tc5"></script>
<![endif]-->
<script type="text/javascript">
document.write("\u003cscript type='text/javascript' src='wa_site_global_settings.js?v=1x8kmssq4i07ni"+urlSuffixe(1)+"'>\u003c/script>");
</script>
<script type="text/javascript" src="jquery.mousewheel.js?v=use"></script>
<link href="webacappella.css?v=10nl" rel="stylesheet" type="text/css" media="all"/>
<!--[if lte IE 7]>
<link href="webacappella_ie.css?v=1tjn" rel="stylesheet" type="text/css" media="all"/>
<![endif]-->
<script type="text/javascript" src="webacappella_tools.js?v=blf"></script>
<script type="text/javascript">
waJSQuery(function() {
initializeWA_JQuery()
});
</script>
<script type="text/javascript">
var waWebFontDescription={families:[
]}
</script>
</head>
<body><div id='wa-dialog-container' class='wa-fullscreen-contenair' style='position:absolute;z-index:52000;'></div><div id='html-centered' style='position:relative;width:100%;z-index:200;'><div id='is-global-layer' class='wa-main-page-contenair' style='position:relative;z-index:200;top:0px;width:600px;;text-align:left;margin:0 auto; '><div style="position:absolute;top:1px;left:0px;width:1px;height:1px;"><a name="anchor-top"> </a></div>
<div style="position:absolute;z-index:10023;left:0px;top:440px;width:600px;height:60px;border:0px;background:rgba(0,0,0,0);overflow:hidden;" class="wa-comp wa-text wa-bg-gradient param[grad(rgba(0,0,0,0)) border(0 #969696)] " ><div style="position:absolute;z-index:10;line-height:1.2;margin:2px;top:0px;left:0px;width:598px;height:58px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Georgia';font-size:11px;font-weight:normal;color:#000000;" >Note : This certificate is used for only online document verificaiton.</span></div></div></div><span style="position:absolute;z-index:10019;left:0px;top:435px;width:600px;height:65px;-moz-border-radius:5px;border-radius:5px;-webkit-border-radius:5px;border:0px;background-color:#b7e2fe;" class="wa-bg-gradient param[grad(#b7e2fe) border(0 #969696)] wa-comp "></span><div style="position:absolute;z-index:10015;left:450px;top:60px;width:131px;height:134px;border:0px;background:rgba(0,0,0,0);overflow:hidden;" class="wa-comp wa-text wa-bg-gradient param[grad(rgba(0,0,0,0)) border(0 #969696)] " ><div style="position:absolute;z-index:10;line-height:1.2;margin:2px;top:0px;left:0px;width:129px;height:132px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Georgia';font-size:14px;font-weight:normal;color:#000000;" ><?php echo $image ?></span></div></div></div><div style="position:absolute;z-index:10011;left:0px;top:46px;width:433px;height:340px;border:0px;background:rgba(0,0,0,0);overflow:hidden;" class="wa-comp wa-text wa-bg-gradient param[grad(rgba(0,0,0,0)) border(0 #969696)] " ><div style="position:absolute;z-index:10;line-height:1.2;margin:2px;top:0px;left:0px;width:431px;height:338px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Georgia';font-size:17px;font-weight:normal;color:#000000;" >
<table>
<tr><td width='100'>Certificate No:</td><td><?php echo $CertificateNo ?></td> </tr>
<tr><td width='100'>Roll No:</td><td><?php echo $Enrollment ?></td> </tr>
<tr><td width='100'>Name:</td><td><?php echo $studentname ?></td> </tr>
<tr><td width='100'>Father:</td><td><?php echo $fathers_name ?></td> </tr>
<tr><td width='100'>Course:</td><td><?php echo $course_name ?></td> </tr>
<tr><td width='100'>Grade:</td><td><?php echo $grade ?></td> </tr>
<tr><td width='100'>Registration Date:</td><td><?php echo $Date_Reg ?></td> </tr>
</table>
<table border="2" class="aTable" style="width: 80%">
<tr bgcolor="#C0C0C0">
<td style="width: 790px">SUBJECT </td>
<td style="width: 113px">TOTAL <br>MARKS</td>
<td>OBTAINED<br>MARKS</td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn1 ?></td>
<td style="width: 113px"><?php echo $pn1_total_marks ?></td>
<td><?php echo $pn1_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn2 ?></td>
<td style="width: 113px"><?php echo $pn2_total_marks ?></td>
<td><?php echo $pn2_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn3 ?></td>
<td style="width: 113px"><?php echo $pn3_total_marks ?></td>
<td><?php echo $pn3_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn4 ?></td>
<td style="width: 113px"><?php echo $pn4_total_marks ?></td>
<td><?php echo $pn4_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn5 ?></td>
<td style="width: 113px"><?php echo $pn5_total_marks ?></td>
<td><?php echo $pn5_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn6 ?></td>
<td style="width: 113px"><?php echo $pn6_total_marks ?></td>
<td><?php echo $pn6_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn7 ?></td>
<td style="width: 113px"><?php echo $pn7_total_marks ?></td>
<td><?php echo $pn7_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn8 ?></td>
<td style="width: 113px"><?php echo $pn8_total_marks ?></td>
<td><?php echo $pn8_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn9 ?></td>
<td style="width: 113px"><?php echo $pn9_total_marks ?></td>
<td><?php echo $pn9_obtained_marks ?></td>
</tr>
<tr>
<td style="width: 790px"><?PHP echo $pn10 ?></td>
<td style="width: 113px"><?php echo $pn10_total_marks ?></td>
<td><?php echo $pn10_obtained_marks ?></td>
</tr>
<tr bgcolor="#C0C0C0">
<td class="auto-style1" style="width: 790px">TOTAL</td>
<td style="width: 113px"><?php echo $totalmarks ?></td>
<td><?php echo $otainedmarks ?></td>
</tr>
<tr bgcolor="#C0C0C0">
<td class="auto-style1" style="width: 790px">Percentage:<?php echo $percentage ?>%</td>
<td style="width: 113px">Grade :<?php echo $grade ?></td>
<td></td>
</tr>
</table>
</span></div></div></div><div style="position:absolute;z-index:10007;left:0px;top:0px;width:600px;height:40px;border:0px;background-color:#b4ccfe;overflow:hidden;" class="wa-comp wa-text wa-bg-gradient param[grad(#b4ccfe) border(0 #969696)] " ><div style="position:absolute;z-index:10;line-height:1.2;margin:2px;top:0px;left:0px;width:598px;height:38px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="center"><span style="font-family:'Georgia';font-size:28px;font-weight:bold;color:#f43319;" >ITCE</span></div></div></div><span style="position:absolute;z-index:10003;left:440px;top:53px;width:150px;height:150px;-moz-border-radius:5px;border-radius:5px;-webkit-border-radius:5px;border:0px;background-color:#b7e2fe;" class="wa-bg-gradient param[grad(#b7e2fe) border(0 #969696)] wa-comp "></span><div style="position:absolute;top:479px;left:0px;width:1px;height:1px;" ><a name="anchor-bottom"> </a></div>
<div id='dynmenu-container' style='position:absolute;z-index:51000;'></div></div>
</div> <!--end html-centered-->
<script type="text/javascript">
<!--
document.webaca_page_option_background=0
document.webaca_page_background_img_size=[-1,-1]
document.webaca_page_is_centered=true;
document.webaca_width_page=600;
document.webaca_height_page=499;
document.webaca_banner_height=0;
document.webaca_is_preview=false;
var wa_global_market = {markets:new Array(),id_modif_dlg_js:''};
Translator.m_lang="en";
Translator.m_languages={}
Translator.m_lang_for_filename="";
function wa_timeout(_fct,_time,p1,p2,p3){return setTimeout(_fct,_time,p1,p2,p3)}
function wa_evaluate(_s){return eval(_s)}
function IS_onload(){
IS_onload_WA();
}
-->
</script>
<script type="text/javascript" src='wa_common_messages_en.js?v='></script>
<script type="text/javascript">
<!--
WA_loadMessages();
-->
</script>
<script type="text/javascript">
<!--
-->
</script>
</body>
</html>
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<?php include 'footer.php'; ?>
<?php include 'topfooter.php'; ?>
|