Some of my friends an I are planning on starting a CounterStrike Clan (yes I am probably a bit old for gaming) and want to set up a small website for it (In fact I think it's required for the league).
Annnnnyway, i'm looking at just getting a dirt cheap bit of hosting, like streamline.net's £19 a year jobby for this but all the cheap packages don't seem to have MySQL databases.
Is it possible to have a site with log-in details/member only areas without relying on a MySQL database? I've only ever used things like Gallery2 or Wordpress. Are there methods using just php/html e.t.c.
Can a website call up a database hosted by a different site, i.e. could I configure say a site on generichost.com to use a database on my host (I have MySql on my host)?
The general consensus is to have an 'individual' site and not use url forwarding otherwise I could just host using my space i'm already paying for (which I think is still the best option).
Cheers 
J's World Welcome to my world







Monkeyboy posted this at 13:09—13th February 2007.
He has: 199 posts
Joined: Feb 2006
That's good news, thanks for the help Conrad. If I can use my existing Database with a seperate site as you say then that's cracking.
I don't know anywhere near enough to develop a "database driven website with user authentication" myself but will have a look around for a decent script. Maybe something like phpBB or similar.
J's World Welcome to my world
andy206uk posted this at 19:17—13th February 2007.
He has: 1,742 posts
Joined: Jul 2002
I use the same host as you and they don't allow remote connections to mysql for security reasons.
If the data is relatively simple you could just store it in a delimited text file rather than using a 'proper' database. Unless it's gonna get loads of views and store loads of data using text files is more than sufficient for most peoples needs.
Andyk
Music Rants News and Reviews | My Photoblog | Blog of a Web Designer
Give a man a fish and you feed him for a day. Teach him to use the Net and he won't bother you for weeks.
Monkeyboy posted this at 08:27—14th February 2007.
He has: 199 posts
Joined: Feb 2006
Pah! Foiled again! I've never even heard of a delimited text file so I suppose i'll just have to use url forwarding and use my current webspace if I need a database then. To be honest I should be able to get away without needing one though, it depends wether my friends decide they need a forum/members only part
J's World Welcome to my world
pr0gr4mm3r posted this at 00:24—16th February 2007.
He has: 544 posts
Joined: Sep 2006
What about SQLite? As far as I know, PHP 5+ has it included by default, and it uses local files for the db.
Hey! It compiles! Ship it!
Monkeyboy posted this at 09:12—16th February 2007.
He has: 199 posts
Joined: Feb 2006
Would this need to be set up on the server or would I be able to install it into my webspace and use from there? I've had a quick look at it and it looks like it's out of my league knowledge wise to try and use
J's World Welcome to my world
pr0gr4mm3r posted this at 14:17—16th February 2007.
He has: 544 posts
Joined: Sep 2006
Run a phpinfo() on your server to see if it's installed. If it's not, you should be able to run the binary w/o installing it.
Hey! It compiles! Ship it!
lordbiron posted this at 17:31—16th February 2007.
He has: 73 posts
Joined: Feb 2007
noone is to old for gameing my dad is 62 and still plays halo with me
This one time... i looked down... and there was this little bug... and he was like ..."whats up?"