Re: PHP and mySQL startup

[Douglas Handy <dhandy@xxxxxxxxx>]

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