Another Date Question

Dev Shed Forums Sponsor:

November 16th, 2012, 09:40 AM

DavidPr

Contributing User

Join Date: Mar 2007

Posts: 98

Time spent in forums: 1 Day 2 h 56 m 15 sec
Reputation Power: 8

Another Date Question

PHP 5 and MySQL 5

In query:

PHP Code:


		
			
 DATE_FORMAT(submitted, '%m/%d/%y') AS date

In page:

PHP Code:


		
			
 $date = stripslashes($row['date']);

$originaldate = $date; 

$ageindays = number_format(floor((date("U")-strtotime($originaldate))/86400),0);

$torenew = 180 - $ageindays;

echo "Renew in $torenew days.";

This worked fine prior to PHP 5 but now it doesn't. Not sure how I should adjust this to get it working. Any help appreciated.

November 16th, 2012, 09:51 AM

gw1500se

Contributing User

Join Date: Jul 2003

Posts: 2,907

Time spent in forums: 1 Year 1 Month 9 h 4 m 10 sec
Reputation Power: 581

"Not sure how to adjust this to get it working" either because I have no idea what " but now it doesn't" means.

__________________
There are 10 kinds of people in the world. Those that understand binary and those that don't.

November 16th, 2012, 10:00 AM

DavidPr

Contributing User

Join Date: Mar 2007

Posts: 98

Time spent in forums: 1 Day 2 h 56 m 15 sec
Reputation Power: 8

Sorry, I forgot to mention what I was trying to accomplish. It's a resume program. The date a person enters their resume is logged in the database under the "submitted" row.

When they login to their resume panel I want to let them to see how many days they have left before their resume will become inactive (6 months total active time from original submit date) and will have to be renewed. The script I posted above worked fine before my hosting company installed PHP 5 and MySQL 5, so I'm assuming that something in this:

Quote:

$ageindays = number_format(floor((date("U")-strtotime($originaldate))/86400),0);

is no longer valid, but I don't know what.

November 16th, 2012, 10:06 AM

gw1500se

Contributing User

Join Date: Jul 2003

Posts: 2,907

Time spent in forums: 1 Year 1 Month 9 h 4 m 10 sec
Reputation Power: 581

So what is the error message? I'm trying to help but you really need to understand that clairvoyance not my strong suit.

November 16th, 2012, 10:27 AM

ManiacDan

Sarcky

Dev Shed God 10th Plane (9500 - 9999 posts)

Join Date: Oct 2006

Location: Pennsylvania, USA

Posts: 9,917

Folding Points: 127430 Folding Title: Super Ultimate Folder - Level 1

Time spent in forums: 2 Months 3 Weeks 1 Day 10 h 25 m 30 sec
Reputation Power: 6113

You don't need stripslashes, and there's no reason to use date_format to format a date to a m/d/Y only to pass it to strtotime to format it to a unix timestamp, do math on it, then translate it back into a number of days. You could do all this math right in the query using NOW() and UNIX_TIMESTAMP()

__________________
HEY! YOU! Read the New User Guide and Forum Rules

"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

"The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

November 16th, 2012, 11:38 AM

DavidPr

Contributing User

Join Date: Mar 2007

Posts: 98

Time spent in forums: 1 Day 2 h 56 m 15 sec
Reputation Power: 8

I used

Quote:

DATEDIFF(NOW(),submitted) AS datediff

Then it was simply a matter of subtracting the datediff number from 180 (6 months).

Another Date Question

Developer Shed Advertisers and Affiliates