I recently set out on a new venture to develop some software for a new client...myself. Technically, the software will be used by another company, but for the first time in my 20-year career, I'll own the product when it's complete. And that's a good motivator to find the right tools. Aside from the obvious benefit of dumping the green-screen for good, there are many benefits to using PHP. Which brings us to the point of the article: to help you to get started using PHP to develop your user interfaces.
You'll note that there are an inordinate number of external links in this article. The reason I did this is that the information is located in what seem rather disparate places. It is therefore the opinion of the author that having the links all in one place would be of value. The reader is left to draw his/her own conclusion.
There are two parts to getting started using PHP on the iSeries. The first step is to get PHP installed and your environment set up for using it. This is not a difficult task, but it does warrant some attention. You can install PHP in two ways.
The first is to download the PHP source code and compile it. While this is the typical install for PHP in the Linux and Windows PC world, I would not recommend it for the typical iSeries developer. If you insist on going the compilation route, then the IBM Redpaper "Bringing PHP to Your eServer iSeries Server" provides a good, if somewhat dated, installation guide for you. Don't bother with the ODBC sample database mentioned toward the end of the Redpaper unless you need to use ODBC specifically. For the purposes of this article, we will be using the IBM_DB2 extensions. The user documentation for the IBM_DB2 extensions can be found here.
For the rest of us, the folks at Zend have created some great tools for developers using PHP on the iSeries. The specific tool that we need to get up and running right away is the Zend Core for i5/OS. At the time of this writing, all the Zend i5/OS products are available for free to Zend.com registered users. A PowerPoint document provides all the details on how to install and set up the Zend Core for i5/OS, which includes the PHP installation. The Zend tools are great for getting started and have some really useful features to help experienced RPG developers make the switch to PHP. I would also recommend the Zend Studio for i5/OS; you can check it out at Zend i5/OS products.
Once PHP is installed and you have an instance of the Apache server running, you can test the install by running the script shown below. I think that both of the install instructions in the links given above have a version of this same script. All it does is confirm that PHP is installed correctly and display the current PHP configuration settings.
phpinfo();
?>
The output when you run this script from your browser should look something like the screen shot in Figure 1:
Figure 1: You should see a screen like this after you run the script. (Click images to enlarge.)
So now that you have PHP installed and running correctly, you'll want to access your existing DB2 databases. To do that, you have to do one more thing. The IBM_DB2 extensions allow you to create a connection to any DB2 database, catalogued or not. However, connecting to a database that is not catalogued requires a bunch more parameters on the connect command and is a bit of a hassle if you are going to be accessing the same server most of the time. So we'll create a catalog entry for the database—or, as the iSeries sees it, a Database Directory Entry. Use the ADDRDBDIRE command as shown in Figure 2 to create a directory entry for the database on your local iSeries machine.
Figure 2: Use the ADDRDBDIRE command to create a directory entry for the database on your local iSeries.
Now you will be able to access the files on the local machine be connecting to YOURRDB.
You're all set now to take PHP for a test drive. Download some of the thousands of free scripts available and test them out—or better yet, write some of your own. If you get really ambitious, try throwing in some JavaScript.
In Part II of this tip, we'll cover how to use the IBM_DB2 extensions with PHP and how to access and update your existing DB2 files. If you get impatient, you can check out the IBM_DB2 reference in Chapter 4 of Developing PERL and PHP Applications for DB2.
Jeff Olen is the owner of Olen Business Consulting, Inc., an iSeries development services company based in Orange, California. When he's not busy writing code or writing articles, you can find him jumping out of perfectly good airplanes (a.k.a. skydiving). To find out more about Jeff or Olen Business Consulting, Inc. go to www.olen-inc.com or email Jeff at
Jeff Olen is a super-spy now but keeps his cover identity intact by working for video game studios on the East Coast. So when he’s not out killing members of ISIS or rescuing refugees, you can find him playing Wolfenstein II or testing the new Fallout 76 releases at his beach house in Costa Rica. In any case, he can’t be reached. You can email his cat at
MC Press books written by Jeff Olen available now on the MC Press Bookstore.
 |
||
 |
|
The IBM i Programmer’s Guide to PHP Get the scoop on how PHP can—and should—be deployed on IBM systems. List Price $79.95 Now On Sale
|
More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.
TRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now! Request Now.
Forms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.
Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:
Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.
IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn:
LATEST COMMENTS
MC Press Online