<?php
require_once 'db.php';
$sql =$conn->query("SELECT * FROM `student_name` ORDER BY id DESC");
if(isset($_POST['name']) && $_POST['name'] != '' ){
if(isset($_POST['status']) && $_POST['status'] != '' ){
$name = $_POST['name'];
$status = $_POST['status'];
$sid = $_POST['sid'];
// $id = $_POST['id'];
$conn->query("INSERT INTO `student_name` (`sid`,`name`, `status`) VALUES ('$sid','$name', '$status')");
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0-alpha3/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<form class="container card card-body mt-5" action="" method="POST">
<div class="mb-3">
<div>
<label for="exampleInputEmail1" class="form-label">Name</label>
<input type="text" name="name" class="form-control">
</div>
<div>
<label for="exampleInputEmail1" class="form-label">SID</label>
<input type="number" name="sid" class="form-control">
</div>
<div class="mt-3">
<label for="exampleInputEmail1" class="form-label">Status</label>
<select name="status" id="">
<option value="active">active</option>
<option value="inactive">inactive</option>
<option value="completed">Completed</option>
<option value="dropout">Dropout</option>
<option value="Suspend">Suspend</option>
</select>
</div>
<button type="submit" class="btn btn-primary mt-3">Submit</button>
</form>
<table class="table container border mt-5">
<thead>
<tr>
<th scope="col">ID</th>
<th scope="col">Name</th>
<th scope="col">Status</th>
</tr>
</thead>
<tbody>
<?php while($r=$sql->fetch_assoc()) { ?>
<tr>
<th><?= $r['id']?></th>
<td><?= $r['name']?></td>
<td><?= $r['status']?></td>
</tr>
<?php } ?>
</tbody>
</table>
</body>
</html>
Post a Comment