Please enable JavaScript to view this site.

Navigation: Introduction

PHPrunner32x32     PHPRunner manual


Welcome to PHPRunner manual

Scroll Prev Next More

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 the 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 can be used as a stand-alone website or can 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

welcome_templ

 

 

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 helps 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 a direct connection, you can connect to it using "PHP proxy" method.

More info

scrDatabases

 

Multiple database connections


PHPRunner lets you add multiple data sources and mix several database types in a single PHPRunner project. You can have a master table in MySQL and a details table in MS Access. The same applies to lookup tables.

 

The multiple database connections feature is a part of the Enterprise Edition of PHPRunner.

More info

welcome_multiple_db_connections

 

Page Designer


WYSIWYG Page Designer allows you to customize the look and feel of your application by using drag-n-drop and configuring the properties of pages, cells, and elements. PHPRunner presents you with a proposed layout for each page. However, the layout and all of the elements on the pages can be easily modified.

Page Designer 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.

Page Designer also allows you to apply custom CSS to elements.

More info

welcome_pd

 

Reports and Charts


PHPRunner lets you build sophisticated, highly customizable interactive charts and reports to complement your website. You can choose from multiple chart and report types.

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

More info

welcome_chart

 

Dashboards


With PHPRunner you can create various types of easy to read and powerful dashboards. They allow you to display multiple related or unrelated objects on the same page like grids, single record views, master and details together, search pages, maps, or even code snippets. You can change the dashboard layout and customize its appearance.

More info

welcome_dashboards

 

Application Preview


After you have built your web application, PHPRunner provides you with multiple options on how to preview it. You can view your application in the browser locally. You can upload files to the remote Web server using a built-in FTP client or to the Demo Account.

More info

welcome_preview

 

SQL Editor


PHPRunner automatically creates an SQL query that can be visually modified with the Query Designer or edited as a text. The SQL Editor also allows you to preview the results of your SQL statement, create joins with drag-n-drop, and specify the criteria (where, order by, group by, etc.).

More info

welcome_query

 

Security


PHPRunner allows you to password-protect the access to your web application. You can either hardcode the username and password, store the login combinations in the database, or use the Active Directory authentication. You can add the Login with Facebook option to your site and allow guest access.

PHPRunner also allows you to set up user groups permissions where you can restrict access for certain groups of users to tables, views, pages, and site functionality.

Enterprise Edition of PHPRunner adds the Active Directory support.

More info

welcome_security

 

User Login Settings


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

More info

welcome_login

 

Dynamic Permissions


With dynamic permissions, PHPRunner lets you create and modify the permissions and assign users to certain groups within the generated web application. So that when you need to modify the permissions, create a new group, or assign users to groups, you don't have to rebuild the project. Dynamic Permissions are especially helpful for larger corporations where the application security administrators are not the actual users of PHPRunner.

More info

welcome_permissions

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

welcome_muliplelanguages

 

Events


With PHPRunner you can expand the functionality of your application by adding your code to events. Events are actions that are performed automatically when certain conditions are met.

Events allow you to send an email with a new data, save data in another table, check record uniqueness, show info related to the current record, etc. You can either select one of the predefined actions, copy-paste some of the sample events, or write the code from scratch.

More info

scrEvents

 

Master-Details Relationships


With PHPRunner all of your data sources and the relationships between them, including master-details, are visually displayed, making them very intuitive to understand and manage. You can link two or more data sets using drag-n-drop. Once you have established the relationships, you can navigate through master records and quickly jump over to the details of those records in the application.

Some basic scenarios of master-details relationships are customers and their orders data, patients and their medical records, or students and information about their courses.

More info

welcome_details

 

Rich Text Editor Controls


PHPRunner supports three third party rich text editors to make sure you have a measure of control over content formatting. The included editors are Basic Rich Text Editor, CKEditor, and InnovaStudio Editor. They vary in features, versatility, and footprints.

More info

welcome_rich_edit

 

Images and Documents


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

More info

welcome_images

 

Dependent Dropdown Boxes


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

More info

welcome_drop

 

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 you can choose from include text field, date, time, checkbox, radio button, file/image, lookup wizard, and others.

More info

welcome_date

 

Integration With Existing Website


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

scrIntegration

 

Ajax-based functionality


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

More info

welcome_ajax

 

FTP Upload


PHPRunner lets you upload the entire application to your web server via a built-in or a third-party FTP. You can set the upload properties based on your needs.

More info

scrFTP

 

Create/Modify Database Tables


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

More info

scrCreatetables

 

Additional Templates


To complement the list of our built-in application templates, we offer three more templates as the Templates Pack that can 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 for all existing PHPRunner users and is guaranteed to integrate with other PHPRunner projects.

welcome_additional_templates

 

Cascade Menu Builder


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

More info

welcome_menu

 

Import


PHPRunner allows you to import CSV files, Excel 2007 (.xlsx) and Excel 97-2003 (.xls) files. You can copy and paste import data instead of uploading the file that can be extremely useful on mobile devices. Column mapping is also supported.

More info

welcome_import