Author Topic: Databases  (Read 1618 times)

0 Members and 1 Guest are viewing this topic.

Offline ZBomber

  • "The Analogy Guy"
  • Posts: 5502
  • Gender: Male
  • A Farewell to Kings
Databases
« on: June 18, 2011, 09:49:09 PM »
Need some help on doing databases for a site. I've been looking into MYSQL but it is confusing as butts. Basically, I just need each image to be stored in the database, and then have that function with the "next", "previous" etc buttons. It seems pretty basic but I can't figure out where to even start with this. Anyone that has any experience with database think they could help out?

Offline icysk8r

  • DTF Resident Magician
  • DTF.org Alumni
  • ****
  • Posts: 1393
  • Gender: Male
  • www.bedeceived.com
Re: Databases
« Reply #1 on: June 18, 2011, 09:59:20 PM »
Sorry bro, I suck with databases :/  I always get my hosting company to create them for me ;)
www.bedeceived.com

ZOMG WHAT'S AT BEDECEIVED.COM?

I DUNNO!  CLICK THE DARNED LINK TO FIND OUT!

Offline rumborak

  • DT.net Veteran
  • ****
  • Posts: 26664
Re: Databases
« Reply #2 on: June 18, 2011, 10:45:18 PM »
Why would you use a database for such a simple task? Seems a bit overkill. Also, storing large amounts of binary data in a database isn't good practice.

rumborak
"I liked when Myung looked like a women's figure skating champion."

Offline ZBomber

  • "The Analogy Guy"
  • Posts: 5502
  • Gender: Male
  • A Farewell to Kings
Re: Databases
« Reply #3 on: June 18, 2011, 10:54:19 PM »
What would you recommend as an alternative then? I don't have any experience in databases, I am just going off what I have read from various sites.

The other part I forgot to mention was it needs to be able to pick a random comic from the list of comics (it's Chris's website). So, if there is an alternative that can be used with a navigation bar.... that would be nice.

Offline rumborak

  • DT.net Veteran
  • ****
  • Posts: 26664
Re: Databases
« Reply #4 on: June 18, 2011, 10:58:39 PM »
tbh, I would probably just fudge a bit of code together that gets the images from a directory, and then you just increase or decrease an index.

rumborak
"I liked when Myung looked like a women's figure skating champion."

Offline XJDenton

  • What a shame
  • Global Moderator
  • *****
  • Posts: 7610
Re: Databases
« Reply #5 on: June 19, 2011, 05:03:44 PM »
I'd do it in javascript personally. Take a look at something like this:

https://www.designmeme.com/tutorials/syndicate/
« Last Edit: June 19, 2011, 05:17:38 PM by XJDenton »
"For a successful technology, reality must take precedence over public relations, for nature cannot be fooled." - Richard Feynman

Offline ZBomber

  • "The Analogy Guy"
  • Posts: 5502
  • Gender: Male
  • A Farewell to Kings
Re: Databases
« Reply #6 on: June 20, 2011, 07:11:42 PM »
Excellent, thank you! I'll look into that later tonight!