Months have how many days between dates

[aozde]

i need that codes automatic calculate how many month and each month have how many days between dates.

$date1="10/24/2009";
$date2="12/10/2009";

for 10. month -> 31-24=7 days
for 11. month -> 30 days
for 12. month -> 31-10=21 days
finally

$month10=7
$month11=30
$month12=21

i need this because i try to create a rental system and in this system all price change for every month. thanks a lot for any help...

[Installer]

This code won't give you exactly what you asked for (data stored in variable variables), but will put the data into an array indexed by yyyymm.

function days_between_by_month($ts_1, $ts_2)
{
    $arr[date('Ym', $ts_1)] = date('t', $ts_1) - date('j', $ts_1);
    $temp_ts = strtotime(date('m', $ts_1) . '/15/' . date('Y', $ts_1));
    while (($temp_ts = strtotime('+1 month', $temp_ts)) < $ts_2) {
        $arr[date('Ym', $temp_ts)] = date('t', $temp_ts);
    }
    $arr[date('Ym', $ts_2)] = date('j', $ts_2);
    return $arr;
}

$date_1 = '10/24/2009'; 
$date_2 = '04/10/2010';
$month_arr = days_between_by_month(strtotime($date_1), strtotime($date_2));
print_r($month_arr);

Array
(
    [200910] => 7
    [200911] => 30
    [200912] => 31
    [201001] => 31
    [201002] => 28
    [201003] => 31
    [201004] => 10
)

By setting the interim day of month to the 15th it avoids such problems as adding one month to a late January date and getting a date in March. Also, using the year in the array keys avoids the problem of duplicate keys if the time between date1 and date2 is one year or more.

[aozde]

thank you so much for your help and i use for

$date_1 = '10/24/2009';
$date_2 = '12/10/2009';

and it works
Array ( [200910] => 7 [200911] => 30 [200912] => 10 )

[Installer]

Glad to have helped, but I posted the function to soon. After getting rid of some unnecessary code:

function days_between_by_month($ts_1, $ts_2) 
{ 
    $arr[date('Ym', $ts_1)] = date('t', $ts_1) - date('j', $ts_1); 
    while (($ts_1 = strtotime('+1 month', $ts_1)) < $ts_2) { 
        $arr[date('Ym', $ts_1)] = date('t', $ts_1); 
    } 
    $arr[date('Ym', $ts_2)] = date('j', $ts_2); 
    return $arr; 
}

[aozde]

i am waiting your news and thanks again 😉

[NogDog]

If you have the PEAR Date package installed (or can install it), you can do:

<?php
require_once 'date/calc.php';
$date1="10/24/2009";
$date2="12/10/2009";
list($m1, $d1, $y1) = explode('/', $date1);
list($m2, $d2, $y2) = explode('/', $date2);
$diff_days = abs(Date_Calc::dateDiff($d1, $m1, $y1, $d2, $m2, $y2));
echo $diff_days;

[Installer]

But besides not giving the desired results (number of days for each month between dates), your code raises, via the Date package, several strict standards errors. I know a lot of people don't care about the latter, but I think the former ought to be a concern.

[NogDog]

Installer;10904238 wrote:

But besides not giving the desired results (number of days for each month between dates),...

Oops #1: That's what I get for not reading the requirements carefully enough.

...your code raises, via the Date package, several strict standards errors. I know a lot of people don't care about the latter, but I think the former ought to be a concern.

Oops #2: That's what I get for working from a faulty memory. Just for completeness, the corrected version of the incorrect solution:

<?php
require_once 'date/calc.php';
$date1="10/24/2009";
$date2="12/10/2009";
list($m1, $d1, $y1) = explode('/', $date1);
list($m2, $d2, $y2) = explode('/', $date2);
$dateCalc = new Date_Calc();
$diff_days = abs($dateCalc->dateDiff($d1, $m1, $y1, $d2, $m2, $y2));
echo $diff_days;

[aozde]

thank you so much your help but i havent got date packets.

[aozde]

Installer;10904183 wrote:

function days_between_by_month($ts_1, $ts_2) 
{ 
    $arr[date('Ym', $ts_1)] = date('t', $ts_1) - date('j', $ts_1); 
    while (($ts_1 = strtotime('+1 month', $ts_1)) < $ts_2) { 
        $arr[date('Ym', $ts_1)] = date('t', $ts_1); 
    } 
    $arr[date('Ym', $ts_2)] = date('j', $ts_2); 
    return $arr; 
}

i am cruious about that. i looked posts about to convert array to string. but i need like that things
i have a list for month prices in my database.
so every month have value like this
$1=10
$2=11
$3=12
$4=10
$5=13
$6=15
$7=11
$8=10
$9=10
$10=14
$11=12
$12=13
that strings $1,$2,$3.... call month value from my database
now i need to to join them.

They are days from their month
Array
(
[200910] => 7
[200911] => 30
[200912] => 31
[201001] => 31
[201002] => 28
[201003] => 31
[201004] => 10
)

And They are monthly per a day prices
$1=10
$2=11
$3=12
$4=10
$5=13
$6=15
$7=11
$8=10
$9=10
$10=14
$11=12
$12=13

i would like to calculate total prices between dates and avarage price...

[Installer]

You should probably start a new thread for this.

What have you tried so far?