capstoneProject.github.io/index.php at main · ssaem1/capstoneProject.github.io · 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
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
<?php

  // connect to database
  $conn = mysqli_connect('localhost', 'Sam', '1234', 'capstone1');

  //check connection
  if(!$conn){
    echo 'failed';
  }

  $user_sql = 'SELECT first_name, last_name, id, biography FROM users';
  $user_result = mysqli_query($conn, $user_sql);
  $users = mysqli_fetch_all($user_result, MYSQLI_ASSOC);

  $year_sql = 'SELECT id, title, description, location, grade_link, grade_pfp FROM grade';
  $year_result = mysqli_query($conn, $year_sql);
  $years = mysqli_fetch_all($year_result, MYSQLI_ASSOC);

  $club_sql = 'SELECT club_id, club_title, club_description, club_location, club_link, club_pfp FROM clubs';
  $club_result = mysqli_query($conn, $club_sql);
  $clubs = mysqli_fetch_all($club_result, MYSQLI_ASSOC);

  $sport_sql = 'SELECT sport_id, sport_title, sport_description, sport_location, sport_link, sports_pfp FROM sports';
  $sport_result = mysqli_query($conn, $sport_sql);
  $sports = mysqli_fetch_all($sport_result, MYSQLI_ASSOC);

  $hobbie_sql = 'SELECT hobbie_id, hobbie_title, hobbie_description, hobbie_location, hobbie_link, hobbie_pfp FROM hobbies';
  $hobbie_result = mysqli_query($conn, $hobbie_sql);
  $hobbies = mysqli_fetch_all($hobbie_result, MYSQLI_ASSOC);
  // free memory
  mysqli_free_result($user_result);
  mysqli_free_result($year_result);
  mysqli_free_result($club_result);
  mysqli_free_result($sport_result);
  mysqli_free_result($hobbie_result);


  // close connention
  mysqli_close($conn);

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <link rel="stylesheet" href="css/home.css">
    <script src="js/home.js" defer></script>
    <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/swiper@9/swiper-bundle.min.css"/>
    <title>Capstone</title>
</head>
<body>
    <header>
    <div class="container">
          <a class="title" href="index.php"><img class= "logo" src="images/FHlogo.png"> <h2>FH Central</h2></a>
          <div class="buttons">
            <a href="signup.php"><button class="signup">Add User</button></a>
          </div>
        </div>
    </header>
    <div class="swiper-container">
        <div class="swiper">
            <!-- Additional required wrapper -->
            <div class="swiper-wrapper">
              <!-- Slides -->
              <div class="swiper-slide"><img src="images/advertisement.png"></div>
              <div class="swiper-slide"><img src="images/penguin.jpg"></div>
              <div class="swiper-slide"><img src="images/blue.png"></div>
              ...
            </div>
            <!-- If we need pagination -->
            <!-- <div class="swiper-pagination"></div> -->

            <!-- If we need navigation buttons -->
            <div class="swiper-button-prev"></div>
            <div class="swiper-button-next"></div>
          </div>
    </div>
    <script src="https://cdn.jsdelivr.net/npm/swiper@9/swiper-bundle.min.js"></script>

    <div class="tab-container">
        <div class="tab">
          <button class="tablinks active" onclick="openTab(event, 'grade')">grade</button>
          <button class="tablinks" onclick="openTab(event, 'club')">club</button>
          <button class="tablinks" onclick="openTab(event, 'sport')">sport</button>
          <button class="tablinks" onclick="openTab(event, 'hobby')">hobby</button>
        </div>
        <div class="tabcontent" id="grade">
          <?php foreach($years as $year) {
            echo "<a href=\"templates/" . $year['grade_link'] . "\" class=\"profile\">";
              echo "<img src=\" images/icons/" . $year['grade_pfp'] .  "\" alt=\"Profile Image\">" ?>
              <h3><?php echo $year['title']; ?></h3>
              <?php echo "</a>";
             }?>
          </div>
          <div class="tabcontent" id="club">
          <?php foreach($clubs as $club) {
            echo "<a href=\"templates/" . $club['club_link'] . "\" class=\"profile\">";
              echo "<img src=\" images/icons/" . $club['club_pfp'] .  "\" alt=\"Profile Image\">" ?>
              <h3><?php echo $club['club_title']; ?></h3>
              <?php echo "</a>";
             }?>
          </div>
          <div class="tabcontent" id="sport">
          <?php foreach($sports as $sport) {
            echo "<a href=\"templates/" . $sport['sport_link'] . "\" class=\"profile\">";
              echo "<img src=\" images/icons/" . $sport['sports_pfp'] .  "\" alt=\"Profile Image\">" ?>
              <h3><?php echo $sport['sport_title']; ?></h3>
              <?php echo "</a>";
             }?>
          </div>
          <div class="tabcontent" id="hobby">
          <?php foreach($hobbies as $hobbie) {
            echo "<a href=\"templates/" . $hobbie['hobbie_link'] . "\" class=\"profile\">";
              echo "<img src=\" images/icons/" . $hobbie['hobbie_pfp'] .  "\" alt=\"Profile Image\">" ?>
              <h3><?php echo $hobbie['hobbie_title']; ?></h3>
              <?php echo "</a>";
             }?>
          </div>
    </div>
    <div class="footer">
  </div>
</body>
</html>