title: How can I get outside foreach loop value in this situation?
body: <p>I am trying to call all the value from a foreach loop from mysql data, and use there value input into another mysql select statement. Look at my code below. It only can gather one value. I was thinking to use the first foreach loop include the whole section, however, since foreach value is individual, and I need explode array for the PDO prepare. So, at last, I want to know a way to get all value from the outside foreach loop. Appreciate.</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>//mysql connection code, remove because it is not relative to this question
  foreach ($tag_id as $term){
   $term=$term['term'].' ';//use space to seprate each one
     
   }
   echo $term:// only can can one, how can I get all result from above foreach.
   $term=explode(' ', $term);
   
   
   $stm =$db-&gt;prepare("SELECT user_id FROM sign WHERE term IN (:term_0,:term_1,:ts.id, s.term, s.counter, os.user_id, os.id, COUNT(oserm_2,:term_3,:term_4,:term_5,:term_6,:term_7,:term_8,:term_9,:term_10)");
  
  $term_0="$term[0]";
   $term_1="$term[1]";
   $term_2="$term[2]";
   $term_3="$term[3]";
   $term_4="$term[4]";
  //following code is not relevive to this question.</code></pre>
  </div>
  </div>
  </p>