Set locale information. PHPMaker uses localeconv() which returns data based upon the current locale as set by setlocale().

Locale names can be found in RFC 1766 and ISO 639. Different systems have different naming schemes for locales.

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)

The default date format for the scripts. Possible values are:

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

with or without time (hh:mm:ss). The selected date format also determines the date separator ("/" or "-" or ".").

Enable multi-language project. If enabled, a combobox will appear on the top of the generated scripts for user to select langauge. 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 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 langauge file (english.xml) is shipped with PHPMaker. 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.

Upload folder - The global folder where the uploaded files resides. If you do not enter a specific folder for a file upload field in the Edit Tag panel of the Field Setup page, all the uploaded files will be put in this folder.

Important note:

1. Unlike the field specific upload folder setting (which is a PHP expression), this field specific setting must be a constant string (without double quotes). If you want dynamic upload folders for different fields, use the field specific upload folder setting instead.
   
   
2. Make sure that the Web server user have read/write access to the folder. You can right-click the folder in Windows Explorer and add read/write access for IUSR_<MachineName> on the Security tab.
   
   
3. The path is relative to application root. Use slashes "/" as path delimiter, no leading slash. e.g. If the application root of your website is C:\Inetpub\wwwroot\demo and you enter "uploads/" in this textbox, the folder for the uploaded files will be C:\Inetpub\wwwroot\demo\uploads. If you are not sure which folder is application root, please read Application Root.

Max File Size - Maximum file upload size in bytes. If <= 0, there is no checking on file size.

Note: File upload also depends on your PHP, web server and database configuration:

1. PHP
Check your php.ini, related configurations are file_uploads, upload_max_filesize, upload_tmp_dir, post_max_size and max_input_time, memory_limit, max_execution_time directives in php.ini

2. Apache
If you use Apache web server, check LimitRequestBody directive.

3. MySQL
Check the max_allowed_packet setting in your MySQL configuration.

Allowed file type - The allowed file extensions of the uploaded files. Separate the file extensions (without ".") by comma, e.g. gif,png,png)

Note: If blank, all file types are allowed.

Delete file on update/delete - Option to delete the uploaded file when the field value is replaced, removed or if the record is deleted.

You can choose to log activities in a log file or in a database table.

Log file folder - The folder where the audit trail log file resides.

Important note:

1. Make sure that the Web server user have read/write access to the folder.
   
2. The path is relative to application root. Use slashes "/" as path delimiter, no leading slash. e.g. If the application root of your website is C:\Inetpub\wwwroot\demo and you enter "uploads/" in this textbox, the folder for the log file will be C:\Inetpub\wwwroot\demo\uploads. If you are not sure which folder is application root, please read Application Root.

Use database table - Log the activities in the specified table instead of log file. The table must have the following fields: (actual data types depend on database type)

• DateTime (DateTime)
• Script (VarChar)
• User (VarChar)
• Action (VarChar)
• Table (VarChar)
• Field (VarChar)
• KeyValue (Long VarChar)
• OldValue (Long VarChar)
• NewValue (Long VarChar)

You can create the database yourselves and select the table in the combobox, then click the [...] button to select the fields in your table. Alternatively, if you have not created the table yet, you can click [Create Table] and let PHPMaker creates the table and setup the settings for you.

Track login/logout activities - If security feature is enabled, login/logout activities will also be logged.

Server-side - Enable server-side form validation.

Client-side (JavaScript) - Enable client-side form validation.

Note: If the available validation format in the Edit Tag panel (see Field Setup) does not fulfil your requiements, you can use your own server-side and/or client-side validation code using Sever Event and Client Scripts.

Enable export in List page - allow export in List pages

Enable export in View page - allow export in View pages also

Print/CSV/HTML/Excel/Word/XML/Email/PDF - Records can be exported to Print (printer-friendly), CSV, HTML, Excel, Word, XML, PDF format or sent as HTML email content.

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. By default export is only enabled in View page. If you want to enable it in the List page also (the number of records to be exported is not large), you can set the advanced settings of the extension (see Tools -> Extensions).
4. The extension supports images (jpg, gif and png only), but a temporary 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.

Note that the fields in printer friendly version are same as in List/View page, while the fields in other format are determined by the Export setting of the field in Field Setup page.

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

• All Pages - Records in all pages are exported
• Current Page - All records in current page are exported
• Selected Record - If selected, a checkbox will be displayed in each row for selection. Only selected records in the current page are exported. (Selecting records in different pages is not allowed.) To select records primary key is required, Current Page export type will be used for tables without primary key.

Note: If Email, the user can select sending the records as URL or HTML. If sending URL only, note that the recipient will need to click the URL and go to your site to view the records. All security settings will apply, the recipient may need to login. If the recipient is not an user of your website and your page is protected, you should send by HTML only.

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 .php), PHPMaker 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.

Notes:

1. Binary data (BLOB fields) cannot be exported.
2. Export to HTML/CSV/XML are not applicable to reports.
3. Images cannot be exported to Word/Excel/CSV/XML.
4. Export-to-XML requires PHP DOM (part of PHP 5 core).
5. Export-to-Word/Excel works by exporting data in HTML format for Word/Excel to convert/import, the exported file is not .doc/.xls format.

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.

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

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

Email address of the sender of all emails

Email address of the recipient(s) for notification emails when a record is added/edited/deleted (if enabled, see Table Setup). If there are multiple recipients, separate them by comma.

Protocol used by the SMTP server. Possible values are: SSL or TLS.

Note: Leave this setting empty if your SMTP server does not use such security protocols.