PHPRunner 9.6, ASPRunner.NET 9.6, ASPRunnerPro 9.6 released

PHPRunner 9.6, ASPRunnerPro 9.6, ASPRunner.NET 9.6 released (November 10th, 2016).

If you purchased or upgraded PHPRunner, ASPRunner.NET or ASPRunnerPro after November 10, 2015 this update is free of charge for you. Logon to control panel at https://xlinesoft.com/dss/support.asp and find download links and registration keys under 'My purchases'. If you do not have a help desk account yet create a new one using the same email address you have used to place the order.

Trial version download links

'Buy now' pages

PHPRunner

ASPRunner.NET

ASPRunnerPro

Upgrade pages

PHPRunner

ASPRunner.NET

ASPRunnerPro

Important: if you purchased PHPRunner, ASPRunnerPro or ASPRunner.NET before November 10th 2015 you have till November 20th, 2016 to use discounted upgrade option. After November 20th, 2016 you will have to purchase software at the full price. Do not miss your chance to upgrade for less.

'Update selected' feature

This is a long awaited feature that allows you quickly makes changes to multiple records. You can choose fields to appear on 'Update selected' dialog. Depending on Edit page settings 'Update selected' page can be shown either in popup or as a separate page.

Continue reading PHPRunner 9.6, ASPRunner.NET 9.6, ASPRunnerPro 9.6 released »

Displaying a popup in PHPRunner 9.0, ASPRunnerPro 9.5, ASPRunner.NET 9.0

In this new version we are providing an easy way to display any page in Bootstrap popup window. Welcome, Runner.displayPopup() function.

The simplest form is really simple. There is only one mandatory parameter, URL of the page to be displayed. You can use this function anywhere you can use Javascript code i.e. in Javascript OnLoad event or ClientBefore event of custom button.

Here is how you can display Add page of Products table in popup:

Runner.displayPopup( {
	url: "products_add.php"
});


Continue reading Displaying a popup in PHPRunner 9.0, ASPRunnerPro 9.5, ASPRunner.NET 9.0 »

Desktop applications with PHPRunner

PHPRunner 9 adds an option to build and package desktop applications as well as web applications. In this article we'll try to answer most common questions and explain what PHPRunner desktop applications can and can not do.

How it works

First of all, Desktop apps functionality is built on the top of wonderful open source PHP Desktop project. PHP Desktop packages together the following software components:

  • web server (Mongoose)
  • PHP
  • Chrome browser

Continue reading Desktop applications with PHPRunner »

Displaying EURO 2016 data with PHPRunner

This is a just for fun PHPRunner project similar to one we built for World Cup 2014. Check this live demo first.

This project requires PHPRunner 9.0. Yes, there is a desktop app for this project. Download it, install it, run it and enjoy. Ignore the security warning, we didn't sign this one yet.

This project uses live Euro 2016 data provided by football-data.org in JSON format. PHPRunner project makes the use of this data and if will not work if they website is down for any reason.

Continue reading Displaying EURO 2016 data with PHPRunner »

New charting functionality: AnyChart 7 support

In PHPRunner 9, ASPRunner.NET 9.0 and ASPRunnerPro 9.5 we are switching to new version of charting components: AnyChart 7. What does this mean for you as a user?

  • AnyChart 7 is Javascript based. No more Flash charts, works out of the box on all devices
  • AnyChart 7 provides better user experience, more functionality, better looking charts
  • We are adding ChartModify event that would allow you to tweak charts appearance and behaviour in endless ways. You can copy and paste basically any example from AnyChart manual as is.

Below are a few examples of how you can use ChartModify event.

Add horizontal scroller

var currentScroller = chart.xScroller();
currentScroller.enabled(true);

Add horizontal scroller and set initial zoom to 50%


Continue reading New charting functionality: AnyChart 7 support »

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 »