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

PHP, PHP Code Generator, Tutorials

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

ASP.NET, PHP, Tutorials

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

ASP.NET, PHP, PHP Code Generator, PHP Form Generator, Tutorials

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

ASP.NET, News, PHP, PHP Code Generator, PHP Form Generator

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" →

How to implement auto-save feature

PHP

Some large forms would benefit from having auto-save functionality. We have built a simple auto-save script that your can add to any Edit page in your PHPRunner/ASPRunnerPro/ASPRunner.NET application. Here is how it looks right after record was saved: Limitations: uploaded files are not saved automatically if page shows one details tables – details won’t be saved automatically The code below can be pasted as is to any Edit page Javascript OnLoad event.   // to log off user automatically after a certain amount of incativity…Continue Reading “How to implement auto-save feature” →

New features in PHPRunner 7.1, ASPRunnerPro 8.1 and ASPRunner.NET 7.0

ASP.NET, News, PHP

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" →

More custom CSS tricks

PHP

These CSS snippets are designed to be pasted to Custom CSS section on Style Editor in PHPRunner/ASPRunnerPro.

Making page background fully transparent

.function-list .rnr-c > *,
.function-list .rnr-s-undermenu > *,
.function-list .rnr-b-vmenu > *,
.function-list .rnr-s-2 > *,
.function-list .rnr-row > *,
.function-list .rnr-toprow > *
{
background-color : transparent !important;
background : transparent !important;
}

Sample screenshot:

Continue Reading "More custom CSS tricks" →