Uncreative Labs

Joined: 01 Oct 2004 Posts: 169 Location: behind you!

One day I decided to catalog my album collection and was about to pull out a pile of paper when it hit me. Why not create a mysql database and web based front end. After nearly a week of coding and de-bugging I have a mostly working setup. The layout is still very much pre-alpha and in the end the site is really for my use only but I will make it look a lot better before I call it done.

For now the images on the site are place holders for later on when I figure out how to update the sql database to store images (already know how so it's only a mater of time).

http://386page.com/albums/index.php

Joined: 01 Oct 2004 Posts: 169 Location: behind you!

workin on the image script so the database is down. Perhaps I'll have a nearly finished version tonight! Very Happy

Joined: 01 Oct 2004 Posts: 169 Location: behind you!

WoHoo

! I have figured out how to store and retrieve images from a sql database! Now what Question

Posted: Wed Jun 15, 2005 1:19 am

Make sure it all works, fix the bugs, refine the design and repeat. (-; At least that's what you're supposed to do in college.

Posted: Wed Jun 15, 2005 1:23 am

Looks pretty good. The only thing I'd add would be a generic menu on all pages.

Posted: Wed Jun 15, 2005 2:51 am

Looks interesting!

Unfortunately I know nothing about PHP or most any other server-side technology, so I probably wouldn't be able to do exactly the same thing.
I personally resorted to making a very detailed catalogue of my own music collection as a spreadsheet in Microsoft Excel 97. I also made a simpler HTML version limited to CDs.

Posted: Wed Jun 15, 2005 4:23 am

PHP isn't really too bad, if you're familiar with C++ and BASIC. It draws its syntax from a few different languages, so it's easy for most programmers to pick up.

http://www.php.net has a lot of good information to get you started, if you're interested. The biggest advantage to PHP is easy database access. In some languages you have to have a driver installed, use a library or 3, and finally make the calls. PHP comes ready to use a MySQL database after you install it.

Joined: 01 Oct 2004 Posts: 169 Location: behind you!

well as I said it's only for my use but my first priority was to get the main scripts working (which about 90% of them do now). Next I'll ask a good friend of mine to help me with how it looks.

Now I delete the database and start entering albums Very Happy

Joined: 02 Oct 2004 Posts: 377 Location: Stuttgart, Germany

I program in PHP4 and MySQL for well over three years now and it's in my opinion just the best programming language and database around. although i'm in the process of creating a visual basic frontend for my mysql database right now and thats pretty cool too!

Joined: 04 Oct 2004 Posts: 114 Location: ~/

Quote:

Unfortunately I know nothing about PHP or most any other server-side technology, so I probably wouldn't be able to do exactly the same thing.

PHP is not only a server-side language. You can run PHP from the command line without a Web server. You could even use this to build a Web site from templates: you would generate all the static content, which you could then host on any Web server regardless of whether or not it supports PHP.

Joined: 01 Oct 2004 Posts: 169 Location: behind you!

ok the main page now displays 6 random albums (I got the images working as you can see. They are pulled out of a sql database).

I'm still FAR from done. I still have to code a search script as well as add a bit more code to the album display screen (so you can browse other albums by the same artist).

I'm begining to think this would have been faster with pen and paper Mr. Green

BTW
I'd post code but for now it's SLOPPY and needs remarks. Once done I'll post a few of the key files.

Guest

could you add a font-tag to your script> teh default font on my parent's computer is just gay and makes it very hard to read text...
make something like arial or times....

Joined: 04 Oct 2004 Posts: 114 Location: ~/

Wow, I was not aware that a font could have a sexual preference! If the font is gay, I assume that means it is attracted to its own type, e.g. Times Roman would be attracted to Palatino or Courier instead of to Helvetica or Verdana? Wink

Joined: 02 Oct 2004 Posts: 377 Location: Stuttgart, Germany

indeed...

teh font is "Schadow BlkCn BT" for web pages and "GunsuhChe" for plain text. while those might look good for headings or wordart or whatever they certainly don;t look good in a website's plain text...
btw: I think it's attracted to "Sceptre", they're next to each other in the list Wink

Joined: 04 Oct 2004 Posts: 114 Location: ~/

Alright. At least it's not attracted to Comic Sans! Wink