Classified Favorites?

[Anon]

I'm working on a classified system. PHP/MySQL. The system itself is working great. So what I want to do now is add a checkbox next to each listing and an 'Add To Favorites' button at the bottom of the page. So you can make a personalized list of the listings that matter to each user.

I've done part of that, now I have a page called favorites.php that gets passed something like this:

favorites.php?favs=123&favs=234&favs=345&send=Submit

I don't know if I should put that information into a DB matched up to the user with a cookie, or just keep it all in a cookie.

I also don't know how to handle this array to do that... Any help would be great, Thanks!

[trooper]

Cy

You're right that this is best put into a database. That way the user will be able to "manage" their favourites, e.g edit / delete etc.

Your easiest way to do this is that every time they click on "add to favourites" is to insert their id and the item id (or whatever you use to uniquely identify the item) into a separate table. That way their favourites will be stored and can be accessed at any time.

HTH