Go Back   CodingForums.com > :: Server side development > PHP

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 09-25-2012, 10:30 PM   PM User | #1
camzenxbt
New Coder

 
Join Date: Aug 2011
Location: England
Posts: 23
Thanks: 9
Thanked 0 Times in 0 Posts
camzenxbt is an unknown quantity at this point
SQL Create Table with access level?

Hi there,
I was wanting to create a sql table with an 'access level' for certain users.
My website is going to be for children, and parents, so my plan is to give children the user level of 1, and parents the user level of 2, so parents can access all pages, but children cant access parental pages as their access level is only 1.

I tried doing this, but I understand you have to enter a 'default' value for the access level, but I wanted to allow the user to choose their level (example: 'are you a parent or child' dropdown list.

Also, to go with this SQL table, their would have to be a PHP access code which allows only parents to the page when the access level is for members with access level '2' only (and obviously the admin with access level 5)

Does anyone know how to do this? I'm not a genius at PHP and MySQL as I am learning it.

Thanks for your help!.
camzenxbt is offline   Reply With Quote
Reply

Bookmarks

Tags
access, level, login, member, user

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:31 AM.


Advertisement
Log in to turn off these ads.