</p> Quantity:<form method="post" class="form-inline"> <select name="quantity" class="form-control"> <option>1</option> <option>2</option> <option>3</option> <option>4</option> <option>5</option> </select> <button type="submit" name="purchase" class="btn btn-default" style="margin-left: 80px;">Purchase</button> </form> </div> <?php if (isset($_POST['purchase'])) { $sale = new SALE(); $stmt = $sale->runQuery("SELECT * FROM sale WHERE user_id=" . $userRow['user_id'] . " and ticket_id=" . $_GET['tid']); $stmt->execute(); $saleRow = $stmt->fetch(PDO::FETCH_OBJ); if ($saleRow) { $sale->update($userRow['user_id'], $_GET['tid'], $_POST['quantity']); echo "Updated: " . $ticketRow->name; } else { $sale->register($userRow['user_id'], $ticketRow->ticket_id, $_POST['quantity']); echo "Purchased: " . $ticketRow->name; } } } ?> </div>
<label class="h5">Hi! : <?php print $userRow['user_name']; ?> </label> <hr /> <?php if (!isset($_GET['tid'])) { ?> <p class="h4">TicketInventory</p><hr /> <table class="table table-striped"> <tr><td>TicketID</td><td>IssuedDate</td><td>Quantity</td></tr> <?php $sale = new SALE(); $stmt = $sale->runQuery("SELECT * FROM sale WHERE user_id=:user_id"); $stmt->bindparam(":user_id", $user_id); $stmt->execute(); while ($saleRow = $stmt->fetch(PDO::FETCH_OBJ)) { ?> <tr><td><?php echo $saleRow->ticket_id; ?> </td><td><a href="?tid=<?php echo $saleRow->ticket_id; ?> "><?php echo $saleRow->date; ?> </a></td><td><?php echo $saleRow->quantity;