Advertisement
Guest User

Untitled

a guest
Dec 1st, 2017
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 7.79 KB | None | 0 0
  1. <?php
  2. $servername = "cs-sql2014.ua-net.ua.edu";
  3. $username = "nachadwick";
  4. $password = "11494129";
  5. $conn = mysqli_connect($servername, $username, $password, 'nachadwick');
  6. if ($conn->connect_error) {
  7.   die("Connection failed: " . $conn->connect_error);
  8. }
  9. ?>
  10.  
  11. <html>
  12.   <head>
  13.   <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css" integrity="sha384-PsH8R72JQ3SOdhVi3uxftmaW6Vc51MKb0q5P2rRUpPvrszuE4W1povHYgTpBfshb" crossorigin="anonymous">
  14.   </head>
  15.   <body>
  16.     <div class="container">
  17.       <h1 class="text-center">Task 3</h1>
  18.       <div class="col-sm-8 offset-sm-2">
  19.         <form method="post" action="index.php">
  20.           <div class="form-group row">
  21.             <label for="tableName" class="col-sm-2 col-form-label">Table:</label>
  22.             <div class="col-sm-6">
  23.               <select name="tableName" class="form-control">
  24.                 <option value="students">Students</option>
  25.                 <option value="teachers">Teachers</option>
  26.                 <option value="courses">Courses</option>
  27.                 <option value="textbooks">Textbooks</option>
  28.                 <option value="departments">Departments</option>
  29.                 <option value="enrollments">Enrollments</option>
  30.                 <option value="teaching">Teaching</option>
  31.                 <option value="coursehasbooks">Course Has Books</option>
  32.               </select>
  33.             </div>
  34.             <button type="submit" class="btn btn-primary col-sm-4">Load Table</button>
  35.           </div>
  36.         </form>
  37.       </div>
  38.  
  39.       <?php
  40.       if($_POST["tableName"]) {
  41.         echo "<h3 class='text-center'>" . ucwords($_POST["tableName"]) . " Table</h3>";        
  42.         $sql = "select * from ".$_POST["tableName"];
  43.         $result = mysqli_query($conn, $sql);
  44.         ?>
  45.         <table class="table-striped col-sm-8 offset-sm-2">
  46.           <tr>
  47.             <?php
  48.             $headers = mysqli_fetch_fields($result);
  49.             foreach($headers as $header) {
  50.               $split = $data = preg_split('/(?=[A-Z])/', $header->name);
  51.               $spacedWords = implode(' ', $split);
  52.               echo "<th>" . ucwords($spacedWords) . "</th>";
  53.             }
  54.             ?>
  55.           </tr>
  56.           <?php
  57.           while($row = mysqli_fetch_assoc($result)) {
  58.             echo "<tr>";
  59.             foreach( $row as $col) {
  60.               echo "<td>" . $col . "</td>";
  61.             }
  62.             echo "</tr>";
  63.           }
  64.           ?>
  65.         </table>
  66.       <?php } ?>
  67.       <hr/>
  68.       <h1 class="text-center">Task 4</h1>
  69.       <h3 class="text-center">Part a</h3>
  70.       <div class="col-sm-12">
  71.         <form  method="post" action="index.php">
  72.           <div class="radio text-center">
  73.             <label><input type="radio" name="queryOption" value="queryOne">Select teachers based on a minimum years of employment</label>
  74.             <label><input type="radio" name="queryOption" value="queryTwo">Select all courses of a given department</label>
  75.           </div>
  76.           <div id="twoOptionQueryForm" style="display: none" class="form-group row">
  77.             <label id="twoOptionQueryLabel" for="queryInput" class="col-sm-7 col-form-label text-right"></label>
  78.             <div class="col-sm-2">
  79.               <input type="text" class="form-control" name="twoOptionQueryInput">
  80.             </div>
  81.             <button type="submit" class="btn btn-primary col-sm-3">Load Results</button>
  82.           </div>
  83.         </form>
  84.       </div>
  85.       <?php
  86.       if($_POST["twoOptionQueryInput"]) {
  87.         $sql;
  88.         if($_POST["queryOption"] == "queryOne") {
  89.           $sql = "select * from teachers where yearsEmployed >= ".$_POST["twoOptionQueryInput"];
  90.         } else {
  91.           $sql = "select courses.* from courses inner join departments on departments.id = courses.departmentId where departments.name = '".$_POST["twoOptionQueryInput"]."'";
  92.         }
  93.         $result = mysqli_query($conn, $sql);
  94.         ?>
  95.         <table class="table-striped col-sm-8 offset-sm-2">
  96.           <tr>
  97.             <?php
  98.             $headers = mysqli_fetch_fields($result);
  99.             foreach($headers as $header) {
  100.               $split = $data = preg_split('/(?=[A-Z])/', $header->name);
  101.               $spacedWords = implode(' ', $split);
  102.               echo "<th>" . ucwords($spacedWords) . "</th>";
  103.             }
  104.             ?>
  105.           </tr>
  106.           <?php
  107.           while($row = mysqli_fetch_assoc($result)) {
  108.             echo "<tr>";
  109.             foreach( $row as $col) {
  110.               echo "<td>" . $col . "</td>";
  111.             }
  112.             echo "</tr>";
  113.           }
  114.           ?>
  115.         </table>
  116.       <?php } ?>
  117.       <br>
  118.       <br>
  119.       <h3 class="text-center">Part b</h3>
  120.       <div class="col-sm-12">
  121.         <h5 class="text-center">Add Yourself as a Student</h5>
  122.         <form  method="post" action="index.php">
  123.           <div class="form-group row">
  124.             <label for="studenFirsttName" class="col-form-label sr-only">First Name</label>
  125.             <div class="col-sm-4">
  126.               <input type="text" class="form-control" placeholder="First Name" name="studentFirstName">
  127.             </div>
  128.             <label for="studentLastName" class="col-form-label sr-only">Last Name</label>
  129.             <div class="col-sm-4">
  130.               <input type="text" class="form-control" placeholder="Last Name" name="studentLastName">
  131.             </div>
  132.             <label for="studentAge" class="col-form-label sr-only">Age</label>
  133.             <div class="col-sm-4">
  134.               <input type="text" class="form-control" placeholder="Age" name="studentAge">
  135.             </div>
  136.           </div>
  137.           <div class="form-group row">
  138.             <button type="submit" class="btn btn-primary col-sm-2 offset-sm-5">Submit</button>
  139.           </div>
  140.         </form>
  141.       </div>
  142.       <?php
  143.       if($_POST["studentFirstName"] && $_POST["studentLastName"] && $_POST["studentAge"]) {
  144.        
  145.         $sql = "insert into students (firstName, lastName, age) values ('".$_POST["studentFirstName"]."', '".$_POST["studentLastName"]."', '".$_POST["studentAge"]."')";
  146.         mysqli_query($conn, $sql);
  147.  
  148.         $sql = "select * from students";
  149.         $result = mysqli_query($conn, $sql);
  150.         ?>
  151.         <table class="table-striped col-sm-8 offset-sm-2">
  152.           <tr>
  153.             <?php
  154.             $headers = mysqli_fetch_fields($result);
  155.             foreach($headers as $header) {
  156.               $split = $data = preg_split('/(?=[A-Z])/', $header->name);
  157.               $spacedWords = implode(' ', $split);
  158.               echo "<th>" . ucwords($spacedWords) . "</th>";
  159.             }
  160.             ?>
  161.           </tr>
  162.           <?php
  163.           while($row = mysqli_fetch_assoc($result)) {
  164.             echo "<tr>";
  165.             foreach( $row as $col) {
  166.               echo "<td>" . $col . "</td>";
  167.             }
  168.             echo "</tr>";
  169.           }
  170.           ?>
  171.         </table>
  172.       <?php } ?>
  173.     </div>
  174.   </body>
  175.   <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  176.   <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/js/bootstrap.min.js" integrity="sha384-alpBpkh1PFOepccYVYDB4do5UnbKysX5WZXm3XxPqe5iKTfUKjNkCk9SaVuEZflJ" crossorigin="anonymous"></script>
  177.   <script>
  178.     $( document ).ready(function() {
  179.       $('input:radio[name="queryOption"]').change(function(){
  180.         $("#twoOptionQueryForm").show();
  181.         if ($(this).is(':checked') && $(this).val() == 'queryOne') {
  182.           console.log("one");
  183.           $("#twoOptionQueryLabel").text("Please Enter a Minimum Number of Years");
  184.         } else if ($(this).is(':checked') && $(this).val() == 'queryTwo') {
  185.           console.log("two");
  186.           $("#twoOptionQueryLabel").text("Please Enter a Department Name");
  187.         }
  188.       });
  189.     });
  190.   </script>
  191. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement