Need help with creating a list website

[Trek15]

Hey folks. I'm not native to English.

 

I would like to create an interactive list-website with... well i don't even know what it's called, which is why i need to explain this and see if you guys perhaps know what i'm looking for!

 

Ok, so, anyone's supposed to be able to register and login to submit something to the list in mind. These submissions however are only supposed to be visible to the author of the website (me) and the user who submitted them until i choose to make them public. Each user is supposed to be able to login and check on the "status" of their submitted items in their account. These items are supposed to be case-sensitive, so that when a user enters the very same name for an item as an already existing item (whether the existing item is showing on the public list or still is hidden to anyone but the author and respective user), the status for that already existing item gets bumped up in number of times submitted. So each item on the list is supposed to be able to be submitted several times but only from different users (no duplicates from the same user), and when this happens every user who has submitted the same item should be able to see how many times this item has been submitted in the already mentioned area in their account, and this number should also be visible on the public list. It would also be good if i could make it automatic for items to enter the public list when they have reached a certain number of times submitted so i don't have to do this manually all the time.

 

I'm not sure what to do with the description of items on the list when they have been submitted with a description by multiple users. Perhaps it would be possible to see a list of all descriptions by all users by hovering the mouse over, or perhaps clicking a + to extend the list of descriptions?

 

So it's kind of a simple list but with a more or less advanced uh... well, function for seeing the status of something submitted. lol. I guess i could compare it to the shopping cart in an online store. A customer can sign in and check the status of their orders whenever they want.

 

It's plain practically straight-forward, but i have no idea what kind of software that could do this. I'm only really experienced with forum software and it doesn't seem like a forum would be the optimal way to do this list in since i don't know any forum software nor mod for a forum software that can do the kind of technical stuff i'm looking for with the submissions and the dynamic status and all that.

 

I would very much appreciate any help!

[Adam]

Sounds like you're wanting to create a directory site; but I'm not sure you'll find pre-built software as specific as you want.

[Trek15]

Sounds like you're wanting to create a directory site; but I'm not sure you'll find pre-built software as specific as you want.

 

Thanks Adam. I looked around but couldn't find anything interesting. The thing is that since english isn't my native language i don't really know what to search for. "Directory" seems somewhat what i'm looking for but i guess google wants me to be more specific than that. The thing is that i've been a member of a website like the one i want to build long ago so i know that it's out there somewhere. I hate it that every time i have a good idea for a website i'm always limited in finding what i need to pull it off due to my limited vocabulary.

[ignace]

Your database schema will look somewhat similar to:

 

CREATE TABLE user (
  user_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  user_email_address VARCHAR(96) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci,
  user_password CHAR(40) NOT NULL CHARACTER SET ascii,
  INDEX idx_user_logon (user_email_address, user_password),
  UNIQUE INDEX idx_user_email_address (user_email_address)
) ENGINE = MyISAM;

CREATE TABLE website (
  website_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  website_url VARCHAR(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci,
  website_count INT UNSIGNED NOT NULL DEFAULT 1,
  website_is_visible TINYINT(1) NOT NULL DEFAULT FALSE,
  INDEX idx_website_url (website_url),
  INDEX idx_website_is_visible (website_is_visible)
) ENGINE = MyISAM;

CREATE TABLE list (
  list_website_id INT NOT NULL,
  list_user_id INT NOT NULL,
  list_comment VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
  list_website_is_accepted NOT NULL DEFAULT FALSE,
  PRIMARY KEY (list_website_id, list_user_id)
) ENGINE = MyISAM;

[Adam]

The thing is that i've been a member of a website like the one i want to build long ago so i know that it's out there somewhere.

 

Perhaps they wrote the code themselves?

[Trek15]

Thanks. That's very kind of you. So is there like any chance you'd know what the php code would look too? Hehe. If i'll have to build this myself it certainly wouldn't feel too eager to spend weeks learning a new coding language to make something that an experienced hobbyist could make in a couple of hours.

 

Your database schema will look somewhat similar to:

 

CREATE TABLE user (
  user_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  user_email_address VARCHAR(96) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci,
  user_password CHAR(40) NOT NULL CHARACTER SET ascii,
  INDEX idx_user_logon (user_email_address, user_password),
  UNIQUE INDEX idx_user_email_address (user_email_address)
) ENGINE = MyISAM;

CREATE TABLE website (
  website_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  website_url VARCHAR(255) NOT NULL CHARACTER SET utf8 COLLATE utf8_general_ci,
  website_count INT UNSIGNED NOT NULL DEFAULT 1,
  website_is_visible TINYINT(1) NOT NULL DEFAULT FALSE,
  INDEX idx_website_url (website_url),
  INDEX idx_website_is_visible (website_is_visible)
) ENGINE = MyISAM;

CREATE TABLE list (
  list_website_id INT NOT NULL,
  list_user_id INT NOT NULL,
  list_comment VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
  list_website_is_accepted NOT NULL DEFAULT FALSE,
  PRIMARY KEY (list_website_id, list_user_id)
) ENGINE = MyISAM;

[ignace]

"If you are good at something, never do it for free." -- The Joker

[Trek15]

"If you are good at something, never do it for free." -- The Joker

 

Hehe, yeah, that's what i thought. Thanks anyways.