billing Database Table

Table: billing

Tool: Billing
Associated Objects: Billing, Billings

Fields

id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT v5

paymentprocessor TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

product INT UNSIGNED NOT NULL DEFAULT 1 v5

redirecturl VARCHAR(255) NOT NULL v5

notifyurl VARCHAR(255) NOT NULL v5

producttype TINYINT UNSIGNED DEFAULT 1 v5

isdirect BIT(1) NOT NULL DEFAULT 0 v5

active BIT(1) NOT NULL DEFAULT 1 v5

title VARCHAR(255) NOT NULL v5

customphpfile VARCHAR(255) NOT NULL v5

membersonly BIT(1) NOT NULL DEFAULT 0 v5

mustbuyinorder BIT(1) NOT NULL DEFAULT 1 v5

contactgroup INT UNSIGNED NOT NULL DEFAULT 0 v5

combineadmin BIT(1) NOT NULL DEFAULT 0 v5

combinemembers BIT(1) NOT NULL DEFAULT 1 v5

searchupline BIT(1) NOT NULL DEFAULT 1 v5

allowmanualrecur BIT(1) NOT NULL DEFAULT 0 v5

cancelsubscription SMALLINT 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 billing");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $paymentprocessor = $resRow["paymentprocessor"];  //
 $product = $resRow["product"];  //
 $redirecturl = $resRow["redirecturl"];  //
 $notifyurl = $resRow["notifyurl"];  //
 $producttype = $resRow["producttype"];  //
 $isdirect = $resRow["isdirect"];  //
 $active = $resRow["active"];  //
 $title = $resRow["title"];  //
 $customphpfile = $resRow["customphpfile"];  //
 $membersonly = $resRow["membersonly"];  //
 $mustbuyinorder = $resRow["mustbuyinorder"];  //
 $contactgroup = $resRow["contactgroup"];  //
 $combineadmin = $resRow["combineadmin"];  //
 $combinemembers = $resRow["combinemembers"];  //
 $searchupline = $resRow["searchupline"];  //
 $allowmanualrecur = $resRow["allowmanualrecur"];  //
 $cancelsubscription = $resRow["cancelsubscription"];  //
}

Other Billing Tables

billing billingagreementpayments billingagreements billingpaymentexceptions billingpayments billingrequirements blockioaddresses btctransactions cancellations creditcardtokens currencyexchange nextbill passups paymanualunlock paymentprocessors paymentprocessorsetup paymentprocessorsetupvars paymentprocessorvars payments promocodes squarecheckoutids squarelocationids stripecustomers stripeplans

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us