Viewing file:  gen_certi_data.php (3.7 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
?>
<?php
include('session.php');
?>
<?php include('header.php'); ?>
<?php include('menubar.php'); ?>
<?php include('sessionbar.php'); ?>
<body class="page-template-default page page-id-528 wp-embed-responsive user-registration-page site-layout-fluid global-layout-right-sidebar elementor-default elementor-kit-983 elementor-page elementor-page-528">
<div>
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
include 'connect.php';
$checkrollno=$_POST['cno'];
// Attempt select query execution
$sql = "SELECT * FROM certificate where CertificateNo='$checkrollno'";
if($result = mysqli_query($link, $sql))
{
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_array($result)){
echo "<br><br><br><center>";
echo "<h1>Studend already registered</h1>";
echo "<br><br><br></center>";
echo "<script>
alert('Studend already registered');
window.location.href='allrecordsshow.php';
</script>";
echo "<a href='allrecordsshow.php'>Go Back</a>";
break;
exit("Unable to establish a connection to $link");
}
// Free result set
mysqli_free_result($result);
} else{
echo "No records matching your query were found.";
}
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
<?php
include 'connect.php';
$sql = "INSERT INTO certificate (Enrollment,Name,branch,Course, pn1,pn1_total_marks, pn1_obtained_marks,
pn2,pn2_total_marks,pn2_obtained_marks, pn3,pn3_total_marks,pn3_obtained_marks, pn4,pn4_total_marks,pn4_obtained_marks,
pn5,pn5_total_marks,pn5_obtained_marks, pn6,pn6_total_marks,pn6_obtained_marks, pn7,pn7_total_marks,pn7_obtained_marks,
pn8,pn8_total_marks,pn8_obtained_marks, pn9,pn9_total_marks,pn9_obtained_marks, pn10,pn10_total_marks,pn10_obtained_marks, certifcate_issue_date,CertificateNo,start_date,end_date,photo,grade)
VALUES ('$_POST[roll_no]','$_POST[name]','$_POST[branchid]','$_POST[course]',
'$_POST[pn1]','$_POST[pn1_total_marks]','$_POST[pn1_obtained_marks]',
'$_POST[pn2]','$_POST[pn2_total_marks]','$_POST[pn2_obtained_marks]',
'$_POST[pn3]','$_POST[pn3_total_marks]','$_POST[pn3_obtained_marks]',
'$_POST[pn4]','$_POST[pn4_total_marks]','$_POST[pn4_obtained_marks]',
'$_POST[pn5]','$_POST[pn5_total_marks]','$_POST[pn5_obtained_marks]',
'$_POST[pn6]','$_POST[pn6_total_marks]','$_POST[pn6_obtained_marks]',
'$_POST[pn7]','$_POST[pn7_total_marks]','$_POST[pn7_obtained_marks]',
'$_POST[pn8]','$_POST[pn8_total_marks]','$_POST[pn8_obtained_marks]',
'$_POST[pn9]','$_POST[pn9_total_marks]','$_POST[pn9_obtained_marks]',
'$_POST[pn10]','$_POST[pn10_total_marks]','$_POST[pn10_obtained_marks]','$_POST[issue_date]','$_POST[cno]','$_POST[start_date]','$_POST[end_date]','$_POST[photo]','$_POST[grade]')";
if (!mysqli_query($con,$sql))
{
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
echo "<br><br><br><center>";
echo "<h1>Studend Certificate Generated</h1>";
echo "<a href=''allrecordsshow.php '>Go Back</a>";
echo "<br><br><br></center>";
?>
<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
include 'connect.php';
$issue_date=$_POST['issue_date'];
// Attempt update query execution
$sql = "UPDATE admission SET certificate_issue_date='$issue_date' WHERE enrollment='$checkrollno'";
if(mysqli_query($link, $sql)){
} else {
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
<?php include 'footer.php'; ?>
|