RE: [PHP] How many Mondays in a month?
-Original Message- From: Cristian Lavaque [mailto:[EMAIL PROTECTED] You could also put the input values in dropdown menus, at least day and month. That way you make sure the input to the funtion is correct everytime. The code is just a function it's not a page in itself. I use it in a form that display checkboxes for each Sunday in a month. Someone else may use it by providing the arguments via a form in the manner you suggest. The function, however, is just that, a function. Cheers, Greg. -- Greg Wiley http://wileysworld.org/ Mail was checked for spam by the Freeware Edition of No Spam Today! The Freeware Edition is free for personal and non-commercial use. You can remove this notice by purchasing a full license! To order or to find out more please visit: http://www.no-spam-today.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How many Mondays in a month?
* Thus wrote Phil Dowson ([EMAIL PROTECTED]): Hi, I have posted a similar question in php.db, but I was wondering if someone could help out with a non-db issue. I am trying to display statistics of visitors to my web site, and what I would like to do is show the average number of visitors that have visited the site in a given month for a certain day e.g..: Stats for www.mysite.com for 09/2003 Monday - 15 average - 65 total Tuesday - 16 average - 66 total Wednesday - 14 average - 65 total Thursday - 13 average - 63 total Friday - 15 average - 65 total Saturday - 5 average - 25 total Sunday - 6 average - 28 total Still sort of a db question: select dayofweek(datefield) as dayindex, count(*) total, from stats group by dayindex; Curt -- I used to think I was indecisive, but now I'm not so sure. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How many Mondays in a month?
Funny you should ask this because I've been meaning to share some code that
I wrote a few months ago that does exactly this for any day of the week.
Please feel free to use this and make changes. I'd appreciate any
changes/bug fixes being sent back to me though.
?php
/*
* num_days
*
* A function that takes a day, a month and a year and returns the number of
* occurrences of that day in the given month and year.
*
* Arguments:
* day - the day required
* month - which month are we talking about
* year - which year are we talking about
*
* Returns:
* occ - the number of times the day occurs in the month.
* or NULL if there are invalid parameters.
*/
function num_days ($day, $month, $year)
{
$day_array = array(Mon = Monday,
Tue = Tuesday,
Wed = Wednesday,
Thu = Thursday,
Fri = Friday,
Sat = Saturday,
Sun = Sunday);
$month_array = array(1 = Jan, Feb, Mar, Apr, May, Jun,
Jul, Aug, Sep, Oct, Nov, Dec);
/*
* Check our arguments are valid.
*/
/*
* $day must be either a full day string or the 3 letter
abbreviation.
*/
if (!(in_array($day, $day_array) ||
array_key_exists($day, $day_array))) {
echo num_days: invalid argument. \$day must be day name or
three letter abbreviation;
return;
}
/*
* $month must be either a full month name or its 3 letter
abrreviation
*/
if (($mth = array_search(substr($month,0,3), $month_array)) = 0) {
echo num_days: invalid argument. \$month must be month name
or three letter abbreviation;
return;
}
/*
* Now fetch the previous $day of $month+1 in $year;
* this will give us the last $day of $month.
*/
/*
* Calculate the timestamp of the 01/$mth+1/$year.
*/
$time = mktime(0,0,0,$mth+1,1,$year);
$str = strtotime(last $day, $time);
/*
* Return nth day of month.
*/
$date = date(j, $str);
/*
* If the difference between $date1 and $date2 is 28 then
* there are 5 occurences of $day in $month/$year, otherwise
* there are just 4.
*/
if ($date = 28) {
return 4;
} else {
return 5;
}
}
?
The other function I have does this:
/*
* nth_day
*
* A function that takes a number and a day and returns the date of
* nth occurrence of that day in the given month and year.
*
* Arguments:
* nth - the nth occurence required
* day - the day required
* month - which month are we talking about
* year - which year are we talking about
*
* Returns:
* date - the date on which the nth day occurs in month and year.
* or NULL for errors.
*/
Give me a shout if anyone wants this one.
Cheers, Greg.
-Original Message-
From: Phil Dowson [mailto:[EMAIL PROTECTED]
Sent: 29 September, 2003 16:22
To: [EMAIL PROTECTED]
Subject: [PHP] How many Mondays in a month?
Hi,
I have posted a similar question in php.db, but I was
wondering if someone could help out with a non-db issue. I am
trying to display statistics of visitors to my web site, and
what I would like to do is show the average number of
visitors that have visited the site in a given month for a
certain day e.g..:
Stats for www.mysite.com for 09/2003
Monday - 15 average - 65 total
Tuesday - 16 average - 66 total
Wednesday - 14 average - 65 total
Thursday - 13 average - 63 total
Friday - 15 average - 65 total
Saturday - 5 average - 25 total
Sunday - 6 average - 28 total
I have tried a number of ways to do this, but I cannot work
out a way to show the number for example Mondays that will be
in a given month, which I need to work out the average. I can
work out the total easy enough, just not the average.
TIA
Phil Dowson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How many Mondays in a month?
Greg,
That worked brilliantly... I bow down to your sheer excellence!!! Thankyou
Thankyou Thankyou
Greg Wiley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Funny you should ask this because I've been meaning to share some code that
I wrote a few months ago that does exactly this for any day of the week.
Please feel free to use this and make changes. I'd appreciate any
changes/bug fixes being sent back to me though.
?php
/*
* num_days
*
* A function that takes a day, a month and a year and returns the number of
* occurrences of that day in the given month and year.
*
* Arguments:
* day - the day required
* month - which month are we talking about
* year - which year are we talking about
*
* Returns:
* occ - the number of times the day occurs in the month.
* or NULL if there are invalid parameters.
*/
function num_days ($day, $month, $year)
{
$day_array = array(Mon = Monday,
Tue = Tuesday,
Wed = Wednesday,
Thu = Thursday,
Fri = Friday,
Sat = Saturday,
Sun = Sunday);
$month_array = array(1 = Jan, Feb, Mar, Apr, May, Jun,
Jul, Aug, Sep, Oct, Nov, Dec);
/*
* Check our arguments are valid.
*/
/*
* $day must be either a full day string or the 3 letter
abbreviation.
*/
if (!(in_array($day, $day_array) ||
array_key_exists($day, $day_array))) {
echo num_days: invalid argument. \$day must be day name or
three letter abbreviation;
return;
}
/*
* $month must be either a full month name or its 3 letter
abrreviation
*/
if (($mth = array_search(substr($month,0,3), $month_array)) = 0) {
echo num_days: invalid argument. \$month must be month name
or three letter abbreviation;
return;
}
/*
* Now fetch the previous $day of $month+1 in $year;
* this will give us the last $day of $month.
*/
/*
* Calculate the timestamp of the 01/$mth+1/$year.
*/
$time = mktime(0,0,0,$mth+1,1,$year);
$str = strtotime(last $day, $time);
/*
* Return nth day of month.
*/
$date = date(j, $str);
/*
* If the difference between $date1 and $date2 is 28 then
* there are 5 occurences of $day in $month/$year, otherwise
* there are just 4.
*/
if ($date = 28) {
return 4;
} else {
return 5;
}
}
?
The other function I have does this:
/*
* nth_day
*
* A function that takes a number and a day and returns the date of
* nth occurrence of that day in the given month and year.
*
* Arguments:
* nth - the nth occurence required
* day - the day required
* month - which month are we talking about
* year - which year are we talking about
*
* Returns:
* date - the date on which the nth day occurs in month and year.
* or NULL for errors.
*/
Give me a shout if anyone wants this one.
Cheers, Greg.
-Original Message-
From: Phil Dowson [mailto:[EMAIL PROTECTED]
Sent: 29 September, 2003 16:22
To: [EMAIL PROTECTED]
Subject: [PHP] How many Mondays in a month?
Hi,
I have posted a similar question in php.db, but I was
wondering if someone could help out with a non-db issue. I am
trying to display statistics of visitors to my web site, and
what I would like to do is show the average number of
visitors that have visited the site in a given month for a
certain day e.g..:
Stats for www.mysite.com for 09/2003
Monday - 15 average - 65 total
Tuesday - 16 average - 66 total
Wednesday - 14 average - 65 total
Thursday - 13 average - 63 total
Friday - 15 average - 65 total
Saturday - 5 average - 25 total
Sunday - 6 average - 28 total
I have tried a number of ways to do this, but I cannot work
out a way to show the number for example Mondays that will be
in a given month, which I need to work out the average. I can
work out the total easy enough, just not the average.
TIA
Phil Dowson
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How many Mondays in a month?
No problem, just glad it's found some wider use.
Cheers, Greg.
-Original Message-
From: Phil Dowson [mailto:[EMAIL PROTECTED]
Sent: 29 September 2003 17:55
To: [EMAIL PROTECTED]
Subject: Re: [PHP] How many Mondays in a month?
Greg,
That worked brilliantly... I bow down to your sheer
excellence!!! Thankyou Thankyou Thankyou
Greg Wiley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
er.demon.net...
Funny you should ask this because I've been meaning to share
some code that I wrote a few months ago that does exactly
this for any day of the week.
Please feel free to use this and make changes. I'd appreciate
any changes/bug fixes being sent back to me though.
?php
/*
* num_days
*
* A function that takes a day, a month and a year and
returns the number of
* occurrences of that day in the given month and year.
*
* Arguments:
* day - the day required
* month - which month are we talking about
* year - which year are we talking about
*
* Returns:
* occ - the number of times the day occurs in the month.
* or NULL if there are invalid parameters.
*/
function num_days ($day, $month, $year)
{
$day_array = array(Mon = Monday,
Tue = Tuesday,
Wed = Wednesday,
Thu = Thursday,
Fri = Friday,
Sat = Saturday,
Sun = Sunday);
$month_array = array(1 = Jan, Feb, Mar, Apr, May,
Jun,
Jul, Aug, Sep, Oct, Nov, Dec);
/*
* Check our arguments are valid.
*/
/*
* $day must be either a full day string or the 3 letter
abbreviation.
*/
if (!(in_array($day, $day_array) ||
array_key_exists($day, $day_array))) { echo num_days:
invalid argument. \$day must be day name or three letter
abbreviation; return; }
/*
* $month must be either a full month name or its 3 letter
abrreviation */ if (($mth = array_search(substr($month,0,3),
$month_array)) = 0) { echo num_days: invalid argument.
\$month must be month name or three letter abbreviation;
return; }
/*
* Now fetch the previous $day of $month+1 in $year;
* this will give us the last $day of $month.
*/
/*
* Calculate the timestamp of the 01/$mth+1/$year.
*/
$time = mktime(0,0,0,$mth+1,1,$year);
$str = strtotime(last $day, $time);
/*
* Return nth day of month.
*/
$date = date(j, $str);
/*
* If the difference between $date1 and $date2 is 28 then
* there are 5 occurences of $day in $month/$year, otherwise
* there are just 4.
*/
if ($date = 28) {
return 4;
} else {
return 5;
}
}
?
The other function I have does this:
/*
* nth_day
*
* A function that takes a number and a day and returns the date
of
* nth occurrence of that day in the given month and year.
*
* Arguments:
* nth - the nth occurence required
* day - the day required
* month - which month are we talking about
* year - which year are we talking about
*
* Returns:
* date - the date on which the nth day occurs in month and
year.
* or NULL for errors.
*/
Give me a shout if anyone wants this one.
Cheers, Greg.
-Original Message-
From: Phil Dowson [mailto:[EMAIL PROTECTED]
Sent: 29 September, 2003 16:22
To: [EMAIL PROTECTED]
Subject: [PHP] How many Mondays in a month?
Hi,
I have posted a similar question in php.db, but I was
wondering if
someone could help out with a non-db issue. I am trying to
display
statistics of visitors to my web site, and what I would
like to do is
show the average number of visitors that have visited the site
in a
given month for a certain day e.g..:
Stats for www.mysite.com for 09/2003
Monday - 15 average - 65 total
Tuesday - 16 average - 66 total
Wednesday - 14 average - 65 total
Thursday - 13 average - 63 total
Friday - 15 average - 65 total
Saturday - 5 average - 25 total
Sunday - 6 average - 28 total
I have tried a number of ways to do this, but I cannot work
out a way
to show the number for example Mondays that will be in a
given month,
which I need to work out the average. I can work out the total
easy
enough, just not the average.
TIA
Phil Dowson
--
PHP General Mailing List (http://www.php.net/) To
unsubscribe, visit:
http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/) To
unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How many Mondays in a month?
Greg Wiley wrote:
Funny you should ask this because I've been meaning to share some code that
I wrote a few months ago that does exactly this for any day of the week.
Please feel free to use this and make changes. I'd appreciate any
changes/bug fixes being sent back to me though.
[ snip ]
function num_days ($day, $month, $year)
{
[ snip ]
One tip that I would add is that instead of using individual arguments,
you might want to consider using an array as an argument. This prevents
people from inserting the arguments in the wrong order, which would not
yield the correct results.
Function call would be :
$my_date = array();
$my_date['day'] = Mon;
$my_date['month'] = Jan;
$my_date['year'] = 2003;
num_days($my_date);
Of course the indexes could be in any order, as long as they have day,
month, year as keys.
Just a thought, good work though :)
--
Burhan Khalid
phplist[at]meidomus[dot]com
http://www.meidomus.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] How many Mondays in a month?
-Original Message-
From: Burhan Khalid [mailto:[EMAIL PROTECTED]
Greg Wiley wrote:
Funny you should ask this because I've been meaning to
share some code
that I wrote a few months ago that does exactly this for
any day of the week.
Please feel free to use this and make changes. I'd appreciate
any
changes/bug fixes being sent back to me though.
[ snip ]
function num_days ($day, $month, $year) {
[ snip ]
One tip that I would add is that instead of using individual
arguments, you might want to consider using an array as an
argument. This prevents people from inserting the arguments
in the wrong order, which would not yield the correct results.
Thanks, that's a good idea; though I would have to change my form
code to match:-(
When I make this change, where would be a good place to submit it?
Cheers, Greg.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] How many Mondays in a month?
Burhan Khalid wrote:
Greg Wiley wrote:
Funny you should ask this because I've been meaning to share
some
code that I wrote a few months ago that does exactly this for
any
day of the week.
Please feel free to use this and make changes. I'd appreciate
any
changes/bug fixes being sent back to me though.
[ snip ]
function num_days ($day, $month, $year)
{
[ snip ]
One tip that I would add is that instead of using individual
arguments, you might want to consider using an array as an
argument.
This prevents people from inserting the arguments in the wrong
order,
which would not yield the correct results.
Function call would be :
$my_date = array();
$my_date['day'] = Mon;
$my_date['month'] = Jan;
$my_date['year'] = 2003;
num_days($my_date);
Of course the indexes could be in any order, as long as they
have day,
month, year as keys.
Just a thought, good work though :)
--
Burhan Khalid
phplist[at]meidomus[dot]com
http://www.meidomus.com
You could also put the input values in dropdown menus, at least
day and month. That way you make sure the input to the funtion is
correct everytime.
Cristian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
