Skip to main content
B
bmmotion
Known Participant
April 14, 2010
Question

Date cancels access

  • April 14, 2010
  • 1 reply
  • 478 views

Is there some way to dynamically using PHP and MySQL prevent access to members-only pages to an individual whose membership has expired based on a due date column in the table? Or do they have to be manually removed from the table?

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
April 14, 2010

Of course. To tell the visitor that their membership has expired, retrieve the due date column and compare with the current date. Or if you just want to restrict access without notifying them, compare the expiration date to the current date in the sql where clause.

B
bmmotionAuthor
Known Participant
April 15, 2010

Great, thanks for that confirmation. Being quite new to working in dynamic environments, is there a specific procedure for how to do this you could point me to?

B
bmmotionAuthor
Known Participant
April 15, 2010

No, nothing specific. How did you create the code that is currently restricting access? Are you using DW server behaviors for this? If so, you will need to modify those which means becoming familiar with your server side scripting language.


I haven't settled on an approach yet. Still looking at some of the David

Powers info and the reference provided in another thread to a separate

question of mine. Both approaches are based on the DW server behaviors

though. Again being new and very naive to the techniques here, is there

a DW behavior that addresses this fairly directly?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices