Table: payments

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 payments");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $amount = $resRow["amount"];  //
 $transactionid = $resRow["transactionid"];  //
 $billingagreementpayment = $resRow["billingagreementpayment"];  //
 $refunded = $resRow["refunded"];  //
 $receipt = $resRow["receipt"];  //
 $pid = $resRow["pid"];  //
 $invoice = $resRow["invoice"];  //
 $subscriptionid = $resRow["subscriptionid"];  //
 $approved = $resRow["approved"];  //
}

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