I get array to string conversion error for the following line:
$diff = array_diff($stockist, $arr);
Here, $arr
is an array decoded from a JSON file. Using the is_array()
function I was able to verify that both parameters are arrays. Can someone point me the problem
$stockist = array();
while (!feof($file_handle)) {
$line_of_text = fgetcsv($file_handle);
$query = "SELECT * FROM reorderchart WHERE medicine = '"
. trim($line_of_text[3])
. "' ORDER BY medicine";
$result = mysql_query($query);
if (trim($line_of_text[2]) - trim($line_of_text[1]) <= 0) {
while ($row = mysql_fetch_array($result)) {
$file = "results.json";
$arr = json_decode(file_get_contents($file),true);
$pharmacy = trim($row['Medicine']);
if (isset($stockist[$pharmacy])) {
$medicine = $stockist[$pharmacy];
$medicine[] = trim($row['Stockist']);
$stockist[$pharmacy] = $medicine;
} else {
$medicine = array();
$medicine[] = trim($row['Stockist']);
$stockist[$pharmacy] = $medicine;
}
}
}
}
$diff = array();
$diff = array_diff_assoc($stockist,$arr);
ksort($diff);
foreach ($diff as $key => $value) {
echo "<table align='center' border='1'>";
echo "<tr><td align = 'center'> <font color = 'blue'> $key</td></tr>";
foreach($value as $key1 => $value1) {
echo "<tr><td align ='center'>$value1</td></tr><br>";
}
echo "</table>";
}
According to it:
One of your arrays is multidimensional.
array_diff
only checks one dimension of a n-dimensional array. Of course you can check deeper dimensions by usingarray_diff($array1[0], $array2[0]);
Yes, the strict answer is because "One of your arrays is multidimensional."
Another useful note might be - depending on your needs of further parsing the actual differences - consider first testing your arrays with:
or
or
All these options will compare the entire array tree, not just the top level.
You can see in the array_diff() documentation that:
So it looks like you can't use this function with multi dimensional array, or in fact any value that cannot be converted to a string. This is because the function will cast values to a
string
to do the comparison.You can write your own function to recursively check arrays for a difference - in fact the following is from the comments of the docs linked above.
You can see the comment here.
Since
array_diff
can only deals with one dimension, you can either:convert your multi-dimentional array into one dimension, e.g. by:
flattening a multidimensional array, e.g.:
serializing the array, e.g.:
use custom recursive
array_diff
-like function,I've got the same error and found the following bug report for php:
https://bugs.php.net/bug.php?id=60198
That report describes, why php throws an error on comparing a multi-dimensional array.
What about my solution: