I want to make a recipe website.In that I had added the add to favourite button.If i click my favourite button the recipe which i clicked will add to favourites.I i re-click it will remove from my favourites.It is controlled by the status field in the favourites table in sql.How could I do this?
Aiswarya_1
0
Newbie Poster
Recommended Answers
Jump to PostIf you want to delete the recipe from the favourites all together you could do the following
You need 3 tables:
UserTable
- UserID (primary key)
RecipeTable
- RecipeID (primary key)
FavouritesTable
- FavouritesID (primary key)
- UserID (foreign key)
- RecipeID (foreign key)
You'll also need 2 stored procedures:
Insert
…
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.