Databases
StackOverflow2013
Postsdbo
POPHP variables inside foreach loop
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPHP variables inside foreach loop
    primarykey
    data
    text
    <p>I am querying an API and getting XML results back. I am trying to take those results and stick them into a table that i have based on their status. Each column is a different status so they need to go in their respective columns. The problem i am running in to is when i have multiple items that are being returned with the same status. I believe this is breaking the loop. i am getting some items that are not appearing at all and some that are being duplicated. Any thoughts how i can acheive what i am looking for? Thanks!!</p> <p>UPDATE with example xml:</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;Assets total="6"&gt; &lt;Asset&gt; &lt;Attribute name="ID"&gt;B-1001&lt;/Attribute&gt; &lt;Attribute name="Title"&gt;Some Bug #1&lt;/Attribute&gt; &lt;Attribute name="Status"&gt;In Progress&lt;/Attribute&gt; &lt;/Asset&gt; &lt;Asset&gt; &lt;Attribute name="ID"&gt;B-1002&lt;/Attribute&gt; &lt;Attribute name="Title"&gt;Some Bug #2&lt;/Attribute&gt; &lt;Attribute name="Status"&gt;Code Review&lt;/Attribute&gt; &lt;/Asset&gt; &lt;Asset&gt; &lt;Attribute name="ID"&gt;B-1003&lt;/Attribute&gt; &lt;Attribute name="Title"&gt;Some Bug #3&lt;/Attribute&gt; &lt;Attribute name="Status"&gt;Code Review&lt;/Attribute&gt; &lt;/Asset&gt; &lt;Asset&gt; &lt;Attribute name="ID"&gt;B-1004&lt;/Attribute&gt; &lt;Attribute name="Title"&gt;Some Bug #4&lt;/Attribute&gt; &lt;Attribute name="Status"&gt;Ready for Development&lt;/Attribute&gt; &lt;/Asset&gt; &lt;Asset&gt; &lt;Attribute name="ID"&gt;B-1005&lt;/Attribute&gt; &lt;Attribute name="Title"&gt;Some Bug #5&lt;/Attribute&gt; &lt;Attribute name="Status"&gt;In Progress&lt;/Attribute&gt; &lt;/Asset&gt; &lt;Asset&gt; &lt;Attribute name="ID"&gt;B-1006&lt;/Attribute&gt; &lt;Attribute name="Title"&gt;Some Bug #6&lt;/Attribute&gt; &lt;Attribute name="Status"&gt;In Progress&lt;/Attribute&gt; &lt;/Asset&gt; &lt;?php foreach($xmlDefect as $assetDefect){ // variables from defects XML $defectId = $assetDefect-&gt;Attribute[0]; $defectTitle = $assetDefect-&gt;Attribute[1]; $defectStatus = $assetDefect-&gt;Attribute[2]; if($defectStatus == "Gathering Requirements"){ $defectGatheringReqs = "&lt;div class='bugsItem'&gt;" . $defectId . "&lt;/div&gt;"; }else if($defectStatus == "Ready for Development"){ $defectReadyForDev = "&lt;div class='bugsItem'&gt;" . $defectId . "&lt;/div&gt;"; }else if($defectStatus == "In Progress"){ $defectInProgress = "&lt;div class='bugsItem'&gt;" . $defectId . "&lt;/div&gt;"; }else if($defectStatus == "Code Review"){ $defectAEReview = "&lt;div class='bugsItem'&gt;" . $defectId . "&lt;/div&gt;"; }else if($defectStatus == "Code Complete"){ $defectCodeComplete = "&lt;div class='bugsItem'&gt;" . $defectId . "&lt;/div&gt;"; } } ?&gt; &lt;table&gt; &lt;tr&gt; &lt;td&gt; Gathering Requirements &lt;/td&gt; &lt;td&gt; Ready for Development &lt;/td&gt; &lt;td&gt; In Progress &lt;/td&gt; &lt;td&gt; Code Review &lt;/td&gt; &lt;td&gt; Code Complete &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;?php echo $defectGatheringReqs; ?&gt; &lt;/td&gt; &lt;td&gt; &lt;?php echo $defectReadyForDev; ?&gt; &lt;/td&gt; &lt;td&gt; &lt;?php echo $defectInProgress; ?&gt; &lt;/td&gt; &lt;td&gt; &lt;?php echo $defectAEReview; ?&gt; &lt;/td&gt; &lt;td&gt; &lt;?php echo $defectCodeComplete; ?&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRyanPitts
    1. USRyanPitts
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPHP variables inside foreach loop
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you post an example of the content of `$xmlDefect`?
      singulars
      1. POPHP variables inside foreach loop
      1. USGeorge Cummins
    2. COyou seem to be missing a closing tag on your foreach loop there.
      singulars
      1. POPHP variables inside foreach loop
      1. USjisaacstone
    3. COBasically you need to reset the output variables on the beginning of the loop otherwise they still contain the values from the last looping (iteration).
      singulars
      1. POPHP variables inside foreach loop
      1. UShakre
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload