php runner

PHPRunner 7.1 Manual 2014 Xlinesoft

PHPRunner 7.1 ManualI

2014 Xlinesoft

Table of ContentsPart I Introduction 1

................................................................................................................................... 11 Welcome ................................................................................................................................... 122 System requirements ................................................................................................................................... 133 Editions comparison ................................................................................................................................... 144 Licensing details ................................................................................................................................... 155 What is the registration ................................................................................................................................... 156 Quick start guide

Part II Using PHPRunner 22................................................................................................................................... 221 Working with projects ................................................................................................................................... 262 Navigation bar ................................................................................................................................... 273 Templates

.......................................................................................................................................................... 27What are templates

.......................................................................................................................................................... 29Cars

.......................................................................................................................................................... 29Classified ads

.......................................................................................................................................................... 30Events

.......................................................................................................................................................... 30Jobs

.......................................................................................................................................................... 30Knowledge base

.......................................................................................................................................................... 31News

.......................................................................................................................................................... 31Paypal

.......................................................................................................................................................... 32Real estate

.......................................................................................................................................................... 32Sporting

.......................................................................................................................................................... 33Vacation houses ................................................................................................................................... 334 Connecting to the database ................................................................................................................................... 405 Datasource tables ................................................................................................................................... 446 Master-detail relationship between tables ................................................................................................................................... 547 SQL query page

.......................................................................................................................................................... 54About SQL query designer

.......................................................................................................................................................... 55Query Designer

.......................................................................................................................................................... 60SQL

.......................................................................................................................................................... 62Results ................................................................................................................................... 638 Charts

.......................................................................................................................................................... 63Creating chart

.......................................................................................................................................................... 67Chart types ......................................................................................................................................................... 67List of chart types......................................................................................................................................................... 68Accumulation chart......................................................................................................................................................... 69Area chart......................................................................................................................................................... 72Bubble chart......................................................................................................................................................... 75Column/Bar charts......................................................................................................................................................... 78Combined chart......................................................................................................................................................... 81Financial OHLC/Candlestick charts......................................................................................................................................................... 84Gauge chart......................................................................................................................................................... 87Line chart......................................................................................................................................................... 90Pie/Doughnut charts

IIContents

II

2014 Xlinesoft

.......................................................................................................................................................... 92Chart parameters

.......................................................................................................................................................... 94Chart appearance

.......................................................................................................................................................... 96Using SQL to shape chart data ................................................................................................................................... 1019 Reports

.......................................................................................................................................................... 101Creating report and setting parameters

.......................................................................................................................................................... 106Report totals and layout ................................................................................................................................... 10810 Choose pages ................................................................................................................................... 11611 Choose fields ................................................................................................................................... 12412 Fields order and totals ................................................................................................................................... 13013 Miscellaneous settings ................................................................................................................................... 13614 Security

.......................................................................................................................................................... 136Login page

.......................................................................................................................................................... 138Login form appearance

.......................................................................................................................................................... 140Registration and passwords

.......................................................................................................................................................... 144Advanced security settings

.......................................................................................................................................................... 146User group permissions

.......................................................................................................................................................... 148Dynamic Permissions

.......................................................................................................................................................... 152Audit and record locking

.......................................................................................................................................................... 157Active Directory

.......................................................................................................................................................... 161Encryption

.......................................................................................................................................................... 164Facebook connect ................................................................................................................................... 16715 Style Editor

.......................................................................................................................................................... 167About Style Editor

.......................................................................................................................................................... 169Adding new fonts to Style Editor

.......................................................................................................................................................... 170Customizing layout

.......................................................................................................................................................... 174Customizing style and color scheme

.......................................................................................................................................................... 184Page layouts ......................................................................................................................................................... 184Add/Edit/View page layouts......................................................................................................................................................... 190List page layouts......................................................................................................................................................... 196Search page layouts

................................................................................................................................... 19916 Visual Editor .......................................................................................................................................................... 199"Edit as" settings ......................................................................................................................................................... 199"Edit as" settings......................................................................................................................................................... 203ColorPicker......................................................................................................................................................... 204Date......................................................................................................................................................... 206File/Image......................................................................................................................................................... 210Lookup w izard......................................................................................................................................................... 220SignaturePad......................................................................................................................................................... 220Text area......................................................................................................................................................... 221Text f ield......................................................................................................................................................... 222Time......................................................................................................................................................... 223Validation types.......................................................................................................................................................... 227"Filter as" settings ......................................................................................................................................................... 227"Filter as" settings......................................................................................................................................................... 229Boolean......................................................................................................................................................... 230Interval list......................................................................................................................................................... 232Interval slider......................................................................................................................................................... 233Values list.......................................................................................................................................................... 236"View as" settings ......................................................................................................................................................... 236"View as" settings......................................................................................................................................................... 239Audio

PHPRunner 7.1 ManualIII

2014 Xlinesoft

......................................................................................................................................................... 240Custom

......................................................................................................................................................... 242File

......................................................................................................................................................... 243Image

......................................................................................................................................................... 245Map

......................................................................................................................................................... 247QRCode

......................................................................................................................................................... 247Video.......................................................................................................................................................... 248Customizing appearance ......................................................................................................................................................... 248Add button to 'With selected' popup......................................................................................................................................................... 250Display details table on tab on Add/Edit/View page of master record.......................................................................................................................................................... 253About .......................................................................................................................................................... 258Toolbars .......................................................................................................................................................... 261Page Elements .......................................................................................................................................................... 265Adding PHP code snippet .......................................................................................................................................................... 267Adding CAPTCHA .......................................................................................................................................................... 269Insert button .......................................................................................................................................................... 275Insert Google Map .......................................................................................................................................................... 279Menu builder

................................................................................................................................... 28417 Event Editor

................................................................................................................................... 29018 Output directory settings

................................................................................................................................... 29219 After you are done

................................................................................................................................... 29420 FTP upload

................................................................................................................................... 29621 FrontPage Publishing

Part III Advanced topics 298................................................................................................................................... 2981 Events

.......................................................................................................................................................... 298Predefined actions ......................................................................................................................................................... 298Send simple email......................................................................................................................................................... 299Send email w ith new data......................................................................................................................................................... 300Send email w ith old data......................................................................................................................................................... 301Save new data in another table......................................................................................................................................................... 303Save old data in another table......................................................................................................................................................... 304Insert a record into another table......................................................................................................................................................... 305Check if specif ic record exists......................................................................................................................................................... 307Display a message on the Web page......................................................................................................................................................... 308Redirect to another page.......................................................................................................................................................... 308Sample events ......................................................................................................................................................... 308Appearance

......................................................................................................................................... 308Add custom field to form

......................................................................................................................................... 309Add dropdow n list box w ith values for search

......................................................................................................................................... 309Add foldable section

......................................................................................................................................... 310Add link to user profile to the menu

......................................................................................................................................... 311Add new button to Add/Edit pages

......................................................................................................................................... 312Change cell background color

......................................................................................................................................... 312Change font in dropdow n list

......................................................................................................................................... 312Change 'Logged on as' message

......................................................................................................................................... 312Change row background color

......................................................................................................................................... 312Change w idth of edit box w ith AJAX popup

......................................................................................................................................... 313Change w idth of text f ield on Quick Search panel

......................................................................................................................................... 313Disable record editing

......................................................................................................................................... 313Hide buttons in some row s of datagrid

......................................................................................................................................... 314Hide controls on Add/Edit pages, based on logged user name

......................................................................................................................................... 314Hide empty f ields on View page

IVContents

IV

2014 Xlinesoft

......................................................................................................................................... 315Hide repeating values on List page

......................................................................................................................................... 316Make search button return data only w hen search value w as entered

......................................................................................................................................... 317Print search parameters on List page

......................................................................................................................................... 317Redirect to details page after master record w as added

......................................................................................................................................... 318Show data from master table on detail view /edit/add page

......................................................................................................................................... 319Show dropdow n list of US states if US w as selected in country list

......................................................................................................................................... 319Show pop-up w indow......................................................................................................................................................... 320Database

......................................................................................................................................... 320Before deleting a record check for related records

......................................................................................................................................... 320Dynamic SQL query

......................................................................................................................................... 321Limit number of records users can add

......................................................................................................................................... 322Select multiple values from checkboxes or a list f ield and have themappear as individual database entries

......................................................................................................................................... 322Show list of customer orders

......................................................................................................................................... 323Store the date and time w hen a record is modif ied

......................................................................................................................................... 323Update multiple records on the List page

......................................................................................................................................... 324Update multiple tables......................................................................................................................................................... 325Email

......................................................................................................................................... 325Email selected records

......................................................................................................................................... 327Send an email to selected users

......................................................................................................................................... 330Send an email w ith updated f ields only

......................................................................................................................................... 330Send mass email to all users

......................................................................................................................................... 331Send an email w ith attachment from the database......................................................................................................................................................... 332Upload

......................................................................................................................................... 332Rename uploaded f iles......................................................................................................................................................... 333Misc

......................................................................................................................................... 333Check if start date is ealier than end date

......................................................................................................................................... 333Implementing 'single sign on' feature

......................................................................................................................................... 334Redirect to user info edit page

......................................................................................................................................... 334Restrict access to PHPrunner application by IP address

......................................................................................................................................... 335Save user data in session variables

......................................................................................................................................... 335Speed up data entry using events.......................................................................................................................................................... 335Global events ......................................................................................................................................................... 335Login page

......................................................................................................................................... 335Before process

......................................................................................................................................... 336Before login

......................................................................................................................................... 337After successful login

......................................................................................................................................... 338After unsuccessful login

......................................................................................................................................... 338Before display

......................................................................................................................................... 340JavaScript OnLoad......................................................................................................................................................... 341Menu page

......................................................................................................................................... 341Before process

......................................................................................................................................... 341Before display

......................................................................................................................................... 343JavaScript OnLoad......................................................................................................................................................... 343Register page

......................................................................................................................................... 343Before process

......................................................................................................................................... 344Before registration

......................................................................................................................................... 345After successful registration

......................................................................................................................................... 346After unsuccessful registration

......................................................................................................................................... 347Before display

......................................................................................................................................... 348JavaScript OnLoad......................................................................................................................................................... 349Change passw ord page

......................................................................................................................................... 349Before process

......................................................................................................................................... 350Before change passw ord

PHPRunner 7.1 ManualV

2014 Xlinesoft

......................................................................................................................................... 350After passw ord changed

......................................................................................................................................... 351Before display

......................................................................................................................................... 352JavaScript OnLoad......................................................................................................................................................... 353Remind passw ord page

......................................................................................................................................... 353Before process

......................................................................................................................................... 354Before passw ord reminder sent

......................................................................................................................................... 355After passw ord reminder sent

......................................................................................................................................... 356Before display

......................................................................................................................................... 357JavaScript OnLoad......................................................................................................................................................... 358After application initialized......................................................................................................................................................... 359Menu item: Modify......................................................................................................................................................... 361Before audit log.......................................................................................................................................................... 362Table events ......................................................................................................................................................... 362Add page

......................................................................................................................................... 362Before process

......................................................................................................................................... 363Copy page: OnLoad

......................................................................................................................................... 364Before record added

......................................................................................................................................... 365After record added

......................................................................................................................................... 366Process record values

......................................................................................................................................... 367Before display

......................................................................................................................................... 368JavaScript OnLoad......................................................................................................................................................... 369Edit page

......................................................................................................................................... 369Before process

......................................................................................................................................... 370Before record updated


......................................................................................................................................... 372After record updated

......................................................................................................................................... 374Before SQL query

......................................................................................................................................... 374Before display

......................................................................................................................................... 375JavaScript OnLoad......................................................................................................................................................... 376List page

......................................................................................................................................... 376Before process

......................................................................................................................................... 377Before record deleted

......................................................................................................................................... 378After record deleted

......................................................................................................................................... 379After group of records deleted

......................................................................................................................................... 380Before SQL query

......................................................................................................................................... 380Before record processed

......................................................................................................................................... 381After record processed

......................................................................................................................................... 382Before display

......................................................................................................................................... 383JavaScript OnLoad

......................................................................................................................................... 384Get Row Count

......................................................................................................................................... 385Custom Query

......................................................................................................................................... 386Custom record fetch......................................................................................................................................................... 387Report page

......................................................................................................................................... 387Before process

......................................................................................................................................... 388Before display

......................................................................................................................................... 389Before SQL query

......................................................................................................................................... 389JavaScript OnLoad......................................................................................................................................................... 390Chart page

......................................................................................................................................... 390Before process

......................................................................................................................................... 391Before SQL query

......................................................................................................................................... 392Before display


......................................................................................................................................... 394Update chart settings......................................................................................................................................................... 399Printer-friendly page

VIContents

VI

2014 Xlinesoft

......................................................................................................................................... 399Before process

......................................................................................................................................... 399Before SQL query

......................................................................................................................................... 400Before record processed

......................................................................................................................................... 401After record processed

......................................................................................................................................... 402Before display

......................................................................................................................................... 403JavaScript OnLoad......................................................................................................................................................... 404View page

......................................................................................................................................... 404Before process


......................................................................................................................................... 406Before SQL query

......................................................................................................................................... 407Before display

......................................................................................................................................... 408JavaScript OnLoad......................................................................................................................................................... 408Search page

......................................................................................................................................... 408Before process

......................................................................................................................................... 409Before display

......................................................................................................................................... 410JavaScript OnLoad......................................................................................................................................................... 411Import page

......................................................................................................................................... 411Before record inserted

......................................................................................................................................... 412Before import started

......................................................................................................................................... 413After import f inished......................................................................................................................................................... 413Export page

......................................................................................................................................... 413Before process

......................................................................................................................................... 414Before SQL query


......................................................................................................................................... 416Before record exported......................................................................................................................................................... 417After table initialized......................................................................................................................................................... 418Get Table Permissions......................................................................................................................................................... 419Is Record Editable.......................................................................................................................................................... 420Page life cycle overview .......................................................................................................................................................... 423Common event parameters

................................................................................................................................... 4252 Programming topics .......................................................................................................................................................... 425Buttons ......................................................................................................................................................... 425Button object

......................................................................................................................................... 425Button object

......................................................................................................................................... 425Methods................................................................................................................................... 425getCurrentRecord................................................................................................................................... 426getNextSelectedRecord

......................................................................................................................................................... 427row Data object......................................................................................................................................... 427row Data object

.......................................................................................................................................................... 428Data Access Layer (DAL) ......................................................................................................................................................... 428About Data Access Layer......................................................................................................................................................... 430Methods

......................................................................................................................................... 430Add

......................................................................................................................................... 430CustomQuery

......................................................................................................................................... 431Delete

......................................................................................................................................... 432DBLookup

......................................................................................................................................... 433FetchByID

......................................................................................................................................... 433Query

......................................................................................................................................... 435QueryAll

......................................................................................................................................... 435TableName

......................................................................................................................................... 436Update

......................................................................................................................................... 437UsersTableName

......................................................................................................................................... 437w hereAdd.......................................................................................................................................................... 438Javascript API

PHPRunner 7.1 ManualVII

2014 Xlinesoft

......................................................................................................................................................... 438About Javascript API

......................................................................................................................................................... 439Control object......................................................................................................................................... 439About Control object......................................................................................................................................... 442Methods

................................................................................................................................... 442addClass

................................................................................................................................... 442addStyle

................................................................................................................................... 443addValidation

................................................................................................................................... 445clear

................................................................................................................................... 445clearEvent

................................................................................................................................... 446getDispElem

................................................................................................................................... 446getValue

................................................................................................................................... 447hide

................................................................................................................................... 448invalid

................................................................................................................................... 448isReadonly

................................................................................................................................... 449makeReadonly

................................................................................................................................... 450makeReadWrite

................................................................................................................................... 450on

................................................................................................................................... 451removeClass

................................................................................................................................... 452removeValidation

................................................................................................................................... 453reset

................................................................................................................................... 454setDisabled

................................................................................................................................... 454setEnabled

................................................................................................................................... 455setFocus

................................................................................................................................... 455setValue

................................................................................................................................... 456show

................................................................................................................................... 457validate

................................................................................................................................... 458validateAs......................................................................................................................................................... 459InlineRow object

......................................................................................................................................... 459About InlineRow object......................................................................................................................................................... 460RunnerPage object

......................................................................................................................................... 460About RunnerPage object

......................................................................................................................................... 460Methods................................................................................................................................... 460getSearchController................................................................................................................................... 461hideField................................................................................................................................... 462show Field

......................................................................................................................................................... 463SearchController object......................................................................................................................................... 463About SearchController object......................................................................................................................................... 464Methods

................................................................................................................................... 464addField

................................................................................................................................... 465clear

................................................................................................................................... 465deleteField

................................................................................................................................... 466display

................................................................................................................................... 467getSearchFields

................................................................................................................................... 468toggleCriteria

................................................................................................................................... 468toggleOptions......................................................................................................................................................... 469SearchField object

......................................................................................................................................... 469About SearchField object

......................................................................................................................................... 471Methods................................................................................................................................... 471addOption................................................................................................................................... 471getControl................................................................................................................................... 472getName................................................................................................................................... 473getOption................................................................................................................................... 473getOptions................................................................................................................................... 474getSecondControl

VIIIContents

VIII

2014 Xlinesoft

................................................................................................................................... 474remove

................................................................................................................................... 475removeOption

................................................................................................................................... 476setOption......................................................................................................................................................... 476Examples

......................................................................................................................................... 476How to access PHP variables

......................................................................................................................................... 478How to ask for confirmation before saving record

......................................................................................................................................... 478How to calculate values on the f ly

......................................................................................................................................... 479How to change font in dropdow n list

......................................................................................................................................... 479How to change font in "edit" controls

......................................................................................................................................... 481How to change w idth of edit box w ith AJAX popup

......................................................................................................................................... 481How to change w idth of text f ield on Quick Search panel

......................................................................................................................................... 482How to control Inline Add/Edit functionality from script

......................................................................................................................................... 483How to convert input into upper case

......................................................................................................................................... 483How to display all Options on Search panel

......................................................................................................................................... 484How to enable/disable a button

......................................................................................................................................... 486How to hide 'Edit selected'/'Delete selected' buttons

......................................................................................................................................... 487How to refresh grid on List page

......................................................................................................................................... 488How to refresh List page after Inline Add/Edit

......................................................................................................................................... 488How to show dropdow n list of US states

......................................................................................................................................... 489How to w ork w ith foldable section

......................................................................................................................................... 490How to w ork w ith tabs.......................................................................................................................................................... 491Page class ......................................................................................................................................................... 491About Page class......................................................................................................................................................... 492Methods

......................................................................................................................................... 492getCurrentRecord

......................................................................................................................................... 492getMasterRecord

......................................................................................................................................... 493hideField

......................................................................................................................................... 494setProxyValue

......................................................................................................................................... 494show Field.......................................................................................................................................................... 495SQLQuery class ......................................................................................................................................................... 495About SQLQuery class......................................................................................................................................................... 496Methods

......................................................................................................................................... 496addField

......................................................................................................................................... 497addWhere

......................................................................................................................................... 497deleteField

......................................................................................................................................... 498replaceField

......................................................................................................................................... 499replaceWhere.......................................................................................................................................................... 500Troubleshooting tips ......................................................................................................................................................... 500Troubleshooting charts......................................................................................................................................................... 503Troubleshooting custom buttons......................................................................................................................................................... 507Troubleshooting Javascript errors......................................................................................................................................................... 511Troubleshooting tips.......................................................................................................................................................... 512How to create your own Edit control plugin .......................................................................................................................................................... 518How to execute SQL Server/MySQL stored procedures .......................................................................................................................................................... 518Master-details relationships .......................................................................................................................................................... 519PHPRunner session variables .......................................................................................................................................................... 522PHPRunner templates .......................................................................................................................................................... 525runner_mail function .......................................................................................................................................................... 528Template files processing rules (Files.txt) .......................................................................................................................................................... 528Template language .......................................................................................................................................................... 534Useful links .......................................................................................................................................................... 535Using JOIN SQL queries

................................................................................................................................... 5363 Publishing PHP application to the remote Web server .......................................................................................................................................................... 536Using FTP client to publish PHP pages to the remote Web server

PHPRunner 7.1 ManualIX

2014 Xlinesoft

.......................................................................................................................................................... 537Using FrontPage to publish PHP pages to the remote Web server ................................................................................................................................... 5394 Demo Account

.......................................................................................................................................................... 539What is the Demo Account?

.......................................................................................................................................................... 539Terms and Conditions ................................................................................................................................... 5415 Web reports

.......................................................................................................................................................... 541Online report/chart builder

.......................................................................................................................................................... 546Creating web report

.......................................................................................................................................................... 559Creating web chart

.......................................................................................................................................................... 571Custom SQL ................................................................................................................................... 5756 Domain host instructions

.......................................................................................................................................................... 575Yahoo! ......................................................................................................................................................... 575Connecting to MySQL......................................................................................................................................................... 580Configuring FTP......................................................................................................................................................... 581Publishing project via FTP.......................................................................................................................................................... 5831&1 ......................................................................................................................................................... 583Connecting to MySQL......................................................................................................................................................... 588Configuring FTP......................................................................................................................................................... 589Publishing project via FTP.......................................................................................................................................................... 591GoDaddy.com ......................................................................................................................................................... 591Connecting to MySQL......................................................................................................................................................... 594Configuring FTP......................................................................................................................................................... 596Publishing project via FTP.......................................................................................................................................................... 598WebHost4Life.com ......................................................................................................................................................... 598Connecting to MySQL......................................................................................................................................................... 601Configuring FTP......................................................................................................................................................... 602Publishing project via FTP.......................................................................................................................................................... 604MyHosting.com ......................................................................................................................................................... 604Connecting to MySQL......................................................................................................................................................... 608Configuring FTP......................................................................................................................................................... 610Publishing project via FTP.......................................................................................................................................................... 612InspiRunner.com ......................................................................................................................................................... 612Connecting to MySQL......................................................................................................................................................... 614Configuring FTP......................................................................................................................................................... 615Publishing project via FTP

................................................................................................................................... 6197 Intellisense config files

................................................................................................................................... 6208 How to install local web server (XAMPP)

................................................................................................................................... 6269 How to add external css/php/js files

................................................................................................................................... 62710 Connect to remote MySQL database via PHP

................................................................................................................................... 63111 AJAX-based Functionality

................................................................................................................................... 63712 Localizing PHPRunner applications

................................................................................................................................... 64313 Layouts

................................................................................................................................... 65414 Rich Text Editor plugins

................................................................................................................................... 65715 PDF view settings

................................................................................................................................... 65816 Web interface guide

................................................................................................................................... 66017 Mobile Template

................................................................................................................................... 66418 Upgrade notes

Part IV Order PHPRunner online 666

XContents

X

2014 Xlinesoft

PHPRunner 7.1 Manual1

2014 Xlinesoft

1 Introduction

1.1 Welcome

Welcome and thank you for choosing PHPRunner!

PHPRunner creates a set of PHP pages to access and modify any MySQL, Oracle, MS SQLServer, PostgreSQL or MS Access database. Using generated PHP pages users can search,edit, delete, and add data into database. PHPRunner is extremely easy to learn, you can getstarted in just 15 minutes!

Templates

PHPRunner offers a large number ofapplication templates - ready-made themedwebsites with complete graphical interfaceand database structure. All of the templatesare easy to work with and completelycustomizable. The template could be used asa stand alone website, or could be integratedwith other PHPRunner web applications. Someof the templates available with PHPRunnerare: cars, classified ads, knowledge base, realestate, job listings, and news.

More info

Wide range of database support

Introduction 2

2014 Xlinesoft

PHPRunner supports four database typesincluding MySQL, SQL Server, MS Access, andPostgreSQL. Even if you don't have adatabase, the software will help you createone.

PHPRunner lets you connect to your localdatabase or a database located on a remoteserver. If you have a remote MySQLdatabase, which does not allow for a directconnection, you will be able to connect to itusing "PHP proxy" method.

More info

Visual Editor

WYSIWYG Visual Editor in PHPRunner allowsyou to customize the look and feel of yourapplication with ease of drag-n-drop.PHPRunner will present you with the proposedlayout for each page. However, all of theelements on the pages can easily be modified.The Visual Editor allows you to drag and drop,copy and paste the objects around the page.For all of the fields and labels on the pageyou can change the font, size, color, style,indentation, and alignment. The Visual Editorallows you to jump into generated HTML codeand make your modifications there.

More info

Reports and Charts


2014 Xlinesoft

PHPRunner let's you build sophisticated color-rich, highly customizable interactive chartsand reports to complement your website. Youwill be able to choose from multiple chart andreport types.

You can also get a Web Charts and ReportsBuilder as part of the Enterprise Edition ofPHPRunner, which will let you build the chartsand reports online. Just like in the software,Web Charts and Reports Builder offers a largeselection of charts and reports that take justminutes to build. You can reuse the samesecurity settings you've establish in theprogram to decide which data sources youwould like to expose to the users, and whatpermissions those users will have.

Application Preview

After you have built your web application,PHPRunner provides you with multiple optionshow to preview it. You can view yourapplication in browser locally. You can uploadfiles to the remote Web server using built-inFTP client. You can publish your applicationto our Demo Server or simply sign up for ourhosting specifically dedicated to PHPRunnercustomers.

More info

SQL Editor

Introduction 4

2014 Xlinesoft

PHPRunner automatically creates a SQL querythat can be easily modified in the graphicalpane or as text. The SQL Editor also allowsyou to preview the results of your SQLstatement, create joins with drag and dropand specify the criteria (where, order by,group by etc).

More info

Security

PHPRunner allows you to password-protectthe access to your web application. You caneither hardcode the username and password,store the login combinations in the databaseor use Active Directory authentication. Youcan add Login with Facebook option to yoursite. PHPRunner also allows you to set theuser groups permission where you can restrictthe tables and views, pages, and sitefunctionality either right in the software oronline.

Enterprise Edition of PHPRunner adds ActiveDirectory support.

More info

User Login Settings


2014 Xlinesoft

PHPRunner lets you create a New UserRegistration page as well as secure yourpages from SPAM abusers using CAPTCHAprotection, which easily determines whetherthe user is a computer or a human. You canalso restrict the users from entering weakpasswords and allow them to requestpassword reminders.

More info

Dynamic Permissions

With dynamic permissions PHPRunner will letyou create and modify the permissions andassign users to certain groups right from thegenerated web application. Every time youwill need to modify the permissions, create anew group or assign users to groups you willnot have to rebuild your project. DynamicPermissions are especially helpful in largercorporations where the application securityadministrators are not the actual users ofPHPRunner software.

More info

Style Editor

Introduction 6

2014 Xlinesoft

With Style Editor in PHPRunner you cancustomize the visual appearance of your webapplication by selecting from a wide range ofpage layouts and color schemes andmodifying them. You can instantly previewthe results.

More info

Multilanguage support

PHPRunner supports more than 30 languagesgiving your users an ability to choose thelanguage while logging in. You can also addthe translations for table names and fields.The list of supported languages includes:Afrikaans, Arabic, Bosnian, Catalan, Chinese,Chinese (Hong Kong S.A.R.), Chinese(Taiwan), Croatian, Danish, Dutch (Belgian),Dutch (Standard), English, French, German,Greek, Hebrew, Hungarian, Indonesian,Italian, Japanese, Malaysian, Norwegian(Bokmal), Polish, Portuguese (Brazil),Portuguese (Standard), Romanian, Slovak,Spanish, Swedish, Thai, Turkish, Urdu.

More info

Events


2014 Xlinesoft

With PHPRunner you can expand thefunctionality of your application by insertingevents- fragments of PHP code. You will beable to define what an event should do andwhen it should be executed. A typical eventwould be to send an email with a new data,save data in another table, check recorduniqueness, show related to current recordinfo etc. You can either select one ofpredefined events or write your own fromscratch.

More info

Master-Detail Relationships

In PHPRunner all of your data sources and therelationships between them, including master-detail, are visually displayed making themvery intuitive to understand and manage. Youwill be able to link two or more data sets witheasy of drag-n-drop. Once you have therelationships established, in the applicationyou can navigate through master records andquickly jump over to the details of thoserecords. Some basic scenarios of master-detail relationships would be customer andorders data, patient and medical records orstudent-and courses information.

More info

Rich Text Editor Controls

Introduction 8

2014 Xlinesoft

PHPRunner supports three third party richtext editors to allow for a great control overcontent formatting including commonstructural treatments like lists; formattingtreatments like bold and italic text, and drag-and-drop inclusion and sizing of images. Thethree options include the Basic Rich TextEditor, CKEditor, and InnovaStudio Editor thatvary in features, versatility, and footprint.

More info

Images and Documents

PHPRunner lets you upload the documentsand images of any type to the database or toa directory on the web server. You can alsocreate the image thumbnails on the fly, resizethem on upload, and display them using iBox.

More info

Dependent Drop-down Boxes


2014 Xlinesoft

With PHPRunner, you can use linked drop-down boxes, where values shown in thesecond drop-down box depend on the valueyou've chosen in the first one. You can linktogether as many drop-down boxes as youneed in a linear chain or have multiple drop-down boxes link to the same master drop-down control.

More info

Edit Controls

PHPRunner offers a large variety of editcontrols, which allow you to customize theappearance of the fields on Edit and Addpages. The field formats that you can choosefrom include text field, date, time, check box,radio button, file/image, lookup wizard andothers.

More info

Integration With Existing Website

Introduction 10

2014 Xlinesoft

PHPRunner lets you seamlessly integrate theweb applications you build into your existingwebsite. You will be able to closely match thelook and feel of all of your pages.

Ajax-based functionality

PHPRunner comes with built-in AJAX-basedfunctionality making your websites much moreuser-friendly. You can search informationmore easily than ever with google-like auto-suggest feature. The AJAX driven dependentdropdown boxes also load much faster. WithAjax you will be able to preview the contentby simply hovering over the links.

More info

FTP Upload


2014 Xlinesoft

PHPRunner will let you upload the entire setof pages to your web server via FTP. You willbe able to set the upload properties based onyour needs.

More info

Create/Modify Database Tables

PHPRunner will let you create and modifytables right in the software. You will haveaccess to table properties where you can setthe field names, types, sizes, as well as setthe primary key field. If you don't have adatabase at all, PHPRunner will let you createone too.

More info

Additional Templates

Introduction 12

2014 Xlinesoft

To complement the list of our built-inapplication templates we offer three moretemplates that make up the Templates Packthat could significantly enhance your webapplication. The Templates Pack includes theShopping Cart template, Calendar templateand Members template. The Templates Packis available for purchase to all existingPHPRunner users and is 100% guaranteed tointegrate with your other PHPRunner projects.

Cascade Menu Builder

Cascade Menu Builder lets you organize yourtables into a multi-level menu for quickerna