Exemple #1
0
</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>
Exemple #2
0
    	<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;