Notes-Application/notes.php at master · santigp258/Notes-Application · 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
<?php include_once('includes/header.php') ?>

<?php
// Si hay un error de conexión a la base de datos, permitir que la página siga funcionando
try {
  require_once('includes/bdconnect.php');
  $sql = "SELECT * FROM `notas` ";
  $result = $conn->query($sql);
} catch (\Exception $e) {
  echo $e->getMessage();
}
?>


<div class="container cont mt-3">
  <?php
  if (isset($_SESSION['message'])) {
  ?>

    <div class="alert alert-<?= $_SESSION['message_type'] ?> alert-dismissible fade show" role="alert">
      <?= $_SESSION['message'] ?>
      <button type="button" class="close" data-dismiss="alert" aria-label="Close">
        <span aria-hidden="true">&times;</span>
      </button>
    </div>

  <?php session_unset();
  } //clear data session
  ?>
  <!--APPLICATION-->
  <div id="App" class="row pt-5">
    <?php while ($note = $result->fetch_assoc()) { ?>
      <div class="col-md-6 mb-5">

        <?php $theDate = new DateTime($note['created_At']);
        $date = $theDate->format('Y-m-d');
        $hour = $theDate->format('H:i:s');
        ?>
        <div class="card box-notes">
          <div class="card-header card-h">
            <h4 class="h4"><?php echo $note['title']; ?></h4>
          </div>
          <div class="card-body">
            <div>
              <div class="descrip min">
                <?php echo $note['descriptions']; ?></div>
            </div>
            <div class="form-group">
              <p> <i class="fas fa-calendar-times"></i> <?php echo $date  ?></p>
              <p> <i class="fas fa-clock"></i> <?php echo $hour  ?></p>
            </div>
            <div class="form-group float-right">
              <a href="edit.php?id=<?php echo $note['id'] ?>" class="btn btn-success button-edit mr-3">
                <i class="fas fa-marker"></i>
              </a>
              <a href="delete.php?id=<?php echo $note['id'] ?>" class="btn btn-danger button-delete" name="delete">
                <i class="far fa-trash-alt"></i>
              </a>
            </div>
          </div>
        </div>
      </div>
    <?php } ?>

    <?php if (mysqli_num_rows($result) < 1) { ?>
      <div class="container">
        <div class="alert alert-dark alert-yet" role="alert">
          <h4 class="alert-heading">There isn't notes yet!</h4>
          <p>Please, add your notes. <a href="index.php" class="span">Click here </a>to add notes. </p>
          <hr>
          <p class="mb-0">"You can create great things starting simple".</p>
        </div>
      </div>
    <?php } ?>
  </div>
</div>
<?php include_once('includes/footer.php') ?>