PHP Settings

 

General Options

 

Add shell call (For Unix-based server only) If you put the PHP parser binary somewhere outside of the web tree of files, for example, in /usr/local/bin, you will have to put a line similar to: #!/usr/local/bin/php as the first line of any file containing PHP tags. (You will also need to make the file executable.)
Set locale Set locale information. PHP Report Maker uses LC_ALL and localeconv(). localeconc() is for PHP 4 >= 4.0.5 only. For pre-4.0.5 versions, PHP Report Maker generated codes use the constants defined in phpmkrfn.php which you can find in the template and customize it to suit your needs.
No Cache Whether caching is required on browser
Use mysqli extension

Use mysqli extension instead of MySQL functions.

Notes:

  1. The mysqli extension is designed to work with PHP 5 and MySQL 4.1.3 or above,
  2. Both mysql and mysqli extension are not installed by PHP 5 by default. (See Introduction to PHP and MySQL)
Default Date Format yyyy/mm/dd, mm/dd/yyyy, dd/mm/yyyy,
yyyy-mm-dd, mm-dd-yyyy, dd-mm-yyyy,
yyyy.mm.dd, mm.dd.yyyy, dd.mm.yyyy
File folder

File folder for images, export-to-email, and email log file.

Notes:

  1. If you use export-to-email or email log to text file, you must grant write permission to this folder on your server so the script can write files in this folder.
  2. If you have field specific file folder, set it in the View Tag panel (see Field Setup).
Multi-Language

Enable multi-language project. If enabled, a combobox will appear on the top of the generated scripts for user to select language. See Tools for selecting languages for the multi-language project.

Important Notes:

  1. Multi-Language project must use utf-8 encoding. The charset of the project must be "utf-8".
  2. The data in your database must be stored in unicode, otherwise your data will not be displayed properly.
  3. If you have customized the template and put unicode characters in the template directly instead of using language files, enable the Advanced Setting UTF-8 output files (see Customizing Template and Tools).
Default Language

Default language of the project. It must be compatible with Charset (see HTML Settings). Default is English.

There is always one default language for a project. Only the English language. file (english.xml) is shipped with PHP Report Maker. If your project is single language but you use another language, create a language file for your language (see Customizing Template), put it in the "languages" subfolder under the installation folder and then select your default language using this combobox.

If you enable Multi-Language, you must select one of the selected languages as the default language.

Server-side validation

Enable server-side form validation for Extended Filter.

Note: If the available validation format in the Report Field Settings panel (see Field Setup) does not fulfil your requirements, you can use your own server-side validation code using Sever Event and Client Scripts.

Client-side validation

Enable Client-side (JavaScript) form validation for Extended Filter.

Note: If the available validation format in the Report Field Settings panel (see Field Setup) does not fulfil your requirements, you can use your own client-side validation code using Sever Event and Client Scripts.

 

Report Page Options (Global)

 

Records per page Number of records to be displayed on the list page of all tables. If blank or 0, default setting of 20 will be used.
Selectable page sizes Number of records to be selected by user. Comma separated values, e.g. 10,20,50,ALL.
Note: "ALL" (without quotes) is supported, other values must be integers.
Paging section style "NumericPages" or "NextPrev"
Sort type None, Single column or Multiple column. If Multiple column is selected, the generated list page supports multi-column sorting by Ctrl-clicking the table header.
Paging section at top Show the paging section at top
Paging section at bottom Show the paging section at bottom
Export

Records can export to HTML, Excel, Word, PDF or Email. HTML format is used as a printer friendly version. Note that If the report contains charts, the charts can NOT be exported to Word, Excel and PDF, only report data can be exported.

Notes for Export to PDF:

  1. The extension is an experimental extension only. There are known issues, see Third-party Tools and read the note in the extension setup page (see Tools -> Extensions) for more information before use. Only enable it if necessary.
  2. The extension performs best if you are using non-unicode alphanumerical characters (e.g. iso-8859-1) only. If you use unicode, configure advanced settings for the extension, read the note in the extension setup page (see Tools -> Extensions) for more information.
  3. The extension supports images (jpg, gif and png only), but a temp folder is required during export, the extension uses the Upload folder (see File Upload above) because write permission for the folder should be already setup properly. If you do not use file upload to folder, but you use export to PDF with images, then make sure you still specify an upload folder and set up the write permssion.

Notes for Export to Email:

  1. When exporting to Email, the user can select sending the records as URL or HTML. If sending as URL, note that the recipient will need to click the URL and go to your site to view the records. The exported page is stored in the File Folder specified above.
  2. If sending as HTML and the report contain charts, the chart still needs the Flash file (.swf) to plot the data, the .swf file is retrieved from your site, so the user must be online in order to view the charts. If you are a registered user and are using the FusionCharts extension, when you open the exported report in the email attachment, you may get Flash player security warning message if Flash chart is used, so by default JavaScript chart will be used for export.

Export type - Determines what to export. The follows are supported:

  • All Pages - Records in all pages are exported
  • Current Page - All records in current page are exported

Known Internet Explorer issue:
For known MIME (Multipurpose Internet Mail Extensions) types such as Microsoft Word ("application/ms-word"), the default behavior of some older versions of Internet Explorer is to open the document in the browser. Also, to allow user saving the file with a proper file extension (otherwise the file extension will be your output file extension, e.g. .php), PHP Report Maker uses content-disposition header to override this behavior by default. For example:
header("content-disposition","attachment; filename=fname.ext")
When Internet Explorer receives the header, it raises a File Download dialog box. However, if user clicks [Open], Internet Explorer may fail to open the file. Therefore, you may want to instruct user to save the file directly to the user's disk without opening it in the browser.

 

Email Settings

 

SMTP server

The host name or IP of the SMTP server.

Note: Some servers do not support "localhost" as SMTP server, in such case you need to specify a valid SMTP server in the network.

 

SMTP server port Port number of SMTP server. Default is 25.
SMTP server username

User name for SMTP server authentication. If your SMTP server does not require authentication, leave it blank.

SMTP server password

Password for SMTP server authentication. If your SMTP server does not require authentication, leave it blank.

Note: PHP Report Maker use PHPMailer to send email, make sure you upload the subfolder "phpmailer" generated in the destination folder.

 

 

 

 ©2007-2011 e.World Technology Ltd. All rights reserved.