Re: [PHP] [php] static html search engine for php static html site
Ashley Sheridan a...@ashleysheridan.co.uk wrote: Please don't top post. Wonder if said poster understands what that means -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Question about date calculations
Hello List,
I am using PHP version 5.2.6.
I have a page I am trying to create where I am comparing the values of two
MySQL date fields with the current date. One of the MySQL Date fields is a
class start date, the other is the class end date.
First I need to calculate the number of days between class start and end
date. Then based on the number of days between these to dates I have to find
out how close the current date is to the class end date.
So far in looking at the functions that are available at
http://www.php.net/manual/en/ref.datetime.php I have not been able to figure
out how to do what I need to do. Below is a snippet showing approximately
what I am trying to do.
?PHP
...
$dteStartDate[$intCnt]= New DateTime($row[10]);
$dteEndDate[$intCnt]= New DateTime($row[11]);
...
$dteCheckDate=date('Y-m-d');
$intDayCnt=$dteEndDate[$i]-$dteStartDate[$i];
if (($dteCheckDate=($dteEndDate[$i]-7)
$dteCheckDate=($dteEndDate[$i]+1)) $intDayCnt16)
...
?
My start date is 12/26/2011, the end date 1/8/2012 so the value for
intDayCnt should be 13, but it is coming up as 0.
Also the check date which is 12/29/2011 is being calculated as after my end
date. Can someone point me in the direction of what I need to do to have
the comparisons I am doing work.
Eric Lommatsch.
Re: [PHP] Question about date calculations
29 dec 2011 kl. 22.22 skrev Eric Lommatsch: So far in looking at the functions that are available at http://www.php.net/manual/en/ref.datetime.php I have not been able to figure out how to do what I need to do. Below is a snippet showing approximately what I am trying to do. On the same page you are referring, there are plenty of examples on how to calculate the difference between two dates. Choose one and see if it fits your bill. Or is there any particular reason why you're writing your own function? http://www.php.net/manual/en/ref.datetime.php#78981 /frank -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Question about date calculations
On Thu, Dec 29, 2011 at 11:40 PM, Frank Arensmeier farensme...@gmail.comwrote: 29 dec 2011 kl. 22.22 skrev Eric Lommatsch: So far in looking at the functions that are available at http://www.php.net/manual/en/ref.datetime.php I have not been able to figure out how to do what I need to do. Below is a snippet showing approximately what I am trying to do. On the same page you are referring, there are plenty of examples on how to calculate the difference between two dates. Choose one and see if it fits your bill. Or is there any particular reason why you're writing your own function? http://www.php.net/manual/en/ref.datetime.php#78981 /frank -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php since you have everything in database tables why not to do this calculation on database side which would be much appropriate place ? /* columns date_start = '2011-02-08'; date_end = ' 2011-03-04'; */ select DATEDIFF(date_end, date_start); http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_datediff
RE: [PHP] Question about date calculations
-Original Message-
From: Fatih P. [mailto:fatihpirist...@gmail.com]
Sent: Thursday, December 29, 2011 5:10 PM
To: Frank Arensmeier
Cc: Eric Lommatsch; php-general@lists.php.net
Subject: Re: [PHP] Question about date calculations
On Thu, Dec 29, 2011 at 11:40 PM, Frank Arensmeier
farensme...@gmail.comwrote:
29 dec 2011 kl. 22.22 skrev Eric Lommatsch:
So far in looking at the functions that are available at
http://www.php.net/manual/en/ref.datetime.php I have not been able
to
figure
out how to do what I need to do. Below is a snippet showing
approximately
what I am trying to do.
On the same page you are referring, there are plenty of examples on
how to
calculate the difference between two dates. Choose one and see if it
fits
your bill. Or is there any particular reason why you're writing your
own
function?
http://www.php.net/manual/en/ref.datetime.php#78981
/frank
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
since you have everything in database tables why not to do this
calculation
on database side which would be much appropriate place ?
/* columns
date_start = '2011-02-08';
date_end = ' 2011-03-04';
*/
select DATEDIFF(date_end, date_start);
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-
functions.html#function_datediff
I looked at this answer and see the date is from an array of a database and not
2 fields with in the table.
While the DATEDIFF() is very useful in queries this will not help you unless
both fields are in the table.
Try this example
$dteStartDate[$intCnt] = new DateTime($row[10]);
$dteEndDate[$intCnt] =new DateTime($row[11]);
$interval = $dteStartDate[$intCnt]-diff($dteEndDate[$intCnt]);
echo $interval-format('%R%a days');
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Question about date calculations
On 12/30/2011 12:19 AM, ad...@buskirkgraphics.com wrote:
-Original Message-
From: Fatih P. [mailto:fatihpirist...@gmail.com]
Sent: Thursday, December 29, 2011 5:10 PM
To: Frank Arensmeier
Cc: Eric Lommatsch; php-general@lists.php.net
Subject: Re: [PHP] Question about date calculations
On Thu, Dec 29, 2011 at 11:40 PM, Frank Arensmeier
farensme...@gmail.comwrote:
29 dec 2011 kl. 22.22 skrev Eric Lommatsch:
So far in looking at the functions that are available at
http://www.php.net/manual/en/ref.datetime.php I have not been able
to
figure
out how to do what I need to do. Below is a snippet showing
approximately
what I am trying to do.
On the same page you are referring, there are plenty of examples on
how to
calculate the difference between two dates. Choose one and see if it
fits
your bill. Or is there any particular reason why you're writing your
own
function?
http://www.php.net/manual/en/ref.datetime.php#78981
/frank
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
since you have everything in database tables why not to do this
calculation
on database side which would be much appropriate place ?
/* columns
date_start = '2011-02-08';
date_end = ' 2011-03-04';
*/
select DATEDIFF(date_end, date_start);
http://dev.mysql.com/doc/refman/5.5/en/date-and-time-
functions.html#function_datediff
I looked at this answer and see the date is from an array of a database and not
2 fields with in the table.
While the DATEDIFF() is very useful in queries this will not help you unless
both fields are in the table.
Try this example
$dteStartDate[$intCnt] = new DateTime($row[10]);
$dteEndDate[$intCnt] =new DateTime($row[11]);
$interval = $dteStartDate[$intCnt]-diff($dteEndDate[$intCnt]);
echo $interval-format('%R%a days');
well then look deeper in the question:
I have a page I am trying to create where I am comparing the values of two
MySQL date fields with the current date. One of the *MySQL Date fields
*is a class start date,*the other* is the class end date.
all needs to do is modify his query.
Re: [PHP] Question about date calculations
Fatih P. wrote: well then look deeper in the question: I have a page I am trying to create where I am comparing the values of two MySQL date fields with the current date. One of the *MySQL Date fields *is a class start date,*the other* is the class end date. all needs to do is modify his query. And by moving the lookup into the query then Eric only needs to return the rows of the table that are in range ... -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk// Firebird - http://www.firebirdsql.org/index.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
