Time table code in PHP and MySQL
Here, in this example of PHP and MySQL code, we have developed the following files;
create.php
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Time Table</title>
<style>
body{
background-image: url(image2.jpg);
background-size: cover;
background-attachment: fixed;
}
</style>
</head>
<body>
<br><br><br>
<div class="container">
<div class="jumbotron">
<h1 class="display-4">Time Table</h1>
<p class="lead">Enter Data</p>
<form action="" method="post">
<div class="form-group">
<label for="formGroupExampleInput">Teacher Name</label>
<input type="text" class="form-control" name="TeacherName" id="formGroupExampleInput" placeholder="Mr.Shamil" required>
</div>
<div class="form-group">
<label for="formGroupExampleInput2">Subject Name</label>
<input type="text" class="form-control" name="SubjectName" id="formGroupExampleInput2" placeholder="Web" required>
</div>
<div class="form-group">
<label for="formGroupExampleInput3">Class Name</label>
<input type="text" class="form-control" name="ClassName" id="formGroupExampleInpu3" placeholder="MCS" required>
</div>
<div class="form-group">
<label for="formGroupExampleInput4">Starting Time</label>
<input type="text" class="form-control" name="StartingTime" id="formGroupExampleInput4" placeholder="24:00:00" required>
</div>
<div class="form-group">
<label for="formGroupExampleInput5">Ending Time</label>
<input type="text" class="form-control" name="EndingTime" id="formGroupExampleInput5" placeholder="24:00:00" required>
</div>
<input type="submit" name="submit" value="Submit" class="btn btn-primary" />
</form>
</div>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</body>
</html>
<?php
//echo "asdasdasdaasd";
if(isset($_POST['submit']))
{
include "dbConnect.php";
$tname = $_POST["TeacherName"];
$sname = $_POST["SubjectName"];
$cname = $_POST["ClassName"];
$st = $_POST["StartingTime"];
$et = $_POST["EndingTime"];
//echo $tname." ".$sname." ".$cname." ".$st." ".$et;
//echo "asdasdasdaasd";
$sql = "INSERT INTO teachertimetable(tn, sn, cn, st, et) VALUES ('$tname', '$sname', '$cname', '$st', '$et')";
if (mysqli_query($conn, $sql)) {
echo "<script type='text/javascript'>
alert('New record created successfully');
</script>" ;
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
}
?>
dbconnect.php
<?php
$conn = mysqli_connect('localhost', 'root', '', 'timetable2');
?>
display.php
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Time Table</title>
<style>
body{
background-image: url(image3.jpg);
background-size: cover;
background-attachment: fixed;
}
</style>
</head>
<body>
<br><br><br>
<div class="container">
<div class="jumbotron">
<h1 class="display-4" align="center">Time Table</h1>
<table class="table">
<thead class="thead-dark">
<tr>
<th scope="col">Teacher Name</th>
<th scope="col">Subject Name</th>
<th scope="col">Class Name</th>
<th scope="col">Starting Time</th>
<th scope="col">Ending Time</th>
</tr>
</thead>
<tbody>
<?php
include "dbConnect.php";
$sql = "Select * from teachertimetable";
$result = mysqli_query($conn, $sql);
if(mysqli_num_rows($result)>0){
while($row=mysqli_fetch_array($result)) {
echo "<tr><td>" . $row["tn"]. "</td><td>" . $row["sn"] . "</td><td>" . $row["cn"] . "</td>
<td>". $row["st"] . "</td><td>" . $row["et"]. "</td></tr>";
}
echo "</table>";
}
?>
</tbody>
</table>
</p>
</div>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</body>
</html>
index.php
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<title>Time Table</title>
<style>
body{
background-image: url(image.jpg);
background-size: cover;
background-attachment: fixed;
}
</style>
</head>
<body>
<br><br><br>
<div class="container">
<div class="jumbotron">
<h1 class="display-4">Time Table</h1>
<p class="lead">Create or Display Time Table</p>
<p class="lead">
<a class="btn btn-primary btn-lg" href="create.php" role="button">Create Class</a>
<a class="btn btn-primary btn-lg" href="display.php" role="button">Display Timetable</a>
</p>
</div>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
</body>
</html>
Database View
