Hi. Just registered and spent a while browsing. Great forum. So I thought I'd ask the wise some advice.

 

I've just completed building a member site in Dreamweaver. Been working on it in a joint business venture for 18 months. All content finalised, everything ready to go.

 

I now need to create a user/membership database for paying customers.

 

I've downloaded xampp with MySQL and phpMyAdmin. However, I've no experience with either. I want to make sure I'm on the right track to nail it before I begin in earnest, without launching into some needless trip down tangent boulevard.

 

So...I'm asking you gents with the requisite knowledge to assess my following logistical plan and benefit me with your advanced wisdom:

 

1) I can create php login/membership registration pages in DW. I know how to apply server behaviours and add authorisation to specific pages for members only.

After that, it's foggy; re: database use. The steps I'm considering for membership would be thus: A direct link from our site to the billing company to receive payment from prospective members. Then, AFTER paying, the new member is linked back to a php page where they can enter their username (e-mail) and chosen password, becoming a registered, paid-up member. (I propose this in order to stop database clutter by only accepting member info after payment.)

 

2) So I need a database which would retain the username (e-mail), password and dates of both joining and expiry (I offer a 6 or 12 month membership plan). I would also need to be able to automatically mail members around the time of membership expiry, offering a renewal deal inclusive of 3 months free membership. And if that's taken up the database would need to recognise and reflect the renewal by adding 3 months to the new expiry date. i.e 9 or 15 months instead of 6 or 12 for renewing members).

 

3) So, regarding 1 & 2, can I ask you to inform me:

 

a - Does the logic sound correct?

b - Is the creation of such a database straightforward? Simple enough for my level of experience? (I did manage to successfully design a working site featuring video and slideshow functions, however I've no coding experience).

c - Are there any layman's step-by-step tutorials you know of for designing such a db that are recommendable?

d- Any points you may wish to make that I have overlooked in my inexperience?

 

Thanks for perusing this post. Look forward to any enlightening replies.

Hi. Just registered and spent a while browsing. Great forum. So I thought I'd ask the wise some advice.

 

I've just completed building a member site in Dreamweaver. Been working on it in a joint business venture for 18 months. All content finalised, everything ready to go.

 

I now need to create a user/membership database for paying customers.

 

I've downloaded xampp with MySQL and phpMyAdmin. However, I've no experience with either. I want to make sure I'm on the right track to nail it before I begin in earnest, without launching into some needless trip down tangent boulevard.

 

So...I'm asking you gents with the requisite knowledge to assess my following logistical plan and benefit me with your advanced wisdom:

 

1) I can create php login/membership registration pages in DW. I know how to apply server behaviours and add authorisation to specific pages for members only.

After that, it's foggy; re: database use. The steps I'm considering for membership would be thus: A direct link from our site to the billing company to receive payment from prospective members. Then, AFTER paying, the new member is linked back to a php page where they can enter their username (e-mail) and chosen password, becoming a registered, paid-up member. (I propose this in order to stop database clutter by only accepting member info after payment.)

 

2) So I need a database which would retain the username (e-mail), password and dates of both joining and expiry (I offer a 6 or 12 month membership plan). I would also need to be able to automatically mail members around the time of membership expiry, offering a renewal deal inclusive of 3 months free membership. And if that's taken up the database would need to recognise and reflect the renewal by adding 3 months to the new expiry date. i.e 9 or 15 months instead of 6 or 12 for renewing members).

 

3) So, regarding 1 & 2, can I ask you to inform me:

 

a - Does the logic sound correct?

b - Is the creation of such a database straightforward? Simple enough for my level of experience? (I did manage to successfully design a working site featuring video and slideshow functions, however I've no coding experience).

c - Are there any layman's step-by-step tutorials you know of for designing such a db that are recommendable?

d- Any points you may wish to make that I have overlooked in my inexperience?

 

Thanks for perusing this post. Look forward to any enlightening replies.

 

Just curious how did u create ur members site without creating a database using phpmyadmin or another mysql tool?

Hi. Just registered and spent a while browsing. Great forum. So I thought I'd ask the wise some advice.

 

I've just completed building a member site in Dreamweaver. Been working on it in a joint business venture for 18 months. All content finalised, everything ready to go.

 

I now need to create a user/membership database for paying customers.

 

I've downloaded xampp with MySQL and phpMyAdmin. However, I've no experience with either. I want to make sure I'm on the right track to nail it before I begin in earnest, without launching into some needless trip down tangent boulevard.

 

So...I'm asking you gents with the requisite knowledge to assess my following logistical plan and benefit me with your advanced wisdom:

 

1) I can create php login/membership registration pages in DW. I know how to apply server behaviours and add authorisation to specific pages for members only.

After that, it's foggy; re: database use. The steps I'm considering for membership would be thus: A direct link from our site to the billing company to receive payment from prospective members. Then, AFTER paying, the new member is linked back to a php page where they can enter their username (e-mail) and chosen password, becoming a registered, paid-up member. (I propose this in order to stop database clutter by only accepting member info after payment.)

 

2) So I need a database which would retain the username (e-mail), password and dates of both joining and expiry (I offer a 6 or 12 month membership plan). I would also need to be able to automatically mail members around the time of membership expiry, offering a renewal deal inclusive of 3 months free membership. And if that's taken up the database would need to recognise and reflect the renewal by adding 3 months to the new expiry date. i.e 9 or 15 months instead of 6 or 12 for renewing members).

 

3) So, regarding 1 & 2, can I ask you to inform me:

 

a - Does the logic sound correct?

b - Is the creation of such a database straightforward? Simple enough for my level of experience? (I did manage to successfully design a working site featuring video and slideshow functions, however I've no coding experience).

c - Are there any layman's step-by-step tutorials you know of for designing such a db that are recommendable?

d- Any points you may wish to make that I have overlooked in my inexperience?

 

Thanks for perusing this post. Look forward to any enlightening replies.

 

Your working to far ahead, Go back a few steps, learn photoshop, Learn dreamweaver, Learn HTML/CSS then learn PHP

Sorry, but you've misread.

 

I have ALREADY created the site, using Dreamweaver8.

 

What I'm looking for is an assessment of my logic as I now seek to create a MySQL database for paying members.

 

The site is a Dreamweaver8-created html monster using php pages as gateways to member sections.

 

I understand the procedure as in accessing a database for clarification of authorizations BUT I do not have any database experience, hence the questions posed in my first post, if anyone could be so kind as to read it fully and give me the benefit of your experience.