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 17, 2010

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.


OK well I guess I'm back to where I began. Thanks for

giving it a go trying to help.


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