Help request!

Does exactly what it says on the tin. Some of the nonsense contained herein may be very loosely related to The Sisters of Mercy, but I wouldn't bet your PayPal account on it. In keeping with the internet's general theme nothing written here should be taken as Gospel: over three quarters of it is utter gibberish, and most of the forum's denizens haven't spoken to another human being face-to-face for decades. Don't worry your pretty little heads about it. Above all else, remember this: You don't have to stay forever. I will understand.
Post Reply
Patti82
Utterly Bastard Groovy Amphetamine Filth
Posts: 683
Joined: 03 Aug 2008, 10:38
Location: Stockholm, Sweden

Hi, most of you might have seen my name earlier :D Anyway, besides sharing stuff I also run the http://www.ultimatesistersguide.org website.
It still needs a bit of tweeking here and there - but my main concern is the bootleg section. At first I just had some huge pages - then I split
them into several pages (too many to handle when it comes to updating stuff!) so I have been thinking I might need some form of database that pages can be created from. However I have NO knowledge in databases and don't even know where to begin. Is there anyone that could give me tips and tricks and perhaps help me with some light programming? (The webserver I'm using does have MySQL intergrated in it so it is not impossible to do on the site...)

I do like the the layout of the bootleg section as it is - by type and/or format - and how it is shown when you load a page. So what I need help with is HOW to do the basic database and HOW to get the pages to look for the information required by pressing one of the links. HTML is one thing to mess around with but it seems databases is over my head :D From what I understand I need:

1) A database - one that can handle pictures as well since there is quite a lot of pictures in the bootleg section these days :D
2) MySQL to get stuff from that database
3) code in the HTML/PHP to get MySQL to show stuff from the database
4) I'm not even sure if I can use HTML for the rest of the site or not or if everything has to be PHP?

Anyone? Please?
Top
User avatar
markfiend
goriller of form 3b
Posts: 21181
Joined: 11 Nov 2003, 10:55
Location: st custards
Contact:
Contact markfiend

Pro web monkey here: Some thoughts:

Well, firstly, you can stick with HTML for the static pages, and use php for the bits that are generated from the database. Mixing php and HTML is fine. In fact the output that php sends from the server to the browser is HTML.

MySQL can store images -- it can store anything in fact -- but its far more efficient to store the images as files and just store information about the images in the database.

Your site is absolutely ideal for a simple MySQL/php setup.

There are some good tutorials on the w3schools site: Clicky

I would recommend you set up a test environment on your home PC so you can make sure you have everything working before you upload it to the web.

Hope this helps to get you started!
The fundamental cause of the trouble is that in the modern world the stupid are cocksure while the intelligent are full of doubt.
—Bertrand Russell
Top
Patti82
Utterly Bastard Groovy Amphetamine Filth
Posts: 683
Joined: 03 Aug 2008, 10:38
Location: Stockholm, Sweden

Sorry, that what I meant with pictures, not that the database should store them but be able to link to an URL. :D

Been looking at the w3school site and it just makes me MORE confused at times. Is MySQL a database or an interface to access an database? If it's only an interface which database is the easiest to handle??

Will look at the php section some more and see if I get a "Eureka" moment, but considering I have been looking into this for about a year now and STILL haven't managed to understand anything :D (Although the basis for PHP is pretty simple, it's the other part of it all that confuses me beyond belief...)
Top
Post Reply

Return to “General Chat”