Multiple users login in Content Management System

[bickyz]

Im doing a intranet project using php and mysql.

How to do make a multiple user logins so that each user can only edit their own details, or add details.

Users will be entering the following details via cms:
Products Name:
Products Price:
Products Quantity:
Products Image:
Products full details:

All of these details will be entered in the database where visitors will search based on the Products Name/Price.

Current one i have designed where only 1 user can add/edit the products.

 

[LeetPCUser]

You should encorporate a primary key. Have this key their user id number.

For example:

When they register associate them to a key (usually the number of user they are...for example the 500th user to register is 500).

Then you should take this number and store it when they submit their info. Then you can compare it and say if user # = blah, let them edit. Else, display message that tells them not too.

If you need more help let me know.

 

[bickyz]

Hi LeetPCUser,
Do you mean i have to create 2 table one with user's name and id as the unique primary key.

And other table with the
Products Name:
Products Price:
Products Quantity:
Products Image:
Products full details: