Stephen Pearce wrote:
Is there anyone who could guide me thru the installation and setting up of a MySQL
database using pHp and apache.
This is for an ICU database in a hospital .. so not a strictly commercial objective
Installation of the software (mysql, php, apache) can be done easily
using your distros installation tool, and there is plenty of info about
that around in HOWTO docs and the likes. Try Google for that stuff. You
probably will also want phpmyadmin.
Designing an appropriate database structure and writing a web
application to run it is a different task altogether.
Last time I looked (a couple of years ago, so maybe someone has some
more current info) there didn't seem to be any easy db design tools
available. At the time I used MS Access to prototype the db I wanted,
and I think I remember that you can export SQL from access, so you can
use that to get your db into mysql. Now if I had to do that task I'd
probably use MS Visual Studio to do it, but I guess that's not the
answer you need. If anyone has any suggestions for open source tools
that can do this I'd be interested in some pointers too.
I don't know what ICU is, but have you tried looking for existing open
source apps that already provide the functionality or that provide most
of it so that you only have to add the bits you want?
Glenn Ramsey <glenn(a)componic.co.nz> 07 8627077