RE: [PHP-DB] Members area
Hi, If anyone else has any further ideas, please let me know - thanks. Thanks Jim for the nuke idea, I've downloaded it am looking through it... very exhaustive though... Thanks Jeff on your thoughts. I've been thinking along very similar lines to what you suggested... - I have a contents table plan to add a column authlevel (Authority Level), so that each page will have a defined minimum access. - I was thinking of creating a members table with username, password, authaccess. I liked the idea of leaving room for further growth, and the 'x = y' control rather than the 'if x = y' or case equivalent. - Establish an SSH session between the browser server for the session/cookie establishment when the username password are submitted (a lot of reading may be needed for this one I think...). - use either sessions to control the access, or cookies (from what I've read, people seem to favour sessions, I will have to do some reading before I make my choice). It is good to know there are others out there that are thinking in the same mannor for this... Let me know how you progress. Cheers, Gav -Original Message- From: Baumgartner Jeffrey [mailto:[EMAIL PROTECTED]] Sent: Thursday, 23 January 2003 9:05 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Members area I'm working on a similar project - I'm also a newbie - here's my approach - which is fairly simple really. Create a database of all members that includes columns for login, name and paymentStatus as well as any other info you need for your database. paymentStatus would be an integer with values of 2 and 5 initially (this allows room for the creation of other levels in the future) in which 2 is for paid members and 5 is for free members. Once members log-in, their paid status is saved as a session variable: $paymentStatus. All member-area pages will start with session_start(); at the beginning and a check of the value of $paymentStatus. If it is null, they are sent to the log-in page. If the page is for members only, then the value of $paymentStatus must be =2. If it is for any member, then $paymentStatus will have to be =5 (this all gives room for different levels of membership in the future, you see). Likewise content, which is stored on tables, includes a $paid variable which indicates who is able to view it. This way, you can deliver dynamic content, links and other information according to the $paymentStatus value of each visiting member. In my case, I will have index pages with links to content pages. All links will be visible, but links for paid members will be clearly indicated. The purpose of this is to show freeloaders what they are missing! I hope this is clear. More experienced members of this list may well find flaws with my method. Good luck, Jeffrey Baumgartner eBusiness Consultant - ITP Europe http://www.itp-europe.com [EMAIL PROTECTED] +32 2 721 51 00 -Original Message- From: Gavin Amm [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:03 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Members area Hi All, I'm about to start development on a members area for a site. The members area will have 2 levels - Paid Free, with the Paid members having access to more pages. I have not created a members area before am after any advice or links I can get... I think a lot of reading is in order... Particularly: - DB structure fields (I'll be using MySQL if that's relevant) - Sessions (I've seen quite a few threads covering sessions over the last couple of months, so should have some links in my 'inbox' somewhere... But the more the merrier...) - Any PHP suggestions/advice/links - Anything else you can think is relevant... Thanks, this will be a big help. Cheers, Gav -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Members area
I'm working on a similar project - I'm also a newbie - here's my approach - which is fairly simple really. Create a database of all members that includes columns for login, name and paymentStatus as well as any other info you need for your database. paymentStatus would be an integer with values of 2 and 5 initially (this allows room for the creation of other levels in the future) in which 2 is for paid members and 5 is for free members. Once members log-in, their paid status is saved as a session variable: $paymentStatus. All member-area pages will start with session_start(); at the beginning and a check of the value of $paymentStatus. If it is null, they are sent to the log-in page. If the page is for members only, then the value of $paymentStatus must be =2. If it is for any member, then $paymentStatus will have to be =5 (this all gives room for different levels of membership in the future, you see). Likewise content, which is stored on tables, includes a $paid variable which indicates who is able to view it. This way, you can deliver dynamic content, links and other information according to the $paymentStatus value of each visiting member. In my case, I will have index pages with links to content pages. All links will be visible, but links for paid members will be clearly indicated. The purpose of this is to show freeloaders what they are missing! I hope this is clear. More experienced members of this list may well find flaws with my method. Good luck, Jeffrey Baumgartner eBusiness Consultant - ITP Europe http://www.itp-europe.com [EMAIL PROTECTED] +32 2 721 51 00 -Original Message- From: Gavin Amm [SMTP:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:03 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Members area Hi All, I'm about to start development on a members area for a site. The members area will have 2 levels - Paid Free, with the Paid members having access to more pages. I have not created a members area before am after any advice or links I can get... I think a lot of reading is in order... Particularly: - DB structure fields (I'll be using MySQL if that's relevant) - Sessions (I've seen quite a few threads covering sessions over the last couple of months, so should have some links in my 'inbox' somewhere... But the more the merrier...) - Any PHP suggestions/advice/links - Anything else you can think is relevant... Thanks, this will be a big help. Cheers, Gav -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Members area
Hi All, I'm about to start development on a members area for a site. The members area will have 2 levels - Paid Free, with the Paid members having access to more pages. I have not created a members area before am after any advice or links I can get... I think a lot of reading is in order... Particularly: - DB structure fields (I'll be using MySQL if that's relevant) - Sessions (I've seen quite a few threads covering sessions over the last couple of months, so should have some links in my 'inbox' somewhere... But the more the merrier...) - Any PHP suggestions/advice/links - Anything else you can think is relevant... Thanks, this will be a big help. Cheers, Gav -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Members area
Gavin, Download PHP-Nuke and look to see how they handle Non-Users/users/Admins and go from there. It's actually quite easy. They have a table structure that you could utilize and some generic routines for determining if a user is logged in or if they are an Admin. www.phpnuke.org Jim ---Original Message--- From: Gavin Amm Date: Wednesday, January 22, 2003 05:05:32 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Members area Hi All, I'm about to start development on a members area for a site. The members area will have 2 levels - Paid Free, with the Paid members having access to more pages. I have not created a members area before am after any advice or links I can get... I think a lot of reading is in order... Particularly: - DB structure fields (I'll be using MySQL if that's relevant) - Sessions (I've seen quite a few threads covering sessions over the last couple of months, so should have some links in my 'inbox' somewhere... But the more the merrier...) - Any PHP suggestions/advice/links - Anything else you can think is relevant... Thanks, this will be a big help. Cheers, Gav -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php .
