RE: PHP and mySQL startup

[Timothy P Clark <timclark@xxxxxxxxxx>]

Hi Jeff,

I'm one of the developers of the storage engine. I noticed this thread 
about using MySQL and PHP and wanted to clarify a few things about the 
storage engine.

First, the storage engine is not yet generally available. We're working 
with MySQL to get it out the door as soon as possible, but I can't give a 
precise date. This also means that the Redbook is not available either. 
The URL that you found is where it *will* be. When we wrote the magazine 
article, schedules were still being solidified, and we figured it would be 
best to reference the URL in case it had gone live by publication time.

Second, you may be able to achieve what you want without needing the 
storage engine at all. If your goal is to take an existing DB2 table and 
make it available to a PHP program, there are a couple of good solutions 
already available. The first is to connect directly to DB2 on your i by 
using the ibm_db2 PHP extension. Michael Sandberg has a helpful article on 
this at 
http://www.ibmsystemsmag.com/ibmi/october07/developer/18368p1.aspx. The 
other technique, which provides the more static updates that you've 
described, is to use CPYTOIMPF to dump the DB2 table into a CSV file, ftp 
that file up to your website, and use the mysqlimport program 
(http://dev.mysql.com/doc/refman/5.1/en/mysqlimport.html) to pull the data 
into a MySQL table.

In short, the storage engine is designed to get your MySQL data *into* 
DB2. The solutions described above allow you to go the other direction 
(DB2 into MySQL), which sounds like what you're really after.

Hope that helps!

Tim Clark

> date: Thu, 26 Feb 2009 11:11:34 -0500
> from: "Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>
> subject: RE: PHP and mySQL startup
>
> A nightly update will be sufficient.  I already have mySQL running on 
the i.
> My intention is to:
>
> 1) Have mySQL on the i use the DB2 storage engine.
> 2) Each night, an RPG program refreshes the contents of a mySQL table on 
the
> i.
> 3) After that table is updated, FTP it to the website.
>
> I was also planning on the PHP code being developed on the i, then 
uploaded
> to the website.  By it being on the i, I could then use it for learning.
>
> There also seems to be an issue with the DB2 storage engine for mySQL 
not
> yet being available.  I got the impression from the webinar I attended 
last
> week that it was.  It might be enabled by a PTF or something, I just 
don't
> know, haven't got that far.
>
>
> --
> Jeff Crosby
> UniPro FoodService/Dilgard
> P.O. Box 13369
> Ft. Wayne, IN 46868-3369
> 260-422-7531
> www.dilgardfoods.com
>
> The opinions expressed are my own and not necessarily the opinion of my
> company.? Unless I say so.
>
>
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
> > bounces@xxxxxxxxxxxx] On Behalf Of Douglas Handy
> > Sent: Wednesday, February 25, 2009 6:09 PM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: PHP and mySQL startup
> >
> > Jeff,
> >
> > What we want to do is put up a "Product Search" on our GoDaddy hosted
> > > website, which I figure should be relatively simple for a good PHP
> > > developer.  I plan on hiring someone local to do the actual PHP. But
> that
> > > local person isn't going to know squat about the i.
> >
> >
> > How static is the product data?  Is real time inventory levels or 
other
> data
> > important?  Is having a local copy of the product data necessary for 
other
> > functions of the website?
> >
> > There are two basic approaches here:
> >
> >    1. Use a MySQL database local to the GoDaddy site, and update that 
db
> at
> >    whatever intervals are appropriate, perhaps nightly
> >    2. Use a CGI program on the i to serve up real time data to the 
GoDaddy
> >    site, using XML or whatever
> >
> > I've done both methods, using PHP/MySQL on an outside hosted server. 
Feel
> > free to contact me offlist if you want.
> >
> > If I am not mistaken, the new ability to have MySQL use the i as a 
storage
> > engine requires MySQL to be running on the i, not on an outside server
> > hosted by GoDaddy or similar.   I'd be happy to be wrong though, if
> someone
> > can correct me.
> >
> > Doug
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
>
>
>
>
>
> ------------------------------