Troubleshooting SQL queries

Web applications generated by PHPRunner, ASPRunner.NET or ASPRunnerPro communicate with databases via means of SQL queries. Whenever you search, edit or delete data your web application issues a series of SQL queries, gets results back and displays it on the web page. Understanding the basics of SQL will help you build better apps and find errors faster.

Our code generators come will handy option to display all SQL queries application executes. For this purpose you can add the following line of code to AfterApplicationInitialized event:

In PHPRunner

$dDebug = true;

Continue reading Troubleshooting SQL queries »

In-place editing

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.

Live demo
Continue reading In-place editing »

Excel like grid in PHPRunner applications

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 »

PHPRunner 8.1, ASPRunnerPro 9.1, ASPRunner.NET 8.1 released

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 »

Using Google Docs Viewer to preview documents online

Google Docs Viewer provides an excellent option to preview Office documents online. No need to download them to end user machine, no need to have any Office software installed. Supported formats are Microsoft Word, Microsoft Excel and PDF.


Continue reading Using Google Docs Viewer to preview documents online »

Using DAL functions in projects with multiple database connections

PHPRunner 8, ASPRunnerPro 9 and ASPRunner.NET 8 added an option to use multiple database connections in single project. This article explains how you can access data from multiple databases in your events.

Method 1: using DAL functions

Continue reading Using DAL functions in projects with multiple database connections »

How to split Add/Edit pages into several subpages

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 »

Random page background: Halloween edition

Happy Halloween everyone!

Just a little Halloween fun project. To make your website more interesting you can choose to display a random background image for each visitor. Here is how it’s going to look:

Check this live demo. Logon as test/test then logout to . . . → Read More: Random page background: Halloween edition

PHPRunner 8.0/ASPRunnerPro 9.0/ASPRunner.NET 8.0

PHPRunner 8.0/ASPRunnerPro 9.0/ASPRunner.NET 8.0 are here. Purchase info and download links.

Click any image to see the full size screenshot.

Major new features

  1. Dashboards
  2. Multiple database connections (part of Enterprise Edition)
  3. Import page with columns mapping
  4. New Printer page/PDF options (portrait/landscape, fit to page, scale)

Continue reading PHPRunner 8.0/ASPRunnerPro 9.0/ASPRunner.NET 8.0 »

Building a nice looking login page with custom CSS

PHPRunner 7.0 and ASPRunnerPro 8.0 add a new new 'Custom CSS' feature - an easy way to modify the appearance of your pages adding bells and whistles Style Editor doesn't support. Lets see how we can build a custom login page similar to this one:


Continue reading Building a nice looking login page with custom CSS »