Image gallery code...

[psycovic23]

Hey! I know that this code is pretty awful, which is why I turn here for help! Please..be as picky as possible😃

Here

[Weedpacket]

One question I'll ask is why you need an entire table for each group, instead of one table with a field for group ID.

[psycovic23]

I used to have it that way..but I thought this way would be a little more efficient since it's more organized?

[Weedpacket]

If anything, it's less organised. How do you link each group's table with group information (like name and so on)?

[drawmack]

It also makes the system less scalable as adding groups is more difficult

[psycovic23]

Well, my system is:

Userdb: contains tables for each user

Each user table: contains title and each individual gallery.

Individual gallery: contains caption, title, links to urls/thumbnails, etc.

Whenever you add a gallery, it adds an entry into the User table, and creates a new table for each gallery.

[drawmack]

It could be normalized like this

UserTable
    userid
    username
    password
    ...

Galeries
     galid
     gal_name
     gal_userid
     ....

GalLinks
    linkid
    link_name
    link_caption
    link_url
    link_galid
    ...

If you code with this layout you'll see that the code is much simpler this way.

[psycovic23]

Alright, I'll try that! Thanks. Is there any way I can make that script leaner though? I feel like I put so much crap in it.