Forum Moderators: coopster
I want to create a website that will be password access only. 6 users will have access to the site. The site is for 5 shops, and each shop manager should be able to login and be able to see the page relating to his site only. The owner of the company should be able to see all the shops pages.
Each manager has to log onto the site everyday and enter in a few figures which will be saved and be viewable to the owner and the manager who entered it...this has to be done everyday.
Now I was thinking of using MySQL, but wanted to know if there is any need. Isnt it possible to develop the password access site with PHP alone, and for the data entry is it possible to just embedd in excel or acess or something, or do it with any other way without using a DB....
please help soon, as i need to get this done in a few weeks!
Thanks
mySQL is not needed (could use flatfile) but it is by far the easiest way
i think you can do this with 3 tables in a MySQL database.
1 for Users and their info (username, password, userlevel)
2 for shops (shopid, shop name, manager's id)
3 The data that you need inputted.
simply have a front page that allows the user to log in by doing a password check (use md5 to encrypt and compare the password hash).
Once logged in the user is checked to see their userlevel, if the user level is "normal" or shop manager or something (you can use names, but i prefere numbers for each level) then display a list of shops that only this manager manages. if the user is company owner then display all shops.
once a user clicks on a shop they can then be presented of what ever they want to do in that section e.g. input data. use a form to take in the data that you want in the database, and use SQL to input what ever the user has placed into the form to the database table "data" (use a better name)
that's a small breif of the logic of how it could be done. Databases are very usefull, powerfull and efficient. use them! :)
Saves you a LOT of coding. :)
