Best way to log IP of user per day?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
JosephDuffy
Forum Newbie
Posts: 2
Joined: Fri Sep 30, 2011 12:48 pm

Best way to log IP of user per day?

Post by JosephDuffy »

Hi,
I'm making a site with the ability to "vote" on something.
I want the user to vote once per day, and that code is currently working.
I'm struggling to figure out how to stop people voting more than once per day. I could log the IP in a db, then delete it every day, but that could be demanding, and I would like to have an archive of old votes, so I think saving them will be good.
I've thought of making a table per ip, and then logging the dates of the things they voted on, but could a database with a lot of tables not be good idea? (I'm new at making/maintaining db's). I've also thought that IPs change, and a cookie might be better, but they can just delete the cookie!
I'm a bit stuck here, so any ideas would be much appreciated!
Hopefully I've gone into enough detail, if not, please tell me.
Thanks for any help,
Joseph Duffy
Post Reply