Contents

Introduction
Welcome
System requirements
Licensing details
What is the registration
Quick start guide
Using PHPRunner
Working with projects
Navigation bar
Templates
What are templates
Cars
Classified ads
Events
Jobs
Knowledge base
News
Paypal
Real estate
Sporting
Vacation houses
Connecting to the database
Datasource tables
Master-detail relationship between tables
SQL query page
About SQL query designer
Query Designer
SQL
Results
Charts
Creating chart
Chart parameters
Chart appearance
Using SQL to shape chart data
Reports
Creating report and setting parameters
Report totals and layout
Choose pages
Choose fields
Fields order and totals
Miscellaneous settings
Security
Login page
User login settings
Advanced security settings
User group permissions
Dynamic Permissions
Choose theme
Visual Editor
About
Toolbars
Page Elements
Adding PHP code snippet
"View as" settings
"View as" settings: Custom
"Edit as" settings
Validation types
Lookup wizard
Menu builder
Events
Output directory settings
After you are done
FTP upload
FrontPage Publishing
Advanced topics
Events
Predefined actions
Send a simple email
Send an email with new data
Send an email with old data
Save new data in another table
Save old data in another table
Insert a record into another table
Check if a specific record exists
Display a message on the Web page
Redirect to another page
Sample events
Appearance
Add dropdown list box with values for search
Add foldable section
Change cell background color
Change row background color
Disable record editing
Hide controls on Add/Edit pages, based on logged user name
Redirect to details page after master record was added
Show data from master table on detail view/edit/add page
Show pop-up window
Make search button return data only when search value was entered
Database
Before deleting a record check for related records
Select multiple values from checkboxes or a list field and have them appear as individual database entries
Show list of customer orders
Update multiple records on the List page
Update multiple tables
Dynamic SQL query
Record locking
Email
Email selected records
Send an email with updated fields only
Send mass email to all users
Upload
Check size and extension of uploaded files
Rename uploaded files
Upload files to users folders
Misc
Check if start date is ealier than end date
Speed up data entry using events
Save user data in session variables
Implementing 'single sign on' feature
Redirect to user info edit page
Global events
Login page
Before process
Before login
After successful login
After unsuccessful login
Before display
Menu page
Before process
Before display
Register page
Before process
Before registration
After successful registration
After unsuccessful registration
Before display
Change password page
Before process
Before change password
After password changed
Before display
Remind password page
Before process
Before password reminder sent
After password reminder sent
Before display
After application initialized
Table events
Add page
Before process
Before record added
After record added
Before display
Copy page
OnLoad
Edit page
Before process
Before record updated
After record updated
Before SQL query
Before display
List page
Before process
Before record deleted
After record deleted
After group of records deleted
Before SQL query
Before record processed
After record processed
Before display
Printer-friendly page
Before process
Before SQL query
Before record processed
After record processed
Before display
View page
Before process
Before SQL query
Before display
Search page
Before process
Before display
Export page
Before process
Before SQL query
After table initialized
Page life cycle overview
Programming topics
Data Access Layer
Debugging tips
How to control Inline Add/Edit functionality from script
Master-details relationships
PHPRunner session variables
PHPRunner templates
runner_mail function
Template files processing rules (Files.txt)
Template language
Using JOIN SQL queries
Useful links
Publishing PHP application to the remote Web server
Using FTP client to publish PHP pages to the remote Web server
Using FrontPage to publish PHP pages to the remote Web server
Demo Account
What is the Demo Account?
Terms and Conditions
Enterprise Edition
Online report/chart builder
Online report/chart builder v2.0 - Installation notes
Creating web report
Creating web chart
Domain host instructions
Yahoo!
Connecting to MySQL
Configuring FTP
Publishing project via FTP
1&1
Connecting to MySQL
Configuring FTP
Publishing project via FTP
GoDaddy.com
Connecting to MySQL
Configuring FTP
Publishing project via FTP
WebHost4Life.com
Connecting to MySQL
Configuring FTP
Publishing project via FTP
MyHosting.com
Connecting to MySQL
Configuring FTP
Publishing project via FTP
InspiRunner.com
Connecting to MySQL
Configuring FTP
Publishing project via FTP
How to install local web server (XAMPP)
Connect using PHP
AJAX-based Functionality
Multilanguage support
Stylesheets
Rich Text Editor plugins
PDF view settings
Order PHPRunner online

 
Home
PHPRunner 5.1 manual
Prev Page Next Page
 
 

Welcome to PHPRunner manual

 

Welcome and thank you for choosing PHPRunner!

PHPRunner creates a set of PHP pages to access and modify any MySQL, Oracle, MS SQL Server, 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 get started in just 15 minutes!

Templates


PHPRunner offers a large number of application templates - ready-made themed websites with complete graphical interface and database structure. All of the templates are easy to work with and completely customizable. The template could be used as a stand alone website, or could be integrated with other PHPRunner web applications. Some of the templates available with PHPRunner are: cars, classified ads, knowledge base, real estate, job listings, and news.

More info

Templates

 

Wide range of database support


PHPRunner supports four database types including MySQL, SQL Server, MS Access, and PostgreSQL. Even if you don't have a database, the software will help you create one.

PHPRunner lets you connect to your local database or a database located on a remote server. If you have a remote MySQL database, which does not allow for a direct connection, you will be able to connect to it using "PHP proxy" method.

More info

Databases

 

Visual Editor


WYSIWYG Visual Editor in PHPRunner allows you to customize the look and feel of your application with ease of drag-n-drop. PHPRunner will present you with the proposed layout for each page. However, all of the elements 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 page you can change the font, size, color, style, indentation, and alignment. The Visual Editor allows you to jump into generated HTML code and make your modifications there.

More info

Visual Editor

 

Reports and Charts


PHPRunner let's you build sophisticated color-rich, highly customizable interactive charts and reports to complement your website. You will be able to choose from multiple chart and report types.

You can also get a Web Charts and Reports Builder as part of the Enterprise Edition of PHPRunner, which will let you build the charts and reports online. Just like in the software, Web Charts and Reports Builder offers a large selection of charts and reports that take just minutes to build. You can reuse the same security settings you've establish in the program to decide which data sources you would like to expose to the users, and what permissions those users will have.

Reports and Charts

 

Application Preview


After you have built your web application, PHPRunner provides you with multiple options how to preview it. You can view your application in browser locally. You can upload files to the remote Web server using built-in FTP client. You can publish your application to our Demo Server or simply sign up for our hosting specifically dedicated to PHPRunner customers.

More info

Application Preview

 

SQL Editor


PHPRunner automatically creates a SQL query that can be easily modified in the graphical pane or as text. The SQL Editor also allows you to preview the results of your SQL statement, create joins with drag and drop and specify the criteria (where, order by, group by etc).

More info

SQL Editor

 

Security


PHPRunner allows you to password-protect the access to your web application. You can either hardcode the username and password or store the login combinations in the database. PHPRunner also allows you to set the user groups permission where you can restrict the tables and views, pages, and site functionality either right in the software or online.

More info

Security

 

User Login Settings


PHPRunner lets you create a New User Registration page as well as secure your pages from SPAM abusers using CAPTCHA protection, which easily determines whether the user is a computer or a human. You can also restrict the users from entering weak passwords and allow them to request password reminders.

More info

User Login Settings

 

Dynamic Permissions


With dynamic permissions PHPRunner will let you create and modify the permissions and assign users to certain groups right from the generated web application. Every time you will need to modify the permissions, create a new group or assign users to groups you will not have to rebuild your project. Dynamic Permissions are especially helpful in larger corporations where the application security administrators are not the actual users of PHPRunner software.

More info

Dynamic Permissions

 

Multiple Colors and Themes


With PHPRunner you can chose a theme for your web application by selecting from a wide range of page layouts and color schemes. You can mix and match any color with any layout to make your website as unique as you wish.

More info

Colors and Themes

 

Multilanguage support


PHPRunner supports more than 30 languages giving your users an ability to choose the language while logging in. You can also add the 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

Multilanguage support

 

Events


With PHPRunner you can expand the functionality of your application by inserting events- fragments of PHP code. You will be able to define what an event should do and when it should be executed. A typical event would be to send an email with a new data, save data in another table, check record uniqueness, show related to current record info etc. You can either select one of predefined events or write your own from scratch.

More info

Events

 

Master-Detail Relationships


In PHPRunner all of your data sources and the relationships between them, including master-detail, are visually displayed making them very intuitive to understand and manage. You will be able to link two or more data sets with easy of drag-n-drop. Once you have the relationships established, in the application you can navigate through master records and quickly jump over to the details of those records. Some basic scenarios of master-detail relationships would be customer and orders data, patient and medical records or student-and courses information.

More info

Master-Detail Relationships

 

Rich Text Editor Controls


PHPRunner support three third party rich text editors to allow for a great control over content formatting including common structural treatments like lists; formatting treatments like bold and italic text, and drag-and-drop inclusion and sizing of images. The three options include the Basic Rich Text Editor, FCKEditor, and InnovaStudio Editor that vary in features, versatility, and footprint.

More info

Rich Text Editors

 

Images and Documents


PHPRunner lets you upload the documents and images of any type to the database or to a directory on the web server. You can also create the image thumbnails on the fly, resize them on upload, and display them using iBox.

More info

Images and Documents

 

Dependent Drop-down Boxes


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

More info

Dependent Drop Down Boxes

 

Edit Controls


PHPRunner offers a large variety of edit controls, which allow you to customize the appearance of the fields on Edit and Add pages. The field formats that you can choose from include text field, date, time, checkbox, radio button, file/image, lookup wizard and others

More info

Edit Controls

 

Integration With Existing Website


PHPRunner lets you seamlessly integrate the web applications you build into your existing website. You will be able to closely match the look and feel of all of your pages.

Integration With Existing Website

 

Ajax-based functionality


PHPRunner comes with built-in AJAX-based functionality making your websites much more user-friendly. You can search information more easily than ever with google-like auto-suggest feature. The AJAX driven dependent dropdown boxes also load much faster. With Ajax you will be able to preview the content by simply hovering over the links.

More info

Integration With Existing Website

 

FTP Upload


PHPRunner will let you upload the entire set of pages to your web server via FTP. You will be able to set the upload properties based on your needs.

More info

FTP Upload

 

Create/Modify Database Tables


PHPRunner will let you create and modify tables right in the software. You will have access to table properties where you can set the field names, types, sizes, as well as set the primary key field. If you don't have a database at all, PHPRunner will let you create one too.

More info

Create/Modify Database Tables

 

Additional Templates


To complement the list of our built-in application templates we offer three more templates that make up the Templates Pack that could significantly enhance your web application. The Templates Pack includes the Shopping Cart template, Calendar template and Members template. The Templates Pack is available for purchase to all existing PHPRunner users and is 100% guaranteed to integrate with your other PHPRunner projects.

Additional Templates

 

Cascade Menu Builder


Cascade Menu Builder lets you organize your tables into a multi-level menu for quicker navigation. This feature is particularly useful to users with large number of tables. You can have as many groups and subgroups as you need. Depending on your page layout the cascade menu will appear as a horizontal menu, vertical menu, or a tree-like vertical menu.

More info

Cascade Menu Builder

 

 

Visit PHPRunner online
Visit PHPRunner online

Converted from CHM to HTML with chm2web Standard 2.83 (unicode)