starquess/interests.php at main · andreiusq/starquess · 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
127
<?php
session_start();
define('BASEPATH', true);

if(!isset($_SESSION["user"])) {
  header("Location: login.php");
  exit();
}

require('backend/config/db.php');
$stmt = $pdo->prepare("SELECT id, name FROM users WHERE email=:email");
$stmt->bindParam(':email', $_SESSION['user']);
$stmt->execute();

$user = $stmt->fetch(PDO::FETCH_ASSOC);

// interessts logic
$stmt = $pdo->prepare("SELECT id, name FROM interests");
$stmt->execute();

$interests = $stmt->fetchAll(PDO::FETCH_ASSOC);


?>

<!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">
    <title>Interests</title>
    <link rel="stylesheet" href="styles/FontAwesome/css/all.css">
    <link rel="stylesheet" href="styles/register/all.css">
    <link rel="stylesheet" href="styles/register/interests.css">
    <link rel="stylesheet" href="styles/register/radio.css">
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@10.10.1/dist/sweetalert2.all.min.js"></script>
    <link rel='stylesheet' href='https://cdn.jsdelivr.net/npm/sweetalert2@10.10.1/dist/sweetalert2.min.css'>
</head>
<body>
<nav class="nav-container">
  <div class="logo">
    <div class="circle"></div>
    <h2>Starquess<span class="fullstop">.</span></h2>
  </div>
</nav>

<section class="container">
  <div class="form-container">
    <div class="section-header">
      <h1 class="primary-heading">
        Bună, <?php echo $user['name'] ?><span class="fullstop">.</span>
      </h1>
      <h2 class="secondary-heading">
        Pentru că la <span class="fullstop">Starquess</span> ne pasă de elev, trebuie să îți alegi niște interese.
      </h2>
    </div>
    <?php
    if (isset($_POST['submit'])) {
      $selectedInterests = $_POST['interests'];
      $userId = $user['id'];
      if (count($selectedInterests) > 5) {
        echo '<script>';
        echo 'Swal.fire({
                icon: "error",
                title: "Eroare!",
                text: "Poți alege maxim 5 interese.",
              });';
        echo '</script>';
      } else {
        try {

          $pdo->beginTransaction();

          $stmt = $pdo->prepare("DELETE FROM user_interests WHERE user_id = :user_id");
          $stmt->bindParam(':user_id', $userId);
          $stmt->execute();

          $stmt = $pdo->prepare("INSERT INTO user_interests (user_id, interest_id) VALUES (:user_id, :interest_id)");
          foreach ($selectedInterests as $interest) {
            $stmt->bindParam(':user_id', $userId);
            $stmt->bindParam(':interest_id', $interest);
            $stmt->execute();
          }

          $pdo->commit();

          echo '<script>';
          echo 'Swal.fire({
                  icon: "success",
                  title: "Success!",
                  text: "Interesele tale au fost adăugate cu succes.",
                });';
          echo '</script>';
          header("Location: pfp.php");
        } catch (PDOException $e) {
          $pdo->rollback();
          echo "Error: " . $e->getMessage();
        }
      }
    }
    ?>
        <form method="post">
          <?php foreach($interests as $interest) { ?>
            <div class="interests-list">
            <label class="checkbox">
              <div class="checkbox-container">
                <input type="checkbox" name="interests[]" value="<?php echo htmlspecialchars($interest['id'], ENT_QUOTES, 'UTF-8') ?>">
                <span class="interest-name"><?php echo htmlspecialchars($interest['name'], ENT_QUOTES, 'UTF-8') ?></span>
                <span class="checkmark"></span>
              </div>
            </label> <br>
          </div>
          <?php } ?> <br> <br> <br>
          <button type="submit" name="submit" class="primary-btn">Mai departe</button>
        <h6><a href="pfp.php" class="omite">Omite (nu recomandăm asta)</a></h6>
      </div>
    </form>
  </div>
  <div class="side-panel">
    <div class="background"></div>
  </div>
</section>
</body>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@10"></script>
</html>