php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #27317 array_unique weirdness
Submitted: 2004-02-19 02:28 UTC Modified: 2004-02-24 17:13 UTC
Votes:3
Avg. Score:3.7 ± 0.9
Reproduced:3 of 3 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: Jan at Bytesmiths dot com Assigned:
Status: No Feedback Package: Arrays related
PHP Version: 4.3.4 OS: MacOS X 10.3
Private report: No CVE-ID:
Have you experienced this issue?
Rate the importance of this bug to you:

 [2004-02-19 02:28 UTC] Jan at Bytesmiths dot com
Description:
------------
array_unique seems to be losing a value somehow when two 
arrays are merged that contain the same value. I am 
merging two arrays, then feeding the result to 
array_unique. (What I REALLY want is a set!) print_r 
seems to show a proper result. However, waling through 
the array results in an empty value. In this 
case, 'IsNew' is missing. I changed the order of the 
merge, and a DIFFERENT value was missing!

If merging the two arrays results in a set (no 
duplicates), then array_unique seems to work fine.

Reproduce code:
---------------
// $InfoThumb AND $PopupThumb determine what fields to fetch. Build the proper query string.
$fieldNames = array_unique(array_merge($PopupThumb, $InfoThumb));
print_r($PopupThumb);
print_r($InfoThumb);
print_r($fieldNames);
for($i=0; $i<count($fieldNames); $i++)
	$fields .= ', ' . $fieldNames[$i];

$inc = $NumberOfColumns * $NumberOfRows;
$sql = "SELECT ID, ImageThumb, ToShow $fields FROM Gallery" . $sql_filter . $sql_sort;
if($total >= $inc) $sql .= " LIMIT $start, $inc";

die($sql);

Expected result:
----------------
SELECT ID, ImageThumb, ToShow , 
Title, Price, IsNew, Medium, Width, Height, Depth FROM 
Gallery WHERE ToShow=1 ORDER BY Updated DESC LIMIT 0, 10

Actual result:
--------------
Array (  [0] => Title  [1] => Price ) Array (  [0] => 
Title  [1] => Medium  [2] => Width  [3] => Height  [4] 
=> Depth  [5] => IsNew ) Array (  [0] => Title  [1] => 
Price  [3] => Medium  [4] => Width  [5] => Height  [6] 
=> Depth  [7] => IsNew ) SELECT ID, ImageThumb, ToShow , 
Title, Price, , Medium, Width, Height, Depth FROM 
Gallery WHERE ToShow=1 ORDER BY Updated DESC LIMIT 0, 10

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-02-19 02:45 UTC] helly@php.net
Please provide a short reproducing script that does not require any database or precondiftions like the page generating your queries or provide your query string and the way it is parsed to the variables - but only if that is really neccessary.
 [2004-02-24 17:13 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 [2004-12-17 15:01 UTC] arve at coretrek dot no

 
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Tue Aug 29 15:01:52 2017 UTC