[Resolved] [Q] One month later in PHP and MySQL...

cyanblue

Howdy, guys... 🙂

I am having problem with '1 month later from today'...

I am basically making a register routine that will activate the username for one month period... That 'month' term is abit unclear, but I want it for one calendar month... In other words, if I register on 12/31, then the membership expires on 1/31, and 2/29 if I register on 1/31...

In MySQL command that's in the PHP script, I have this line...

$sql = "INSERT INTO " . MEMBERSHIP_TABLE . "(`StartDateTime`, `EndDateTime`) VALUES ( CURDATE(), CURDATE() + INTERVAL 1 MONTH);";

and I get to see '2004-01-31 00:00:00' and '2004-02-29 00:00:00'... Well... It seems to be just what I want... 🙂

In PHP, I have found this script from the forum... and I think it is basically adding 31 days to the previous date and I don't really want it...

$regDate = date("m/d/Y", mktime(0, 0, 0, date("m"), date("d"), date("Y")));
$expDate = date("m/d/Y", mktime(0, 0, 0, date("m") + 1, date("d"), date("Y")));
$monthLater = date("m/d/Y", strtotime("+1 month"));

That script returns '01/31/2004' and '03/02/2004' and '03/02/2004'... The last two should be '02/29/2004' but it is not the case... 🙁

So, how do I make the one month later in PHP return one month in calendar day??? Or am I missing something here??? 🙁

Thank you very much... 🙂

Sxooter

Why not just let the database do it?

cyanblue

Thank you for the reply... 🙂

Yeah... I could do that, but if I were to do that, I'd need to make another query to get the date from the MySQL...

As I was saying, it is for the registration page...
This is what I roughly do...

Flash sends out the new username and password to PHP script...
PHP makes a query call to see if the given username exists in the database...
If the given username does not exist in the database, I make another query to insert the new row into the database with this SQL command...

$sql = "INSERT INTO " . MEMBERSHIP_TABLE . "(`StartDateTime`, `EndDateTime`) VALUES ( CURDATE(), CURDATE() + INTERVAL 1 MONTH);";

Once I get to see okay sign from the MySQL by using mysql_affected_rows() function, I need to return the message back to Flash saying that your usename has been registred and it is valid until (today + 1 month)...

If I were to get the value of (today + 1 month), I'd need to make another query to get the value of 'EndDateTime' field, but I want to avoid that call if it is possible... and that's where I want the PHP take care of calculating the value of (today + 1 month)...

I'd appreciate any input on this since I am pretty much the new to PHP and MySQL... There might be some function that I am missing maybe???

Thank you very much... 🙂

Sxooter

You should be able to just do a simple:

select now()+interval '1 month'

without having to store and retrieve the data if that's what you're worried about. I do that kinda thing all the time in postgresql and it's quite fast to do it that way, and since you're not actually hitting the data under the database shouldn't really add to your database load enough to make a difference.

cyanblue

Oh... Thank you very much... I'll try that as well... I've done basically the same thing that you have told me, but I was worried that it might make server load higher since I am adding another call... (I am pretty much the novice in this PHP/MySQL stuff...)

Thank you and have a nice day... 🙂