Log in
 NESTU - An IBM i users group

Alan Seiden - All Things PHP - Double Session

  • 16 Nov 2017
  • 5:30 PM
  • 111 Route 46 East, Parsippany, NJ 07054


Registration is closed

Start Time: Reg. 5:30 pm




Alan Seiden

PHP Tricks for RPG’ers: Graphics, Excel, PDFs, E-Mail and More

Ever want to enhance RPG programs with PDFs, spreadsheets, charts and graphics, or connect to web services, without complicating your RPG program? Help is here from PHP and DB2.  PHP not only builds web sites, but it can be called by RPG programs. Alan will show how to accomplish marvelous tasks by calling PHP from ordinary RPG programs via DB2's web service support, a fast, flexible technique that's a handy trick in itself.


Examples will include:

  • Creating graphs and charts based on DB2 data
  • Excel spreadsheets from your data
  • PDF files from your data
  • Connecting to external JSON-based web services while keeping the RPG simple
  • Send flexible email messages, including HTML format and attachments, and using any SMTP server, including an Exchange server

You will come away brimming with ideas to add pizzazz to your applications.

Learning Objectives

  1. How to use SQL to call a web service, including a simple PHP-based web service
  2. How RPG can use SQL to call the web service.
  3. Put it together: RPG calls PHP via a web service, creating graphical output from RPG in a simple manner


  1. Those wishing to add non-traditional functionality to RPG programs without adding proprietary or complicated tools
  2. Web developers (PHP, Ruby, etc.) who want their scripts to be accessible from RPG.
  3. Fans of DB2 who wish to see a practical use of the new web service consumption capabilities of DB2.

This talk could be categorized under PHP, RPG, DB2, web services, etc., because it brings together several subjects in a practical application. 

Bring RPG/COBOL Business Logic to the Web with the PHP Toolkit

Don't reinvent the wheel when developing PHP applications. Instead, re-use your valuable business logic. Reduce risk, speed development, reduce costs when developing web and mobile applications by calling RPG and COBOL programs, system commands, accessing data areas, and more, with the open-source PHP Toolkit for IBM i, co-developed by IBM and Alan Seiden. The toolkit is free, flexible, supported by Zend and uses IBM's XMLSERVICE toolkit on the back end.

Learning Objective:

  1. Create a modern PHP-based graphical interface that uses RPG/COBOL/CL building blocks
  2. Know when to access DB2 directly, and when to call a program
  3. Optimize toolkit performance


PHP on IBM i developers; CIOs and IT managers wanting to understand how PHP can fit smoothly with existing resources, how to reuse existing RPG business logic to help bring projects in on time and on budget.

Powered by Wild Apricot. Try our all-in-one platform for easy membership management