FSCCPIS/advisorDay.php at master · Programsquad101/FSCCPIS · GitHub

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
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
<?php

require_once 'scripts/database.php';
require_once 'scripts/app_config.php';

$advisor_search = $_POST['day'];
$advisor_search = '%'.$advisor_search.'%';
$sql = "SELECT aa.available_id, a.advisor_id, a.firstName,a.lastName,a.email,aa.availableDate, aa.availableTime, aa.room, a.rating, a.totalAppointments FROM tblAdvisorAvailable aa JOIN tblAdvisors a ON aa.advisor_id = a.advisor_id  WHERE availableDate LIKE ?;";
$stmt = mysqli_stmt_init($con);
if(!mysqli_stmt_prepare($stmt, $sql)){
  echo "ERROR PREPAREs";
  echo mysqli_error($con);
} else{
  mysqli_stmt_bind_param($stmt, "s", $advisor_search);
  mysqli_stmt_execute($stmt);
  if(!mysqli_stmt_bind_result($stmt, $available_id, $advisor_id,$advisor_firstName, $advisor_lastName, $advisor_email, $advisor_availableDate, $advisor_availableTime, $advisor_room, $rating, $totalAppointments)){
    echo "Error binding result";
    } else{
      $advisor_firstName = htmlspecialchars($advisor_firstName, ENT_QUOTES, 'UTF-8');
      $advisor_lastName = htmlspecialchars($advisor_lastName, ENT_QUOTES, 'UTF-8');
      $advisor_email = htmlspecialchars($advisor_email, ENT_QUOTES, 'UTF-8');
      $advisor_search = str_replace('%', '', $advisor_search);
      echo "<div style='font-size:20px; font-weight:bold;'>$advisor_search</div>";

      while(mysqli_stmt_fetch($stmt)){
        //print out advisors
        echo "
        <div class='appointment_wrapper'>
          <div class='date'>
            <span> $advisor_availableDate</span>
          </div>
          <div class='details'>
            <div style='font-size: 22px;font-weight: bold;margin-bottom:5px; '> $advisor_firstName $advisor_lastName </div>

            <div class='icons2'>
              <i class='far fa-envelope'></i>
            </div>
            <div class='infos2'>
              $advisor_email
              &nbsp;
            </div>


            <div class='icons2'>
              <i class='far fa-calendar-o'></i>
            </div>
            <div class='infos2'>
              $advisor_availableDate
              &nbsp;
            </div>

            <div class='icons2'>
              <i class='far fa-clock-o'></i>
            </div>
            <div class='infos2'>
              $advisor_availableTime
              &nbsp;
            </div>

            <div class='icons2'>
              <i class='fas fa-search-location'></i>
            </div>
            <div class='infos2'>
              $advisor_room
              &nbsp;
            </div>
            <div class='icons2'>
              Rating:
            </div>
            <div class='infos2'>
              $rating out of 5
              &nbsp;
            </div>
            <div class='icons2'>
              Total Appointments:
            </div>
            <div class='infos2'>
              $totalAppointments
              &nbsp;
            </div>

          </div>
          <div class='selection'>
            <div style='font-size:20px'>                    <a href='scripts/request_advisor_appointment.php?$advisor_id/$available_id'>Request Appointment</a></div>
            <!-- <i class='far fa-calendar-check fa-lg'></i> -->
          </div>
        </div>
        <div id='survey' style='visibility:hidden;'>Request Appointment</div>
        ";
      }
  }
}

?>