PHPRunner 8.1 beta

PHPRunner 8.1 beta is here. Download it now!

This beta is for PHPRunner only. When release time comes (in a few weeks) will make all PHPRunner, ASPRunnerPro and ASPRunner.NET available at the same time. Despite the fact this is only a beta version you can purchase it already.

PHPRunner 8.1 new purchase

PHPRunner 8.1 Standard - $499

PHPRunner 8.1 Enterprise - $799

PHPRunner 8.1 upgrade

Upgrade from PHPRunner Standard 6.x, 7.x, 8.x - $99

Upgrade from PHPRunner Enterprise 6.x, 7.x, 8.x - $200

Upgrade from Standard to Enterprise Edition 8.1 - $399

Note: PHPRunner upgrade doesn't come with support. Support needs to be renewed separately here.

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 beta »

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 »

Displaying a list of users that are currently logged in

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

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 »

Using third party API in PHPRunner apps. Playing with Twitter.

Most popular websites like Facebook, Twitter, Dropbox, LinkedIn etc provide an API that allows to retrieve or post data programmatically. API examples come in many programming languages and PHP is usually one of them. In this article we'll show how easy is to add API calls to your PHPRunner project.

Lets start by adding Twitter posting functionality. We'll be using a lightweight twitter-php library for this purpose. Similar libraries exist for other languages as well.

1. Setup a developer account with Twitter.

A quote from twitter-php usage page:

Sign in to the http://twitter.com and register an application from the http://dev.twitter.com/apps page. Remember to never reveal your consumer secrets. Click on My Access Token link from the sidebar and retrieve your own access token. Now you have consumer key, consumer secret, access token and access token secret.

Continue reading Using third party API in PHPRunner apps. Playing with Twitter. »

Date/time handling in web applications

Date/time calculations can be perform either on database side or in your server side language (PHP, ASP, C#) or even in Javascript. We'll try to cover all those scenarios.

When copying and pasting code from this article to your application replace table name (mytable) and field names (posted, dob).

MySQL

Calculating age

SELECT DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(dob, '%Y') -
(DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(dob, '00-%m-%d'))
from mytable AS age

30 days before date

select posted, DATE_SUB(posted, INTERVAL 30 DAY) from mytable

Date plus 30 days

select posted, DATE_ADD(posted, INTERVAL 30 DAY) from mytable

Difference between two dates in days

select posted, DATEDIFF(now(), posted) from mytable

Continue reading Date/time handling in web applications »

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

Displaying World Cup 2014 data with PHPRunner.

This is a just for fun PHPRunner project for all soccer fans out there. Check this live demo first.

This project uses live World Cup 2014 data provided by http://worldcup.sfg.io/ in JSON. PHPRunner project makes the use of this data and if will not work if they website is down for any reason.

Continue reading Displaying World Cup 2014 data with PHPRunner. »

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 »