k4pil

Hi there.

I have created a website which requires users to have an appropriate username and password to enter. However, the next step is that each time a user logs a record is made on the mySql database.

Also, would it be possible to record on the same database which files from my server this user has accessed??

Just need some direction, iv searched the web and looked in the library, but nothing as of yet.

Thanks in advance

DaWei

Anything you can detect the user doing you can log. You wouldn't want to keep a list of files in the user table. It would be better to keep a list of files (another table) with the user's id (a unique key, I presume) as part of the record. Then you could make a joined query if you wanted to see the list for a given user. Stuff like that. Same with login records.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

k4pil

Cheers DaWei, but what do i need to know in order to get something like that working.

Also, the users do have a unique id that i could use in some new table e.g.usersActivities(activityLog, userID,time,activity) here activityLog would be unique. That look ok?

NFreak

You can make a footer to run a script at the bottom of every page that updates a table in the database and keeps track of how many times each page was viewed.

__________________
http://nfreak.net/

k4pil

Ok. So if i have a table like
usersActivities(activityLog, userID,time,page)

I can add to this databse everytime a page is accessed because there is a script at the bottom, makes sense.

Script would be something like
INSERT INTO UsersActivities VALUES ('', $userID,'', $pageTitle

Well something like that?
Ill give it a go

NFreak

I would make a table that has a field for every page you want information logged in. Then there would be a record for each member on your site. Then when a member views a page, you have it update the table where member = $userID and pagetitle = $pageTitle.

__________________
http://nfreak.net/

Arevos

Are you saying that you should have a table with a column for each page? Because that isn't really a very good solution. k4pil's table seems a lot better, though I have no idea what the "activityLog" field is for. And I think he needs a unique ID for each row in his log.

DaWei

Arevos is correct. Whether it turns out to be overkill or not, I generally have a unique ID in every table. For instance, if I had a database with a bunch of customers, each of which could have multiple orders, my orders table would have a unique ID for each row, a product ID for each product included in the order, and a customer ID to relate the order back to the customer. The product ID would relate back to the product table.

__________________
Abstraction doesn't make it impossible to write bad code; it makes it possible to write superior code.
Contributor's Corner: Grumpy on C++ Exceptions DaWei on Pointers

k4pil

Well mu activityLog was a unique id for each activity i guess...well it made sense when i wrote it and kinda still does

NFreak

Well if he only wanted to log activity on certain pages, then my solution would probably be a better idea, but I'm assuming he wants every page on his site logged, so yes, my idea was stupid.

I'm new to MySQL. I've only been using it for maybe a month. >.<

__________________
http://nfreak.net/