Create members only contact list

[SteveJones]

I'm brand new here, and this is my first post. My site is hosted by BlueHost (since 2006) and is built with straight HTML, Javascript, and CSS. It is my homebrew clubs' web site (www.franklinbrew.org).

I'd like to create a members contact list that is only accessible by club members, and that is actually populated by the members who would like to make their info available to other members. It has been suggested by a coworker that I use PHP and MySQL, but I would need to learn PHP and don't have the time right now. I am very familiar with MS SQLServer, so should be able to pick up MySQL very easily.

So ... I'm looking to create a db for the contact list, a page to login, a page to display the info, and a page for members to add their info. Does anyone have a contact list similar to this? Would you be willing to share the details ... including code and db design?

Thanks in advance.
Steve

[pmbinky]

Hi SteveJones,
I live at this site: http://www.w3schools.com/default.asp and their tutorials are excellent and very "real world." It is where I learned enough php in a couple of hours to accomplish what you are asking.
I too created a database of users who signed up for a distribution and then created a private access area. Here are the steps I took:


Using cpanel, I created the database and tables I needed (use phpMyAdmin in cpanel to manage after creation)
I created a page with an html form and a javascript on that page validates the form info
The 'action' for the form calls a php page that does the database entry based on the validated form data
I created another page in a password protected area that has a form prompted the user for what tasks they want to do, ie. email to the list members, access member information, etc.
This page then calls another php page in that password protected area that performs the requested task(s) and presents the results to the user
If I ever need to do modifications to my database I just use phpMyAdmin in cpanel
I hope this helps.

blessings,
Tony <><