Comparing Array Dates in PHP

Question

I have two lists of Dates in MySQL tables with the following outputs:

$BetDate - array(25) { [0]=> int(1355468400) [1]=> int(1355468400) [2]=> int(1355468400) [3]=> int(1355468400) [4]=> int(1355468400) [5]=> int(1355468400) [6]=> int(1355295600) [7]=> int(1355295600) [8]=> int(1355295600) [9]=> int(1355295600) [10]=> int(1355468400) [11]=> int(1355468400) [12]=> int(1355209200) [13]=> int(1355209200) [14]=> int(1355209200) [15]=> int(1355295600) [16]=> int(1355209200) [17]=> int(1355209200) [18]=> int(1355468400) [19]=> int(1355468400) [20]=> int(1355554800) [21]=> int(1355554800) [22]=> int(1355554800) [23]=> int(1355554800) [24]=> int(1355554800) } 
array(25) { [0]=> string(10) "2012-12-14" [1]=> string(10) "2012-12-14" [2]=> string(10) "2012-12-14" [3]=> string(10) "2012-12-14" [4]=> string(10) "2012-12-14" [5]=> string(10) "2012-12-14" [6]=> string(10) "2012-12-12" [7]=> string(10) "2012-12-12" [8]=> string(10) "2012-12-12" [9]=> string(10) "2012-12-12" [10]=> string(10) "2012-12-14" [11]=> string(10) "2012-12-14" [12]=> string(10) "2012-12-11" [13]=> string(10) "2012-12-11" [14]=> string(10) "2012-12-11" [15]=> string(10) "2012-12-12" [16]=> string(10) "2012-12-11" [17]=> string(10) "2012-12-11" [18]=> string(10) "2012-12-14" [19]=> string(10) "2012-12-14" [20]=> string(10) "2012-12-15" [21]=> string(10) "2012-12-15" [22]=> string(10) "2012-12-15" [23]=> string(10) "2012-12-15" [24]=> string(10) "2012-12-15" }    

$BetGameDate - array(4) { [0]=> int(1355554800) [1]=> int(1355468400) [2]=> int(1355900400) [3]=> int(1355554800) }
array(4) { [0]=> string(10) "2012-12-15" [1]=> string(10) "2012-12-14" [2]=> string(10) "2012-12-19" [3]=> string(10) "2012-12-15" }

Here is some of my PHP code:

foreach($checkit as $row1) {
    $BetDate[] = strtotime($row1['BetDate']);
    }
    foreach($result as $row) {
    $BetGameDate[] = strtotime($row['GameDate']);
    }
    for($i=0; $i<=$count; $i++) { 
if($BetDate==$BetGameDate[$i]) {
    echo "Hello2";
    }
}

However, I would like to compare the dates in the following manner: I want to loop through $BetGameDate, seeing if ANY dates in $BetDate match the ith selection of $BetGameDate. The code that I have does not echo the result, and what's really confusing me is when I change $BetDate to $BetDate[$i] in the if statement, it echo's Hello2 twice, when only one selection should be equal (the 2nd value, 1st position in the arrays). Does anyone have suggestions on how to compare $BetGameDate[$i] with all dates in $BetDate[]?

Any help is greatly appreciated!

iBiryukov · Accepted Answer · 2012-12-17 22:06:07Z

1

Try this function: array_intersect

answered Dec 17, 2012 at 22:06

iBiryukov

1,7404 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stegrex · Accepted Answer · 2012-12-17 22:11:35Z

0

Not sure why you are iterating through the list of results in GameDate inside the for loop of BetDate.

I'm thinking you might want to do:

foreach($checkit as $row1) {
    $BetDate[] = strtotime($row1['BetDate']);
}
foreach($result as $row) {
    $BetGameDate[] = strtotime($row['GameDate']);
}
$matchArray = array_intersect($BetDate, $BetGameDate);

answered Dec 17, 2012 at 22:11

Stegrex

4,0441 gold badge19 silver badges19 bronze badges

Comments

Theolodis · Accepted Answer · 2012-12-17 22:13:25Z

0

for($BetGameDate as $b) { 
    for($BetDate as $bet){
        if($b == $bet) {
            echo "Hello2";
        }
    }
}

this should compare each of BetDate with each of BetGameDate. But I guess the array_intersect is easier to implement.

EDIT: just saw that BetDate isnt as long as BetGameDate

answered Dec 17, 2012 at 22:13

Theolodis

5,1623 gold badges38 silver badges58 bronze badges

Comments

Dillen Meijboom · Accepted Answer · 2012-12-17 22:43:10Z

0

It's quite simple:

<?php
$array1 = array('1', '2', '3');
$array2 = array('0', '2', '0');
$length = count($array1);

for ($i = 0; $i < $length; $i++) {
    $key = array_search($array1[$i], $array2);

    if ($key != null && $key > 0) {
        echo 'HELLO 2';
    }
}
?>

Just change your $BetDate to $BetDate[$i].

edited Dec 17, 2012 at 22:43

answered Dec 17, 2012 at 22:08

Dillen Meijboom

9647 silver badges13 bronze badges

1 Comment

Theolodis Over a year ago

Nope... you got to do a double for loop. This one just compares each index with eachother, but if the indices are not in the same order this fails.

Collectives™ on Stack Overflow

Comparing Array Dates in PHP

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related