Event-Management-simplePHP/events.php at master · MrRoy121/Event-Management-simplePHP · 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
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/main.css">
<link rel="stylesheet"href="https://www.w3schools.com/w3css/4/w3.css">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
</head>

<body style="background: #000;">

    <div class="section-header">
        <h1><b><strong>Events</strong></b></h1>
        <p>Text messaging, or texting, is the act of composing and sending electronic messages, typically consisting of alphabetic and <br>numeric characters, between two or.</p>
    </div>

    <div class="w3-container w3-cell" >
        <img src="images/pic2.jpg" class="img-responsive" alt="" style="margin-left:150px;">
      </div>

      <div class="w3-container  w3-cell" >
        <h2>Available Programs</h2>

<div class="container">
<?php

include "config/config.php";
$result = mysqli_query($conn,"SELECT * FROM events");

while($row = mysqli_fetch_array($result))
{?>


    <div class="card border-secondary" style="width: 500px; height: 180px; margin-top: 20px; background: #000;">
     <div class="card-header border-secondary"><b><span style="margin-right: 330px"><?php echo  $row['time'] ;?></span><?php echo  $row['date'];?></b></div>
     <div class="card-body text-secondary">
    <h5 class="card-title"><b><?php echo  $row['name'] ;?><b></h5>
    <p class="card-text" style="font-size: 20px;"><?php echo  $row['place'] ;?><br><span style="font-size: 14px;" >Number Of Tickets: <?php echo  $row['Ticket'] ;?></span><span style="font-size: 15px; margin-left: 20px">Available Tickets: <?php echo  $row['avaiTicket'] ;?></span></p>
   <?php echo "<td><a  class = 'btn border-secondary' href='events.php?No={$row['No']}' style='font-size: 10px; padding: 10px; color: #fff; margin-left: 350px; margin-top: -50px;'> Buy Ticket </a></td>";?>
  </div>
  </div>


    <?php
}
echo "<br>";
?>
    <a href="events1.php" class="btn btn-large border-secondary" style="margin-bottom: 25px; padding: 20px; font-size: 16px; margin-left: 200px">Upload Events</a>

</body>

</html>

<?php
if((!isset($_GET['No']))) {
  }else{
    $No=$_GET['No'];
    $avaiTicket= mysqli_query($conn, "SELECT avaiTicket from events Where No='$No'");

    while ($row = $avaiTicket->fetch_assoc()) {
      $row['avaiTicket']++;
      $upTicket = $row['avaiTicket'];
      $result = mysqli_query($conn, "UPDATE events SET avaiTicket='$upTicket' WHERE No='$No'");
      If($result){
          echo '<script>alert("Ticket Booked")</script>';
          header("location: events.php");
      }
  }
}

?>