Signup-Webpage/editsheet.php at master · yencoder/Signup-Webpage · 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
<?php
require 'includes/header.php';
//check session for whatever user info was stored
//if(!isset($_SESSION['username'])){
  //no user info, redirect
//header("Location:login.php");
//exit();
//}
$userid = $_SESSION['userid'];
$sheetid = $_SESSION['sheetid'];
include 'includes/library.php';
$pdo = connectdb();

$query = "SELECT * FROM signin_info where sheetid = ?";
$stmt=$pdo->prepare($query);
$results = $stmt->execute([$sheetid]);
$sheets = $stmt->fetchAll();

$query = "SELECT * FROM slot_info where sheetid = '?'";
$stmt=$pdo->prepare($query);
$results = $stmt->execute([$sheetid]);
$slots = $stmt->fetchAll();

if(isset($_POST['add'])) {
  // ERROR VERIFICATION
  if (!isset($date)) { $errors['date'] = true; }
  if (!isset($title)) { $errors['emptyTitle'] = true; }
  if(count($errors)===0) {
    // RETRIEVE USER EMAIL
    $query = "SELECT `email` FROM `signup_users` WHERE userid=?";
    $stmt = $pdo->prepare($query);
    $stmt->execute([$userid]);
    $results = $stmt->fetch();
    $query = "INSERT into slot_info values (NULL, $sheetid, $userid,?,?,?,?)"; //foreign key
    $stmt = $pdo->prepare($query)->execute([$title, $date, $username, $results['email']]);
  }
}

if(isset($_POST['confirm'])){
    $query = "UPDATE signin_info SET title=?, 'description'=?, privacy=? WHERE sheetid=?";
    $stmt = $pdo->prepare($query)->execute([$sheets['title'], $sheets['description'], $sheets['privacy'], $results['sheetid']]);
        $stmt->execute([$sheetid]);
}
?>


<!DOCTYPE html>
<html lang="en">
  <head>
  <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
    <script src="https://kit.fontawesome.com/6786f5cbb4.js" crossorigin="anonymous"></script>
    <title>Editing</title>
    <link rel="stylesheet" href="styles/master.css" />
  </head>
  <body>
    <section class="signup">
          <form id="signupform" action="<?=htmlentities($_SERVER['PHP_SELF']);?>" method="post" novalidate>
          <h2>
              Edit Your Sign Up Sheet
          </h2>
            <div class="input">
                <label for="title">Sheet Title</label>
                <?php  foreach($sheets as $r): ?>
                <input id="title" name="title" type="text" value="<?= $r['title']; ?>"; />
             <span class="error <?=!isset($errors['title']) ? 'hidden' : "";?>">Please enter a Sheet Title</span>
                <?php endforeach ?>
              </div>
              <div class="input">
                <label for="description">Description</label>
                <?php  foreach($sheets as $r): ?>
                <textarea name="description" id="description" cols="50" rows="5";><?= $r['description']; ?></textarea>
                <?php endforeach ?>
              </div>
              <div class="input">
                <label for="date">Time Slot</label>
                <ol>
            <?php  foreach($slots as $r): ?>
                <div>
                <p>Date and time: <?= $r['timeslot']; ?></p>
                <button id="delete" name="delete">Delete</button> </li>
                <?php endforeach ?>
            </ol>
            </div>
                <div>
                <input id="date" name="date" type="datetime-local" placeholder="YYYY-MM-DD"/>
                <span class="error <?=!isset($errors['date']) ? 'hidden' : "";?>">It's Empty!</span>
                <button id="add" name="add">ADD</button>
            </div>
              </div>
              <fieldset>
                <legend>Privacy</legend>
                <div>
                <input id="public" name="privacy" type="radio" value='Y'
              <?php if (isset($_POST['privacy']) && $_POST['privacy'] == "Y") echo 'checked="checked"';?>/>
                  <label for="public">Public</label>
                </div>
                <div>
                <input id="private" name="privacy" type="radio" value='N'
              <?php if (isset($_POST['privacy']) && $_POST['privacy'] == "N") echo 'checked="checked"';?>/>
                  <label for="private">Private</label>
                </div>
              </fieldset>
              <span class="error <?=!isset($errors['privacy']) ? 'hidden' : "";?>">Please choose one</span>
              <button id="confirm" name='confirm'>CONFIRM YOUR EDITING</button>
          </form>
  </section>
    <?php include "includes/footer.php" ?>
  </body>
</html>