And thanks for all your help.

Jerry Kornbluth

I've got nothing written up, sorry. This would be considered a custom addition, though it's likely a pretty quick one. Can you email Ross at consulting@interactivetools.com with a link to this thread? 

I know I'm pushing the envelope, but could you offer any code snippet that I could use to do this? 

I'm feeling very programming challenged by this for some reason. (I think I always feel challenged about working with dates.)

Thanks,

Jerry Kornbluth

I think you're overthinking this. You already know that the renewal date will be September 30th or October 1st, yeah? It's only the year that changes. So your code doesn't need to add on a certain number of days - you effectively only need to work out what year it should be in.

I think some PHP logic should sort this out - as in, looking at the current time, working out whether it's before or after January 1st, and then setting the year manually instead of using the date function.

<?php $current_expiration = $CURRENT_USER['expiresDate'] ?>
  <?php $expires_date_plus_1_year = date('Y-m-d H:i:s', strtotime($current_expiration) + 60*60*24*365); ?>
<?php
  mysqlStrictMode(false);
 mysql_query("UPDATE `{$TABLE_PREFIX}accounts`    
    SET
    expiresDate       = '".mysql_escape($expires_date_plus_1_year)."'
   WHERE num = '".mysql_escape( $CURRENT_USER['num'] )."'")  
       or die("MySQL Error:<br/>\n". htmlspecialchars(mysql_error()) . "\n");  
        $userNum = mysql_insert_id();  
    // redirect after a successful update  
    header("Location:  $masterurl/renewal-confirmation.php");
 ?>

Then I tried using add_date and it throws the following mySQL error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATE_ADD('2020-09-29 00:00:00', INTERVAL 5 YEAR); WHERE num = '4'' at line 3

(the date 2020-09-29 is correct, as is the user number '4")

 <?php $current_expiration = $CURRENT_USER['expiresDate'] ?>
<?php
  mysqlStrictMode(false);
 mysql_query("UPDATE `{$TABLE_PREFIX}accounts`    
    SET
     DATE_ADD('$current_expiration', INTERVAL 5 YEAR);
   WHERE num = '".mysql_escape( $CURRENT_USER['num'] )."'")  
       or die("MySQL Error:<br/>\n". htmlspecialchars(mysql_error()) . "\n");  
        $userNum = mysql_insert_id();  
    // redirect after a successful update  
    header("Location:  $masterurl/renewal-confirmation.php");
 ?>

Any thoughts?

Thanks,

Jerry Kornbluth

Can you offer a basic coding format to start with?

(You're so good at this...)

Thanks,

Jerry Kornbluth

Hardcoded checks are not ideal, but they'll be fine as long as you've only got a couple to deal with.

Could I use Sept 30 as a fixed value and add 1 or 2 to the year value depending on which part of the year they renewed in?

Thanks,

Jerry Kornbluth

Adding time using the UNIX timestamp and a string of multiplication is really the simplest method of doing it, unfortunately.

I feel like I'm pushing my luck by asking, but is there an easy way to add one year (or 2 years) to the expiresDate to a specific date without a long string of multiplication operatives?

Possibly one that takes into account that dreaded leap year calculation?

So for example, if a membership cycle is Oct 1 - September 30, and someone renews in the first half of the cycle (October 1 - March 31), they get renewed through September 30 of the next year.

If they renew in the second half of the cycle (On or after April 1) they get renewed through September 30 of the second year.

Thanks,

Jerry Kornbluth

That works perfectly.

It's so easy when you know how....

Best,

Jerry Kornbluth

$end_date_plus_7_days = date('Y-m-d H:i:s', strtotime($event_end_date) + 60*60*24*7); 

Jerry Kornbluth

That is exactly what i am working on in my database.  For now, I used phpMyAdmin to do it manually.

As soon as I figure it out I will respond to the post.

Ragi

P.S.  BTW, have you every heard of phpGrid? (http://phpgrid.com)  Worth a look.

Appreciate your looking at this.

I'm not too good at mysql syntax. Where would you insert that code in the above?

Thanks,

Jerry Koirnbluh

UPDATE tablename SET fieldname1 = fieldname2 + INTERVAL 7 DAY;

I have used it with + 1 YEAR.  You may need to check the syntax to confirm is "DAY"

So you should be able to do this:

UPDATE tablename SET removeDate = event_end_date + INTERVAL 7 DAY;

Tell me if it works!

Ragi

Thanks for your help,

Jerry Kornbluth
 
Here’s the code I’m using so far.

Near the top of the page to define variables:

 $event_end_date = date("Y-m-d",mktime(0,0,0,@$_REQUEST['month_2'],@$_REQUEST['day_2'],@$_REQUEST['year_2']));  //Works to populate the event_end_date field

And, I’ve tried both:

$end_date_plus_7_days =date("Y-m-d", strtotime($event_end_date . " +7 day");
and
$end_date_plus_7_days = strtotime(date("Y-m-d", strtotime($event_end_date)) . " +7 day");

but neither work to populate the removeDate field

In my mysql insert I’m using:

event_end_date    = '".mysql_escape($event_end_date)."',
and
removeDate     = '".mysql_escape($end_date_plus_7_days)."',

And in the form I'm using:

<tr>
              <td class="body-text-bold-9">Event End Date</td>
              <td> Month:
                <select name="month_2">
                  <?php foreach(range(1,12) as $month_2): ?>
                  <option value="<?php echo $month_2;?>"><?php echo date("F",strtotime("0000-$month_2"));?></option>
                  <?php endforeach ?>
                </select>
                Day:
                <select name="day_2">
                  <?php foreach(range(1,31)as $day_2): ?>
                  <option value="<?php echo $day_2;?>"><?php echo $day_2;?></option>
                  <?php endforeach ?>
                </select>
                Year:
                <select name="year_2">
                  <?php foreach (range($lowestYear,$highestYear) as $year_2):?>
                  <option value="<?php echo $year_2;?>"><?php echo $year_2;?></option>
                  <?php endforeach?>
                </select></td>
            </tr>