SaaS applications, also known as multi-tenant applications, are very popular these days. A single instance of the software is available to multiple customers/tenants. Each tenant's data is isolated and remains invisible to other tenants. All tenant databases have the same structure. The data is different, of course.

Continue Reading "SaaS application design"

Tri-part events are a special code snippets that provide a convenient way of programming interactions between the browser and the webserver.

Why three parts?

Any web application consists of two parts - server and client. The client part runs in the browser on the computer of the web site visitor. This part takes care of all user interface interactions, such as buttons, input controls, blocks of text and images. Client-side code is written in Javascript in most cases.

Server part - this code runs on the webserver itself and has direct access to the database, can send emails, read and write files to the disk. In PHPRunner-created applications server code language is PHP, ASPRunner.NET uses C# or VB.NET, ASPRunnerPro uses Classic ASP.

Most real-life tasks though require a joint action of both client and server parts. For example, the user presses a button and wants something changed in the database, or an email being sent.
Tri-part events provide a relatively easy way to create such integrated code snippets.

They consist of three parts running one after another:

  • Client Before - this Javascript code is run immediately after user's action such as pressing the button.
  • Server - this part runs on the server after the Client Before part has finished. You can only user server-side code here (PHP, C# or ASP).
  • Client After - back to the web browser, another Javascript code part.
Continue Reading "Tri-part events"

PHPRunner, ASPRunner.NET, ASPRunnerPro 10.3 is here! If you purchased the software less than twelve months ago you can logon to the control panel and find download links and registration keys under 'My purchases'. There should be 'Reg info' link next to your latest purchase.

Customers who purchased more than twelve months ago can renew their maintenance using links below:

PHPRunner maintenance

ASPRunner.NET maintenance

ASPRunnerPro maintenance

Trial version download links:

https://xlinesoft.com/download

Here is what's new in this update.

1. Separate permissions for additional pages

It will apply to both Static and Dynamic permissions

Continue Reading "Version 10.3 of PHPRunner, ASPRunner.NET and ASPRunnerPro"

There was an article posted back in 2007 in our forums that provided a solid start for many SEO-friendly URLs applications. It is about time to talk about how you can implement it in version 10.x of PHPRunner, ASPRunnerPro, and ASPRunner.NET. We have helped one of our clients to implement this solution in their project. They run a website that lists public voters’ information in certain Florida counties. The objective is to make these pages rank high when someone searches for county, city or neighborhood…Continue Reading “SEO-friendly pages in your web application”

If you purchased or upgraded PHPRunner, or ASPRunner.NET less than one year ago logon to control panel and find download links and registration keys under 'My purchases'. There should be 'Reg info' link next to your latest upgrade purchase.

Note: Software maintenance coverage needs to be continuous. If your last purchase or upgrade were more than one year ago you have till June 20, 2019 to renew your maintenance. After that date you will have to purchase PHPRunner, ASPRunner.NET or ASPRunnerPro at the full price.

New customer purchase links:
PHPRunner
ASPRunnerPro
ASPRunner.NET

Upgrade/maintenance renewal links:
PHPRunner
ASPRunnerPro
ASPRunner.NET

What's new in version 10.2

Collapsible menu bar

Hide/collapse menu bar on the left. This feature is inspired by AdminLTE template.

Continue Reading "Version 10.2 of PHPRunner, ASPRunner.NET and ASPRunnerPro is here"

This is a weekend project, not much practical use but it was fun to create. Hopefully you find techniques mentioned here useful.

Some our employees need to connect to our FTP server while travelling. As an extra protection measure we maintain a whitelist of IP addresses where connection is allowed from. We thought it would be nice to convert IP addresses to geographical coordinates and display them on a map. It worth saying that IP to latitude/longitude conversion is not 100% accurate and IP addresses get re-assinged all the time. However for our task it is not really important.


Continue Reading "Displaying IP addresses on the map"

By default PHPRunner/ASPRunner.NET provide "Delete selected" functionality. In some cases you need to be able to delete records individually. In this tutorial we will show how to add a delete button to each record. We will also show how to make it look as a regular edit/copy/view buttons.

1. Proceed to the List page in Page Designer and insert a button. Move it to one of grid columns. Set button style to "link-button" and choose icon "glyphicon-remove" as appears on a screenshot below.

Continue Reading "How to add a “Delete” button to each row in grid"

Normally tab order is determined by the web browser based on your Add/Edit page structure. If you have a single row two-column form browser will tab through first cell edit controls first before switching to second cell. If you place each control into its own cell it will tab through first row, then second, then third etc. The point is that you want to be in control and you need to specify tab order that fits your application logic. Luckily it is easy to achieve…Continue Reading “Changing default tab order”

Page Designer is one of the most amazing new features in version 10 but as any new functionality it also introduces a learning curve. In this article we are answering the most common questions people ask us about Page Designer usage.

If you have Page Designer questions that are not answered in this article feel free to ask here in comments or via helpdesk.

How to work with additional pages?

In version 10 you can add extra pages of the same type. For instance, besides the main edit page you can have extra edit pages named edit1, edit2 etc. The big question is how to use these additional pages in your application.

Changing button properties

Since we created multiple edit pages lets see how we can use those. On the List page select Edit button. On the right side using 'Page' dropdown select the page this button will open.

Continue Reading "Page Designer: Frequently Asked Questions Answered"

If you purchased or upgraded PHPRunner, or ASPRunner.NET less than one year ago logon to control panel at https://xlinesoft.com/dss/support.asp and find download links and registration keys under 'My purchases'. There should be 'Reg info' link next to your latest upgrade purchase.

Note: Software maintenance coverage needs to be continuous. If your last purchase or upgrade were more than one year ago you have till February 28, 2019 to renew your maintenance. After that date you will have to purchase PHPRunner, ASPRunner.NET or ASPRunnerPro at the full price.

Continue Reading "PHPRunner 10.1 and ASPRunner.NET 10.1 are here!"