Foreach multidimensional array display values

Question

Within a BPM application, I'm trying to loop through an associative array of associative arrays and return only the values (APP_UIDs) using a foreach loop. However, I'm only able to display the very last generated value and not all the values.

Here is my code:

$currentUser = @@USER_LOGGED;
//Copy Notes to Subprocess
$caseId = @@APPLICATION; //Case UID
$subcases = executeQuery("SELECT APP_UID FROM SUB_APPLICATION WHERE APP_PARENT='$caseId'");
if (is_array($subcases) and count($subcases) > 0) { 
  foreach($subcases as $subcase)
  $subCaseId = $subcase["APP_UID"] . ", ";

//Update the Sent By status
executeQuery("UPDATE APP_CACHE_VIEW SET PREVIOUS_USR_UID = '$currentUser' WHERE APP_UID IN ('$subCaseId')");
}

The executeQuery function should generate a SQL statement of something like below but it is not. Example:

UPDATE APP_CACHE_VIEW SET PREVIOUS_USR_UID = '54454572356235' WHERE APP_UID IN      
('336545547', '436545534', '736545125')

Any ideas as to what I'm doing wrong?

The others have given you the correct answer. However I just want to say that in these cases of building IN statements, I prefer to create an array with the values to be used, then create the comma separated string using implode(',', $array) — eli
– eli, Commented Feb 25, 2013 at 4:48

Maulik Vora · Accepted Answer · 2013-02-25 04:42:40Z

3

try this.

    $currentUser = @@USER_LOGGED;
    //Copy Notes to Subprocess
    $caseId = @@APPLICATION; //Case UID
    $subcases = executeQuery("SELECT APP_UID FROM SUB_APPLICATION WHERE APP_PARENT='$caseId'");
    if (is_array($subcases) and count($subcases) > 0) { 
      $subCaseId = '';
      foreach($subcases as $subcase)
      $subCaseId .= $subcase["APP_UID"] . ", ";

    //Update the Sent By status
    executeQuery("UPDATE APP_CACHE_VIEW SET PREVIOUS_USR_UID = '$currentUser' WHERE APP_UID IN ('$subCaseId')");
    }

Also don't forget to 'reinitialize the string' by doing $subCaseId = ''; in your code.

answered Feb 25, 2013 at 4:42

Maulik Vora

2,5845 gold badges28 silver badges49 bronze badges

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

Comments

Minesh · Accepted Answer · 2013-02-25 04:49:54Z

I think you are missing concatenation here:

Initialize variable like below on top of loop:

$subCaseId = '';

and use concatenation operator .= as below:

$subCaseId .= $subcase["APP_UID"] . ", ";

Ideally, you should also remove last command and space from variable $subCaseId

also you need to remove single quote around this variable for IN query.

See complete solution as below:

$currentUser = @@USER_LOGGED;
//Copy Notes to Subprocess
$caseId = @@APPLICATION; //Case UID
$subcases = executeQuery("SELECT APP_UID FROM SUB_APPLICATION WHERE APP_PARENT='$caseId'");
if (is_array($subcases) and count($subcases) > 0) { 
    $subCaseId = '';
      foreach($subcases as $subcase)
          $subCaseId = $subcase["APP_UID"] . ", ";
    //To remove last comma and space
    $subCaseId = substr($subCaseId,0,-2);

//Update the Sent By status
executeQuery("UPDATE APP_CACHE_VIEW SET PREVIOUS_USR_UID = '$currentUser' WHERE APP_UID IN ($subCaseId)");
}

Prasanth Bendra · Accepted Answer · 2013-02-25 04:46:12Z

0

Change

 foreach($subcases as $subcase)
  $subCaseId = $subcase["APP_UID"] . ", ";

to :

  $subCaseId = '';
  foreach($subcases as $subcase)
  $subCaseId .= $subcase["APP_UID"] . ", ";

Note the concatenation .=

edited Feb 25, 2013 at 4:46

answered Feb 25, 2013 at 4:41

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

Collectives™ on Stack Overflow

Foreach multidimensional array display values

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related