Home

Form Processor Pro v5 User Manual - Web-Site

1. 2000 2008 email form com TM All rights reserved 96 Form Processor Pro v5 User Manual The following characters are recognized in the dat e_format modifier Sun j Day of the month without leading zeros 1 to 31 l q Sunday SC A full textual representation ofthe day ofthe week through L Saturday 1 for N ISO 8601 numeric representation of the day of the week Monday allowed in PHP 5 1 0 through 7 for Sunday st nd rd or A English ordinal suffix for the day ofthe month 2characters th Works well with j 0 for Sunday w Numeric representation of the day of the week trah 6 Cort Saturday S The day of the year starting from 0 EE Week SE Example 42 w ISO 8601 week number of year weeks starting on the 42nd Monday allowed in PHP 4 1 0 week in the year Mont ___ h A full textual representation of amonth suchas January or January F through March December 2000 2008 email form com TM All rights reserved Modifiers 97 The following characters are recognized in the dat e_format modifier m Numeric representation of a month with leading zeros SS KN M A short textual representation of a month three letters aie n Numeric representation of amonth without leading zeros 1 through 2 t Number of days in t
2. 31 6 2 If condition If condition allows selecting the data output depending on some condition of user entered parameters Template ifcond exprl expr2 expr3 This expression evaluates and prints result of expr2 if expr1 evaluates to TRUE and expr3 if expr1 evaluates to FALSE You can use lt and gt symbols in the expr1 expression Left and right delimiters for aren t being used inside ifcond operator Note that spaces must be placed like in the example Example ifcond Numberl gt Number2 Numberl 10 Number2 Let s say we have Number 20 and Number2 5 Then Number is greater than Number2 expression Number1 gt Number2 is TRUE and we print Number 10 this equals 30 Result 30 2000 2008 email form com TM All rights reserved Advanced Features 113 6 3 Switch function Switch function allows you to output custom message depending on the user input It simplifies some cases when you can use If condition It should be used if you have radio buttons dropdown menus and multiple lists and on one hand want to leave field values short and simple and on the other hand want to output human readable text depending on user s choice Template sw field_name field_values_separated_by_commas output_strings_separated_by_commas Example Which way do you want to travel lt lab
3. 2000 2008 email form com TM All rights reserved 122 Form Processor Pro v5 User Manual Message Body Text in free form Either plain text or HTML formatted text Note File generation is only available in the following licenses Business World Wide ISP 6 6 5 CSV Return auto generated CSV comma separated values file Syntax Attachment SFORMFILE CSV Example Email template To recepient somehost com From sender somehost com Subject This is an email subject Attachment FORMFILE CSV Message Body Text in free form Either plain text or HTML formatted text 6 7 Error Message Block You may output error messages block in any position you wish Use a special parser tag 2000 2008 email form com TM All rights reserved Advanced Features 123 to doit lt FPP_ERROR gt In case of error or improper user input it will be replaced by error message To tune its view see custom error reporting section of this manual 6 8 Allow Deny access to form by IP or Host You can allow or deny access to a certain form from certain IP subnet or host You should use these settings in config php file for certain form or global 6 8 1 AllowIP You may allow some users to submit your form only by setting their IP addresses or address ranges Examples allow_ip 12
4. setting The following characters are recognized in the time_format setting Neie Example garde Description returned ter values Time m a Lowercase Ante meridiem and Post meridiem am or pm A Uppercase Ante meridiem and Post meridiem AM or PM B Swatch Internet time 000 through 999 g 12 hour format of an hour without leading zeros 1 through 72 G 24 hour format of an hour without leading zeros Othrough 23 h 12 hour format of an hour with leading zeros 01 through 72 H 24 hour format of an hour with leading zeros 00through 23 i Minutes with leading zeros 00 to 59 2000 2008 email form com TM All rights reserved Advanced Features 131 The following characters are recognized in the time format setting S Seconds with leading zeros O0through 59 u Microseconds allowed in PHP 5 2 2 Example 54321 Timezo We ne Examples UTC e Timezone identifier allowedin PHP 5 1 0 GMT Atlantic Azores I 1ifDaylight capital Whether or note date isin daylight saving time Saving Time 0 i otherwise DEN Example O Difference to Greenwich time GMT in hours 0200 P Difference to Greenwich time GMT with colon Example between hours and minutes allowed in PHP5 1 3 02 00 SC Examples EST T Timezone abbreviation MDT Timezone offsetin seconds The offset fortimezones 43200through Z west of UTC is always negative
5. Form Processor Pro Form Processor Pro v5 User Manual 2000 2008 email form com TM All rights reserved Form Processor Pro v5 User Manual Table of Contents Foreword 0 Part Introduction 7 1 System Requirements sn ssnnennnrnnnnnnennneennnnnnnnnnns 7 2 Package Contents sccesseceseeceeseeeeeneeeeseecesseeeenseeesseeeenseeeeneanenseeeesseeesnsenenseneeneeneeneenes 8 3 HOW IT WOrKS E E Rued ee ee nes 10 4 What s New In ND eege heEe ni ann gti an tente munie nest ins rete 12 Part Il FPP Basics 16 1 How to get Started eseu deeg 16 2 INStANAtOn A EE bss T avs ashes sacetead csbaadh cs sadetecdechaadeszecdet acct 16 3 Initial Configuration Script sense 18 4 What is actions validations etc sscecceceesseseesssenceeseeeeessnsnsecaeeseeeeesenensenaaes 19 5 Setting up My First Form ccsccccsseeceseeeeseeeeeeneeseeeeeseceeseeeneneeseeeeeseeesneeeeeseeeeeneeeenes 19 1st Step Creating contact form with HTML editor 2nd Step Configuring the form escessseseeeeees 3rd Step Configuring Thank you page neuen 4th Step Preparing Email templates ui isniririnrrnnns 5th Step Configuring config php Summarizing configuration 6 Configuration File Overview sn sesnnnennennnnennss T Templates Syntax seruan daenna ie aE nn ee es 39 8 Custom error reporting mi nnnnnnnnnnnnnnnnnnnnss 40 Part Ill Field Validations 43 Field Validations OVervieW ssssscccecees
6. city street phone from the database record which contains user s name and surname If record with such name and surname doesn t exist the error message after sign will be shown and form will not go to edit page If record was loaded user will go to edit page with editable fields filled with information from the database When user submits edit page second MySQL query runs and updates record in the database Note MySQL database queries support is available in the following licenses Business World Wide ISP only 4 8 Payment Gateways Payment gateway actions help you to create shopping carts If your form has this action user will be redirected to the payment checkout system after submission 4 8 1 PayPal Redirects form applicants to PayPal checkout Require arguments 3 variables First sets your PayPal business name second sets item to be sold name third item s price in U S dollars Example 2000 2008 email form com TM All rights reserved Actions 83 paypal_checkout user domain com My special product 30 95 Note PayPal payment gateway support is only available in the following licenses Business World Wide ISP 4 8 2 2Checkout Redirects form applicants to 2Checkout checkout page Required arguments first 4 variables SID is your 2CO s vendor id SID total total amount or purchase You can use mathematical_ calculati
7. 2000 2008 email form com TM All rights reserved 120 Form Processor Pro v5 User Manual And you will receive email with attached PDFs with data submitted Example Email template To recepient somehost com From sender somehost com Subject This is an email subject Attachment FORMFILE_PDF_TABLE Message Body Text in free form Either plain text or HTML formatted text Note File generation is only available in the following licenses Business World Wide ISP 6 6 3 XLS Returns Excel auto generated file all data in one row Syntax Attachment FORMFILE XLS Example 2000 2008 email form com TM All rights reserved Advanced Features 121 Email template Message Body Text HTML formatted text To recepient somehost com From sender somehost com Subject This is an email subject Attachment FORMFILE_XLS in free form Either plain text or Note Wide ISP File generation is only available in the following licenses Business World 6 6 4 XLS with Table view Returns Excel auto generated file all data in a table Syntax Attachment FORME Example Email template L E_XLS_ TA E To recepient somehost com From sender somehost com Subject This is an email subject Attachment FORMFILE_XLS_TABLE
8. VALID 0146708912 01 46 70 89 12 0146708912 INVALID 01 46708912 0146708912 33235256677 3 2 13 german_postcode fields Validate German postal codes PLZ or Postleitzahlen VALID 12556 01550 80796 INVALID 05234 8973 62980 2000 2008 email form com TM All rights reserved 50 Form Processor Pro v5 User Manual 3 2 14 icd9 code_fields ICD9 code validation VALID E123 123 0 045 23 INVALID b123 3456 0 3 2 15 image file fields Validate image file names VALID picture jpg picture gif INVALID picture doc picture zip 3 2 16 int fields Validate integer numbers VALID 0 5 7 INVALID 12 23 ABC 2000 2008 email form com TM All rights reserved Field Validations 3 2 17 ip fields Validation of the format of IP Addresses 51 VALID 127 0 0 1 255 255 255 0 192 168 0 1 INVALID 1200 5 4 3 abc def ghi jkl 255 foo bar 1 3 2 18 ipv6 fields Match full and compressed IPv6 addresses as defined in RFC 2373 VALID FEDC BA98 7654 3210 FEDC BA98 7654 3210 1080 8 800 200C 417A FFFF 129 144 52 38 INVALID FEDC 7654 3210 BA98 7654 3210 FEDC BA98 7654 3210 3 2 19 isbn fields Validate ISBN number VALID 0930289234 1 56389 668 0 2000 2008 email form com TM All rights reser
9. 8 28 nn ENEE EE EE le OO TE uk_bsc_fields i uKk driver licens fields eessen k nin fields e ne tnt in nn entente Ae EEN k postcode fields nn unes den na ne een sde sens T a oem ages en en ins IV EE UC Phone OC E US State UE E vat MUM E E VIN CT EE weekday_fields r Word RT TE year E TE EIS E Zip tles E TE 3 File extensions allowed for upload Part IV Actions 65 1 Actions Overview in eees ene ceeeneeeeeeenseeeceeeneeaeeseneeneceesnenaeesenseeeeeeenenaees 65 2 Email Sending Action 66 3 HTML email Overview 69 4 Auto generated Email 73 5 Log submissions to file nes 74 6 Database Storage is EE A 75 OC Den RS 75 PostgreSQL 76 ER EE 77 Giel 78 ODBC Eee SR Eee EEE 79 Database Select Queries snnnnnennenns 80 8 Payment Gateways isninneennennnnennnennnennnnnennnnennnnnennnnnnns 82 PayPal e reae korenaar aeaaeae aoee iaeiae aeea aaae ra par raaraa Sa Eara ea a a oo Kea ekee aP aade oak K Ra ea arii 82 PAE 1 LEVEL C0 11 i ERP E P E E T E ET 83 LinkPoint aset 84 2000 2008 email form com TM AN rights reserved A Form Processor Pro v5 User Manual CR File ur TE 85 10 Simple Redir ct ctenacdeecateeees cdenaedeecaterens cdenacdeecatescens 86 TA CIE 86 12 Password Generation cccsssssccseseesesseesnnsneeceeecessessnncncecoeesesseseennnncneeecees
10. Template article article upper spacify SES article lower spacify truncate article lower truncate 30 spacify 2000 2008 email form com TM All rights reserved Modifiers 109 article lower spacify truncate 30 Output Smokers are Productive but Death Cuts Efficiency SMOKERS ARE PRODUCTIVE BUT DEATH CUTS EFFICIENCY smokers are productive but death cuts smokers are productive but smokers are p 2000 2008 email form com TM All rights reserved Advanced Features 111 6 6 1 Advanced Features Mathematical calculations Furthermore you may do some math and calculation by using Form Processor Pro Just make sure you have separated all variables and signs by a white space That s the only one rule Example You have three text input fields lt input type text name field_a gt lt input type text name field_b gt lt input type text name field_c gt You can use following expression on the next form page in the database template log file template or email template Template field a field_b field ci Let s say you enter following numbers into those fields Into field_a 2 Into field_b 5 Into field_c 7 Result 2000 2008 email form com TM All rights reserved 112 Form Processor Pro v5 User Manual
11. the exact character length pass the optional third parameter of true Example Input Two Sisters Reunite after Eighteen Years at Checkout Counter Template article truncate 30 true Output Two Sisters Reunite after E 5 2 18 upper This is used to uppercase a variable Example 2000 2008 email form com TM All rights reserved Modifiers 107 Input John Smith Template name upper Output JOHN SMITH 5 2 19 wordwrap This wraps a string to a column width default is 80 As an optional second parameter you can specify a string of text to wrap the text to the next line default is carriage return n By default wordwrap will attempt to wrap at a word boundary If you want to cut off at the exact character length pass the optional third parameter of true Example Input Blind woman gets new kidney from dad she hasn t seen in years Template article wordwrap 30 n true 2000 2008 email form com TM All rights reserved 108 Form Processor Pro v5 User Manual Output Blind woman gets new kidney from dad she hasn t seen in years 5 3 Combining modifiers You can apply any number of modifiers to a variable They will be applied in the order they are combined from left to right They must be separated with a pipe character Example Input Smokers are Productive but Death Cuts Efficiency
12. suitable human readable form to customer Log templates must have the filename to write to as the first line Everything after the first line will be appended tacked onto the bottom of the file specified Example for config php log_file log txt Example of the content for logging template DB or CSV file simple csv eMail Name Result simple csv file will contain such lines one email com namel two email com name2 You can open CSV file in MS Excel as simple spreadsheet Note Path to log file in log template is relative to log template file For example if they in the same folder it should be just name of log file If log template in folder public_html and log file is in folder public_html log then it should be log simple log 2000 2008 email form com TM All rights reserved Actions 75 4 6 4 6 1 Database Storage You may execute any database query after each form submission to save user input to your database MySQL Use mysql_query action to save data to MySQL database This action works with INSERT and UPDATE queries If you want to get data from MySQL database please use Database Select action Syntax mysql_query lt query gt query may be any valid MySQL query Example mysql_query INSERT INTO mytable name email VALUES name kemai Entities name and email
13. No scripts e g PHP ASP will be executed on the page If you use full URL e g http www yoursite com path file html Form Processor Pro will let webserver execute all server side scripts on the page and then will parse the form PHP option allow_url_fopen must be enabled to allow this behaviour Setting up validations In order to set Full Name Email and Subject fields as required we need to use required_fields validation rule and put all required field names here See below required_fields name Full Name email Contact Email subject Subject Please note that phrases in and brackets are just used in error messages instead of internal field names from HTML Thus your error messages can be intuitive user friendly and you can even use language other than English As we have already mentioned you can put validation rules as one field per line or write all in one string and separate field names by comma Thus required_fields nam Full Name email Contact Email subject Subject 2000 2008 email form com TM All rights reserved 36 Form Processor Pro v5 User Manual and required_fields name Full Name required_fields email Contact Email required_fields subject Subject Will have the same effect required form fields name email and subject In order to restrict only properly formatted emails
14. i otherwise heart Example O Difference to Greenwich time GMT in hours 0200 P Difference to Greenwich time GMT with colon Example between hours and minutes allowed in PHP 5 1 3 02 00 DE Examples EST T Timezone abbreviation MDT Z Timezone offsetin seconds The offset for timezones 43200through 2000 2008 email form com TM All rights reserved Modifiers 99 forma t Example charac Description returned ter values westof UTC is always negative and for those east of l D 50400 UTCis always positive Note Unrecognized characters in the format string will be printed as is 5 2 7 default This is used to set a default value for a variable If the variable is empty the given default value is printed instead Default takes one argument Example Input Template name default none Output none 2000 2008 email form com TM All rights reserved 100 Form Processor Pro v5 User Manual 5 2 8 indent This indents a string at each line default is 4 As an optional parameter you can specify the number of characters to indent As an optional second parameter you can specify the character to use to indent with Use t for tabs Example Input NJ judge to rule on nude beach Sun or rain expected today dark tonight Statistics show that teen pregna
15. string Example 2000 2008 email form com TM All rights reserved Language Settings 139 1 file p rmissions File Permissions should be in French 1 file_permissions File Permis Note You have to leave s signs and escape special characters e g to and to for the proper work of FPP5 Example Don t don t configure the MySQL server configure the MySQL server Change language value in the config file language fr 2000 2008 email form com TM All rights reserved FAQ 141 8 FAQ FAQ e Howto restore forgotten password to Initial Configuration Script e want to allow file download just after form submission How can I do that e How can allow only certain file extensions for user file uploading e Does Form Processor Pro have any API How can use it e My second form page preview has broken images styles How can fix this e Howto make selection box required to be selected e How to make checkbox choice and dropdown required e Howto make group of checkboxes with one line results in templates e How to allow server side scripts execution on form pages 8 1 How to restore forgotten password to Initial Configuration Script Unfortunately you can t restore your old password in Form Processor Pro because it is not saved in explicit form due to security reasons Instead you can
16. Finance News Chat Other 8 9 How to allow server side scripts execution on form pages You have full control over any server side script execution on form pages If you use relative or absolute path to file e g form file html or fpp form filename php Form Processor Pro will open it as a text file No scripts e g PHP ASP will be executed on the page If you use full URL e g http www yoursite com path file html Form Processor Pro will let web server execute all server side scripts on the page and then will parse the form Note PHP option allow_url_fopen must be enabled to allow server side scripts execution 2000 2008 email form com TM All rights reserved 150 Form Processor Pro v5 User Manual Suggestions and Tips e Protect email templates Store email templates in separate htaccess protected directories preventing them from outside browsing e Protecting form from bots and auto filler scripts In order to protect your form from automated submissions by bots and auto filler scripts you can use CAPTCHA feature It will include graphical image with certain symbols that only human can read and type into special verification field e Use absolute paths in HTML templates instead of relative You may store file with the first page of the form separately from other files You can easily store each HTML template in a different folder Therefore relative paths
17. a LOG D 3rd PARTY JE Excel XLS POF D io ABI d i TEXT 2 RICH TRANFER FORMAT EXTEND WITH AVE TO MS EXCEL FILE YOUR SOLUTION SELF DATAFILE CSV ZIP a COMMA SEPARATED SAVE ALL FILES VALUES FORMAT TO ARCHIVE 2000 2008 email form com TM All rights reserved 12 Form Processor Pro v5 User Manual 1 4 What s new in v5 Form Processor Pro v5 has completely redesigned core and workflow scheme Now there are no separate configuration files for every form created added There is only one configuration file responsible for global and local settings FPP v5 has several groups of features that help to process any form with very sophisticated requests These groups are e Validators validation rules responsible for validating user input e Actions actions that have to be done after form submission e Modifiers modifiers help to pre format user inputted data by certain modification rules Features list e Multilingual support e 40 field validations e 15 user input modifiers e Secured SMTP support e Security and spam protection o Spam Protection with CAPTCHA Spam Injection Prevention o Email harvesting protection 2000 2008 email form com TM All rights reserved Introduction 13 o SSL Support o Unique Submissions o Block IPs or Hosts o Allow only certain IPs and Subnets e Simplified configuration o One configuration file for FPP and forms
18. and for those east of f SC 50400 UTCis always positive Note Unrecognized characters in the format string will be printed as is 2000 2008 email form com TM All rights reserved 132 Form Processor Pro v5 User Manual 6 10 3 Fields List in HTML Return all form fields and their values in HTML format Example SFIELDS LIST HTML Result lt b gt Field1_Name lt b gt Field1_value lt br gt lt b gt Field2_ Name lt b gt Field2_value lt br gt 6 10 4 Fields List in Plain Text Return all form fields and their values in Plain Text format Example SFIELDS LIST PLAIN Result Field1_ Name Field1 Value Field2 Name Field2 Value 2000 2008 email form com TM All rights reserved Advanced Features 133 6 10 5 HTTP Referer Returns current forms URL Example SHTTP_REFERER 6 10 6 HTTP User Agent Return submitter s user agent OS Type amp Version Browser Type amp Version Example SHTTP_USER_AGENT Result Mozilla 5 0 Windows U Windows NT 5 1 en US rv 1 8 1 2 Gecko 20070219 Firefox 2 0 0 2 6 10 7 Remote IP Return submitter s IP address Example SREMOTE_ADDR Result 2000 2008 email form com TM All rights reserved 134 Form Processor Pro v5 User Manual 192 168 0 1 6 10 8 Time
19. applicants to provide you with correct email address on field named your_email Detailed syntax of major form validators configuration validator_name field_namel field title 1 field_name2 field name 2 Where validator_name the name of Form Processor Pro validator field_namet1 field_name2 the name of the fields on your form The exact name of HTML element Also you may use special field titles for your fields written in round brackets It will be shown up in error message if the field contains any errors or misspells otherwise field_name will be shown 2000 2008 email form com TM All rights reserved 44 Form Processor Pro v5 User Manual Examples for your good understanding 1 email fields email Email address 2 zip fields zip 3 required fields name First name zip email Email address By example 1 we require form applicants to input correct email address in field emai like and in case it wasn t an email address the error message will be generating Field Email address is not correct email address Example 2 we are checking zip code on field zip as you see it s not necessary to use field title in case of error the following message will be shown Field zip is not correct zip code Moreover you can set more than one field in one validation set Please refer to example 3 we set fields name zip and email as re
20. form name forml method post action gt Form tag after required corrections lt form name forml method post action http www mydomain com fpp index php enctype multipart form data gt If you use relative path in the action parameter and do not use Base href tag every page after first one must have action index php parameter lt form name forml method post action index php gt 2000 2008 email form com TM All rights reserved FPP Basics 25 That s all for the FORM tag Now we need to give a unique name to our form let s name it contact_form We can do this by inserting HIDDEN field just after the FORM tag with the name fpp_form and value contact_form Like this lt input name fpp_ form type hidden value contact_form gt Note In form names you can use only letters numbers underscore and dash characters Corrected HTML Code with highlighted changes lt html gt lt head gt lt title gt My Contact Form lt title gt lt head gt lt body gt lt h3 gt My Contact Form lt h3 gt lt p gt required fields lt p gt lt table width 300 border 0 gt 2000 2008 email form com TM All rights reserved Form Processor Pro v5 User Manual lt tr gt lt td gt lt div align right gt Full Name lt div gt lt td gt lt td gt lt input type text name name
21. get a brand new one To do that you need to follow these steps 1 Go to the Initial Configuration Script page e g www yoursite com fpp install index php 2 Click on Login button 2000 2008 email form com TM All rights reserved 142 Form Processor Pro v5 User Manual 3 Click on Forgotten Password link 4 Enter e mail address that you used during installation 5 Receive an e mail with your new password 8 2 want to allow file download just after form submission How can do that As well as page you may output any file stored on your server Use action file instead of page This is very useful in case you want to gather some information prior allowing downloading certain file Example of config php page index html page preview html file usr home secured area secretfile zip In the example above Form Processor Pro will output the file secretfile zip after preview page 8 3 How can allow only certain file extensions for user file uploading Set allowed file extensions for uploaded user files in file_filter_fields 2000 2008 email form com TM All rights reserved FAQ 143 Syntax allowed_ files ext or allowed_files extl ext2 ext3 Example In your form lt input type file name attach gt Config file allowed_files gif bmp png file filter_fields attach Picture Result O
22. gt lt td gt lt tr gt lt tr gt lt td gt lt div align right gt Email lt div gt lt td gt lt td gt lt input type text name email gt lt td gt lt tr gt lt tr gt lt td gt lt div align right gt Phone lt div gt lt td gt lt td gt lt input type text name phone gt lt td gt lt tr gt lt tr gt lt td gt lt div align right gt Subject lt div gt lt td gt lt td gt lt input type text name subject gt lt td gt lt tr gt lt tr gt lt td valign top gt lt div align right gt Comment lt div gt lt td gt lt td gt lt textarea name comment rows 5 gt lt textarea gt lt td gt lt tr gt lt tr gt lt td valign top gt nbsp lt td gt lt td gt lt input type submit name Submit value Submit gt lt input type reset name Reset 2000 2008 email form com TM All rights reserved FPP Basics 27 value Reset gt lt td gt lt tr gt lt table gt lt form gt lt body gt lt html gt Note Please specify absolute paths in relative to Form Processor Pro b may use HTML tag lt BASE gt to spe all links images path of the action parameter etc on your form pages Otherwise all relative paths would be ut NOT to the page of your web site Or you cify base URL lt BASE HREF URL_TO_PAGI E gt If you have more tha
23. just like in the previous step We want to have all form fields to be included in our email So the email template that will be sent to us should look like this From emai Subject Con E In To info mydomain com 1 tact Form Filled P ormation Full Name Email ema Phone pho Comments comment Subject subject rom the Contact form name il ne Email template to us saved as email txt We create email template for the auto generated email to the form s submitter the same Way To email Dear name mydomain com From info mydomain com Subject Thank you for contacting Mydomain com You have submitted the following information to hy Name nam Comments comment Email email Phone phone Subject subject 2000 2008 email form com TM All rights reserved FPP Basics 31 Thank you for contacting us We will respond as soon as possible Sincerely Mydomain com Team Email template to client saved as autoresponder txt 2 5 5 5th Step Configuring config php Summarizing configuration We have configured our form thank you page and prepared required email templates Now in order to make final configurations we have to teach FPP how we would like our form to be processed To do so we have to e
24. steps you need to have Form Processor Pro installed on your web server and initial configuration should be completed Please refer to Installation section of this manual In this example we have a domain mydomain com and Form Processor Pro installed in the fpp public folder under www root In other words Form Processor Pro can be accessed through http www mydomain com fpp index php 2 5 1 1st Step Creating contact form with HTML editor We ve used Dreamweaver to create the form and we ve got the following form and auto generated HTML code 2000 2008 email form com TM All rights reserved 22 Form Processor Pro v5 User Manual My Contact Form required fields Full Name Pas Phone Subject Comment A Rese HTML Code of the Form Page lt html gt lt head gt lt title gt My Contact Form lt title gt lt head gt lt body gt lt h3 gt My Contact Form lt h3 gt lt p gt required fields lt p gt lt form name forml method post action gt lt table width 300 border 0 gt lt tr gt lt td gt lt div align right gt Full Name lt div gt lt td gt lt td gt lt input type text name name gt lt td gt 2000 2008 email form com TM All rights reserved FPP Basics 23 lt tr gt lt tr gt lt td gt lt div align right gt Email lt div gt lt td gt lt td gt lt input type te
25. such a configuration after user filled the form on index html he she will see parsed preview html page and after that thank you html However action s argument can be a template tag and depends on submitted data Like page page_from_form In this case forms applicant will see the page which name was submitted in page from Form field Action arguments may be very different depends of action it does It may be set of field names SQL query path to template etc 2000 2008 email form com TM All rights reserved 66 Form Processor Pro v5 User Manual 4 2 Email Sending Action Process email templates and send emails Parameter Path to the template file Example email somedir email txt Email templates should have the following format To recepient somehost com From sender somehost com Subject This is an email subject This is an email body Note There is an empty line before email body and no empty lines between headers So first of all you have to set correct headers The required headers are To From and Subject Additionally you can add 2000 2008 email form com TM All rights reserved Actions 67 Cc carbon copy Bcc blind carbon copy Format sets email format HTML or plain plain by default Charset sets email charset ISO 8851 UTF 8 etc Attachment user
26. will be changed to user submitted data on name and email field To set MySQL hostname username and password use the following settings in your config php file mysql_host MySQL hostname mysql_user MySQL username mysql_password MySQL password mysql_db the name of MySQL database to be used 2000 2008 email form com TM All rights reserved 76 Form Processor Pro v5 User Manual 4 6 2 These settings are common for for all forms and must be set in the first section of config php before form configuration blocks Note MySQL database storage support is available in the following licenses Business World Wide ISP only PostgreSQL PostgreSQL query executor Syntax pgsql_query lt query gt lt query gt is any valid PostgreSQL query Example pgsql_query INSERT INTO test name email VALUES name email Additional settings pgsql_ host PostgreSQL hostname pgsql_user PostgreSQL user pgsql_password PostgreSQL password pgsql_db PostgreSQL database name 2000 2008 email form com TM All rights reserved Actions 77 Note PostgreSQL database storage support is available in the following licenses Business World Wide ISP only 4 63 MS SQL Microsoft SQL query executor Syntax mssql_query lt query gt Where lt query gt is any valid Microsof
27. 111111111 3 Card expire month e g 10 4 Card expire year e g 07 5 Amount to charge e g 39 95 Also you should put your PEM file to tmp directory Example linkpoint_checkout 1234567 card_num 2000 2008 email form com TM All rights reserved Actions 85 card_exp_month card_exp_year 40 00 Note LinkPoint payment gateway support is only available in the following licenses Business World Wide ISP 4 9 File Output As well as page you may output any file stored on your server Use action file instead of page This is very useful in case you want to gather some information prior allowing downloading certain file Example of config php page index html page preview html file usr home secured area secretfile zip In the example above Form Processor Pro will output the file secretfile zip after preview page 2000 2008 email form com TM All rights reserved 86 Form Processor Pro v5 User Manual 4 10 Simple Redirect Allows you to redirect form applicants to predefined URL Example page index html redirect http somesite com 4 11 Referers Referrers is the feature that denies access to you Form Processor Pro from domains that is not listed This feature is optional If it is set up form can be submitted only from specified domains Example referers www yourdomain com local
28. 2 4 Does Form Processor Pro have any API How can I use it ssssssesunsennnennrennnee 143 5 My second form page preview has broken images styles How can fix this 144 6 How to make selection box required to be selected c ssccsesseteeeeseeeees 145 7 How to make checkbox choice and dropdown required sssssseeeeseeees 145 8 How to make group of checkboxes with one line results in templates 146 9 How to allow server side scripts execution on form pages sssseeeeeeeeeees 148 Part IX Suggestions and Tips 150 Part X Support Information 152 Index 0 2000 2008 email form com TM All rights reserved Introduction 7 1 1 1 Introduction System Requirements Form Processor Pro 5 x is being offered in PHP version only PHP available on most Windows and Unix compatible platforms web servers Form Processor Pro has standard requirements for PHP scripts In other words normally you do not have to install any additional software to get Form Processor Pro working To run Form Processor Pro v5 you must meet the following requirements e PHP 4 3 0 or higher e Standard mail function SMTP Secured SMTP or Sendmail In addition we have created special Form Processor Pro test script that you can upload to your server in order to check general Form Processor Pro compatibility and availability of special features that depend on PHP configuration on your host In order to
29. 3 i 2000 2008 email form com TM All rights reserved Advanced Features 117 Example 2 Count how many cities are filled count fields city_count city 0 3 i This will set variable city_count to6 Example 3 Count how many people are aged 18 count_fields count_agel8 age 0 3 i 18 This will set variable count_agel8 to3 Example 4 Count how many people are aged 18 and filled their name count_fields count_namel8 name 0 3 i age 18 This will set variable count_name18 to2 Example 5 Count how many people are from washington are 21 and filled their name count_fields count_name_washington21 name 0 3 i age 21 city Washington 2000 2008 email form com TM All rights reserved 118 Form Processor Pro v5 User Manual 6 6 6 6 1 This will set variable count_name_washington21 tol As you can see each example contains the same regular expression structure Let s see how it works name 0 3 i and are used like brackets to set where regular expression starts and ends name is a part of field name that remains unchanged In our example there are three of them name age city 0 3 isan expression that captures any string with length up to 3 It allows to capture such fields as name1 name6 nameaaa nametjz name134 in our example but ignore such fields as name_of_person
30. 3 45 67 8 This will allow all users with IP 123 45 67 8 to submit your form allow_ip 123 45 This will allow all users with IP range 123 45 0 0 to 123 45 255 255 to fill your form allow_ip 123 45 67 123 55 77 88 2000 2008 email form com TM All rights reserved 124 Form Processor Pro v5 User Manual 6 8 2 This will allow all users with IP 123 55 77 88 and on range 123 45 67 0 to 123 45 67 255 Denied IP You may deny some user to submit your form by setting their IP addresses or address ranges Examples denied_ip 123 45 67 8 This will deny all users with IP 123 45 67 8 to submit your form denied_ip 123 45 This will deny all users with IP range 123 45 0 0 to 123 45 255 255 to fill your form denied_ip 123 45 67 123 55 77 88 This will deny all users with IP 123 55 77 88 and on range 123 45 67 0 to 123 45 67 255 6 8 3 Denied Address Works exactly as denied_ip but hosts specifically by their names instead of IP address Examples denied_addr someone domain com This will deny all users came from someone domain com address denied_addr edu 2000 2008 email form com TM All rights reserved Advanced Features 125 This will deny all users with domain edu to fill out your form 6 9 Zip Feature You can apply file2zip modifier to a file name variable to receive for example a zipped archive of this file It s ver
31. 91 5 Modifiers 5 1 Modifiers Overview Modifiers used in order to perform certain transformations with user input prior inserting result into template or generating output Variable modifiers can be applied to any variable in a template tag To apply a modifier specify the value followed by the pipe and the modifier name A modifier may accept additional parameters that affect its behaviour These parameters follow the modifier name and are separated by colon and quoted by double quotes Examples tit tit le upper le truncate 40 tit el lower First example uppercases the value of title variable Second truncates it to 40 characters and add 5 2 Modifiers This cha 5 2 1 capitalize This is u at the end of string and the third makes the title value lowercased Reference pter includes complete reference of Form Processor Pro modifiers sed to capitalize the first letter of all words in a variable 2000 2008 email form com TM All rights reserved 92 Form Processor Pro v5 User Manual Example Input john smith Template name capitalize Output John Smith 5 2 2 count_characters This is used to count the number of characters in a variable Example Input john smith Template name count_characters 2000 2008 email form com TM All rights reserved Modifiers
32. ALID 55127 55127 1234 INVALID D11 501 555 3 2 49 zip files fields Zip archive files validation VALID secret zip INVALID file doc 2000 2008 email form com TM All rights reserved Field Validations 63 3 3 File extensions allowed for upload Set allowed file extensions for uploaded user files in file filter fields Syntax allowed or allowed Example In your form les ext s extllext2 ext3 lt input type file name attach gt Config file allowed_files gif bmp png file filter_fields attach Picture Result Only gif bmp png files would be allowed for user upload 2000 2008 email form com TM All rights reserved Actions 65 4 4 1 Actions Actions Overview The main purpose of Form Processor Pro is to perform some actions and process submitted data In form configuration file you can specify the sequence and number of required actions such as sending one or several emails database queries redirects etc Like a validator each action has a name and custom parameters Parameters arguments can be static as well as dynamic that depends on submitted data Basicactions The very basic action is page It used to set the sequence and names of your form pages Example page index html page preview html page thank you html With
33. Output 5 2 3 count_paragraphs This is used to count the number of paragraphs in a variable Example Input This is a test paragraph The next paragraph Template article count_paragraphs Output 5 2 4 count_sentences This is used to count the number of sentences in a variable 93 2000 2008 email form com TM All rights reserved 94 Form Processor Pro v5 User Manual Example Input His name is John Smith He is a good man Template ext count_sentences Output 5 2 5 count words This is used to count the number of words in a variable Example Input His name is John Smith He is a good man Template text count_words 2000 2008 email form com TM All rights reserved Modifiers 95 Output 10 5 2 6 date format Returns a string formatted according to the given format string Use variable TIMESTAMP to get a timestamp Example Template STIMESTAMP date_format m d y Output 12 15 2006 You can also use characters from following tables to customize the date_format modifier The following characters are recognized in the dat e_format modifier Fa Example d ra Description returned cter values Day d Day ofthe month 2 digits with leading zeros O1 to 31 D A textual representation of a day three letters Monthrough
34. PLET gt e Frameset tag lt FRAMESET gt e Frame tag lt FRAME gt e IFrame tag lt e Comments lt lt FRAMESET gt FRAME gt lt FRAME gt comments gt Note It is advised to create email templates in plain text editor If you use some HTML editor like Dreamweaver or FrontPage make sure that it doesn t add these unwanted tags without notice Also there is some general advices for HTML mail 1 Use tables for layout 2000 2008 email form com TM All rights reserved Actions 71 Because of the very limited support of style sheets in webmail clients the best and safe way to layout your HTML email is to use tables 2 Use absolute urls for all your images and links Example lt img src http www example com images head gif width 20 height 60 gt lt a href http www example com products shoes tiger html gt Tiger lt a gt 3 Use simple style sheets that means not to use absolute or relative positioning This is bad supported by most webmail Don t use external or embedded style sheets because email programs are removing or ignoring everything between the lt HEAD gt lt HEAD gt That means the lt LINK gt tag won t work if you want to define external style sheets Use inline stylesheets for fonts font colors links background colors etc Example lt ta
35. a www yourdomain com fpp install index php URL Default password to Initial Configuration Script is admin You will change it during the installation 7 That s all Now you can create and configure your existing forms for processing with Form Processor Pro If you are newbie to Form Processor Pro please read Setting up My First Form To test your installation completeness simply open main Form Processor Pro file index php in your browser like this http www yourdomain com fpp index php If you see the message as on the picture below you ve successfully completed installation process and you can move to form configuration Otherwise you ll see error messages Thus further actions should be done according to these messages Most common and known problem is improper permission settings for attachments tmp directories and config php file These have to be writable Form Mail Email Form Processor Pro Script v5 If you see this message then Form Processor Pro correctly installed on your web server and your permissions on attachments and tmp directories are correct The latest version of Form Processor Pro script and documentation available from Web Site Scripts com Form Mail Email Form Processor Pro 2000 2007 Web Site Scripts com 2000 2008 email form com TM All rights reserved 18 Form Processor Pro v5 User Manual Note In order to set writable permissions in UNIX shell
36. able width 100 height 100 gt lt tr gt lt td bgcolor FFO000 gt lt table width 400 align center gt lt tr gt lt td gt Lorem ipsum dolor sit amet consectetuer lt td gt lt tr gt lt table gt lt td gt lt tr gt lt table gt 5 You have to specify the font font color and the font size for all the text and links in every table cell If you don t specify a style then most webmail clients will use their own style sheets This could result in displaying different fonts font colors and sizes and could also mess up your design Hotmail and Yahoo display Arial as the default font if you don t specify a font Gmail uses Verdana Hotmail uses a 11px as the default font size Yahoo uses 12px and Gmail uses 16px Example lt table width 400 cellspacing 0 cellpadding 0 gt lt tr gt lt td style font family Verdana sans serif font size lipx color black gt lt p gt lt a href http www example com link style font family Verdana font size 11px color blue gt Lorem lt a gt ipsum dolor sit amet consectetuer adipiscing elit lt p gt lt td gt lt td style font family Verdana sans serif font size 10px color black gt Vivamus ut sem Fusce aliquam nunc vitae purus lt td gt lt tr gt lt table gt 2000 2008 email form com TM All rights reserved Actions 73 6 The lt P gt tag in Intern
37. ages if check fails or incompliant data is submitted Modifiers used in order to perform certain transformations with user input prior inserting result into template or generating output e Afterward submitted data is being parsed according to field validations and rules required fields email field etc processed calculations and function calls All data gets parsed and processed by Form Processor Pro and now ready 2000 2008 email form com TM All rights reserved Introduction 11 for output Form Data Output According to variables and their values set in Configuration File Form Processor Pro sends an output to a web browser sends data by email and saves data to log files different types of databases CSV XLS PDF file formats or processes data to the payment gateways Also Form Processor Pro gives you an opportunity to archive files before sending or redirect all form data to another third party software page via GET request Combinations of those are possible You can define the output root in the Configuration file DEM mm SCHU E CONFIG FILE ROL OVER SIMPLE INI FILE wm DATABASE MYSQL El CALCULATIONS MS SQL EMAIL nsssssssssss MODIFIERS sssssssssse Ki POSTGRESQL PLAIN TEXT HTML VALIDATION RULES SQLLITE o e ee se PAYMENT FILE dd VA mee Ji PAYME ACCESS TO FILE gessasosssee FORM PROCESSOR PRO ee H LINKPOINT
38. ate_format setting The following characters are recognized in the date_format setting E Example chara Description returned cter values Day d Day ofthe month 2 digits with leading zeros O1 to 31 D A textual representation of a day three letters GE anole j Day of the month without leading zeros I to 31 l ewer Sunday oe A full textual representation of the day of the week through L Saturday 1 for N ISO 8601 numeric representation of the day of the week Monday allowed in PHP 5 1 0 through 7 for Sunday 2000 2008 email form com TM All rights reserved 128 Form Processor Pro v5 User Manual The following characters are recognized inthe date_format setting st nd rd or A English ordinal suffix for the day ofthe month 2characters th Works wellwith j 0 for i Sunday w Numeric representation of the day of the week throueh 6 ot Saturday z The day of the year starting from 0 oe Week Example 42 w ISO 8601 week number of year weeks starting on the 42nd Monday allowedin PHP 4 1 0 week in the year Mont ___ CH h A full textual representation of a month such as January or une F through March December m Numeric representation of a month with leading zeros SS Deeg M A shorttextual representation of a month three letters nc n Num
39. ble width 400 cellspacing 0 cellpadding 0 gt lt tr gt lt td style font family Verdana Arial Helvetica sans serif font size 10px line height 150 color red gt lt p gt Lorem ipsum dolor sit amet consectetuer adipiscing elit lt p gt lt td gt lt td style font family Verdana Helvetica sans serif font size 10px text transform uppercase color black gt Vivamus ut sem Fusce aliquam nunc vitae purus lt td gt lt tr gt lt table gt 4 Create your design with a white background color Most webmail and email clients use a white background color to display messages Often webmail clients ignore or remove the lt BODY gt tag which is why background colors often don t work When you do use a different background color than white you could mess up your design This could for example happen if you create your design for a red background Images may have a red background When viewed in a webmail client you most likely will see a white background and images with a red background that 2000 2008 email form com TM All rights reserved 72 Form Processor Pro v5 User Manual doesn t seamlessly integrate with the background color The best thing to do is to create your design with a white background color If you must use a different background color than white you can use a table with a 100 width and perhaps 100 height to simulate the background color Example lt t
40. character or string to insert Example Input John Template name spacify Output 2000 2008 email form com TM All rights reserved 104 Form Processor Pro v5 User Manual John 5 2 14 string format This is a way to format strings such as decimal numbers and such Use the syntax for sprintf PHP function for the formatting Example Input 2 43243252 Template num string_format 2 Output 2 43 5 2 15 strip This replaces all repeated spaces new lines and tabs with a single space or with a supplied string Example 2000 2008 email form com TM All rights reserved Modifiers 105 Input John Smith Template name strip Output John Smith 5 2 16 strip tags This strips out markup tags basically anything between lt and gt Example Input John lt b gt Smith lt b gt Template name strip_tags Output 2000 2008 email form com TM All rights reserved 106 Form Processor Pro v5 User Manual John Smith 5 2 17 truncate This truncates a variable to a character length default is 80 As an optional second parameter you can specify a string of text to display at the end if the variable was truncated The characters in the string are included with the original truncation length By default truncate will attempt to cut off at a word boundary If you want to cut off at
41. check your host with Form Processor Pro checkup script 1 Download Form Processor Pro test script here 2 Unpack downloaded zip file There is only one file in the package fpp test php 3 Upload or copy fpp test php to your public directory www 4 Open this script in your favorite web browser directly from the host by correspondent URL For Example You have a domain www mydomain com and you uploaded fpp test php script to your host by FTP so that it can be viewed through http www mydomain com fpp test php By opening this link in your browser you ll see results of the checkup script 2000 2008 email form com TM All rights reserved Form Processor Pro v5 User Manual Note If you are not aware of the details above contact directly your web hosting Provider Company You may also find this information in your hosting package details Package Contents Form Processor Pro Download Package has the following structure File folder name Description Archive of our Form Processor Pro Download Ee fpp v5 zip Pankage Main Form Processor Pro folder with all required files for proper work You must upload this folder to your public folder www on your web server gt amp fpp Folder with examples of typical forms Feel gt amp sample forms j free to use and change them for your needs Form Processor Pro configured to serve sample forms You shou
42. command you should run the following command chmod 777 lt filedir name gt lt filedir_ name is file or folder in question 2 3 Initial Configuration Script We have included Initial Configuration Script in the package in order to simplify FPP configuration for further form processing Using this script you will easily do the following 1 Check permissions for required files and folders 2 Configure Email Sending feature set correct SMTP server 3 Configure Database settings if you intend to save form submissions to database 4 Change password for this configuration script You should know that script stores all parameters in config php file and actually you can simply edit this file by yourself if you understand what are you doing and know SMTP and DB parameters Run Initial Configuration Script and follow the instructions in order to perform initial Form Processor Pro configuration Initial Configuration Script is located in the fpp 2000 2008 email form com TM All rights reserved FPP Basics 19 install folder E g If you ve uploaded the fpp folder to wwwroot folder of your www yourdomain com server you can access Initial configuration Script via www yourdomain com fpp install index php URL When you ve completed Initial Configuration Script wizard you are ready to setup your first form 2 4 What is actions validations etc FPP v5 has several groups of
43. dation of the postcodes for the Netherlands VALID 1234AB 1234AB INVALID 123BBB 023AB 3 2 27 percentage fields Validate percentage numbers VALID 13 24 85 INVALID 13 24 5 12 2000 2008 email form com TM All rights reserved Field Validations 3 2 28 required fields Check fields to be required for filling 55 VALID Sometext INVALID 3 2 29 roman num fields Roman numerals validation VALID XXL MCMXCIX II INVALID ALPHA I9E 3 2 30 same fields Validate that all listed fields have the same value 3 2 31 spanish _ postcode fields Match Spanish postcodes VALID 01234 50000 12345 2000 2008 email form com TM All rights reserved 56 Form Processor Pro v5 User Manual INVALID 00 999 3 2 32 ssn fields U S social security numbers SSN validation VALID 145470191 145470191 145 47 0191 INVALID 000470191 145 00 0191 145 47 0191 3 2 33 swedish_ phone fields Swedish phone numbers according to SIS standard VALID 46812345678 08 123 456 78 0123 45678 INVALID 4608 123 456 78 0812345678 0123456 78 2000 2008 email form com TM All rights reserved Field Validations 3 2 34 swedish_zip fields Validate Swedish zip codes postnr with or without space b
44. detailed information about availability of certain functionality and general possibility of usage of Form Processor Pro on your web server s current configuration index php Main Form Processor Pro executable file All forms actions should refer to this file Like lt form name my_form 2000 2008 email form com TM All rights reserved 10 Form Processor Pro v5 User Manual action URL To This File gt This folder holds the HTML manual In order to gt manual read it you should open index html file from this folder In order to use Form Processor Pro you only need to know the location of the config php URL to index php and may be attachments directory location in case you will use attachments functionality in your forms Permissions Set writeable permissions 0777 to the folders tmp and attachments inside Form Processor Pro after uploading Form Processor Pro directory to your web server 1 3 How it works Form Data Input e When a web site visitor clicks on Submit button in your web form Form Processor Pro starts loading Configuration File It is a simple INI file where you can specify all your forms and their settings This file also sets basic variables to make Form Processor Pro work correctly e Submitted data is being checked for compliance with form field validations and modifiers and generates detailed highlighted error mess
45. dit config php located in Form Processor Pro installation Files placement on web server Before that we should place created files to the web server as we will use paths to these files in our config php file So we place contact html and thank you html to the web server s www public folder Both email template files email txt and autoresponder txt we place in separate folder under www e www public folder of mydomain com e fpp folder with installation of Form Processor Pro e attachments e classes e install e lang 2000 2008 email form com TM All rights reserved 32 Form Processor Pro v5 User Manual In our case plugins tmp htaccess captcha img php config php configuration file fop test php index php style css contact folder with email templates htaccess protect this folder from outside browsing see tip suggestion below email txt autoresponder txt contact html our contact form thank you html our thank you page and other web site pages FPP can be accessed through http www mydomain com fpp index php Contact form can be accessed through http www mydomain com contact html Tip 2000 2008 email form com TM All rights reserved FPP Basics 33 In order to protect your email template files from undesirable browsing through HTTP we suggest you to place them in separate folder and protect th
46. e and receive forms with correct timestamp Example time_zone 5 It specified relatively to server time Time zone sets up for each form separately 2000 2008 email form com TM All rights reserved 88 Form Processor Pro v5 User Manual 4 14 Expiration Date for the Form You may set expiration date for any form by using expire_date validation You should use these settings in config php file for certain form or global Syntax xpire_date lt date gt Where lt date gt is any US English date Example xpire_date 23 September 2007 This will deny all users to submit your form after 23 September 2007 4 15 Unique Submissions If you want to limit your form submissions by 1 or couple times per some person use unique_submits action in config php Syntax unique_submits lt number gt lt period gt Where lt number gt is a number of times the form can be submitted during any lt period gt of time 2000 2008 email form com TM All rights reserved Actions 89 Example unique_submits 1 3M Means that form can be submitted just once per three months You can specify period by any integer number followed by a letter exterminating a period S seconds minutes H hours D days M months Y years Examples 6H 30I 5D 1Y 2000 2008 email form com TM All rights reserved Modifiers
47. e same way as for the other field types you have to mention the name of this field as required_ fields in config php Example required_fields department Department Also you need to create option with blank value by default Example lt option lt option lt option option gt lt option option gt lt select gt val val va val lt select name department gt ue billing gt ue Sales gt Sales lue support gt Support Billing ue selected gt Select lt option gt Department lt option gt Department lt Department lt 8 7 How to make checkbox choice and dropdown required The required attribute for these elements is much harder to perform because of their features in html specification Alike for other fields you need to specify them in config 2000 2008 email form com TM All rights reserved 146 Form Processor Pro v5 User Manual 8 8 php Example required_fields interests Interests Also you have to create hidden fields with the same names and blank values Example lt input type hidden value name interests gt lt input type checkbox name interests value Finance News gt How to make group of checkboxes with one line results in templates To make a group of checkboxes you need to give them names like interests index as it
48. e would like to have custom thank you page with personalized greeting Hmm that s pretty much requirements just for Simple form However significantly complicated and sophisticated forms are possible with Form Processor Pro too In this case we just want to have contact form to be processed the right way and accept only correctly formatted submissions avoiding user typos and mistakes To create any form with Form Processor Pro you need to assemble four easy things 1 Point your form and give it a name You should point ACTION of your form to the Form Processor Pro installation and give it a unique name by inserting HIDDEN field in the form s HTML just after form tag 2 Handle with error messages Put lt FPP_ERROR gt tag to your form s page in the where you d like to display error messages 3 Create required Email HTML or Log templates Use and brackets and hash signs to include any variable field content in the template If you have text field with name email then you can use this variable in any template by putting it in brackets like this Hemail This will be changed with user s entered value after processing 2000 2008 email form com TM All rights reserved FPP Basics 21 4 Edit simple config file with required configurations Set actions to perform validation rules etc All available actions validations and modifiers can be found in this manual In order to follow further
49. eeseessescseeceeseeesessnsesaeaaeceeesessesenseseaaeesees 43 2 Fields Validation Reference cccccssssssssssecceseessnsssssseceeseeesessnsnssceeeaeenseseneenseaaes 44 australian phone fields it eege dE EEN belgium_postcode_ fields Canadian provincial fl ldS dd ni A aa Aa poaa SANAA SAna EENEN aR e EIER E UE EE E TL e BR OC E CH TE domain d EE dutch posteode Helde eege Seege ENEE Een El EUR OT TE PhO aR UE EE france postcode E E fren h phone field nn da aaan aaa aa a Eea Paa Vaada ASAA saai dadaa dadada SEa german_postcode_fields icd9 code _fields image_file_fields int_fields 0 0 seeeeeeeeeees ip_fieldS esses ipv6_fields see 2000 2008 email form com TM All rights reserved Contents 3 ISD ET EE italian_ codice fiscale fields s Italian Ee EE TC EE mac address fields enee EEN EEN lei FIO EE monthday TL DE msoftice file ET E netherlands postcode fields aaeain nae aaa Eataa daa aapea a anaal percentage fields entr co mere a ao E aa raana aN SES required_fieldS mu mnnannnnannnennnnnannnnnenenenanennanensancnnanneneenennenaenanennennensanennennnnnnnene roman_num_fields ei Same fields ennemie n e spanish_postcode_ fields ns iininrrarnnrrnesneerenannannenneenennesnnnesneeneeanenenneneeneinse UR E e e A ne E SR St nn nn nn Swedish phone fields Re ne sacshecescesuacesuessieecereserseacquers SwediSh Zip fields 5
50. el gt lt input type radio name travel value CAR gt Drive a car lt label gt lt label gt lt input type radio name travel value HORSE checked gt Ride a horse lt label gt GI gt Take lt label gt lt input type radio name travel value PLAN a plane lt label gt We use Switch function in one of the templates or another form pages sw travel CAR HORSE PLANE Drive a car Ride a horse Take a plane Let s say user check the HORSE radio button 2000 2008 email form com TM All rights reserved 114 Form Processor Pro v5 User Manual Result Ride a horse 6 4 CAPTCHA Feature CAPTCHA is a type of challenge response test used to determine whether or not the user is a human CAPTCHA requires that the user type the letters of a distorted image with the addition of an obscured sequence of letters or digits that appears on the screen To add it to your page you need to e create field to enter CAPTCHA lt INPUT TYPE text name mycaptcha VALUE gt e add CAPTCHA picture using this code lt img src fpp captcha img php gt e then point in the config php file captcha_field mycaptcha Note CAPTCHA is only available in the following licenses Business World Wide ISP 2000 2008 email form com TM All rights reserved Advanced Fea
51. en space or period VALID 18005551212 1 800 555 1212 1 800 555 1212 800 555 1212 8005551212 800 555 1212 800 555 1212 5551212 2000 2008 email form com TM All rights reserved 60 Form Processor Pro v5 User Manual 555 1212 555 1212 INVALID 2 800 555 1212 55 5212 551212 15551212 3 2 42 us state fields US state 2 chars long code validation VALID CO GA TX INVALID A ZZ Florida 3 2 43 vat_num_fields Validate VAT numbers VALID GB464645 AT134645 INVALID GB1321 D5464D 2000 2008 email form com TM All rights reserved Field Validations 3 2 44 vin fields Test Vehicle Identification Numbers VINs 61 VALID abcDEFghp3t123456 A1C3E5G6Y98123456 A1C3E5G6FFF123456 INVALID ABBBC3E5G6F9F12345HHH 3 2 45 weekday_fields Weekday names numbers validation VALID 05 Tue Sunday INVALID 09 12 Wdn 1st 3 2 46 word_fields Validate single word VALID someword 2000 2008 email form com TM All rights reserved 62 Form Processor Pro v5 User Manual INVALID The word 3 2 47 year fields Validate number of the year VALID 2007 06 98 INVALID 132 24566 3 2 48 zip fields US ZIP and ZIP 4 validation V
52. eric representation of amonth without leading zeros 1 through 72 t Number of days in the given month SS through Year L Whetherit s aleap year lifitis a leap 2000 2008 email form com TM AN rights reserved Advanced Features 129 The following characters are recognized in the date_format setting year 0 otherwise ISO 8601 yearnumber This has the same valueas Y Beas S except that if the ISO week number W belongs to the 1999 8 previous or next year that year is used instead allowed in 2003 PHP 5 1 0 Examples Y A fullnumeric representation ofa year 4 digits 1999 or 2003 y A twodigitrepresentation ofa year E or 03 Note Unrecognized characters in the format string will be printed as is 6 10 2 Time Returns current time Syntax STIME Returns current time The format should be specified by setting t ime_format in configuration file You can use following common examples of the t ime_format setting and output time value 2000 2008 email form com TM All rights reserved 130 Form Processor Pro v5 User Manual Examples Assuming now is 5 16 18 pm date_format g i a 5 16pm date_format G i s 17 16 08 date_format G i 17 16 You can also use characters from following table to customize the t ime_format
53. eseeenenes 86 13 Time Zone EE 87 14 Expiration Date for the Form ss ssnssnnnennenennnnnnnnnss 88 15 Unique SUBMISSIONS ee RE EE EE r TENN iaiT 88 Part V Modifiers 91 Modifiers OVervieW 5i2a52e22 ta0 em side acasaavassansuccvavaeacteacce pdcsscdesecvusccacdcccccabcatoecdss 91 2 Modifiers Reference v2 22 2cecertvie s2sts scedecteden EEAENEEEE EAR 91 CAPITALIZE sin cies sesntessentescenctnsevensaesansnceeosenteusesssneasenatevadsusesoesnsantancedesasensnuanuscuseeuaecouanssuedunestiudceserderstaesndedanseateveda COUNT characters enr coment encre EES count_paragraphs count_sentences count_words Gate format ccc A eel ege See EES Ee default indent lower nl2br regex FOPlaCe eege EE EE dese replace nn restucedeustasauasueusvccevatesesdaeacauucabseusavieavacaccssusadicusoucvaucucunayysustuadeannaussacsdetuainctvace spacify String el SE CHL e e TEE E E E uen in ane nada A AEE dau m ageadan nero dur en een mean ide tres d nait dcr end entente Strip tags E TL EE upper WOFAWFAP eaae AeA ES EAEE E AEE A AE T E EEE ene encens ane E anna na ane ene EAEE nee ES 3 Combining modifiers st insssnnrinrnnnnnnnenennnennnnennnnennnnse Part VI Advanced Features 111 1 Mathematical calculations cccssssseseeceeeseesenssssseeeeeseesensenesseeeeseeseeneneenensess 111 2 SE COMGITION EE Be SWITCH te RE 4 CAPT GHA Feature sisi scssedcia adc aace iacaadevivacecatedeaseuncdincsuate scadecectuccs sede dcads
54. et Explorer uses more space margin top and margin bottom than in Gecko based browsers This could lead to layout problems For example if you re using a table width a fixed width and height and your design is based upon these dimensions If you have content in the table within lt P gt tags than the height of the table could increase in Internet Explorer which could lead to gaps in your design To prevent layout problems use the lt BR gt tag instead of the lt P gt tag as it renders the same in all browsers If you still have troubles with the layout you can also use spacers instead of the lt P gt and the lt BR gt tag Another problem with lt P gt tags is in Windows Live Hotmail lt P gt tags are removed So the safest way is to use the lt BR gt tag 4 4 Auto generated Email Provides you with possibility to send auto generated emails without creating any email templates It takes only one argument email address Example autogen_email user domain com By adding the line above to form configuration will give you the opportunity to receive auto generated emails that contain all submitted data from the form to user domain com email box Optional settings are the same as for emai 2000 2008 email form com TM All rights reserved 74 Form Processor Pro v5 User Manual 4 5 Log submissions to file Log template is designed to record all form submissions and to present them ina
55. etween groups With leading s or not VALID 12345 93268 S 62146 INVALID 5367 425611 3154 3 2 35 time fields Value should be a correct timestamp VALID 1 01 AM 23 52 01 11 04pm 03 24 36aM INVALID 24 03 13 pm 3 2 36 uk_bsc_fields Validate a UK Bank Sort code VALID 09 01 29 2000 2008 email form com TM All rights reserved 58 Form Processor Pro v5 User Manual 05 06 25 INVALID 090125 3 2 37 uk driver license fields Match the UK Drivers License format VALID JOHNS711215GG9SY INVALID JOHNS731215GG9SY 3 2 38 uk_nin_fields UK National Insurance Number NINo validation VALID JG103759A AP019283D ZX047829C INVALID DC135798A FQ987654C KL192845T 3 2 39 uk _postcode fields UK postcode validation VALID W1A1AA EC2V LIN GIROAA 2000 2008 email form com TM All rights reserved Field Validations 59 INVALID TB121AB EC2V 1JM W2A 1AA 3 2 40 url fields Value should be a correct full URL address mailto support web site scripts com ftp ftp mysite com VALID http www email form com online manual index html INVALID www google com microhard com 3 2 41 us phone fields US phone number with optional leading 1 optional area code and optional delimiters hyph
56. features that help to process any form with very sophisticated requests These groups are e Field Validations validation rules responsible for validating user input e g email validation ZIP code validation e Actions actions that have to be done after form submission e g send an email put data to database open a web page e Modifiers modifiers help to pre format user inputted data by certain modification rules e g capitalize first letters of second name set all letters of special field to lowercase Click on correspondent group for more information and features reference 2 5 Setting up My First Form Here we ll guide you through the process of creating and configuring your first form with Form Processor Pro After learning this sample you ll be able to configure any form in just 5 minutes or less For a head start we ll create a simple contact form with the 2000 2008 email form com TM All rights reserved 20 Form Processor Pro v5 User Manual following in mind e We will have such form fields Name Phone Email Subject and Comment e We would like to validate only properly formatted email addresses e Name Email and Subject fields are required e We want to receive form results to our email e We want to send auto responder confirmation email to form submitter e We would like to provide user with error messages on the same page and highlight improperly filled fields e W
57. file if you want user to attach file via the form In this case user file should be an upload field name from your form Attachment file name to attach with corresponding path Note all paths should be provided relatively to Form Processor Pro directory or absolutely Examples Attachment path to file zip Or Attachment myform test zip For properly mail contents display same charsets need to be used both in html pages and in mail templates Email templates will be parsed as a usual template and you may use all parser features Also you may separate by comma multiple recipients or attachments 2000 2008 email form com TM All rights reserved 68 Form Processor Pro v5 User Manual Example of the email template To email From user domain com Subject Your data was successfully added to database Dear name Thank you for filling out our form Optional setting for email action config php smtp_server SMTP server host name address smtp_port SMTP server port number auth_email Does the same as email action but send messages via SMTP server that requires username and password authorization Additional settings config php smtp_login Username smtp_password Password 2000 2008 email form com TM All rights reserved Actions 69 4 3 HTML email Overview You can also send HTML emails with Form P
58. file in the action parameter of the lt form gt tag to get fpp_back button work correctly lt FORM name myform method post action http www mysite com fpp index php gt Or you may use HTML tag lt BASE gt to specify base URL lt BASE HREF http www mysite com fpp gt In this case you can use relative path to Form Processor Pro as well as path to 2000 2008 email form com TM All rights reserved 136 Form Processor Pro v5 User Manual your images styles etc E g Your form is located in the root folder on your server and Form Processor Pro is located in the fpp folder so action would be as follows lt FORM name myform method post action fpp index php gt 2000 2008 email form com TM All rights reserved 138 Form Processor Pro v5 User Manual 7 Language Settings 7 1 Changing Language You can choose your language by language setting Example config file language en Result Sets English language for all Form Processor Pro messages 7 2 Adding your own language To add your own language you have to create new language file in fpp lang To do that just copy the previous en lang php file and rename to lang php where two letter country code e g French fr lang php After that you have to translate right part of php file to the language selected Syntax 1 var_name
59. gly So we will have the following changes in our HTML code for the Thank You Page HTML code for the Thank You page with highlighted changes 2000 2008 email form com TM All rights reserved FPP Basics 29 lt html gt lt head gt lt title gt My Contact Form Thank you lt title gt lt head gt lt body gt lt p gt Dear name lt p gt lt p gt Thank you for interest in our company We will reply as soon as possible lt p gt lt p gt Auto responder email has been sent to email lt p gt lt body gt lt html gt Thank you page saved as thank you html 2 5 4 4th Step Preparing Email templates Email templates are just text files with specially formatted content Generally email has following required fields rows in template To From Subject and Message Body However other fields like BCC Attachments etc are also possible Please refer to Email Sending Action article for more information In email template it should look like this Email template To recepient somehost com From sender somehost com Subject This is an email subject Message Body Text in free form Either plain text or HTML formatted text 2000 2008 email form com TM All rights reserved 30 Form Processor Pro v5 User Manual In order to use variables fields we need to put them in figure brackets with hash signs
60. he given month through Year lifitisaleap L Whether it s a leap year year 0 otherwise ISO 8601 yearnumber This has the same valueas Y Paasi S except that if the ISO week number W belongs to the 1999 g z previous or next year that year is used instead allowed in 2003 PHP 5 1 0 Examples Y A fullnumeric representation ofa year 4 digits 1999 or 2003 y A twodigitrepresentation ofa year ae E E Example diaraec Description returned i r values Time a Lowercase Ante meridiem and Post meridiem am or pm A Uppercase Ante meridiem and Post meridiem AM or PM 2000 2008 email form com TM All rights reserved 98 Form Processor Pro v5 User Manual forma Example charac Description returned ter values B Swatch Internet time 000 through 999 g 12 hour format of an hour without leading zeros 1 through 72 G 24 hour format of an hour without leading zeros Othrough 23 h 12 hour format of an hour with leading zeros 01 through 2 H 24 hour format of an hour with leading zeros OOthrough 23 i Minutes with leading zeros 00 to 59 S Seconds with leading zeros O0through 59 u Microseconds allowed in PHP 5 2 2 Example 54321 Timezo ___ ee ne Examples UTC e Timezone identifier allowedin PHP 5 1 0 GMT Atlantic Azores I 1ifDaylight capital Whether ornot the date isin daylight saving time Saving Time 0
61. host web site scripts com referers www yourdomain com Referrers specifies for each form separately You can set localhost if form is located on the same server as Form Processor Pro is 4 12 Password Generation This feature might be helpful if you want to generate a password for a user who submits the form You can send generated password to email save it to a database or use as any other field Syntax gen_pass field_name num dict_file php 2000 2008 email form com TM All rights reserved Actions 87 Example gen_pass password 3 will generate password with length 3 symbols gen_pass password will generate password with default length 6 symbols gen_pass password forms sample dict php will select randomly one of the passwords form dictionary located at forms sample dict php and write it to the password field Example of dict php lt php header Location index html gt DO NOT REMOVE THIS LINE password0 passwordl password2 lt php header if Location index html gt this line will protect your password dictionary from unauthorized access You should put the name of actual file instead of index html or create an empty index html file 4 13 Time Zone Time Zone feature help you to set up time zone of your forms If your server time zone differs from the your time zone you can set this differenc
62. idate date fields VALID 10 September 2000 12 12 2006 31 Dec9999 2000 2008 email form com TM All rights reserved Field Validations 47 29Feb 2004 INVALID MMVIII 29 Feb 2002 13 Octo 1998 32May1913 3 2 7 domain fields Validate domain names VALID email form com example co uk INVALID http email form com test mitridat com 3 2 8 dutch postcode fields Dutch zip code verification VALID 1054 WD 1054WD 1054wd INVALID 10543 3 29 email fields Validate an RFC 2822 email addresses 2000 2008 email form com TM All rights reserved 48 Form Processor Pro v5 User Manual 3 2 10 float_fields VALID user domain com user id domain name com INVALID userdomain com user 300 0 0 1 user domain com file_filter_fields File type validation Allow user to submit only files with allowed extensions see allowed files Validate decimal numbers VALID 12 0 25 36 678 INVALID A10 25 10 3 2 11 france postcode fields Postcode check for France including colonies VALID 12345 F 12345 2000 2008 email form com TM All rights reserved Field Validations 49 F 2B100 INVALID S123456 F 123456 123456 3 2 12 french _ phone fields Validate phone numbers in France
63. in email field we will use email_fields validation rule the same way as above email fields email Contact Email As you can see you can have more than one validation per one field any amount actually But they have to be reasonable of course For more information about possible validation rules refer to Field Validations chapter Setting up email sending We would like to send two emails one for us with form results and another as auto responder for submitter We have already created these templates and we use them here with email action Just like this email contact email txt email contact autoresponder txt For more information about possible actions refer to Actions chapter 2000 2008 email form com TM All rights reserved FPP Basics 37 That s all configurations for the config php file according to our initial requirement to this Contact Form After adding all of the above to our config php we will have the following changes in it lt php header Location index php gt GLOBAL FPP SETTINGS BEGIN THESE SETTINGS APPLY TO ALL FORMS mysql_host localhost mysql_user user_name mysql_password password mysql_db fpp5 smtp_server localhost smtp_port 25 date_format H m d m y GLOBAL FPP SETTINGS END FORMs configurations for
64. is folder from browsing You can use htaccess file for this purpose on any Unix Linux compatible host Just add create this file htaccess in the folder with email templates with the following content you can also copy htaccess file from tmp or attachments folder of the Form Processor Pro installation lt Files gt Order allow deny Deny from all lt Files gt You will protect yourself from email harvesting bots by doing this On Windows based hosts you can do this by setting correspondent permissions for this folder Adding new form to config php file Now we have all required files in place and we can edit our config php Note Please use plain text editor to edit config php to prevent adding unnecessary lines and symbols Sample content for config php lt php header Location index php gt GLOBAL FPP SETTINGS BEGIN THESE SETTINGS ARI APPLIED TO ALL FORMS GI mysql_host localhost mysql_user user_name mysql_password password mysql_db fpp5 2000 2008 email form com TM All rights reserved 34 Form Processor Pro v5 User Manual smtp_server localhost smtp_port 25 date_format H m d m y GLOBAL FPP SETTINGS END FORMs configurations form name Declares form name and its settings below
65. lation instructions Prepare your installation using configuration script and Initial configuration instructions Follow the steps in Setting up My First Form chapter and configure your first form in order to understand the process of form configuration After succeeding these steps you ll be able to configure any form with FPP v5 just in 5 minutes or even less Form Processor Pro 5 is very easy to install just follow the following steps Download latest package from the member area Unpack downloaded package using any ZIP archive extraction program e g WinZIP Upload complete fpp folder from the package to your web server Main www folder is preferred If you would like to use or test demo forms you can upload complete demo forms folder as well Main www folder is preferred 2000 2008 email form com TM All rights reserved FPP Basics 17 5 Set writable permissions 0777 using UNIX shell command or any FTP A u client e g CuteFTP to the folders tmp attachments and config php file inside Form Processor Pro fpp directory 6 Run Initial Configuration Script and follow the instructions in order to perform initial Form Processor Pro configuration Initial Configuration Script is located in the fpp install folder E g If you ve uploaded the fpp folder to wwwroot folder of your www yourdomain com server you can access Initial configuration Script vi
66. ld upload this folder to your web server with other sample forms folder content to see how sample forms work amp fpp It is temporary folder for user uploads and attachments i files that you would like to attach in emails classes Classes are core files of Form Processor Pro 2000 2008 email form com TM All rights reserved Introduction 9 Install Initial configuration script lang Contains language files translations of all available languages for error messages You can change language in a moment by changing only 1 string in configuration file Please refer to Language Settings plugins Plug ins directory Each plug in refers to certain functionality of Form Processor Pro tmp Form Processor Pro use this folder to store temporary files that may be needed during form processing like PDF XLS generated files for counting unique submissions etc htaccess htaccess file prevent unauthorized access to the folder contents from the web captcha img php Provides CAPTCHA anti spam protection config php One and only configuration file of Form Processor Pro and forms It has simple structure where you should specify all your forms and their settings as well as global settings fpp test php By opening this file in your browser you will check your system requirements for Form Processor Pro It shows
67. m name Declares form name and its settings below some_form page form html page thank you html required_fields name Full Name email Contact Email subject Subject email fields email Contact Email autogen_email info mydomain com That s all We have finished configuring our first form 2000 2008 email form com TM All rights reserved 38 Form Processor Pro v5 User Manual 2 6 Configuration File Overview Form Processor Pro is tuned and configured by special configuration file located in Form Processor Pro directory and named as config php It is a simple INI file where you can specify all your forms and their global and local settings This file sets basic variables to make Form Processor Pro work correctly You can disable certain variables by putting in the beginning of the line with variable All symbols put after are not treated as data and are mostly used as comments Note Please use plain text editor to edit config php to prevent adding unnecessary lines and symbols to it Each setting may be applied globally as well as only for a custom form Form descriptions in configuration file start by declaring a new INI file style section Example myform page index html page preview html page thank you html email emailtpl txt In the configuration above we have set up
68. n one form page repeat this step few times It s not necessary to add hidden field to pages other than first Form saved as contact html 2 5 3 3rd Step Configuring Thank you page As we would like to have custom thank you page we need to prepare it before dealing with email template and config file So on the thank you page we want to pu t something like this 2000 2008 email form com TM All rights reserved 28 Form Processor Pro v5 User Manual Dear here we would like to put filler s name Thank you for interest in our company We will reply as soon as possible Auto responder email has been sent to here we would like to put filler s email Initial HTML code for the Preview Page lt html gt lt head gt lt title gt My Contact Form Thank you lt title gt lt head gt lt body gt lt p gt Dear here we would like to put filler s name lt p gt lt p gt Thank you for interest in our company We will reply as soon as possible lt p gt lt p gt Auto responder email has been sent to here we would like to put filler s email lt p gt lt body gt lt html gt In order to insert any variables dynamically we need to use and brackets Inside these brackets we need to put appropriate variable name Variable is the name of the corresponding field in our form In our case we should use name and email accordin
69. name9238 namefrjhgh You can set any other number instead of 3 but note that larger numbers slow down the script i means that fields names would be insensitive to the register so Form Processor Pro will not make difference between nAme3 Name3 and name3 field names File Generation Sometimes it s useful to generate some online files that contain user submitted data and much more useful to send it by emails Predefined file variables lets you easily include such files as attachments into generated emails Generate PDF file with all form s data represented by rows For example you if need to generate a PDF file with user submitted data and send it by email specify it in your email template 2000 2008 email form com TM All rights reserved Advanced Features 119 Syntax Attachment SFORMFILE PDF and you will receive email with attached PDFs with data submitted Example Email template To recepient somehost com From sender somehost com Subject This is an email subject Attachment FORMFILE PDF Message Body Text in free form Either plain text or HTML formatted text Note File generation is only available in the following licenses Business World Wide ISP 6 6 2 PDF with Table view Same as above but data output in a table view Syntax Attachment SFORMFILE_PDF_TABLE
70. ncy drops off significantly after 25 Template article indent 10 Output NJ judge to rule on nude beach Sun or rain expected today dark tonight Statistics show that teen pregnancy drops off significantly after 25 5 2 9 lower This is used to lowercase a variable Example 2000 2008 email form com TM All rights reserved Modifiers 101 Input John SMITH Template name lower Output john smith 5 2 10 nl2br All line breaks will be converted to lt br gt tags in the given variable It s very usable to output text area fields Example Input John Smith Template name nl2br 2000 2008 email form com TM All rights reserved 102 Form Processor Pro v5 User Manual Output John lt br gt Smith 5 2 11 regex_ replace A regular expression search and replace on a variable Use the syntax for preg_ replace from the PHP manual Example Input John Smith Template name regex_replace h H Output JoHn SmitH 5 2 12 replace A simple search and replace on a variable Example 2000 2008 email form com TM All rights reserved Modifiers 103 Input John Smith Template name replace John Samuel Output Samuel Smith 5 2 13 spacify Spacify is a way to insert a space between every character of a variable You can optionally pass a different
71. ness World Wide ISP only 2000 2008 email form com TM All rights reserved 80 Form Processor Pro v5 User Manual 4 7 Database Select Queries The mysql_ select action selects data from database using MySQL query and puts it to specified fields with corresponding names This action supports SELECT queries only If you want to update or insert data to MySQL database use MySQL Database Storage action Syntax mysql_select query error message query mysql SELECT query error message optional parameter If present will be shown on the form in Error Message Block if query returns O records If not present form processing will be continued even if O records were returned Example mysql_select SELECT country city street phone FROM form _ table WHERE name name AND surname surname Result This query makes selection from the form_table table where name and surname values matches submitted fields and puts data from the first matched result to country city street phone fields You can use these fields later in templates and form pages as if they where inputted by user e g country city Example showing two forms with add record and edit record functions Let s say we have a small form with following fields name surname country 2000 2008 email form com TM All rights reserved Acti
72. nly gif bmp png files would be allowed for user upload 8 4 Does Form Processor Pro have any API How can use it Script allows redirecting all form data to another page via GET request This can be used 2000 2008 email form com TM All rights reserved 144 Form Processor Pro v5 User Manual as API to third party scripts and for further data processing Example http_request http example com foo php This will open http example com foo php with your form data in URL e g http example com foo php username Edward amp password abc123 username Edward and password abc123 is data received from the form after user entered Edward value in username field and abc123 in the password field This data is being sent to the foo php script by GET request method 8 5 My second form page preview has broken images styles How can fix this Most likely those relative paths to images styles are specified in HTML templates So please specify absolute paths in all links images etc on your form pages Otherwise all relative paths would be relative to Form Processor Pro but NOT to the page of your web site Or you may use HTML tag lt BASE gt to specify base URL lt BASE HREF URL_TO_PAGE gt 2000 2008 email form com TM All rights reserved FAQ 145 8 6 How to make selection box required to be selected Th
73. o Minimal configuration to existent form HTML Just point it to FPP and give it a name in form s HTML e User friendly error messages Error messages now can be displayed on the same form page with fields highlighting You have full control over style e Back amp Edit feature e Multiple data output Processor can perform unlimited combination of tasks per form Send different emails with PDF XLS and even ZIP them as well as put data into database e Advanced output formats o PDF o XLS o CSV o ZIP o TXT and LOG template based storing e Storing to databases o MySQL 2000 2008 email form com TM All rights reserved 14 Form Processor Pro v5 User Manual o MSSQL O SQLite o PostgreSQL e Payment gateways o PayPal o 2CheckOut o LinkPoint e File output This feature allows you to output file for download just after form submission e File uploading validation e Expire date for the form e Plug in architecture e API for third party integration e And much more 2000 2008 email form com TM All rights reserved 16 Form Processor Pro v5 User Manual 2 2 1 2 2 FPP Basics How to get started Installation In order to start using Form Processor Pro you should follow the following steps in this Read Package Contents for better understanding further chapters of this manual Perform installation of the package according to Instal
74. ons 81 city street phone This form has following query in configuration file mysql_query INSERT INTO Tom table name surname country city street phone VALUES name surname country city street phone User can submit this form and his information will be added to the database by mysql_query action Now lets think we have a form where user can edit his record This form should have 3 pages login page edit page and thank you page Login page can contain 2 fields or any other number of fields these fields will be used to identify the correct record in the database Let s think we have login page with fields name surname So user can restore his data using his name and surname Second page has following fields name surname country city street phone In config file we have mysql_select SELECT country city street phone FROM form _ table WHERE name name AND surname surname Error no such name surname in the 2000 2008 email form com TM All rights reserved 82 Form Processor Pro v5 User Manual database mysql_query UPDATE form_table SET name name surname Hsurname country country city city street street phone phone First query loads user information country
75. ons and If condition to calculate total amount of purchase You can also find examples of calculation in the checkout page with connection to payment gateway demo form unique_number is a unique number of the shopping cart session you can use ES UNIQUE_REFERENCE function that will generate unique number for each submission product1_id product1_quantity product1_price 2CO id of your product number of items and product price You can set as many products as you wish Product_price and product _quantity are optional parameters if not specified product price will be set by 2CheckOut system to default value and product quantity will be set to 1 You can leave the space between commas empty to omit optional parameters Syntax tco_checkout SID total unique number productl_id 2000 2008 email form com TM All rights reserved 84 Form Processor Pro v5 User Manual productl_quantity productl_ price product2_id product2_quantity product2 price Example tco_checkout 1234567 139 90 UNIQUE_REFERENCE my_productl 2 69 95 Note 2Checkout payment gateway support is only available in the following licenses Business World Wide ISP 4 83 LinkPoint Charge user credit cards via LinkPoint payment gateway Require 5 parameters 1 Your config file number e g 1234567 2 Creditcardnumber e g 41111111111
76. or_block_end Error block ending HTML error_msg_begin Error message beginning HTML error_msg_end Error message ending HTML error_field_style Error field CSS style Example error_block_begin lt TABLE align center border 1 gt error_msg_begin lt TR gt lt TD gt error_msg_end lt TD gt lt TR gt error_block_end lt TABLE gt error_field_style border solid lpx red background yellow If error appears form applicant will see the error message like a table and error fields will be highlighted by red border and yellow background 2000 2008 email form com TM All rights reserved FPP Basics 41 Remember to put in lt FPP_ display error messages ERROR gt tag to the page where you d like to 2000 2008 email form com TM All rights reserved Field Validations 43 3 3 1 Field Validations Field Validations Overview Form Processor Pro allows you to control check and verify user inputted data by using a number of bundled validating functions It means you may set some restrictions or requirements for any field on your form For example if you have some text field named your_email and you want to be sure that all applicants will give you correct email address and nothing else you should use your form configuration and add the following line my_form By doing this you are forcing form
77. quired to be filled 3 2 Fields Validation Reference 3 2 1 australian phone fields Verify Australian phone numbers Matches all known formats including normal 10 digit landline numbers valid area code mandatory 13 1300 1800 1900 1902 plus mobile 10 and 11 digit formats VALID 0732105432 1300333444 2000 2008 email form com TM All rights reserved Field Validations 45 131313 INVALID 32105432 13000456 3 2 2 belgium _postcode fields Postcode for Belgium VALID 1234 INVALID 123 123A 3 2 3 canadian provincial fields Match provincial codes of Canada VALID ON PE NB INVALID OB NM 3 2 4 canadian zip fields Accurate Canadian postal code format verification VALID M1R4B0 LOR1B1 2000 2008 email form com TM All rights reserved 46 Form Processor Pro v5 User Manual 3 2 5 3 2 6 LOR1B9 INVALID W1R4B0 LOR1D1 LOR1B9 credit_card_fields Verify major credit card numbers including Visa MasterCard Diners Club Carte Blanche Discover and American Express IMPORTANT It does not do REAL credit card validation it only checks could inputted data be accredit card number VALID 4111 2222 3333 4444 3411 22222233333 5111222233334444 INVALID 4111 2222 3333 444 3411 2222 3333 4444 Visa date fields Val
78. rocessor Pro HTML email templates are used to send HTML emails Entry in the config php for HTML email templates is the same as for plain text mail template Example email somedir email txt Structure of HTML email template is similar to plain text template You should only add following header Syntax Format html So header of the mail template will look like following Example To recepient somehost com From sender somehost com Subject This is an email subject Format html This is an email body Empty line should be inserted after headers Then the email body is located 2000 2008 email form com TM All rights reserved 70 Form Processor Pro v5 User Manual Body of the HTML mail is similar to HTML page and most of the html tags can be used there however some of tags advised not to be used in it This may cause incorrect display of the email Avoid these tags in HTML email template e DOCTYP GI HTML tag BODY tag All Meta Head tag Base tag Link tag lt HT L gt lt HTML gt BODY gt lt BODY gt tags lt META gt lt H SG lt BASE gt lt LI NK gt AD gt lt HI EAD gt e Script tag lt SCR e Tit IPT gt lt SC RIPT gt Le tag lt T e App TL E gt lt T TI Li gt let tag lt APPLET gt lt AP
79. shown in the example where index is field index starting from 1 Example lt table gt lt tr gt lt td gt lt label gt lt input type hidden value name interests 1 gt 2000 2008 email form com TM All rights reserved FAQ 147 lt input type checkbox name interests 1 value Finance News checked gt Finance News lt label gt lt td gt lt td gt lt label gt lt input type hidden value name interests 2 gt lt input type checkbox name interests 2 value Chat checked gt Chat lt label gt lt td gt lt tr gt lt tr gt lt td gt lt label gt lt input type hidden value name interests 3 gt lt input type checkbox name interests 3 value Weather gt Weather lt label gt lt td gt lt td gt lt label gt lt input type hidden value name interests 4 gt lt input type checkbox name interests 4 value Other checked gt Other lt label gt 2000 2008 email form com TM All rights reserved 148 Form Processor Pro v5 User Manual lt td gt lt tr gt lt table gt In future to receive data from this group of checkboxes and to acquire the list of comma separated values of checked checkboxes we use interests variable note that we do not use indexes here Result if we check first second and forth checkboxes
80. some_form page form html page thank you html required_fields name Full Name email Contact Email subject Subject email fields email Contact Email autogen_email info mydomain com First we have to declare new form in our configuration file We do this by adding form name in brackets as a new line at the end of config php file or just after global settings section The form s name is the value used for previously added hidden files In our case it s contact form In our case we have contact_form After form s declaration we can put any form settings just after this line Defining pages and their order Ok now we have to declare all pages that would be used during Form Processor Pro work in a particular order of process We use page setting for this purpose and set full or relative paths to these pages relative to fpp installation path If we would like to show thank you page just after successful submission of our one page contact form we have to put it as second one Just like this 2000 2008 email form com TM All rights reserved FPP Basics 35 page contact html page thank you html Note You have full control over any server side script execution on form pages If you use relative or absolute path to file e g form file html or fpp form filename php Form Processor Pro will open it as a text file
81. stamp Returns UNIX timestamp value Should be used with date_format modifier to set required format Example ol ESTAMP 6 10 9 Unique Reference Number Returns a very unique reference number It may be used for your own records Example SUNIQUE_REFERENCE 6 11 API to third party solutions Script allows redirecting all form data to another page via GET request This can be used as API to third party scripts and for further data processing Example http_request http example com foo php This will open http example com foo php with your form data in URL e g http 2000 2008 email form com TM All rights reserved Advanced Features 135 example com foo php name Edward amp password abc123 name Edward and password abc123 is data received from the form after user entered Edward value in the name field and abc123 in the password field 6 12 Back amp Edit Feature This feature allows you to create multi page forms with back button allowing form applicant return to previous page and edit previously entered values As well as SUBMIT you may add BACK button on your forms The syntax is very simple Just add another submit button but called fpp_back Example lt input type submit name fpp_back value Back gt Note Please specify absolute path to Form Processor Pro
82. t SQL query Example mssql_query INSERT INTO test name email VALUES name email Additional settings mssql_host Microsoft SQL hostname mssql_user Microsoft SQL user mssql_password Microsoft SQL password mssql_db Microsoft SQL database name 2000 2008 email form com TM All rights reserved 78 Form Processor Pro v5 User Manual Note MS SQL Database storage support is available in the following licenses Business World Wide ISP only 46 4 SQLite SQLite query executor Syntax sqlite_query lt query gt Where lt query gt is any valid SQLite query Example sqlite_query INSERT INTO test name email VALUES name email Additional settings sqlite_file SQLite filename Note SQLite database storage support is available in the following licenses Business World Wide ISP only 2000 2008 email form com TM All rights reserved Actions 4 6 5 ODBC ODBC SQL query executor Syntax odbc_query lt query gt Where lt query gt is any valid SQL query Example odbc_query INSERT INTO test name email VALUES name email Additional settings odbc_dsn ODBC DSN value 79 Note ODBC Database storage support is available in the following licenses Busi
83. the form named myform that has 3 pages and sends one email after filling is over 2000 2008 email form com TM All rights reserved FPP Basics 39 2 7 Note In form names you can use only letters numbers underscore and dash characters Templates Syntax Templates are email template preview page or any page following the first one All template tags are enclosed within delimiters These delimiters are and All content outside of delimiters is displayed as static content or unchanged When Form Processor Pro encounters template tags it attempts to interpret them and displays the appropriate output in their place The first variable in is usually a name of field which value should be displayed Examples Lets imagine you have a text field named first_name on your form lt input type text name first_name gt And you need to show preview So in the preview page you should set First name first_name And after user submitted the form and filled the field first_name with John he will see on preview page 2000 2008 email form com TM All rights reserved 40 Form Processor Pro v5 User Manual First name John It is very simple 2 8 Custom error reporting If you wish to change the way of error messages showing you have next settings to implement in configuration file error_block_begin Error block beginning HTML err
84. to the same files may differ So specify absolute paths in all links images etc on your form pages Otherwise all relative paths would be relative to Form Processor Pro but NOT to the page of your web site 2000 2008 email form com TM All rights reserved 152 Form Processor Pro v5 User Manual 10 Support Information e Have a Pre Sale question Use Live Chat The quickest possible way to have answer on your presale question is to contact our sales representative via Live Chat Sales representatives would be glad to assist you in presales questions from 10am to 10pm GMT 2 EST 7 Time Zone e Help Desk Ticket System and Knowledgebase Whether you use Web Site Scripts com products or are just thinking of ordering any of them welcome to Help Desk Here you will receive a quick and informative response to your presales questions as well as qualified help on technical support issues A member of our Client Support Center will review answer and publish the answer to your question to your Help Desk account and you will be automatically notified by email Registration allows you to submit technical support requests and review the history of your questions and support responses In addition registered users can report bugs submit suggestions and request product customizations Registration is short and easy and takes only 1 minute 2000 2008 email form com TM All rights reserved
85. tures 115 6 5 Fields Counter Fields Counter helps you to count how many fields from a field set satisfy certain conditions This may be used in surveys and with repeating field set Syntax count_fields output_field reqular_ expression fieldl valuel field2 value2 output_field field where result will be put You can use it in any page or template as any other field output_field regular_expression count fields fit this expression See below for detailed explanation fieldN valueN field conditions if value of fieldN field equals valueN then Form Processor Pro counts this field If value is not specified Form Processor Pro checks if field is not empty If was filled Form Processor Pro counts this field Example Let s say we have filled a form with following fields empty values name1 John age1 18 city1 New York name2 Kim 2000 2008 email form com TM All rights reserved 116 Form Processor Pro v5 User Manual age2 18 city2 Washington name3 John age3 21 city3 Washington name4 Mary age4 21 city4 Sydney names Adolph age5 70 city5 Berlin name6 age6 18 city6 Paris Result You can count different combinations of these fields using count_fields feature Example 1 Count how many names were entered count_fields name_count name This will set variable name_count to5 0
86. ucstuaascnaus 5 Fields el TT E 6 File Generation Zeie EENS d GE PDF with Table view EIER eege gege deed XLS with Table view CSV RE TE nes Essen tnt ete nanas tee ced Sun ees 7 Error Message Block siccc cciteccctcssciceencitencctenndivecndiecnccteendivecndtececcteancvceencteseccteancveeencies 8 Allow Deny access to form by IP or Host c sesecssseeceeeeeeseneeseeeesneeneeseneeseeneeneenens 123 ATOM IP ele E M D D sde Deel eege 123 2000 2008 email form com TM All rights reserved Contents 5 NIT RI Dented Address uerdent ege ed Dee er Qs ZID Wl TE 10 Predefined Variables 58288 ek K ENNEN d E ee dE ee Dates eege eege Eege eege Times ss Fields List in HTML Fields List in Plain Text HTTP Referer ssessssssesrenenns HTTP User Agent Remote IP eessen UL OU EE Unique Reference Number 11 API to third party solutions sn isnnnnnnnnnnnnnnnennnnns 12 Back amp Edit Feature ccccscccssssseeeseeccnesssceecceesusceeeeeeeueaaseeeseeeaunassseeeeeeausassesenauens Part VII Language Settings 1 Changing Language nine n ennnen nnna 138 2 Adding your own language ss nnnnnnnnennnnnnnnennnnnns 138 Part VIII FAQ 141 1 How to restore forgotten password to Initial Configuration Script 141 2 I want to allow file download just after form submission How can I do that 142 3 How can allow only certain file extensions for user file uploading 14
87. ved 52 Form Processor Pro v5 User Manual 1 56389 016 X INVALID 123456789X 9 87654321 2 123 456 789X 3 2 20 italian_codice_fiscale_fields Validate Italian fiscal code codice fiscale VALID SPGGRG73A02E625S czzdil74h18f205w INVALID SP6FFFF3A02E625S czzdll74h18f205 3 2 21 italian_postcode_fields Postcode check for Italy including possible Vatican Italy indications VALID 1234 V 1234 INVALID 12345 3 2 22 mac_address_fields Designed to verify a MAC address with hex values separated by a colon VALID 00 00 39 F9 3C 59 00 90 83 6A B3 B7 2000 2008 email form com TM All rights reserved Field Validations 53 00 00 39 59 30 5C INVALID 00 0H 39 59 30 5C 00 39 59 30 5C 00 39 59 30 5C BZ 3 2 23 month fields Month name number validation VALID 05 11 Jul August INVALID 0 13 jne 3 2 24 monthday_fields Field value should be between 1 and 31 VALID 15 30 INVALID 32 3 2000 2008 email form com TM All rights reserved 54 Form Processor Pro v5 User Manual 3 2 25 msoffice file fields Microsoft Office filename validation VALID document doc spearsheet xls INVALID document dl spearsheet exe 3 2 26 netherlands postcode fields Vali
88. xt name email gt lt td gt lt tr gt lt tr gt lt td gt lt div align right gt Phone lt div gt lt td gt lt td gt lt input type text name phone gt lt td gt lt tr gt lt tr gt lt td gt lt div align right gt Subject lt div gt lt td gt lt td gt lt input type text name subject gt lt td gt lt tr gt lt tr gt lt td valign top gt lt div align right gt Comment lt div gt lt td gt lt td gt lt textarea name comment rows 5 gt lt textarea gt lt td gt lt tr gt lt tr gt lt td valign top gt nbsp lt td gt lt td gt lt input type submit name Submit value Submit gt lt input type reset name Reset value Reset gt lt td gt lt tr gt lt table gt 2000 2008 email form com TM All rights reserved 24 Form Processor Pro v5 User Manual lt form gt lt body gt lt html gt 2 5 2 2nd Step Configuring the form We put lt FPP_ERROR gt tag to the form s HTML in a place where we d like to display error messages Now we need to point our form to be processed with Form Processor Pro We do this by editing FORM tag s ACTION attribute to refer to the URL where Form Processor Pro resides You can use either relative or absolute path We need to set METHOD attribute as POST as well And finally set ENCTYPE as MULTIPART FORM DATA Form tag before lt
89. y usable for email attachments file2zip Zip the file Example You can apply it in your email templates like Attachment user_file file2zip In result you will receive an email message with attached zip archive that contains a user uploaded zipped file Note Zip compression is only available in the following licenses Business World Wide ISP 2000 2008 email form com TM All rights reserved 126 Form Processor Pro v5 User Manual 6 10 Predefined Variables There are some predefined dynamically generated variables for your usage in templates 6 10 1 Date Returns current date Syntax SDATE Returns current date The format should be specified by setting date_format in configuration file You can use following common examples of the date_format setting and output date value Examples Assuming today is March 10th 2001 date_format F j Y March 10 2001 date_format m d y 03 10 01 date_format j n Y 10 3 2001 date_format Ymd 20010310 date_format i t i s t h e js d a y It is the 10th day 2000 2008 email form com TM All rights reserved Advanced Features 127 date_format D M j Y Sat Mar 10 2001 Note date_format validator If you want to use different date format for each form refer to You can also use characters from following table to customize the d

Form Processor Pro v5 User Manual - Web-Site

Contents

Download Pdf Manuals

Related Search

Related Contents