[RESOLVED] multi dimensional array question.

bluto374

Here is a sample of the multi array. I am scratching my head on how to search for "Green-Green" and return value of [1]=>144. there is approximately 2,800 of these that needs to looped through and searched. The looping is not a problem, its just the proper way to search for these. I am sure it is very simple, I just can't see it.

I am just Green myself, 🙂

Array
(
    [0] => Array
        (
            [0] => 1
            [1] => 144
            [2] => Green-Green
            [3] => 
        )

[1] => Array
    (
        [0] => 2
        [1] => 386
        [2] => Pricks-Pricks
        [3] => 
    )

dagon

the 2nd user function on the manual page array_search(), should do this, however this sort of data is crying out for a database.

bradgrafelman

dagon is right - it sounds like you're ready to move this part of whatever it is you're doing into some type of DBMS (such as the popular MySQL DBMS). There are options such as SQLite for software/daemon-less DBMS solutions, too.

bluto374

I am formatting a file from a distributor so that it can be imported into a shopping cart using mysql. I have been away from programming for quite a while and things have changed since I was doing this regularly. What would recommend doing? The shopping cart is CRE-Loaded, and they are pansies when it comes to documentation. I am basically extracting the option names/ types and values and formatting them for Easy Populate "What a horrible name, if it was only easy to get the correct format".

bluto374

I have used the function below and the output is not quite what I was expecting. The output is, what am I doing wrong here??

 
Array
(
    [0] => Array
        (
            [2] => Green-Green
        )

)


multiArrayValueSearch($key4, 'Green-Green', $t);

print_r($t);

function multiArrayValueSearch($haystack, $needle, &$result, &$aryPath=NULL, $currentKey='') {
  if (is_array($haystack)) {
    $count = count($haystack);
    $iterator = 0;
    foreach($haystack as $location => $straw) {
      $iterator++;
      $next = ($iterator == $count)?false:true;
      if (is_array($straw)) $aryPath[$location] = $location;
        multiArrayValueSearch($straw,$needle,$result,$aryPath,$location);
        if (!$next) {
          unset($aryPath[$currentKey]);
        }
      }
    } else {
      $straw = $haystack;
      if ($straw == $needle) {
        if (!isset($aryPath)) {
          $strPath = "\$result[$currentKey] = \$needle;";
        } else {
          $strPath = "\$result['".join("']['",$aryPath)."'][$currentKey] = \$needle;";
        }
        eval($strPath);
      }
   }
}


Expected results is :
Array
(
    [0] => Array
        (
        [0] => 1
        [1] => 144    

        [2] => Green-Green
        )

)

dagon

the array is not really the issue, why don't you import the whole file in to a db.

bluto374

Easy populate will only allow the options, values, and attributes to be imported via tab delimited file. I guess I don't understand the logic here. I have already written 280 lines of code to get to this point. Maybe there was a better way, but I am not experienced enough to see it.
I have tried to import the formatted price file into mysql using phpmyadmin, and I keep getting invalid field count on line 1, no matter how the file looks.