Storing field labels and visibility rules in the database

PHP, PHP Code Generator, Tutorials

You need to change some field labels in your project but don’t want to rebuild and upload the whole project. In this tutorial, we’ll show how to do that by storing field labels in the database and displaying them dynamically. As a bonus, we’ll also show how to hide fields based on visibility rules stored in the database, and make fields read-only or required.

First, we need to create a table in the database to store all those settings. We would need fields like table name, field name, field label and visibility. Here is the sample table script for MySQL.

Continue Reading "Storing field labels and visibility rules in the database" →

In-place editing

ASP.NET, PHP, PHP Code Generator, PHP Form Generator, Tutorials

The code in this article was updated to be compatible with version 10.x of PHPRunner, ASPRunner.NET and ASPRunnerPro.

Similar to Excel-like grid discussed in previous article this technique helps you to achieve similar goals. Instead of bringing up the whole edit page you can click that single field you need to edit, change its value and see your changes posted to the database automatically.

Continue Reading "In-place editing" →

Excel like grid in PHPRunner applications

PHP, PHP Code Generator, PHP Form Generator, Tutorials

Some applications may require to provide users with quick editing capabilities. While Inline Edit does just that entering inline edit mode for multiple records can be painful. It would be much easier is some or all fields appear as edit controls when page is loaded.

While PHPRunner/ASPRunner.NET/ASPRunnerPro do not have such functionality built-in it’s fairly easy to implement it in your project. In this sample project we’ll show how to make fields ProductName, UnitPrice and Discontinued editable automatically. For now we only support text boxes and check boxes. Data is saved automatically once you leave the text box or check off check box. To see that data is actually saved in the database simply reload the page.

You can also see how server-side validation works. Enter Unit Price that is less than $20 and move to the next field to see it in action. Record won’t be saved until you enter $20 or more price value.

Live demo

Continue Reading "Excel like grid in PHPRunner applications" →

Adding PDF preview support to your web application

PHP, Tutorials

In recent Using Google Docs Viewer to preview documents online article we reviewed the use of Google Docs Viewer for document preview purposes. While this is a viable approach two main concerns arise:

  • dependency on third party service
  • security issues

For those who is looking for another solution there is a brilliant Javascript library named ViewerJS that supports PDF files as well as Open Office formats (.odp, .odt, .ods). This library can display documents right in the web browser, no need to install any additional software. Documents can be displayed either in full page mode or embedded into other pages. See some examples.

Continue Reading "Adding PDF preview support to your web application" →

New mapping features

ASP.NET, News, PHP, Tutorials

The latest version of Runner family products comes with several improvements in mapping area like support of Bing and OpenStreet maps, maps in dashboards, custom map markers etc. In this article I want to show a couple more mapping features that you can use in your apps, heat maps and clustered maps.

Live demo

Both those features can help you visualize large amounts of mapping data. It gives your users a better insight on your data. For instance, those maps tell you that if you are a taxi driver in NYC, your chances to pickup a passenger are higher if you are nearby Trump Tower.

Continue Reading "New mapping features" →

PHPRunner 8.1, ASPRunnerPro 9.1, ASPRunner.NET 8.1 released

ASP.NET, News, PHP, PHP Code Generator, PHP Form Generator

Great news! PHPRunner 8.1, ASPRunnerPro 9.1, ASPRunner.NET 8.1 released. Grab your copy now.

PHPRunner 8.1

More info

New purchase

Upgrade

ASPRunner.NET 8.1

More info

New purchase

Upgrade

ASPRunnerPro 9.1

More info

New purchase

Upgrade

Mobile template v2

New purchase $50

Upgrade from previous version of Mobile template $25

Here is the list of new features in this update.

Free-form design mode

You are no longer required to use HTML tables to arranger fields on Add/Edit/View forms. Turn on free-form mode and drag-n-drop fields and labels where they need to be. This mode is available on Add/Edit/View pages and also on List page in vertical mode.

This is an example of List page edited in free form mode.

Continue Reading "PHPRunner 8.1, ASPRunnerPro 9.1, ASPRunner.NET 8.1 released" →

Displaying a list of users that are currently logged in

News, PHP, Tutorials

Some web applications like forum or Q&A website may benefit from the list of active users displayed somewhere on the page. In this article we’ll show how to add such functionality to PHPRunner application. ASPRunnerPro/ASPRunner.NET code to follow.

We need to remember that sometimes in web application we can not determine if user is still active or left his computer or even closed his browser. What we actually going to do is to find the list of users that performed some action on the website in last 10 minutes.

We assume that login table is named users and username field is username. We are going to add one more datetime field to the login table named lastaccess.

Continue Reading "Displaying a list of users that are currently logged in" →

How to split Add/Edit pages into several subpages

ASP.NET, PHP, PHP Code Generator, PHP Form Generator, Tutorials

Fairly often we want to split long forms into several steps letting users fill a few fields on each step. Besides making a long form easier to fill out for your users you can also save partial results between pages.

Here is how this can be done in PHPRunner, ASPRunnerPro and ASPRunner.NET.

Lets assume we have Cars table with about 20 fields and we want to split Add/Edit pages into three steps.

1. Create two custom views

Create two custom views (Cars1 and Cars2) based on Cars table

Continue Reading "How to split Add/Edit pages into several subpages" →