php on ibm i rpg examples - mrmugmrmug.org/archives/docs/november 2014 presentation... · php on...

© All rights reserved. Zend Technologies, Inc.

PHP on IBM i RPG Examples

Mike Pavlak

Solution Consultant

[email protected]

mailto:[email protected]


Agenda

•Open Source Toolkit

•RPG Program Calls

•Stored Procedures

•Q&A

2


Zend Server 7 for IBM i

Key Features

Z-Ray (Like Firebug for PHP)

Server Dashboards

Code libraries

Much more!

3


RPG Examples

www.zend.com

Introduction to PHP


PHP is a Scripting Language PHP Hypertext Pre-Processor

Developed initially by Rasmus Lerdorf in 1994: PHP/FI

Zeev Suraski and Andi Gutmans Contributing since1997+ (ZEev + aNDi = Zend)

Interpreted, not compiled

Forgiving and intuitive code structure (Short learning curve)

Immediate feedback during development

PHP is to Java what RPG is to COBOL

| 5 Geting Started with PHP on IBM i

Presenter

Presentation Notes

Change slide to reflect benefits


What Is Zend Server? • Production quality PHP stack

PHP, ZF, DB connectivity, debugging extension, and more

• Three Editions – No charge “Basic Edition” provided by IBM & Full Professional and Enterprise commercial edition

All are production ready

• Application monitoring and diagnostics (integrated with Zend Studio)

• Multi-level performance enhancement capabilities

• Software updates and security hot fixes

• Easy and quick installation

• Zend Framework Integration



Zend Server

Zend Server Under the Covers

HTTP:10080 Apache Server (FastCGI)

IBM i

i/OS

DB2 UDB

PHP CGI

PHP file PASE

*PGM

CMD

ILE Apache:10080 • Default

configuration FastCGI

URL Request

HTML/response


MySQL, SQL Server,

Oracle

Presenter

Presentation Notes

Move to right after Zend server for Ibm i


Sample Scripts! (http://IBMi:10080/samples )


http://ibmi:10080/samples

© All rights reserved. Zend Technologies, Inc. | | 9 Geting Started with PHP on IBM i

Presenter

Presentation Notes

Move to after slide installation


Sample Script – Hello World • Obligatory program when starting out

• Confirms correct setup of PHP

• Sample code: (Shortest PHP Macro around!)

• Save script in IFS /www/zendsvr6/htdocs /helloworld.php

• Browser URL: http://ibmisystem:10080/helloworld.php


http://systemname:89/phpinfo.php

© All rights reserved. Zend Technologies, Inc. |

11 Geting Started with PHP on IBM i


Basic file listing script (Update) • Connect to DB2 i

• Select records from a DB2 table

• Load the records in an HTML table

02/03/10



Connection to DB2 for i (Update) • Need three things:

System

User ID

Password

02/03/10

Note: If your data sets have *PUBLIC access, no user or password is required



Reading data...(Update) Loop through record set

02/03/10



Basic file listing script (Update)

02/03/10



RPG Examples

www.zend.com

Open Source Toolkit


What is the toolkit?

•Set of classes that access IBM i native artifacts

•All Program Objects

RPG, COBOL, CL, etc.

•Others

Command processor

Data Queue’s

Spooled File

More…

•Access naturally from PHP code. No SP’s required

•Easy to use

17 Insert->Header & Footer


New toolkit is Object Oriented

•Series of classes that “wrap” the IBM project

•All PHP but Object Oriented…(wait, there’s more!)

•Zend built the PHP wrapper

•No OO training required to use them!!!

•Sam Pinkhasov, Zend



XML Service

• IBM has open sourced XMLService.

•First Open Source project on IBM i. (that I know of…)

•Made up of RPG, CL and DB2 stored procedures (SQL)

•Tony Cairns, IBM Rochester



XML Service

•Cross platform

•Language agnostic

•Basic plumbing for all open source languages



Compatibility Wrapper

• Intercepts existing i5 function requests

•Written in pure PHP

•Passes them on to OO PHP which then…

•Passes on to XML Service

•Alan Seiden, SBS & alanseiden.com



Source Code for XML Service on YiPs…


•http://youngiprofessionals.com/

http://youngiprofessionals.com/


Source Code for PHP Toolkit on GitHub…


•https://github.com/zendtech/IbmiToolkit

https://github.com/zendtech/IbmiToolkit


PHP Classes

•Class where all wrapper functions start

Yes, this is OO but not too bad…

Look at it and poke around, It’s OK!

This is why we need the path set correctly



Housekeeping…

•Need to set the extension and instantiate the object

Singleton pattern

Try & Catch

Can put this in your own include



Now the program call

•Set parameters based on function

Call program

Output results


I/O

Length

Comment

Var name

Init val


AddParameterChar •Located in ToolkitService.php

/usr/local/zendsvr/share/ToolkitAPI

Uses CharParam which extends ProgramParam, etc…



Before and after…Part 1 •Existing code call



Before and after…Part 2 •New Open Source Toolkit program call



Additional Parameter Types

• AddParameterInt32($io, $comment, $varName, $value, $dimension)

• AddParameterInt64($io, $comment, $varName, $value, $dimension)

• AddParameterUInt32($io, $comment, $varName, $value, $dimension)

• AddParameterUInt64($io, $comment, $varName, $value, $dimension)

• AddParameterFloat ($io, $comment, $varName, $value, $dimension)

• AddParameterReal($io, $comment, $varName, $value, $dimension)

• AddParameterPackdec($io, $length, $scale, $comment, $varName, $value, $dimension)

• AddParameterZoned($io, $length, $scale, $comment, $varName, $value, $dimension)

• AddParameterBin($io, $size, $comment, $varName, $value, $dimension)

• AddDataStruct($array, $parameters, $name=‘struct_name’, $dim, $by, $isArray, $labelLen)



RPG Examples

www.zend.com

Stored Procedure - Array


Now an array

Data elements are nice, but…

Sometimes you need a little more…

How about an array of information?

34


Have RPG build an array and use SQL…



SQL to create the SP & test in iNav CREATE PROCEDURE mpavlak/rpgsp2() LANGUAGE RPGLE

EXTERNAL NAME mpavlak/rpgsp2 GENERAL



Test it in iNav…



Now open results in PHP…



Results in browser…



RPG Examples

www.zend.com

Stored Procedure – Record Set


Have RPG build the result set and use SQL…



SQL to create the SP & test in iNav CREATE PROCEDURE mpavlak/rpgsp3() LANGUAGE RPGLE

EXTERNAL NAME mpavlak/rpgsp3 GENERAL



Now open results in PHP…



Results in browser…



Zend Server Update

www.zend.com

Command processing & *libl


Several ways to call commands…

•$conn->CLCommand(‘my command’);

•$conn->CLInteractiveCommand(‘DSP… command’);

•$conn->CLCommandWithOutput(‘RTV… command’);


Other uses for the toolkit

•Command processing

Call CL command directly from toolkit

Retrieve response from command call

•Example

DSPLIBL

CHGLIBL

DSPLIBL

Useful for managing access to resource

• Files & Programs from RPG



PHP Code



Zend Server Update

www.zend.com

Pricing Example


Standard line discount

•RPG is black box, callable from nearly anywhere

•PHP has function to contain RPG call

•Routine to spin through line call for each quantity



Mainline of code



CalcDiscount() Part 1

•Setup session for user-RPG program dedication



CalcDiscount() Part 2 •Create object, etc.



CalcDiscount() Part 3 •Call program



Zend Server Update

www.zend.com

Miscellaneous Toolkit Points


What was passed?

•Toolkit.ini setting

Debug = TRUE

•Turns on DebugOutput file

debugLogFile = "/usr/local/zendsvr/share/ToolkitApi/debug.log“

•Many other directive settings here



Contents of output



Stateful processing

•IPC

•Use session ID, for example • $PHPToolkitObj->setToolkitServiceParams ( array ('InternalKey' => "/tmp/$user" ) );



Zend Server Update

www.zend.com

Wrap it up


Join us at

ZendCon Advancing the World of PHP

Conference Highlights

● Sessions designed for all knowledge levels

● Intensive tutorials for accelerated learning

● UnConference sessions for expanded topics

● PHP Certification crash course and 50% discount on certification exams

● Exhibit hall showcasing the latest products

● Networking opportunities with PHP community members and thought-leaders from around the world

w w w . z e n d c o n . c o m

Conference Tracks

● PHP Best Practices & Tooling Take home the latest tips and techniques for high-quality PHP apps

● Continuous Delivery & DevOps Explore best practices for high-velocity application delivery

● Application Architecture - APIs, Mobile, Cloud Services Learn how to harness the server-side and client-side revolutions


Q&A

www.zend.com

[email protected]

Please fill out your Session Evaluation!

http://www.zend.com/

mailto:[email protected]

php on ibm i rpg examples - mrmugmrmug.org/archives/docs/november 2014 presentation... · php on...

Documents