Cross DataBase Fields
Condor Informatique
- Turin
A PHP object for creating an HTML table or a matrix of crossed fields of a SQL Database table
The cells obtained can contain the count or a function on a third field.
The Database is accessed via PDO and has been tested whit MySql and SQLite.
Data choice
Product
Seller
Town
Rows
Label
Product
Seller
Town
Columns
Label
Count
%
SUM
% SUM
% ROWS
% COLS
AVERAGE
MIN
MAX
FIELD
Operation on field
Qty
Price
Sold
Town
label
Where Clause
Data presentation
Table
Title
Decimals
If empty
Decimal point
Thousands separator
Table without style
Call Back demo