Basic Database

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

Hi, I use FP2002 with MS XL and need to produce a basic database (hopefully
using Excel) but I know anything about creating a database. Can anyone tell
me of a simple (idiot proof) database system or provide a link that could
help me achieve this. My housing service says they can use PHP (whatever
this is). Fred
 
PHP usually means a Unix server which don't support MS databases (Access)
FP DB integration tools (Database Results Wizard) are only supported on Windows Servers
You will need to probably use something like MySQL
Contact your host for what DB they support or provide
--




| Hi, I use FP2002 with MS XL and need to produce a basic database (hopefully
| using Excel) but I know anything about creating a database. Can anyone tell
| me of a simple (idiot proof) database system or provide a link that could
| help me achieve this. My housing service says they can use PHP (whatever
| this is). Fred
|
|
 
Fred -
Using Excel as a database just isn't a good idea because .. it isn't a database.
You may have to climb a bit of a learning hill, but boy is it worth it in the end.
MikeR
 
Hello.....

Here is a link to a tutorial that will get you started.
http://webmonkey.wired.com/webmonkey/backend/databases/tutorials/tutorial1.html

But I'll go ahead and warn you.... it is going to take a little digging on
your part.
It would be easier if you were on a windows server as ( of course this is
just an opinion ) asp and access are somewhat easier to work with for a
beginner. Again, just an opinion.

While you are digging take the time to learn good database design. It will
save you a lot of headaches in the future if you take that time up front.

As has been suggested you are probably going to be working with php
(scripting language) and mysql (database). There are a number of books out
there on using these two together. Use your old friend Mr google search and
you will find lots of material out there.

Best to you......
Tom Gahagan
 
PHP is a server side scripting lanaguage.
if you want a simple database try www.ezscripting.co.uk for a solution using
flat-files (text files).

They are PERL scripts - Perl being another server side scripting language.

Ask your host if they support perl/cgi.

The scripts are pretty easy to set up and there's a help forum for any
questions.
 
Back
Top