PHP question......again :)

[uklejon]

Tweet

Another new site being designed and this time its using PHP and not ASP.......thought i'd have a go at what most here seem to be using.

This is probably a really silly question but........with a MySQL database....is there just the one? I'm setting up 3 custom made scripts which all use MySQL so do i use the same one for all scripts......ie the same password details etc for each script.

In ASP you tend to have separate databases for spearate applications unless you want to combine them somehow!!!

Told you it was a silly question

Thanks

Carol

[scifind]

It depends what your hosting lets you have, if you are alloud more than 1 db then you will have to set them up via your control panel.

[ianm]

For a start it'll depend on how many MySQL databases your host have given you.

I tend to keep all the stuff for a single site in one database as it makes keeping track of connections a lot easier, but I can't see any reason why you shouldn't split them into separate datebases if you wanted to.

[Rich]

A MySQL server can host multiple databases, but some hosts only let you have one database. If your stuck with a host that only lets you have one database, the easiest thing to do is use prefixes on the table names to keep them logical - e.g. guestbook_message, phpads_blar, etc.

Edit: (Sir, I didn't copy his answer, sir, I promise, sir). Agree with ianm, one database per site does help keep things simple.

[uklejon]

Thanks Guys,

So when these individual scripts write the tables to the database they won't overwrite the exisiting tables already there.


Is that right ?

Carol

[Rich]

Most scripts force you to create the database first, so they should be ok. Just watch out for two scripts wanting to use the same table name.

[uklejon]

Wonderful....thank you

Carol