Compare two 2-dimension arrays in PHP with array_diff error

Question

The question could have been different, like : Compare two tables in mySQL on a specific metric. My tables have a dimension (date) and a metric (number) and I want to check if I am getting the same number for the same date.

As a solution I started creating a PHP script where the table contents will be put into arrays. Then I am comparing this arrays to trace the differences.

If the number is not the same in the two tables for the same date , I will print the "date, number from table 1 - number from table 2".

Here is my code but it seems that I am having a problem with array_diff :

// Connect to the database (mySQL)
$Db = mysqli_init();
$Db->options(MYSQLI_OPT_LOCAL_INFILE, true);
$Db->real_connect($servername, $username, $password, $dbname, 3306);

// Creation of 1st Array
$result_one  = array();

// Creation of 1st SQL query
$sql = "select date, sum(number) from Table1 group by date";

// Run the 1st query
$query = $Db->query($sql);

// Save the results of the 1st query in the 1st array called result_one
$i = 0;
while ($row = $query->fetch_assoc()) 
{
    echo "aaa";
    $result_one[$i] = $row;
    $i++;
}

// Print the results (array)
print_r ($result_one);

#####################################################

// Creation of 2nd Array
$result_two  = array();

// Creation of 1st SQL query
$sql = "select date, sum(number) from Table2 group by date";

// Run the 1st query
$query = $Db->query($sql);

// Save the results of the 1st query in the 1st array called result_two
$i = 0;
while ($row = $query->fetch_assoc()) 
{
    echo "aaa";
    $result_two[$i] = $row;
    $i++;
}

// Print the result_two (array)
print_r ($result_two);

#####################################################

// Use of array_diff
$diff = array_diff($result_one,$result_two);

// Print the differences
print_r($diff);

I am getting an error like :

PHP Stack trace:... Array to string conversion

The tables have two dimensions

On what line are you getting that error? – Anko - inactive in protest Dec 10 '15 at 15:45 — Anko - inactive in protest, Dec 10 '15 at 15:45

score 2 · Accepted Answer · answered Dec 10 '15 at 15:11

2

You can do this with a single SQL query:

$sql = "SELECT t1.date, t1.number as `t1num`, 
        t2.number as `t2num` 
        FROM `table1` t1, `table2` t2 
        WHERE t1.date = t2.date AND t1.number != t2.number"
$query = $Db->query($sql);


while ($row = $query->fetch_assoc()) 
{
    echo sprintf("mismatch: date: %s, table1: %s, table2: %s", $row['date'], $row['t1num'], $row['t2num']);
}

answered Dec 10 '15 at 15:11

Steve

20,703
5
41
67

It works. I just want to change it and print only the rows that do not match. With this one I am getting them all. – Datacrawler Dec 10 '15 at 15:43
The SQL specifically queries for results that dont match: `AND t1.number != t2.number` - so im not sure what problem you are having – Steve Dec 10 '15 at 15:49
It works fine. I just tried to run this for the sum(num). – Datacrawler Dec 10 '15 at 15:52

score 0 · Answer 2 · edited May 23 '17 at 12:15

0

the function array_diff check only 1 dimensional array, and this from php manual

This function only checks one dimension of a n-dimensional array. Of course you can check deeper dimensions by using array_diff($array1[0], $array2[0]);.

through this link

you can iterate the arrays and compare each 1 dimensional array.

this may help you

edited May 23 '17 at 12:15

Community

1
1

answered Dec 10 '15 at 14:58

Gouda Elalfy

6,888
1
26
38

@Gould Elalfy array_diff_assoc gives me the same error – Datacrawler Dec 10 '15 at 15:04
sorry even array_diff_assoc not work. I update the answer – Gouda Elalfy Dec 10 '15 at 15:09

score 0 · Answer 3 · answered Dec 10 '15 at 15:04

0

array_diff function is okey, I think problem it is in $result_one and $result_two. Print them to see what there are in them.

answered Dec 10 '15 at 15:04

kostova

61
4

They are two-dimension tables. I forgot to mention – Datacrawler Dec 10 '15 at 15:13

Compare two 2-dimension arrays in PHP with array_diff error

3 Answers3