Viewing file:  paperset.php (3.17 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
<title>Untitled</title>
<link rel="stylesheet" href="assets/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/fonts/fontawesome-all.min.css">
<link rel="stylesheet" href="assets/fonts/font-awesome.min.css">
<link rel="stylesheet" href="assets/fonts/fontawesome5-overrides.min.css">
<link rel="stylesheet" href="assets/css/Customizable-Carousel-swipe-enabled.css">
<link rel="stylesheet" href="assets/css/Lista-Productos-Canito.css">
<link rel="stylesheet" href="assets/css/styles.css">
</head>
<body>
<?php
$keywords = $user;
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "rcgi_examuser", "rb!exa838", "rcgi_examdata");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Attempt select query execution
$sql = "SELECT * FROM student_registration";
if($result = mysqli_query($link, $sql)){
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_array($result)){
$roll_no= $row['roll_no'];
$name= $row['name'];
$batch_name= $row['batch_name'];
$reg_date= $row['reg_date'];
$expiry_date= $row['expiry_date'];
$deposit_fees= $row['deposit_fees'];
}
// 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);
?>
<div>
<div class="container">
<div class="row">
<div class="col-md-12">
<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
<tbody>
<tr>
<th>1-</th>
<th>Students Roll No</th>
<th><?php echo $user ?></th>
<th></th>
</tr>
<tr>
<td>2-</td>
<td>Registration Date</td>
<td><?php echo $reg_date ?></td>
<td></td>
</tr>
<tr>
<td>3-</td>
<td>Remaing Days</td>
<td>:</td>
<td></td>
</tr>
<tr>
<td>4-</td>
<td>Account Expiry Date</td>
<td><?php echo $expiry_date ?></td>
<td></td>
</tr>
<tr>
<td>5-</td>
<td>Deposit/Renewal Payment</td>
<td><?php echo $deposit_fees ?></td>
<td></td>
</tr>
</tbody>
</table></div>
</div>
</div>
</div>
<script src="assets/js/jquery.min.js"></script>
<script src="assets/bootstrap/js/bootstrap.min.js"></script>
<script src="assets/js/Customizable-Carousel-swipe-enabled.js"></script>
</body>
</html>
|