Viewing file:  marksheet.php (8.4 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
?>
<?php
include('session.php');
?>
<?php
include('certificateno.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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Certificate Registration</title>
<style type="text/css">
body {
background-color: #CCC;
}
</style>
<center>
</head>
<body>
<table width="100%" border="0" bgcolor="#FFFFFF">
<tr>
<td colspan="4" align="center"><?php include('header.php'); ?></td>
</tr>
<tr>
<td colspan="4" bgcolor="#FFFF00"><?php include('menubar.php'); ?></td>
</tr>
<tr>
<td colspan="3" bgcolor="#CCCCCC"> <?php include('sessisionbar.php'); ?></td>
</tr>
<tr>
<td colspan="1" bgcolor="#CCCCCC">
<form action="" method="get" id="form" name="form">
Enter Your Roll No:- <input name="q" type="text" id="q">
<input type="submit" name="Submit" value="Search" />
</form>
<?php
$var = @$_GET['q'] ;
$trimmed = trim($var);
$certino=$trimmed;
$link = mysqli_connect("localhost",'itce_user','rb!itc838',"itce_data");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Attempt select query execution
$sql = "select * from marks WHERE student_certificate_no='$certino'";
if($result = mysqli_query($link, $sql))
{
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_array($result))
{
$sr=$sr+1;
$photo="<img border='1' width='100%' height='100' src=http://itce.co.in/branch/upload/".$row['photo'] .">";
$count++ ;
}
echo "</table>";
// Free result set
mysqli_free_result($result);
} else{
echo "Record Not found";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$certificatnonew=$certificatnonew+1;
// Close connection
mysqli_close($link);
?>
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td colspan="2"><?php include('footer.php'); ?></td>
</tr>
</table>
</body></center>
</html>
<!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-04-03T06:22:02 *******************************-->
<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=21tlno113skxq"+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:800px;;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:10007;left:114px;top:434px;width:660px;height:247px;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:658px;height:245px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Arial';font-size:11px;font-weight:normal;color:#f43319;" >
<?php
$var = @$_GET['q'] ;
$trimmed = trim($var);
$certino=$trimmed;
$link = mysqli_connect("localhost",'itce_user','rb!itc838',"itce_data");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Attempt select query execution
$sql = "select * from marks WHERE student_certificate_no='$certino' LIMIT 9";
if($result = mysqli_query($link, $sql))
{
$sr=0;
if(mysqli_num_rows($result) > 0)
{
echo "<table width=\"100%\" border=\"1\" style='table-layout:fixed' class='w3-table w3-bordered w3-striped w3-border w3-hoverable'>\n>\n";
echo " <tr>\n";
echo " <td width='20' align='left'>Sr.No</td>\n";
echo " <td width='70' align='left'>CERTIFICATE NO</td>\n";
echo " <td width='150' align='left'>COURSE NAME</td>\n";
echo " <td width='50' align='left'>Total Marks</td>\n";
echo " <td width='50' align='left'>Obtained Marks</td>\n";
echo " </tr>\n";
while($row = mysqli_fetch_array($result))
{
$sr=$sr+1;
$photo="<img border='1' width='100%' height='100' src=http://itce.co.in/branch/upload/".$row['photo'] .">";
echo " <tr>\n";
echo " <td align='left'><b>$sr</b></td>\n";
echo " <td align='left'>$row[student_certificate_no]</td>\n";
echo " <td align='left'>$row[subject_exam_name]</td>\n";
echo " <td align='left'>$row[subject_total_marks]</td>\n";
echo " <td align='left'>$row[subject_obtained_marks]</td>\n";
echo " </tr>\n";
$totalmarks=$row[subject_total_marks]+$totalmarks;
$totalobtainedmarks=$row[subject_obtained_marks]+$totalobtainedmarks;
$count++ ;
}
// Free result set
mysqli_free_result($result);
} else{
echo "Record Not found";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$percentage=round(($totalobtainedmarks/$totalmarks)*100);
echo " <tr>\n";
echo " <td align='left'></b></td>\n";
echo " <td align='left'>Percentage :$percentage%</td>\n";
echo " <td align='left'>Total:</td>\n";
echo " <td align='left'>$totalmarks</td>\n";
echo " <td align='left'>$totalobtainedmarks</td>\n";
echo " </tr>\n";
echo "</table>";
// Close connection
mysqli_close($link);
?>
</span></div></div></div><img src="wa_import.png?v=1x3tqw2v2jcou0" alt="" class="wa-img wa-comp " style="position:absolute;z-index:10003;left:0px;top:0px;width:800px;height:848px;border:0px;"/><div style="position:absolute;top:827px;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=800;
document.webaca_height_page=847;
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>
|