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.