Time table code in PHP and MySQL
Here, in this example of PHP and MySQL code, we have developed the following files;
create.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 |
<!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
|
1 2 3 |
<?php $conn = mysqli_connect('localhost', 'root', '', 'timetable2'); ?> |
display.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
<!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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
<!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
