invoices Database Table

Table: invoices

Tool: Store
Associated Objects: Invoice, Invoices

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

details TEXT NOT NULL v5

title VARCHAR(255) NOT NULL v5

clientemail VARCHAR(255) NOT NULL v5

totalprice DECIMAL(8,2) NOT NULL v5

added INT UNSIGNED NOT NULL v5

clientname VARCHAR(255) NOT NULL v5

paid BIT(1) NOT NULL DEFAULT 0 v5

clientid INT UNSIGNED NOT NULL DEFAULT 0 v5

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

shiptracking VARCHAR(100) NOT NULL v5

status TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

shipping DECIMAL(8,2) 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 invoices");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $details = $resRow["details"];  //
 $title = $resRow["title"];  //
 $clientemail = $resRow["clientemail"];  //
 $totalprice = $resRow["totalprice"];  //
 $added = $resRow["added"];  //
 $clientname = $resRow["clientname"];  //
 $paid = $resRow["paid"];  //
 $clientid = $resRow["clientid"];  //
 $tax = $resRow["tax"];  //
 $shiptracking = $resRow["shiptracking"];  //
 $status = $resRow["status"];  //
 $shipping = $resRow["shipping"];  //
}

Other Store Tables

invoicecart invoiceitems invoices productreviews shoppingcarts

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us