Jump to content

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


Bluezep

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.