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 »

PHPRunner 9.0, ASPRunnerPro 9.5, ASPRunner.NET 9.0 released

PHPRunner 9.0, ASPRunnerPro 9.5, ASPRunner.NET 9.0 released (July 22nd, 2016).

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 July 1st 2015 you have till September 1st, 2016 to use discounted upgrade option. After September 1st, 2016 you will have to purchase software at the full price. Do not miss your chance to upgrade for less.

Bootstrap templates and themes

New version comes with 15 Bootstrap themes and you can add your own. Where to find best Bootstrap themes

Continue reading PHPRunner 9.0, ASPRunnerPro 9.5, ASPRunner.NET 9.0 released »

MassMailer template use case

MassMailer template v2 was updated. This is a free upgrade for existing MassMailer template v2 owners. More info.

MassMailer template can be used for more than just sending bulk emails. Lets consider the case where you manage a table with usernames and passwords for your internal company application. For increased security users should change passwords every 60 days. As an administrator you need to perform two standard tasks:

  1. Set reminders to users when their password is about to expire
  2. Mark their account as inactive when password expires

We'll show how this can be done with the help of MassMailer template. In this example we'll be using MySQL and here is how our table with logins and passwords looks. Only users where 'active' field equals 1 are able to logon.

Continue reading MassMailer template use case »

Executing your code after Inline Add or Edit

PHPRunner/ASPRunnerPro/ASPRunner.NET have a couple of handy events that allow you execute your own code after record was added or edited in inline or in popup mode. For instance, you may want to change some fields appearance based on new data modified or redirect user to view page after record was added in popup mode.

1. Change text color and background color after Inline Add/Edit

To do so add the following code to List page: Javascript OnLoad event.

function funcAfter(fieldsData) {
    for (f in fieldsData) {
        var field = fieldsData[f];
        if (field.name == 'status') {
            if (field.value == 'Pending') {
                field.container.closest('td').css('background', 'red');
                field.container.closest('td').css('color', 'white');
            } else if (field.value == 'Active') {
                field.container.closest('td').css('background', 'orange');
                field.container.closest('td').css('color', 'darkblue');
            }
        }
    }
}
this.on('afterInlineEdit', funcAfter);
this.on('afterInlineAdd', funcAfter);

In this event we evaluate the value of 'status' field and then change CSS properties of the cell when this field is located. To save the amount of coding we define the funcAfter function and make it run after both Inline Add and Edit.

This code will work without any changes in PHPRunner, ASPRunnerPro and ASPRunner.NET apps. Here is how it's going to look.

Continue reading Executing your code after Inline Add or Edit »

Speed-up data entry

We continue series of posts that show how to make you PHPRunner/ASPRunnerPro/ASPRunner.NET apps behave in Excel-like way. In this article we'll show how you can speed-up data entry in inline mode eliminating the need to click 'Inline Add' and 'Save' buttons multiple times.


Continue reading Speed-up data entry »

Adding badges to application menu

In this post we'll show how to spice up your application menu drawing attention to new and important items. For this purpose we'll be using so called menu badges.


Continue reading Adding badges to application menu »