Ever since I learned basic html, my cel gallery has basically been set up in a standard table format. I've flirted with php and stuff, but what I've decided I would like to do is set up a database system for myself for my own reference and insurance purposes. Now, I could use rubberslug, but I have so many cels, it would take a year and a day.
What I really want is a simple database that I can associate an image with various fields I set up. I thought about trying to put something together in access first, since I've programmed a little vba in the past. But I hate they way it deals with image files, at least pre-2007. I haven't tried it in 2007/2010 - do the newer versions of access handle image files other than bitmaps and png? Ideally, what I was going to do was set up the database on my home computer.
Another option would be an sql database. My webspace comes with the ability to use a couple of sql databases. I've found "photo album" generating scripts, but they don't have as many fields as I'd like to include. I don't have any experience programming or running that kind of database though. Can anyone point me in a good direction?
Database technical help
-
jcaliff
- Kuwabarakuwabara - Oh My God!
- Posts: 720
- Joined: Wed Mar 03, 2004 9:59 am
- Location: Houston
- Contact:
Database technical help
Hector the Collector loved these things with all his soul,
Loved them more than shining diamonds, loved them more than glistenin' gold.
Hector called to all the people,"Come and share my treasure trunk!"
And all the silly sightless people came and looked...and called it junk.
-
zerospace
- Taiyo - Sun Fearer
- Posts: 2714
- Joined: Wed Nov 10, 2004 10:31 am
- Location: stuck in an infinite loop =P
- Contact:
I have a PHP/MySQL gallery app that I've posted to the web for anyone to use--it's alright for recordkeeping, but that would depend on what fields you'd like to have. It has pre-defined fields for cels/artwork. If you want to try it out, it's here: www.meteorgalleries.com I'm forever fixing bugs in it, but it's the driving force behind my own gallery ( www.zero-space.net/gallery2/ ). I can't guarantee it'll be perfect, but I can help with any issues that come up if you do decide to try it out. I could also possibly assist you with a custom version if you need extra fields, but it might just be easier to create your own.
On the other hand, creating such a thing isn't that difficult if you're a programmer, especially if your host has PHPMyAdmin installed on your server. It makes quick work of setting up a mysql database.
If you want some good info on it, here's the sites I like to use for reference:
http://us.php.net/manual/en/ref.mysql.php (PHP's built-in mysql functions)
http://dev.mysql.com/doc/refman/5.0/en/index.html (mysql 5.0 reference online)
Of course, it helps to have a clue where to start. I've done a ton of work with PHP & mysql, so feel free to pick my brain
.
On the other hand, creating such a thing isn't that difficult if you're a programmer, especially if your host has PHPMyAdmin installed on your server. It makes quick work of setting up a mysql database.
If you want some good info on it, here's the sites I like to use for reference:
http://us.php.net/manual/en/ref.mysql.php (PHP's built-in mysql functions)
http://dev.mysql.com/doc/refman/5.0/en/index.html (mysql 5.0 reference online)
Of course, it helps to have a clue where to start. I've done a ton of work with PHP & mysql, so feel free to pick my brain
.-
jcaliff
- Kuwabarakuwabara - Oh My God!
- Posts: 720
- Joined: Wed Mar 03, 2004 9:59 am
- Location: Houston
- Contact:
Thanks! I'll totally check out your sql app this weekend and play with it. 
Hector the Collector loved these things with all his soul,
Loved them more than shining diamonds, loved them more than glistenin' gold.
Hector called to all the people,"Come and share my treasure trunk!"
And all the silly sightless people came and looked...and called it junk.
-
zerospace
- Taiyo - Sun Fearer
- Posts: 2714
- Joined: Wed Nov 10, 2004 10:31 am
- Location: stuck in an infinite loop =P
- Contact:
Just let me know if you need any assistance .
Side note: I just thought about this, but have you considered XML as a possible solution? It's a bit simpler than a database, but it's pretty easy to work with. I wrote my for-sale site in PHP and XML .. the biggest pain in the butt is dealing with specific characters that must be escaped in an XML document (I was using an on-server script to update my primary XML file, and found myself cussing at the forms for auto-interpreting my HTML entities as the characters themselves, thus causing my XML file to be interpreted incorrectly).
Just another thought for ya.
.Side note: I just thought about this, but have you considered XML as a possible solution? It's a bit simpler than a database, but it's pretty easy to work with. I wrote my for-sale site in PHP and XML .. the biggest pain in the butt is dealing with specific characters that must be escaped in an XML document (I was using an on-server script to update my primary XML file, and found myself cussing at the forms for auto-interpreting my HTML entities as the characters themselves, thus causing my XML file to be interpreted incorrectly).
Just another thought for ya
.