eventtickets Database Table

Table: eventtickets

Tool: Events
Associated Objects: EventTicket, EventTickets

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

event INT UNSIGNED NOT NULL v5

eventprice INT UNSIGNED NOT NULL v5

contact INT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

amount DECIMAL(8,2) NOT NULL v5

used INT UNSIGNED NOT NULL DEFAULT 0 v5

istemp BIT(1) NOT NULL DEFAULT 0 v5

transactionid VARCHAR(50) NOT NULL v5

begin INT UNSIGNED NOT NULL DEFAULT 0 v5

duration INT UNSIGNED NOT NULL DEFAULT 0 v5

paid DECIMAL(8,2) NOT NULL DEFAULT 0 v5

payment INT UNSIGNED NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM eventtickets");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $event = $resRow["event"];  //
 $eventprice = $resRow["eventprice"];  //
 $contact = $resRow["contact"];  //
 $added = $resRow["added"];  //
 $amount = $resRow["amount"];  //
 $used = $resRow["used"];  //
 $istemp = $resRow["istemp"];  //
 $transactionid = $resRow["transactionid"];  //
 $begin = $resRow["begin"];  //
 $duration = $resRow["duration"];  //
 $paid = $resRow["paid"];  //
 $payment = $resRow["payment"];  //
}

Other Events Tables

event eventdiscounts eventextras eventprices eventrecurremove eventrecurs eventsettings eventtickets eventtypes

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us