Building the best web application builder, one byte at the time
The code in this article was updated to be compatible with version 10.x of PHPRunner, ASPRunner.NET and ASPRunnerPro.
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.
The latest version of Runner family products comes with several improvements in mapping area like support of Bing and OpenStreet maps, maps in dashboards, custom map markers etc. In this article I want to show a couple more mapping features that you can use in your apps, heat maps and clustered maps.
Both those features can help you visualize large amounts of mapping data. It gives your users a better insight on your data. For instance, those maps tell you that if you are a taxi driver in NYC, your chances to pickup a passenger are higher if you are nearby Trump Tower.
Continue Reading "New mapping features"Great news! PHPRunner 8.1, ASPRunnerPro 9.1, ASPRunner.NET 8.1 released. Grab your copy now.
Upgrade from previous version of Mobile template $25
Here is the list of new features in this update.
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.
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.
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.
Create two custom views (Cars1 and Cars2) based on Cars table
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).
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 mytableContinue Reading "Date/time handling in web applications"
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: How to add this functionality to your project. 1. Download a set of sample images and unzip it to the output folder keeping directory structure. This should create a folder named backgrounds with a few images in there. You are free to add more images or to remove any you don’t…Continue Reading “Random page background: Halloween edition”
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.
We are working on the next version of all our code generation products. We plan to release all three products at the same time and expect all of them to carry the same set of functionality.
Download PHPRunner 7.1 preview
Starting with this update we will offer both 32-bit and 64-bit versions of our software. 64-bit version will solve out of memory issue that may occur while working with large projects having hundreds of tables and thousands of fields.
Continue Reading "New features in PHPRunner 7.1, ASPRunnerPro 8.1 and ASPRunner.NET 7.0"
Major new features
Add CSS rules manually in Style Editor to build professionally looking pages. Take a look at this customized login page: page background, input controls and Facebook button appearance were adjusted via CSS rules added in Style Editor. Click this image to open sample app in browser.
