Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "cs-sql2014.ua-net.ua.edu";
- $username = "nachadwick";
- $password = "11494129";
- $conn = mysqli_connect($servername, $username, $password, 'nachadwick');
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- ?>
- <html>
- <head>
- <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
- </head>
- <body>
- <div class="container">
- <h1 class="text-center">Task 3</h1>
- <div class="col-sm-8 offset-sm-2">
- <form method="post" action="index.php">
- <div class="form-group row">
- <label for="tableName" class="col-sm-2 col-form-label">Table:</label>
- <div class="col-sm-6">
- <select name="tableName" class="form-control">
- <option value="students">Students</option>
- <option value="teachers">Teachers</option>
- <option value="courses">Courses</option>
- <option value="textbooks">Textbooks</option>
- <option value="departments">Departments</option>
- <option value="enrollments">Enrollments</option>
- <option value="teaching">Teaching</option>
- <option value="coursehasbooks">Course Has Books</option>
- </select>
- </div>
- <button type="submit" class="btn btn-primary col-sm-4">Load Table</button>
- </div>
- </form>
- </div>
- <?php
- if($_POST["tableName"]) {
- echo "<h3 class='text-center'>" . ucwords($_POST["tableName"]) . " Table</h3>";
- $sql = "select * from ".$_POST["tableName"];
- $result = mysqli_query($conn, $sql);
- ?>
- <table class="table-striped col-sm-8 offset-sm-2">
- <tr>
- <?php
- $headers = mysqli_fetch_fields($result);
- foreach($headers as $header) {
- $split = $data = preg_split('/(?=[A-Z])/', $header->name);
- $spacedWords = implode(' ', $split);
- echo "<th>" . ucwords($spacedWords) . "</th>";
- }
- ?>
- </tr>
- <?php
- while($row = mysqli_fetch_assoc($result)) {
- echo "<tr>";
- foreach( $row as $col) {
- echo "<td>" . $col . "</td>";
- }
- echo "</tr>";
- }
- ?>
- </table>
- <?php } ?>
- <hr/>
- <h1 class="text-center">Task 4</h1>
- <h3 class="text-center">Part a</h3>
- <div class="col-sm-12">
- <form method="post" action="index.php">
- <div class="radio text-center">
- <label><input type="radio" name="queryOption" value="queryOne">Select teachers based on a minimum years of employment</label>
- <label><input type="radio" name="queryOption" value="queryTwo">Select all courses of a given department</label>
- </div>
- <div id="twoOptionQueryForm" style="display: none" class="form-group row">
- <label id="twoOptionQueryLabel" for="queryInput" class="col-sm-7 col-form-label text-right"></label>
- <div class="col-sm-2">
- <input type="text" class="form-control" name="twoOptionQueryInput">
- </div>
- <button type="submit" class="btn btn-primary col-sm-3">Load Results</button>
- </div>
- </form>
- </div>
- <?php
- if($_POST["twoOptionQueryInput"]) {
- $sql;
- if($_POST["queryOption"] == "queryOne") {
- $sql = "select * from teachers where yearsEmployed >= ".$_POST["twoOptionQueryInput"];
- } else {
- $sql = "select courses.* from courses inner join departments on departments.id = courses.departmentId where departments.name = '".$_POST["twoOptionQueryInput"]."'";
- }
- $result = mysqli_query($conn, $sql);
- ?>
- <table class="table-striped col-sm-8 offset-sm-2">
- <tr>
- <?php
- $headers = mysqli_fetch_fields($result);
- foreach($headers as $header) {
- $split = $data = preg_split('/(?=[A-Z])/', $header->name);
- $spacedWords = implode(' ', $split);
- echo "<th>" . ucwords($spacedWords) . "</th>";
- }
- ?>
- </tr>
- <?php
- while($row = mysqli_fetch_assoc($result)) {
- echo "<tr>";
- foreach( $row as $col) {
- echo "<td>" . $col . "</td>";
- }
- echo "</tr>";
- }
- ?>
- </table>
- <?php } ?>
- <br>
- <br>
- <h3 class="text-center">Part b</h3>
- <div class="col-sm-12">
- <h5 class="text-center">Add Yourself as a Student</h5>
- <form method="post" action="index.php">
- <div class="form-group row">
- <label for="studenFirsttName" class="col-form-label sr-only">First Name</label>
- <div class="col-sm-4">
- <input type="text" class="form-control" placeholder="First Name" name="studentFirstName">
- </div>
- <label for="studentLastName" class="col-form-label sr-only">Last Name</label>
- <div class="col-sm-4">
- <input type="text" class="form-control" placeholder="Last Name" name="studentLastName">
- </div>
- <label for="studentAge" class="col-form-label sr-only">Age</label>
- <div class="col-sm-4">
- <input type="text" class="form-control" placeholder="Age" name="studentAge">
- </div>
- </div>
- <div class="form-group row">
- <button type="submit" class="btn btn-primary col-sm-2 offset-sm-5">Submit</button>
- </div>
- </form>
- </div>
- <?php
- if($_POST["studentFirstName"] && $_POST["studentLastName"] && $_POST["studentAge"]) {
- $sql = "insert into students (firstName, lastName, age) values ('".$_POST["studentFirstName"]."', '".$_POST["studentLastName"]."', '".$_POST["studentAge"]."')";
- mysqli_query($conn, $sql);
- $sql = "select * from students";
- $result = mysqli_query($conn, $sql);
- ?>
- <table class="table-striped col-sm-8 offset-sm-2">
- <tr>
- <?php
- $headers = mysqli_fetch_fields($result);
- foreach($headers as $header) {
- $split = $data = preg_split('/(?=[A-Z])/', $header->name);
- $spacedWords = implode(' ', $split);
- echo "<th>" . ucwords($spacedWords) . "</th>";
- }
- ?>
- </tr>
- <?php
- while($row = mysqli_fetch_assoc($result)) {
- echo "<tr>";
- foreach( $row as $col) {
- echo "<td>" . $col . "</td>";
- }
- echo "</tr>";
- }
- ?>
- </table>
- <?php } ?>
- </div>
- </body>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
- <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
- <script>
- $( document ).ready(function() {
- $('input:radio[name="queryOption"]').change(function(){
- $("#twoOptionQueryForm").show();
- if ($(this).is(':checked') && $(this).val() == 'queryOne') {
- console.log("one");
- $("#twoOptionQueryLabel").text("Please Enter a Minimum Number of Years");
- } else if ($(this).is(':checked') && $(this).val() == 'queryTwo') {
- console.log("two");
- $("#twoOptionQueryLabel").text("Please Enter a Department Name");
- }
- });
- });
- </script>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement