Web Database

[harveypooka]

Hello,
I'm going to start a basic review site and need some advice on database management and creation tools.
I need to know what program to use to create my database and how to
get it on the net.
I'm not exactly sure how it all works, so a brief guide/explanation would
be great.
I've had a quick look at Navicat and MacSQL, but again, I'm not sure how
they link onto the net.

Cheers.

 

[angelneo]

The most common combination to use on the web is php with mysql. First of all you need a server to host your database. Most web hosting company provides mysql, so this shouldn't be too hard. Next you will need a scripting language that allows you to code an application with the database, this is when php comes in.

If you need to manage your database, there is quite a number of open source applications to use. For example phpMyadmin, this should get you started, I think

 

[snkTab]

I agree, most popular combo is mysql+php. Get a host that comes with phpmyadmin or at least the ability to install it. Talking from experience, building and working on a database through the terminal sucks, altough I kinda liked it.

 

[harveypooka]

Cool, that's a great help, thanks. I understand the terminal thing...there's some satisfaction of doing things the wrong way (or the more difficult way) and working!!! I'm just getting into UNIX at the moment, but I don't think
I'm anywhere near the level of managing database's!

 

[harveypooka]

Ok, I've downloaded PhpMyAdmin and also the latest version of PHP (link through Apple's site)...I'm stuck! The various read me's are (unfortunately) gibberish to me. Any idea on how to quickly install and get basic functionality? Or, where to start?

 

[jeremy.king]

http://wserverxkit.sourceforge.net/

Edit: That is if you are trying to develop locally.

 

[angelneo]

Ok, I've downloaded PhpMyAdmin and also the latest version of PHP (link through Apple's site)...I'm stuck! The various read me's are (unfortunately) gibberish to me. Any idea on how to quickly install and get basic functionality? Or, where to start?

Here's a link to help you get all the installation in one go.

http://www.apachefriends.org/en/xampp.html