Copy link to clipboard
Copied
I am new to PHP and MySQL and struggling with developing members-only access pages on the site for existing members of an organization. The organization I'm developing the site for provided an Excel spreadsheet with the details of the existing members. These people need access to more pages on the site than non-members visiting the site. I have been reading David Powers's books which have been tremendously helpful in dveloping my understanding of the technology. Example applications I've seen are for a registration system on a website that allows anyone to register on the site and have access to all pages. I need to allow full access to existing members only right off the bat. The second part of my quandary is how to set it up so that people can join the organization right on the site and then have immediate access to the full site. Any help is greatly appreciated!
Copy link to clipboard
Copied
Have you investigated DW built in server behaviors for user authentication and access restriction?
Copy link to clipboard
Copied
To some degree, again primarily by working through David Powers' tutorials. It hasn't helped me translate how to incorporate the existing member spreadsheet into an access-only database for the site. That's my key issue I'm trying to resolve. That and giving immediate access to people who become a new paying member online through the website.
Copy link to clipboard
Copied
You can import your spreadsheet directly into your users table in your database using phpMyAdmin. The easiest way to set up your pages is going to be to use DW's built-in server-side user authentication tools.
This page my help you: http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt3_03.html
http://www.adobe.com/devnet/dreamweaver/articles/first_dynamic_site_pt3_03.html
Copy link to clipboard
Copied
Michael I think that is what I've been looking for. Thanks a lot for taking the time to help. I'm very happy and relieved!
Thanks also to bregent. You were clearly trying to get me on that track too.