Board index   FAQ   Search  
Register  Login
Board index PHP PHP Scripts

The time is ticking

Links for php scripts

Moderators: macek, egami, gesf

The time is ticking

Postby icu90ucme » Mon Jul 07, 2003 2:35 pm

Problem: I only want a member's subsciption to last one year.

Solution: I need a script that will check a user's "registration date" in a mysql database and tell me a couple of month's before the year is over so i can inform the user to resubscribe.

Any help is appreciated
icu90ucme
New php-forum User
New php-forum User
 
Posts: 23
Joined: Mon Jul 07, 2003 2:29 pm

Postby bezmond » Mon Jul 07, 2003 4:26 pm

please don't cross-post.
User avatar
bezmond
Moderator
Moderator
 
Posts: 312
Joined: Sat Apr 05, 2003 4:33 am
Location: Mansfield, UK

Postby liquedus » Mon Jul 07, 2003 5:10 pm

dammit andrew i wanted to get to NAG first... :wink:
liquedus
php-forum Active User
php-forum Active User
 
Posts: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada

Postby icu90ucme » Mon Jul 07, 2003 7:09 pm

sorry i'm a newbie... i just really need to know a solution
icu90ucme
New php-forum User
New php-forum User
 
Posts: 23
Joined: Mon Jul 07, 2003 2:29 pm

Postby nathanwebb6 » Tue Jul 15, 2003 2:30 pm

what i would suggest is when they sign up, get the current seconds from 1970, and write it into the database. Also in the dtabase add a row called confirmed. confirmed will either be yes or no. no as default. Then if you add a script in a webpage viewed frequently, you could tell the script to get the time from 1970, then take the time from the date subscribed in the entry. If the subscribed date is over 7 months gone, tell it to send a e-mail to the persons e-mail in db, and if the e-mail is sent successfully set te confirmed row to yes

make sure that you only select entries from the database that have checked as no.... can you understand that?
nathanwebb6
New php-forum User
New php-forum User
 
Posts: 27
Joined: Sat Jul 05, 2003 5:08 pm
Location: england uk


Return to PHP Scripts

Who is online

Users browsing this forum: No registered users and 2 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron