Learn VBA & Macros in 1 Week!

PHP - Print Array Info

Full Excel VBA Course - Beginner to Expert

Print Array Info	View Content

You can ignore my previous thread: Xpath help. I made it needlessly complicated!

Here's my problem:

My array $selected contains:
Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[buildingName] => EiffelTower
[code] => lM
[type] => building
)
[requiredLevel] => 5
[cost] => 5000
[built] => 03/31/1889
[storageType => SimpleXMLElement Object
(
[@attributes] => Array
(
[itemClass] => EiffelTower_construct
)
)
[defaultItem] => SimpleXMLElement Object
(
[@attributes] => Array
(
[amount] => 1
[name] => iron
)
)
[finishedReward] => iron
[image] => Array
(
[0] => SimpleXMLElement Object
(
[@attributes] => Array
(
[loadClass] => mc
[name] => construct_0
[url] => /buildings/eiffel_tower.swf
)
)
[1] => SimpleXMLElement Object
(
[@attributes] => Array
(
[loadClass] => mc
[name] => construct_1
[url] => /buildings/eiffel_tower.swf
)
)
[2] => SimpleXMLElement Object
(
[@attributes] => Array
(
[loadClass] => mc
[name] => built_0
[url] => /buildings/eiffel_tower.swf
)
)
[3] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => icon
[url] => buildings/eiffel_tower.png
)
)
[4] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => startIcon
[url] => /buildings/eiffel_tower.png
)
)
[5] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => halfIcon
[url] => /buildings/eiffel_tower.png
)
)
[6] => SimpleXMLElement Object
(
[@attributes] => Array
(
[name] => completeIcon
[url] => /buildings/eiffel_tower.png
)
)
)
[constructionUI] => /buildings/Construct_eiffel_tower.swf
[countryCard] => france
)
)

I have the following code:
echo "<td>".$selected[0]['name']."</td>";
echo "<td>".$selected[0]['code']."</td>";
echo "<td>".$selected[0]['type']."</td>";
echo "<td>".$selected['requiredLevel']."</td>";

This line of that code does not work:
echo "<td>".$selected['requiredLevel']."</td>";

I've tried:
echo "<td>".$selected[0]['requiredLevel']."</td>";
which also does not work.

Can anyone help me figure out why?[/code]

Full Excel VBA Course - Beginner to Expert

Getting Info From Api Response - Looping Through Array

Similar Tutorials

View Content

Hi. I have the fokllowing xml response from an API and I am wanting to loop through the array(s) and get informaton for each of the rows below. For example I want to get the cells below for Consulting Income / 98e83040-fa3a-4185-9b9b-a49241e2bb76/150.32 then get each of the other items in the array. So the second iitem I want is Contract Income / 7d05a53d-613d-4eb2-a2fc-dcb6adb80b80 / 11748.96 and so on for each of the results returned

I am having a mental block about best way to get this information. Please advise best approach.

<Response xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Id>20f0b472-a63d-4c1f-a8de-d0fc4e860983</Id>
  <Status>OK</Status>
  <ProviderName>Xero API Previewer</ProviderName>
  <DateTimeUTC>2020-10-12T21:34:33.5492839Z</DateTimeUTC>
  <Reports>
    <Report>
      <ReportID>ProfitAndLoss</ReportID>
      <ReportName>Profit and Loss</ReportName>
      <ReportType>ProfitAndLoss</ReportType>
      <ReportTitles>
        <ReportTitle>Profit &amp; Loss</ReportTitle>
        <ReportTitle>Demo Company (NZ)</ReportTitle>
        <ReportTitle>1 October 2020 to 31 October 2020</ReportTitle>
      </ReportTitles>
      <ReportDate>12 October 2020</ReportDate>
      <UpdatedDateUTC>2020-10-12T21:34:33.5492839Z</UpdatedDateUTC>
      <Rows>
        <Row>
          <RowType>Header</RowType>
          <Cells>
            <Cell />
            <Cell>
              <Value>31 Oct 20</Value>
            </Cell>
          </Cells>
        </Row>
        <Row>
          <RowType>Section</RowType>
          <Title>Income</Title>
          <Rows>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Consulting Income</Value>
                  <Attributes>
                    <Attribute>
                      <Value>98e83040-fa3a-4185-9b9b-a49241e2bb76</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>150.32</Value>
                  <Attributes>
                    <Attribute>
                      <Value>98e83040-fa3a-4185-9b9b-a49241e2bb76</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Contract Income</Value>
                  <Attributes>
                    <Attribute>
                      <Value>7d05a53d-613d-4eb2-a2fc-dcb6adb80b80</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>11748.96</Value>
                  <Attributes>
                    <Attribute>
                      <Value>7d05a53d-613d-4eb2-a2fc-dcb6adb80b80</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Engineering Income</Value>
                  <Attributes>
                    <Attribute>
                      <Value>225d8c93-251d-4a0b-9093-201acf69fe50</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>7217.29</Value>
                  <Attributes>
                    <Attribute>
                      <Value>225d8c93-251d-4a0b-9093-201acf69fe50</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Equipment Income</Value>
                  <Attributes>
                    <Attribute>
                      <Value>43f518a6-558f-402a-b22d-317bd64b1566</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>7377.17</Value>
                  <Attributes>
                    <Attribute>
                      <Value>43f518a6-558f-402a-b22d-317bd64b1566</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Licence Income</Value>
                  <Attributes>
                    <Attribute>
                      <Value>1ff30343-7bb2-4402-bb8f-a0813a7fb59e</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>3047.68</Value>
                  <Attributes>
                    <Attribute>
                      <Value>1ff30343-7bb2-4402-bb8f-a0813a7fb59e</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Other Income</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b447935a-4b37-4f38-a841-fb3ae3b491e0</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>331.06</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b447935a-4b37-4f38-a841-fb3ae3b491e0</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>SummaryRow</RowType>
              <Cells>
                <Cell>
                  <Value>Total Income</Value>
                </Cell>
                <Cell>
                  <Value>29872.48</Value>
                </Cell>
              </Cells>
            </Row>
          </Rows>
        </Row>
        <Row>
          <RowType>Section</RowType>
          <Title>Less Cost of Sales</Title>
          <Rows>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Other Direct Costs</Value>
                  <Attributes>
                    <Attribute>
                      <Value>9e77a829-37ea-4976-a9a8-d754e0e62f44</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>333.72</Value>
                  <Attributes>
                    <Attribute>
                      <Value>9e77a829-37ea-4976-a9a8-d754e0e62f44</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>SummaryRow</RowType>
              <Cells>
                <Cell>
                  <Value>Total Cost of Sales</Value>
                </Cell>
                <Cell>
                  <Value>333.72</Value>
                </Cell>
              </Cells>
            </Row>
          </Rows>
        </Row>
        <Row>
          <RowType>Section</RowType>
          <Rows>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Gross Profit</Value>
                </Cell>
                <Cell>
                  <Value>29538.76</Value>
                </Cell>
              </Cells>
            </Row>
          </Rows>
        </Row>
        <Row>
          <RowType>Section</RowType>
          <Title>Less Operating Expenses</Title>
          <Rows>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Accounting</Value>
                  <Attributes>
                    <Attribute>
                      <Value>5e312344-4123-4cac-bb69-ad2d72d2280b</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>60.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>5e312344-4123-4cac-bb69-ad2d72d2280b</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Advertising &amp; Promotional</Value>
                  <Attributes>
                    <Attribute>
                      <Value>61835d79-5a1c-4ab3-af82-af6930b38492</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>1112.21</Value>
                  <Attributes>
                    <Attribute>
                      <Value>61835d79-5a1c-4ab3-af82-af6930b38492</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Bank Fees</Value>
                  <Attributes>
                    <Attribute>
                      <Value>19828003-cea7-4920-b0fa-9223a2cdb0dc</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>28.75</Value>
                  <Attributes>
                    <Attribute>
                      <Value>19828003-cea7-4920-b0fa-9223a2cdb0dc</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Cellphones</Value>
                  <Attributes>
                    <Attribute>
                      <Value>ba533632-ac64-45c8-874e-b5a5aa6829f0</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>155.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>ba533632-ac64-45c8-874e-b5a5aa6829f0</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Courier</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b70cadef-d8aa-46e6-b128-79e2c997fd2c</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>232.02</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b70cadef-d8aa-46e6-b128-79e2c997fd2c</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>EFTPOS Charges</Value>
                  <Attributes>
                    <Attribute>
                      <Value>a164d99b-308e-4b2e-b3b4-a0c502214c77</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>40.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>a164d99b-308e-4b2e-b3b4-a0c502214c77</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Engineering Resources</Value>
                  <Attributes>
                    <Attribute>
                      <Value>53fdcc86-32ee-4fcb-b053-f449405bc7a5</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>1303.31</Value>
                  <Attributes>
                    <Attribute>
                      <Value>53fdcc86-32ee-4fcb-b053-f449405bc7a5</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Entertainment - Partly Deductible</Value>
                  <Attributes>
                    <Attribute>
                      <Value>d27cb87b-a3d2-4275-8948-95871fec4929</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>15.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>d27cb87b-a3d2-4275-8948-95871fec4929</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Equipment Costs</Value>
                  <Attributes>
                    <Attribute>
                      <Value>573a170b-6792-4cfa-b8ce-6f8fd27f5458</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>13746.93</Value>
                  <Attributes>
                    <Attribute>
                      <Value>573a170b-6792-4cfa-b8ce-6f8fd27f5458</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>General Expenses</Value>
                  <Attributes>
                    <Attribute>
                      <Value>11f618a8-f17e-4757-8b4a-6f24841bdb93</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>323.23</Value>
                  <Attributes>
                    <Attribute>
                      <Value>11f618a8-f17e-4757-8b4a-6f24841bdb93</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Insurance</Value>
                  <Attributes>
                    <Attribute>
                      <Value>92c673af-b2bc-45be-a888-a7e2c4bcc7f9</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>119.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>92c673af-b2bc-45be-a888-a7e2c4bcc7f9</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>KiwiSaver Employer Contributions</Value>
                  <Attributes>
                    <Attribute>
                      <Value>ab57eabe-5fa8-49d4-87dc-d5e7428323af</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>519.53</Value>
                  <Attributes>
                    <Attribute>
                      <Value>ab57eabe-5fa8-49d4-87dc-d5e7428323af</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Licence Costs</Value>
                  <Attributes>
                    <Attribute>
                      <Value>02dbaa55-95b9-464e-999c-c68e203cd67f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>2176.91</Value>
                  <Attributes>
                    <Attribute>
                      <Value>02dbaa55-95b9-464e-999c-c68e203cd67f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Motor Vehicle Expenses</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b149780d-69bc-4f7c-a3ce-bd48f7a37de5</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>619.63</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b149780d-69bc-4f7c-a3ce-bd48f7a37de5</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Office Consumables &amp; Postage</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b1769b51-e98e-432c-9670-d5be3054b717</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>56.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>b1769b51-e98e-432c-9670-d5be3054b717</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Office Expenses</Value>
                  <Attributes>
                    <Attribute>
                      <Value>935e0fbe-6749-41c8-a024-11321e44dfac</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>113.23</Value>
                  <Attributes>
                    <Attribute>
                      <Value>935e0fbe-6749-41c8-a024-11321e44dfac</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Payment Processing</Value>
                  <Attributes>
                    <Attribute>
                      <Value>8cd42505-ad73-46e2-932f-67952fdc4e99</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>174.51</Value>
                  <Attributes>
                    <Attribute>
                      <Value>8cd42505-ad73-46e2-932f-67952fdc4e99</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Rent</Value>
                  <Attributes>
                    <Attribute>
                      <Value>28113b99-6df2-4123-a2d0-5f54dcf8017b</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>1935.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>28113b99-6df2-4123-a2d0-5f54dcf8017b</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Salaries &amp; Wages</Value>
                  <Attributes>
                    <Attribute>
                      <Value>be2e984a-17e1-4bf7-809c-b03a69325c90</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>17317.58</Value>
                  <Attributes>
                    <Attribute>
                      <Value>be2e984a-17e1-4bf7-809c-b03a69325c90</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Security</Value>
                  <Attributes>
                    <Attribute>
                      <Value>c814b08e-6558-4ac4-adce-ba76848a3a9f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>45.00</Value>
                  <Attributes>
                    <Attribute>
                      <Value>c814b08e-6558-4ac4-adce-ba76848a3a9f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Subscriptions</Value>
                  <Attributes>
                    <Attribute>
                      <Value>5ba8d64a-5b98-4bfd-a35e-7d0569e3446f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>102.96</Value>
                  <Attributes>
                    <Attribute>
                      <Value>5ba8d64a-5b98-4bfd-a35e-7d0569e3446f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Telephone &amp; Internet</Value>
                  <Attributes>
                    <Attribute>
                      <Value>230e4cfc-f4c4-4c15-aa0d-bab02b954622</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>89.95</Value>
                  <Attributes>
                    <Attribute>
                      <Value>230e4cfc-f4c4-4c15-aa0d-bab02b954622</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Travel &amp; Accommodation - National</Value>
                  <Attributes>
                    <Attribute>
                      <Value>36d33c5d-7dea-4911-9ed0-7fccc16f2b5f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>210.43</Value>
                  <Attributes>
                    <Attribute>
                      <Value>36d33c5d-7dea-4911-9ed0-7fccc16f2b5f</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Utilities</Value>
                  <Attributes>
                    <Attribute>
                      <Value>2e277847-022c-48f3-8467-0207230004d6</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
                <Cell>
                  <Value>348.14</Value>
                  <Attributes>
                    <Attribute>
                      <Value>2e277847-022c-48f3-8467-0207230004d6</Value>
                      <Id>account</Id>
                    </Attribute>
                  </Attributes>
                </Cell>
              </Cells>
            </Row>
            <Row>
              <RowType>SummaryRow</RowType>
              <Cells>
                <Cell>
                  <Value>Total Operating Expenses</Value>
                </Cell>
                <Cell>
                  <Value>40844.32</Value>
                </Cell>
              </Cells>
            </Row>
          </Rows>
        </Row>
        <Row>
          <RowType>Section</RowType>
          <Rows>
            <Row>
              <RowType>Row</RowType>
              <Cells>
                <Cell>
                  <Value>Net Profit</Value>
                </Cell>
                <Cell>
                  <Value>-11305.56</Value>
                </Cell>
              </Cells>
            </Row>
          </Rows>
        </Row>
      </Rows>
    </Report>
  </Reports>
</Response>

Edited October 13, 2020 by Barand
code tags (XML) added

Array Print

Similar Tutorials

View Content

Probably a simple solution, just one I'm not sure how to do it.

I need the array to print out like this

Code: [Select]
array(
'name'=>'Store 1',
'address'=>'LA1'
),

Right now, I got it to look like this

Thanks in advance
Code: [Select]
Array
(
[name] => 'Albertville Farmers Market',
[address] => '116 Main Street Albertville, Alabama 35950'
)
,
Array
(
[name] => 'Alexander City Downtown Market',
[address] => 'Braod Street Alexander City, Alabama 35010'
)
,

How can I go about accomplishing this?

Here is my code
Code: [Select]
$stores = array('name'=>"'$MktName',",'address'=>"'$address'");
echo "<pre>";
print_r($stores);
echo "</pre>";

Print Array Of Results

Similar Tutorials

View Content

What I'm trying to achieve is to get a set of data from a database and then cycle through the array and add the contents of each row to a variable. I'm trying to use $i to cycle through the array but at the moment it's just printing the first character of each set. Any help would be great.

$fav_products_sql = "select fav_products.product_id, fav_products.product_order, product_list.product_name from fav_products, product_list where fav_products.product_id = product_list.id";
$fav_products_rs = mysql_query($fav_products_sql, $conn);
$fav_products = mysql_fetch_array ($fav_products_rs);

while ($i < 11) {
$_SESSION['fav_products'] = "<li>" . $fav_products['product_order']['$i'] . ": " . $fav_products['product_name']['$i'] . "</li>";
$i++;
}

How To Print A String That Also Contains An Array?

Similar Tutorials

View Content

If I wanted to print a string that contains a variable that also contains an array, how would I do so? I want to put the resulting echo into a log file.

Example: “These are the books: $userArray and these are the pages: $pagesArray”;

With just an array, I can use print_r($array, true) to get an array formatted for use in a string (which works well for my purposes) but this doesn’t work with two arrays unless I do this manually. (Such as setting the $user_array = print_r($userArray). But I want to write a function that will take a string, potentially containing arrays (as variables), and interpolate/make them legible for humans. (Some of the arrays are also multidimensional.)

But it looks like I can't even concatenate a string and an array. $string = $string . $array. gives an error, array to string conversion.

I don’t understand PHP very well so please explain what is going on here. and the best way to record something like the Example above.

How To Print An Array Of $post

Similar Tutorials

View Content

Hi all

This is probably the easiest question ever , but I am not familiar with arrays , so hope somebody can help me

User post this checkbox form (array):

<input type="checkbox" name="type[0][]" value="1" >
<input type="checkbox" name="type[0][]" value="2" >
<input type="checkbox" name="type[0][]" value="3" >

I need to get all checked values and print them ...
How can I do this?

I tried the code below, but it only returns me one value

Code: [Select]

$values = array($_POST["type"]);

foreach ($values as $item){

echo $item;

}

Any help???

Thanks!!

Store Multiple Selection From Pagination Info Into Single Array

Similar Tutorials

View Content

Hi

I have a results page from a MySQL query and I have implemented pagination to present data in chunks of 25 per page in a table view (each row => 1 entry).

My problem is that next to each data row, I have a selection checkbox, and if the user clicks on it, he can download the selected entries. This thing worked OK before I employed paginated view, when I presented all data in one page. Now, if I select e.g. 2 entries in page 1, then I jump to page 12 and select another 2 entries, if I click on the "Retrieve" button, I get only the last 2 entries (from the last page visited).

How can I solve this problem? With JS? Can I use PHP only?

Unable To Print Out Array From A Php Function

Similar Tutorials

View Content

Dear all,

Kindly help with this code I have written, it is not returning the array I created. It is a very small script but I have been looking for a very long time but I couldn't see why it went wrong.

$duration = 2;
$start='01-01-2019';
$month =date('n', strtotime($start));
$year =date('Y', strtotime($start));
$mon = 12-$month+1;
$remainingMonth = $duration*12;

$years_arr = array("$year");
$residue_arr = array("$remainingMonth");
$years_arr = process($remainingMonth,$year,$mon,$years_arr,$residue_arr);

print_r($years_arr); //<output

function process($remainingMonth,$year,$mon,$years_arr,$residue_arr){
    $residue = $remainingMonth - $mon;//$D$18-D20
    if($residue != 0){
        $new_year = $year+1;
        array_push($years_arr, $new_year);
        array_push($residue_arr, $residue);
        
        if($residue > 12 ){
            $mon = 12;
        } else {
            $mon = $residue;
        }
        echo "<br>";
        process($residue,$new_year,$mon,$years_arr,$residue_arr);
    } else {
        print_r($years_arr);
        return $years_arr;
    }
}//end of process(..)

The objective is to add a year to the $years_arr array and then print it put, yet I notice that nothing get's printed out. Please assist, if you need more info from my side, please do ask. Thank you very much in advance.

Print Each Array Element On New Line

Similar Tutorials

View Content

I am trying to break down an array to make it easier to read. An array that looks like Array ( => 0 [1] => 0 [2] => 0 [3] => 0012844 1 [4] => 37 [5] => 1 etc...) I want to display it like: Code: [Select]
[0] => 0
[1] => 0
[2] => 0
etc...
how can this be accomplished.

Print Json Results / Array Loop

Similar Tutorials

View Content

Hello,

Having a bit of a tough time understanding what is going on in my brain!

I'm basically pulling some data from an API using CuRL, which is working fine. The structure of the data is:

[data][tickets] - tickets being an array of support tickets in the system, which then contains ticketNumber, title, content. I want to display these values in a list, I have this code currently:

  if ($err) {
    echo "cURL Error #:" . $err;
  } else {
    $return = json_decode($response, true);
    foreach($return as $key) {
      echo $key["tickets"][1]['ticketNumber']." - ";
      echo $key["tickets"][1]['title']." - ";
      echo $key["tickets"][1]['content'];
    }
  }

Which obviously returns the ticketNumber, title & content of the first support ticket in the array, but I want to loop through and display that information for each ticket!

Can anyone advise as to where I am going wrong? I think I need to utilise the ["tickets"][x] but not sure how!

Thanks in advance!

Steve

How To Output $_post['user'] Array Using Print

Similar Tutorials

View Content

Hi the above title explains it all.How to output a post array which has been given input using forms.I know you can do it my echo but what about print()
Thanks

Print Duplicate Records Once From An Array Into A Table

Similar Tutorials

View Content

[ Newbie Alert ]
Hi

i have an array of 39 arrays. Only 5 are shown below so that you have an idea before i ask my question.

<?
array(39)
{
[0]=> array(3) { [0]=> string(18) "unit name 1" [1]=> string(9) "category name 1" [2]=> string(20) "Course 1" }

[1]=> array(3) { [0]=> string(54) "unit name 2" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" }

[2]=> array(3) { [0]=> string(29) "unit name 3" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" }

[3]=> array(3) { [0]=> string(64) "unit name 4" [1]=> string(30) "category name 3" [2]=> string(20) "Course 2" }

[4]=> array(3) { [0]=> string(57) "unit name 5" [1]=> string(24) "category name 1" [2]=> string(20) "Course 1" }

[5]=> array(3) { [0]=> string(50) "unit name 6" [1]=> string(24) "category name 4" [2]=> string(20) "Course 2" }
}

i want a php solution to print category names in table headers , unit names in table rows and course name(s) in table caption.I have tried foreach loop but how to remove duplicate entries as you can see category name 1 and 2 will become two separate headers instead of one and same is the case with Course 1 and 2.
i have googled but could'nt find any solution. i don't want to remove duplicate entries , all i want to display them once in a table as described above.

$data $array - The Print Result Mashes All The Numbers Together

Similar Tutorials

View Content

Hello, I am fairly new to PHP and I found some php code to print an array of numbers that create a combination - however, its slams all the numbers together without a space or a comma separator. How can I separate the numbers in this array with the given code? Ive attached a photo of the code.

Php?cid= For Info

Similar Tutorials

View Content

Very simple question. I have a table with courses and a table with students registered for those courses. I have a page where I can change the course name. What I want to do is, when changing the course name in the course table, I want all students in the students table who are already registered for that course to have that course name updated as well in the student table.

I'm currently using a field cid to update the courses in the course table however, the student table doesn't have a cid field rather a cname ( course name) which I want to use to update the fields in the student table.

Is it possible to use
Code: [Select]
<a href=\"editcourse.php?cid=" for more than one field of info? i.e transfer the cid + cname and so you can use $_GET[cid]"; and $_GET[cname]"; ?

Something like this maybe ( dont know how the code will go) "editcourse.php?cid=&cname=" ?

Do I have the right idea for how to go about this?

Php Get Url Info

Similar Tutorials

View Content

Hey guys,

It's been awhile since I've coded in PHP and I can not for the life of me remember how to do this.

Say I have http://www.example.com/search.php?name=joe&size=small

What the PHP code to grab the ?name=joe&size=small part?

thanks

Not Submiting The Info

Similar Tutorials

View Content

Hi all, Ive latly coded a option for my website which allowes users to send money. Ive finished coding it but when I press the submit button the money dont get sent to the other user it just puts it in the url bar.

Example: http://********.com/newbank.php?touser=Test&sendmoney=1000000000&sendmoney=Send+Money!

<?php
session_start();

include ("includes/db_connect.php");
include ("includes/functions.php");
logincheck();

$username = $_SESSION['username'];

// Fetch users stuff..

$fetch_u = mysql_query("SELECT * FROM users WHERE username='$username'") or die (mysql_error());
           $fetch_users = mysql_fetch_object($fetch_u);

// Fetch bank stuff..

$fetch_b = mysql_query("SELECT * FROM bank") or die (mysql_error());
           $fetch_bank = mysql_fetch_object($fetch_b);

// User sending money..

if ($_POST['sendmoney']){
$send_money = strip_tags($_POST['ammount']);
$to_user = strip_tags($_POST['touser']);

if (!$to_user){
   echo ("You must enter a username.");
}elseif ($to_user){

$user_real = mysql_num_rows(mysql_query("SELECT * FROM users WHERE username = '$to_user'")) or die (mysql_error());

if ($user_real == 0){
   echo ("No such user!");
}elseif ($user_real != 0){

         if ($send_money > "0"){
           if ($send_money == 0 || !$send_money || ereg('[^0-9]',$send_money)){
              echo ("You carnt send that type of money");
           }elseif ($send_amount != 0 || $send_amount || !ereg('[^0-9]',$send_amount)){

           if ($send_money > $fetch->money){
             echo ("You havent got that much money");
           }elseif ($send_money <= $fetch->money){

             // Try sending money to yourself

             if (strtolower($to_user) == strtolower($username)){
               echo ("You cannot send money to yourself");
             }elseif (strtolower($to_user) != strtolower($username)){

           $to_person = mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$to_user'"));

           $otherusercash = $send_money;
           $otheruser = $to_user->money + $otherusercash;

            mysql_query("UPDATE users SET money = money-$send_money WHERE username='$username'");
        mysql_query("UPDATE users SET money = '$otheruser' WHERE username='$to_person'");

        $time = gmdate('Y-m-d h:i:s');
                          mysql_query("INSERT INTO `transfers` ( `id` , `to` , `from` , `amount` , `date` )
                            VALUES ('', '$to_person', '$username', '$send_amount', '$time')") or die (mysql_error());

echo "Money Sent!";
echo "<meta http-equiv=\"refresh\" content=\"0;URL=newbank.php\">";
}
}
}
}
}
}
}
?>

<html>
<head>
<link rel="stylesheet" href="includes/in.css" type="text/css">

<style type="text/css">
.infobg {
font-family: Arial;
font-weight:normal;
font-size:12px;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
background: URL(textbg1.png);
font-weight:300;
}

.button {
font-size: 12px;
background:url(button.png);
vertical-align: middle;
border-top: 1px solid #000000;
border-right: 1px solid #000000;
border-bottom: 1px solid #000000;
border-left: 1px solid #000000;
color: #FFFFCC;
height:23px;
font-weight:300;
border-radius: 10px;
padding-bottom:2px;
}

</style>
<title>Running-Mafia || Send Money</title>
</head>
<body>
<form action='' name='form1'>
<table width='50%' border='1' bordercolor='#000000' align='center' bgcolor='#808080' cellpadding='0' cellspacing='0' style='border-collapse: collapse'>
<tr>
<td colspan='2' background='header.jpg' align='center'>Send Money</td>
</tr>
<tr>
<td>
Username:
</td>
<td>
<input type='text' name='touser' class='infobg' id='touser'>
</td>
</tr>
<tr>
<td>
Ammout:
</td>
<td>
<input name="sendmoney" class='infobg' type="text" id="send_money">
</td>
</tr>
<tr>
<td>
 
</td>
<td>
<input class="button" name="sendmoney" type="submit" id="sendmoney" value="Send Money!">
</td>
</tr>
</table>
</form>
</body>
</html>

Anyone see why its not sending the money?

Thanks.

Fetching Info From .txt

Similar Tutorials

View Content

hello guys

i heard there is a way that you can make something like a database on a text editor and when ever u want to change the info you just open a text editor and change the information

How is this called? where can i find a tutorial? any tips? thanks you very much

Retrieving Info

Similar Tutorials

View Content

ok im back quicker than i thought....

i got my drop box sorted and i got it reloading the page. so it all works correctly.

but how do i get the page to display information regarding the film i have selected in the drop box.? i have no code for this at the mo.

also i would like the drop box to display the selected item at top of box when it refreshes

code for drop box:

Code: [Select]
<FORM>
<?php $result = mysql_query( "SELECT * FROM movie_info ORDER BY title ASC ")
;
echo "<select name= Film onChange='submit()' >film name</option>";
while
($nt=mysql_fetch_array($result)){
?>
<?php
echo "<option value='$nt[id]'>$nt[title] </option>";
}
?>
</select>
</FORM>

any help would be great

Getting Rid Of Unwanted Info

Similar Tutorials

View Content

I am parsing an rss feed from my flickr photostream using this:-

<?php

$url = "http://api.flickr.com/services/feeds/photos_public.gne?id=49466419@N05&lang=en-us&format=rss_200";
$rss = simplexml_load_file($url);
	if($rss)
	{
	echo '<h1>'.$rss->channel->title.'</h1>';
	echo '<li>'.$rss->channel->pubDate.'</li>';
	$items = $rss->channel->item;
		foreach($items as $item)
		{
		$title = $item->title;
		$link = $item->link;
		$published_on = $item->pubDate;
		$description = $item->description;
		echo '<h3><a href="'.$link.'">'.$title.'</a></h3>';
		echo '<span>('.$published_on.')</span>';
		echo '<p>'.$description.'</p>';
	}
}

?>

which gives me this as the description for each image:-

public 'description' => string '
<p><a href="http://www.flickr.com/people/alfthomas/">Alf Thomas</a> posted a photo:</p>
	
<p><a href="http://www.flickr.com/photos/alfthomas/14064465890/" title="harlaw_12">
<img src="http://farm6.staticflickr.com/5077/14064465890_83c02ecec6_m.jpg" width="240" height="110" alt="harlaw_12" />
</a>
</p>

<p>A view of Harlaw Reservoir.</p>' (length=338)

What I actually want is the photo (linked back) without the "Alf Thomas posted a photo" bit, does anyone have any idea how I would go about cloning that bit out?
Edited by foucquet, 31 May 2014 - 08:14 AM.

Need Some Help Parsing Info

Similar Tutorials

View Content

When I get a hit on my site I like to see where they came from and if they came from a search engine what keywords they used. So here is the refer info:

http://www.google.com/search?q=dog+training&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a

I guess I need to split everything into an array or something.

Has anyone done this? Any Ideas?

Thank you!

Not Putting In All Info?

Similar Tutorials

View Content

Ok so for some reasons on my register and edit profile page when i hit submit it says that i have not filled in all the info i need.. Even after i fill all of them in..

but heres the code for the register form..

Code: [Select]
<?php require("top.php"); ?>
<div id='homeright'>
<?php

echo "<font size='6'>Sign up</font>";

echo "<hr width='75%' align='left'/>";
$form = "<form action='index.php' method='post'>
<table cellspacing='5px'>

<tr>
<td>First Name:</td>
<td class='register'><input type='text' name='firstname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Last Name:</td>
<td><input type='text' name='lastname' class='textbox' size='35'></td>
</tr>

<tr>
<td>Username:</td>
<td><input type='text' name='username' class='textbox' size='35'></td>
</tr>

<tr>
<td>E-mail:</td>
<td><input type='text' name='email' class='textbox' size='35'></td>
</tr>

<tr>
<td>Password:</td>
<td><input type='password' name='password' class='textbox' size='35'></td>
</tr>

<tr>
<td>Confirm Password:</td>
<td><input type='password' name='repassword' class='textbox' size='35'></td>
</tr>

<tr>
<td></td>
<td><input type='submit' name='submitbtn' value='Register' class='button'></td>
</tr>
</table>

</form>";

if ($_POST['submitbtn']){

$firstname = fixtext($_POST['firstname']);
$lastname = fixtext($_POST['lastname']);
$username = fixtext($_POST['username']);
$email = fixtext($_POST['email']);
$password = fixtext($_POST['password']);
$repassword = fixtext($_POST['repassword']);
$website = fixtext($_POST['website']);
$youtube = fixtext($_POST['youtube']);
$bio = fixtext($_POST['bio']);

$name = $_FILES['avatar'] ['name'];
$type = $_FILES['avatar'] ['type'];
$size = $_FILES['avatar'] ['size'];
$tmpname = $_FILES['avatar']['tmpname'];
$ext = substr($name, strrpos($name, '.'));

if ($firstname && $lastname && $username && $email && $password && $repassword){
if ($password == $repassword){
if (strstr($email, "@") && strstr($email, ".") && strlen($email) >= 6){

require("scripts/connect.php");
/*$query = mysql_query("SELECT * FROM users WHERE username='$username' ");*/
$query=mysql_query("SELECT * FROM users WHERE username='$username' ") or die(mysql_error());
$numrows = mysql_num_rows($query);
if ($numrows == 0){

/*$query=mysql_query("SELECT * FROM users WHERE email='$email' ");*/
$query=mysql_query("SELECT * FROM users WHERE email='$email' ") or die(mysql_error());
$numrows=mysql_num_rows($query);
if ($numrows == 0){

$pass = md5(md5($password));
$date = date("F d, Y");

if($name){
move_uploaded_file($tmpname, "avatars/$username.$ext");
$avatar = "$username.$ext";
}
else
$avatar = "/avatars/default_avatar.png";

$code = substr (md5(rand(11111111111, 999999999999999)), 2, 25);

mysql_query("INSERT INTO users (`first_name`,`last_name`,`username`,`email`,`password`,`avatar`,`bio`,`website`,`youtube`,`last_login`,`active`,`code`,`locked`,`date`) VALUES ( '$firstname', '$lastname', '$username', '$email', '$pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");

/*mysql_query("INSERT INTO users (Field, Type) VALUES ('', '$firstname', '$lastname', '$username', '$email', 'pass', '$avatar', '$bio', '$website', '$youtube', '', '0', '$code', '0', '$date')");*/

$webmaster = "Admin@trucksite.com";
$subject = "Activate Your Account!";
$headers = "From: Admin <$webmaster>";
$message = "Hello $firstname.\n\nWelcome to trucksite below is a link for you to activate your account!.\n http://tprofiletesting.net23.net/activate.php?code=$code";

mail($email, $subject, $message, $headers);
echo "Your activation email has been sent to <b>$email</b>.";
}
else
echo "That email is currently in use.";

}
else
echo "That username is currently in use.";
}
else
echo "You did not enter a vaild email.";
}
else
echo "Your passwords did not match.";
}
else
echo"You did not fill in all the required fields.";
}
echo "$form";

?>

</div>
<div id='homeleft'>
<center><font size='6'>Create! Showoff! Educate!</font></center>
<hr />

</div>
</body>
</html>