Jump to content

Quiz-How to storing history peruser like in common forum?


Recommended Posts

Just like the above. how any common forum storing history of thread user posted?

1. in mysql table on "profile user table" in history column as array

OR

2. create one table specially for history(with this one , there will be so many table because one user may make one table-which is maybe not practical)?

 

i'm asking it because "making shoppping cart tutorial"-which is similiar- using session which is not practicall. when userbrowser close, history lost too. i think webmaster practically storing history in database and using cookies as filter for SELECT and UPDATE database. am i wrong?

i just don't know how to store it in mysql as an array.  :(

 

the method i've know so far for this problem is:

 

create one table for history. it contains 1 column for user id and 1 column for topic id. and it stand for intermediate between userid table and topic table.

so we will have 3 table, one for userid, one for history, one for topic.

 

i wonder if there is any other method.

and  i wonder if mysql can contain array in column value.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.