Hi all.

 

 

 

Ok, here's what I've got so far;

 

*WAMP 5 installed and working :mrgreen:

 

*A text editor with PHP highlighters

 

*Some basic pages which work. :mrgreen:

 

 

 

 

 

I've worked my way through w3school's PHP tutorials and understand it all (its all fairly simple).

 

Now I want to add database use to my pages, I know I must use mySQL, but I've got no idea on what to download and where from :uhh: .

 

 

 

Any help would be great.

You don't actually have to use MySQL - but it's the easiest of the options for people starting out. Oracle should be what you aim for eventually, especially if you're aiming to do this kind of thing on a professional level. If not... well just stick with MySQL :)

 

 

 

 

 

But for now, go here and download the MySQL Community Server.

 

 

 

Extract it all to some temporary location, install it. I suggest installing it as a service, so you don't have to keep starting the server whenever you want to do database related scripting work, etc.

 

 

 

I think the later builds allow you to select to install as a service when you go with custom install. But if not... open up a command prompt once install and type:

 

 

 

 

 

C:\> mysqld --install

 

C:\> NET START MySql

 

 

 

I think it's mysqld anyways. Nothing you can't google if you get stuck :)

 

 

 

 

 

That should pretty much be all you have to do. And there's plenty of DBA apps out there you can use if you're not a fan of using the command line to do everything ;)

Ok, thanks.

 

I've downloaded and installed MySQL.

 

I'm getting the hang of the command line interface, but I'm still finding it a little hard. Any programs you can recommend for data manipulation (of the MySQL)?

WAMP5 already has MySQL included (installed as a service along side apache if you told it to during installation). It also comes with phpMyAdmin for datebase work. Both of which should be in the WAMP menu in your tray.

 

 

 

Php.net is by far the best resource for functions and such (IMO anyway). I haven't gone threw any of the first few sections of the manual in a while but it should be fairly helpful. Many of the functions also have example snippets for you to work with.