Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Ran Cole: "We bought the tool last week and want to say how much we love it. We've found it not only powerful, but very user friendly. We have used the tool to create an interface that manages our MySQL DB for different types of users".
Philipp Gerber: "

The product is so easy and super built that you can achieve visible and great success after a short time. Also very much possible with the product. A class product. I'm already looking forward to the next versions and extensions. Keep it up.

Support to the product is just perfect. Each Support request is quickly and very competent solved. Also various assistance, which does not fall into a support, are also perfectly processed. There is a direct wire to the manufacturer / developer and this is notth. Thanks for the class Support".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

OnGetCustomExportOptions

This event fires on exporting data from a database to a file. It allows you to customize some advanced export settings.

 

Signature:

function OnGetCustomExportOptions ($Page page, $exportType, $rowData, &$options)

 

Parameters:

$page

An instance of the Page class.

$exportType

The type of the result file. Possible values are "csv", "xls", "doc", "pdf", "xml".

$rowData

An associative array of values that corresponds to the currently processed row (for exporting a single row). NULL if a record list is exported.

$options

An associative array of options passed to the export engine (see below).

 

The list of supported options is as follows:

 

All export types

filename

The name of the output file.

 

Export to PDF

orientation

Page orientation. Possible values are "P" (portrait orientation) or "L" (landscape orientation). Default value is "P".

size

Size of the page. Possible values are A0 - A10, B0 - B10, C0 - C10, 4A0, 2A0, RA0 - RA4, SRA0 - SRA4, Letter, Legal, Executive, Folio, Demy, Royal, A (type A paperback 111x178mm), B (type B paperback 128x198mm). Default value is A4.

margin-left

Distance in mm from the left side of page to the left side of text.

margin-right

Distance in mm from the right side of page to the right side of text.

margin-top

Distance in mm from top of page to start of text (ignoring any headers).

margin-bottom

Distance in mm from bottom of page to bottom of text (ignoring any footers).

margin-header

Distance in mm from top of page to start of header.

margin-footer

Distance in mm from bottom of page to bottom of footer.

header

In any page header, '{PAGENO}' or '{DATE j-m-Y}' can be used - which will be replaced by the page number or current date. j-m-Y can be replaced by any of the valid formats used in the php

date() function.

 

The page number is the calculated number, taking regard of any resetting of numbering during the document.

html-header

Standard HTML code to define the header of pdf file. It can only be defined outside HTML block tags (except <body>).

footer

In any page footer, '{PAGENO}' or '{DATE j-m-Y}' can be used - which will be replaced by the page number or current date. j-m-Y can be replaced by any of the valid formats used in the php

date() function.

 

The page number is the calculated number, taking regard of any resetting of numbering during the document.

html-footer

Standard HTML code to specify the footer of pdf file. It can only be defined outside HTML block tags (except <body>).

 

Export to Excel

file-format

The format of the output file. Possible values are "xlsx" and "xls".

Default value is "xlsx".

engine

The engine to be used on data export. Possible values are "template" (template-based export) and "phpexcel" (to create native .xls files). Default value is "phpexcel". If you customize templates for export to Excel then you should use the "template" engine.

 

Example

This example shows how to customize the result file name according to row values. If a record list is exported, the file name is set to list.pdf (list.xml, list.xls, etc).

 

$options['filename'] = ($rowData ? $rowData['id'] : 'list') . '.' . $exportType;

 

Example

This example shows how to customize header, footer and margins of pdf file.

 

if ($exportType == 'pdf') {

 

  $options['header'] = '{DATE Y-m-d}';

 

  $options['footer'] = '{PAGENO}';

 

  $options['margin-top'] = 12;  

 

}



Prev Return to chapter overview Next