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
 
 

Quick start guide

 

This is step-by-step tutorial that will help you build your first PHP pages quickly. Hit Help button if you need more information during the process.

Note: To get more familiar with PHPRunner, you can also watch flash tutorials that are available at http://www.xlinesoft.com/phprunner/php-database.htm.

Run PHPRunner application after you installed it on your computer. It can be found at Start -> Programs -> PHPRunner -> PHPRunner.

On the first screen enter a project name and a project location. If you already have a database select Application Wizard to build the project from scratch. Otherwise, you can select one of the predefined templates and get a themed web site and database created for you. Click Next>>.

On the next screen you need to connect to MySQL database. If you do not have MySQL server, read how to install local server.

Connect to MySQL and select the database or create a new one. When finished click Next>>.

Select datasource tables from the list of available tables. Click Next>>. On the next screen you can modify SQL query.

On the next screen choose pages you would like to create and select key fields.

Note: Key column is the datasource column which lets you query each table row individually and modify each row without altering other rows in the same table. The values that compose a key column are always unique. When finished click Next>>.

On the next several screens you can choose the fields to appear on each page, customize your data appearance and set the fields order on each page. You can also modify the miscellaneous settings.

Security screen allows you to protect an access to your database. Refer to security settings for more information. Click Next>>.

On the next screen you can choose a theme for displaying the pages.

Visual editor allows you to customize the look and feel of your web pages in a more user-friendly way.

On the next screen you can enhance your web site functionality by adding events.

You are almost finished! On the next screen select output directory where you like to put generated PHP pages and image files. Press Build to generate files. You are done! Now you are ready to test the generated application.

To preview your application locally, you need the Internet Information Server or Apache up and running on your computer. If you do not have a web server, read how to install a local Web server article. You can also upload the 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.

Here is the sample generated page:

 

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