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
bregent
Participating Frequently
April 16, 2010

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?


I don't think the DW server behaviors handle this - you would need to modify them. Be aware that once you modify the behavior code, you effectively break the behavior interface so you will then need to make any change to the code on that page by hand.

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