Table: payment

Tool: Billing
Associated Objects: Payments, Payment

Fields

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 payment");
while ($resRow = $results->fetch_assoc())
{
 $subscriptionid = $resRow["subscriptionid"];  //
 $parentid = $resRow["parentid"];  //
 $paymenttype = $resRow["paymenttype"];  //
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $sid = $resRow["sid"];  //
 $pid = $resRow["pid"];  //
 $amount = $resRow["amount"];  //
 $pdate = $resRow["pdate"];  //
 $did = $resRow["did"];  //
 $iid = $resRow["iid"];  //
 $ptype = $resRow["ptype"];  //
 $transactionid = $resRow["transactionid"];  //
 $company = $resRow["company"];  //
}

Other Billing Tables

billing     cancellations     nextbill     payment     paymentprocessor     paymentprocessorsetup     paymentprocessorvariables     paymentprocessorvars