Show/Hide Toolbars

Navigation: Introduction

PHPrunner32x32     PHPRunner manual


Quick start guide

Scroll Prev Next More

 

The aim of this step-by-step guide is to help you get an idea about PHPRunner and its main features. After reading it, you will be able to create your project promptly and smoothly. You can always open the help file by pressing the Help button on the navigation bar.

 

yellowbulbNote: To get more familiar with PHPRunner, watch the video tutorials available at http://www.xlinesoft.com/phprunner/php-database.htm  

Start working with the projects

PHPRunner provides an option either to create an application from scratch or to choose one of the application templates. Choose Blank application if you want to build the project from scratch. Otherwise, you can select one of the predefined templates. Templates are pre-made sample projects and they also create all the required database tables for you.

intro_choose_the_project

 

See also:

Working with the projects

Templates

Navigation

You can navigate the PHPRunner application using the bottom panel and clicking Back or Next to move between the screens. Let’s go to the next step.  

intro_navigation_bar

 

See also:

Navigation Bar

Working with databases

PHPRunner supports all popular databases: MySQL, MariaDB, Microsoft SQL Server, Oracle, MS Access, DB2, PostgreSQL, and more. Select the type of the database you are going to use.

intro_choose_the_db_type

 

yellowbulbNote: If you do not have a database server or web server, see how to install it.

 

Then you should provide the database connection credentials. You have an option to select an existing database or to create a new one.

intro_connect_to_the_database

 

See also:

Connecting to the database

Working with Tables

In PHPRunner, you can modify the tables, fields and the database structure, as well as create new tables, queries, and relations between them.

 

You can also create dashboards, charts, and reports on the Tables screen to present your project data in a user-friendly way.

intro_modify_tables

 

See also:

Master-details relationship between tables

Dashboards

Reports

Charts

Queries

This screen provides options for modifying the database and the tables using SQL queries. You can generate SQL queries via Query Designer, or write the code on your own. Using the Query Designer can help you sort and filter your data, create aliases to the fields, and control the data output on the pages. You also can preview the Results and create Additional Where clauses.

intro_queries

 

See also:

About SQL query

SQL

Pages

On the next screen - Pages, you can choose what pages to build for each table. You can also set additional options, for example, show Add/Edit/View pages in a popup or freeze the header of the grid on the List page.

intro_pages_tab

 

yellowbulbNote. Make sure to select a proper key column. A key column is used to identify table rows, so, the key values must be unique for each record.

Fields

On this screen you may choose the fields to appear on each page. Do this by selecting the respective checkboxes. You can also configure Search and Filter settings and set up different columns for a different device types.

intro_fields_page

 

See also:

Choose fields

Visual appearance customization

The next step is the visual appearance customization. On the Page Designer screen you can customize and position the elements, and set the layout and grid type of the pages.

intro_page_designer

 

The Editor screen displays the previews of the pages. You can select a Bootstrap theme, set the size of the elements, add custom CSS code, edit the menu, and view the page as HTML.

intro_page_editor

Miscellaneous settings

Proceed to the Miscellaneous settings screen to configure the projects settings, such as application language, map settings, notifications, SMS and email settings, as well as the Table specific settings, such as number of records per page, Search and Filter settings, and add Next/Prev buttons on Edit/View pages.

intro_misc_settings

Security configuration

Proceed to the Security screen to configure the user registration and authentication system, as well as to restrict access to the database. You can set up a Hardcoded login/password combination, or you can store it in the Database or even use Active Directory. You can also regulate access to the specific tables and pages via User Group Permissions.

intro_security_settings

 

Events

You are able to extend the functionality of your application - by adding your code to Events. Events are actions that are performed automatically when certain conditions are met, for instance: a record was added to the database, or the user opened the List page. You can use sample Event code snippets or write the code on your own.

intro_events

 

See also:

Event editor

Sample events

 

Output

Proceed to the Output screen to select the project output directory - a place to store your project files.

 

You may use the built-in Apache web-server or your own one to preview the project locally.

 

You can also configure the Server database connection.

intro_output

 

See also:

Output directory settings

How to install local web server (XAMPP)

 

Final stages

As soon as everything is completed, you are ready to Build! Now you can preview the application in the browser and start testing it. Moreover, you have options to Open output folder of the project, Create desktop app, or Create SQL Script.

 

Share your application with other people - publish your project using the Demo Account provided by PHPRunner free of charge. You can also upload the files to your web server using a built-in FTP client or any third-party FTP software.

intro_build

See also:

After you are done

 

Have a look at a sample page created with PHPRunner.

intro_project_sample