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.
Note: To get more familiar with PHPRunner, watch the video tutorials available at http://www.xlinesoft.com/phprunner/php-database.htm
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.
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.
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.
Note: If you do not have a database server or web server, see How to install local server..
Then you should provide the database connection credentials. You have an option to select an existing database or to create a new one.
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.
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.
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.
Note. 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.
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.
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.
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.
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.
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.
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.
Have a look at a sample page created with PHPRunner.