Viewing file:  certificateprint.php (8.88 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('session.php');
?>
<?php include 'connect.php';?>
<?php
// Get the search variable from URL
$certificateno=$_POST[q];
$var = $certificateno;
$trimmed = trim($var); //trim whitespace from the stored variable
// rows to return
$limit=10;
// check for an empty string and display a message.
if ($trimmed == "")
{
echo "<h2></h2>";
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
// Build SQL Query
$query = "select * from certificate where certificate_no =$trimmed "; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
echo " Sorry, $trimmed this Certificate Numbere is not found";
break;
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
// begin to show results set
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
$image="http://pcclasses.in/branch/upload/".$row['photo'];
$certi_no= $row['certifiacte_no'];
$rollno= $row['roll_no'];
$studentname=$row['student_name'];
$fname=$row['fathers_name'];
$duration=$row['duration'];
$course=$row['course_name'];
$grade=$row['grade'];
$idate=$row['certifcate_issue_date'];
$dstart=$row['course_join_date'];
$totalmarks=$row['total_marks'];
$obtained_marks=$row['obtained_marks'];
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
?>
<!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-->
<!-- 2019-09-30T06:41:13 *********************************-->
<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.27 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=1e526s72bbr5kct"+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:10008;left:229px;top:329px;width:127px;height:120px;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:125px;height:118px;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:#000000;" ><img src="https://chart.googleapis.com/chart?chs=110x110&cht=qr&chl=http://pcclasses.in/branch/print/certificateprint.php?q=<?php echo $trimmed ?>&Submit=Search%2F&choe=UTF-8" title="Link to Google.com" /></span></div></div></div><div style="position:absolute;z-index:10044;left:605px;top:454px;width:120px;height:27px;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:118px;height:25px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Arial';font-size:14px;font-weight:normal;color:#000000;" ><?php echo $certi_no ?></span></div></div></div><div style="position:absolute;z-index:10020;left:187px;top:453px;width:170px;height:27px;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:168px;height:25px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Arial';font-size:14px;font-weight:normal;color:#000000;" ><?php echo $idate ?></span></div></div></div><div style="position:absolute;z-index:10016;left:360px;top:331px;width:366px;height:127px;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:364px;height:125px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Arial';font-size:14px;font-weight:bold;color:#000000;" ><I></I>This is to certify that <?php echo $studentname ?> s/o <?php echo $fname ?> has been successful completed <?php echo $course ?> course of duration <?php echo $duration ?> on <?php echo $dstart ?> to <?php echo $idate ?> with Grade '<?php echo $grade ?></I></span></div></div></div><div style="position:absolute;z-index:10012;left:308px;top:305px;width:420px;height:28px;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:418px;height:26px;word-wrap:break-word;overflow-y:auto;overflow-x:hidden;" ><div align="left"><span style="font-family:'Arial';font-size:14px;font-weight:bold;color:#000000;" ><?php echo $course ?></span></div></div></div><img src="<?php echo $image ?>?v=27ykfc72bsfyese" alt="" class="wa-img wa-comp " style="position:absolute;z-index:10004;left:85px;top:311px;width:124px;height:124px;border:8px solid #969696;"/><img src="certificate0.jpg?v=26s91k72bbralw1" alt="" class="wa-img wa-comp " style="position:absolute;z-index:10000;left:8px;top:1px;width:791px;height:1089px;border:0px;"/><div style="position:absolute;top:1069px;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=1089;
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>
|