|
PHP - Getting Info From Api Response - Looping Through Array
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 & 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 & 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 & 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 & 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 & 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 & 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 Similar TutorialsIt's been quite a while since I have coded in PHP and I am running into difficulties looping through the returned response from an API. I am pretty comfortable in my PHP skills, but for some reason I keep getting caught up trying to loop through the following... Many of the returns from the API include several more layers of Objects, the example below is about the most simplistic return from the API.
I'm sure I'm just missing something easy and any help or example code simply looping through and echoing each result would be greatly appreciated!! Ideally I would like to be able to loop through both of the scenarios below.
I did a var_dump on the response and here is what I get:
array (size=1)
'Body' =>
object(stdClass)[6]
public 'userContext' =>
object(stdClass)[8]
public 'convCred' =>
object(stdClass)[10]
...
public 'valid' => boolean true
public 'isPasswordExpired' => boolean false
public 'cbId' => int 0083802121
public 'cnId' => int 1000545
public 'locale' => string 'en_US' (length=5)
public 'tncVersion' => int 2
public 'applicationId' => string 'ECFDA1FDBC00270772870CDC1786FFED' (length=32)
public 'cbConvCred' =>
object(stdClass)[9]
...
public 'preferenceInfo' =>
object(stdClass)[7]
...
public 'lastLoginTime' => int 1406729928
public 'loginCount' => int 282
public 'passwordRecovered' => boolean false
public 'emailAddress' => string 'abc@123.com' (length=11)
public 'loginName' => string 'TEST' (length=8)
public 'userId' => int 15932274
public 'userType' =>
object(stdClass)[14]
public 'userTypeId' => int 1
public 'userTypeName' => string 'normal_user' (length=11)
public 'isConfirmed' => boolean false
If I jsonencode and jsondecode the response this is what I get:
object(stdClass)[13]
public 'Body' =>
object(stdClass)[17]
public 'userContext' =>
object(stdClass)[18]
public 'convCred' =>
object(stdClass)[19]
...
public 'valid' => boolean true
public 'isPasswordExpired' => boolean false
public 'cbId' => int 0083802121
public 'cnId' => int 1000545
public 'locale' => string 'en_US' (length=5)
public 'tncVersion' => int 2
public 'applicationId' => string 'ECFDA1FDBC00270772870CDC1786FFED' (length=32)
public 'cbConvCred' =>
object(stdClass)[20]
...
public 'preferenceInfo' =>
object(stdClass)[21]
...
public 'lastLoginTime' => int 1406729953
public 'loginCount' => int 283
public 'passwordRecovered' => boolean false
public 'emailAddress' => string 'abc@123.com' (length=11)
public 'loginName' => string 'TEST' (length=8)
public 'userId' => int 15932274
public 'userType' =>
object(stdClass)[24]
public 'userTypeId' => int 1
public 'userTypeName' => string 'normal_user' (length=11)
public 'isConfirmed' => boolean false
Here is my java script
$.each(data, function() {
var myTable1 =
'<tr bgcolor=#ffffff>' +
'<td align=center>'+this.vehiclelog_plate+'</td>' +
'<td align=center>'+this.vehiclelog_name+'</td>' +
'<td align=center>'+this.vehiclelog_date+'</td>' +
'<td align=center>'+this.vehiclelog_reftype+'</td>' +
'<td align=center>'+this.vehiclelog_refid+'</td>' +
'<td align=center>'+this.vehiclelog_description+'</td>' +
'</tr>';
$('#tableField').append(myTable1);
});
And here is my HTML
<div id="tabs-6">
<div id="rform">
<form action = "home.php" method="post">
<fieldset>
<legend>View Vehicle Service</legend><br><br>
<div>
<label class="label-left">Vehicle Name:</label>
<span role="status" aria-live="polite" class="ui-helper-hidden-accessible"></span>
<input id="autocomplete" title="type "a"" class="ui-autocomplete-input" name="vehicle_service_search" autocomplete="off">
</div>
<div>
<button id="searchVehicleDesc" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only" role="button" aria-disabled="false">
<span class="ui-button-text">View</span>
</button>
</div>
<div>
<table border="1" width="650" id = "tableField">
<tr bgcolor=#c0c0c0>
<td width=100 align="center"><font face="helvetica"><b>Vehicle Name</b></font></td>
<td width=80 align="center"><font face="helvetica"><b>Service Type</b></font></td>
<td width=80 align="center"><font face="helvetica"><b>Others</b></font></td>
<td width=100 align="center"><font face="helvetica"><b>Reference No.</b></font></td>
<td width=80 align="center"><font face="helvetica"><b>Reference Date</b></font></td>
<td width=80 align="center"><font face="helvetica"><b>Reference Type</b></font></td>
</tr>
</table>
</div>
</fieldset>
</form>
</div>
</div>
And here is my response
[{"success":1,"plate":"SIX666","name":"YAMAHA ISUZU","date":"0000-00-00","type":"Add Vehicle","id":"0","desc":""},{"success":1,"plate":"VIE597","name":"Resource id #6","date":"2014-05-09","type":"OIL","id":"332142","desc":"castroil"}]
Im getting the right response from ajax but I can't put my value to a table I get an alert that says undefined.
Hello.
I am new here.
I have a sligh problem, i saw a few results here which however did not lead to the desired result.
The problem is , i have this Json Response from a API:
Array
(
[0] => Array
(
[isoid] => 0
[omschrijving] => - leeg -
)
[1] => Array
(
[isoid] => 64
[omschrijving] => ArchLinux 2013.5
)
[2] => Array
(
[isoid] => 75
[omschrijving] => AsteriskNOW 3.0.0 64b
)
[3] => Array
(
[isoid] => 67
[omschrijving] => CentOS 5.9 32b
)
[4] => Array
(
[isoid] => 2
[omschrijving] => CentOS 6.3 64b
)
[5] => Array
(
[isoid] => 96
[omschrijving] => CentOS 7.0 64b
)
[6] => Array
(
[isoid] => 4
[omschrijving] => Clear OS 5.2 64b
)
[7] => Array
(
[isoid] => 93
[omschrijving] => CloudLinux 6.4
)
[8] => Array
(
[isoid] => 1
[omschrijving] => Debian GNU/Linux 6.0 / Squeeze 64b
)
[9] => Array
(
[isoid] => 79
[omschrijving] => Debian GNU/Linux 7.0 / Wheezy 32b
)
[10] => Array
(
[isoid] => 71
[omschrijving] => Debian GNU/Linux 7.0 / Wheezy 64b
)
[11] => Array
(
[isoid] => 63
[omschrijving] => Fedora 18 64b
)
[12] => Array
(
[isoid] => 82
[omschrijving] => FreeBSD 10 64b
)
[13] => Array
(
[isoid] => 77
[omschrijving] => FreeBSD 9.2 64b
)
[14] => Array
(
[isoid] => 10
[omschrijving] => FreePBX 5.211.65-12
)
[15] => Array
(
[isoid] => 76
[omschrijving] => GParted Live CD
)
[16] => Array
(
[isoid] => 3
[omschrijving] => KVM Virtio drivers voor Windows
)
[17] => Array
(
[isoid] => 66
[omschrijving] => MailCleaner 2012v6 64b
)
[18] => Array
(
[isoid] => 68
[omschrijving] => Manjaro KDE 0.8.6 64b
)
[19] => Array
(
[isoid] => 78
[omschrijving] => Microsoft Windows 7 Pro 64b
)
[20] => Array
(
[isoid] => 69
[omschrijving] => Microsoft Windows Server 2003 EN
)
[21] => Array
(
[isoid] => 8
[omschrijving] => Microsoft Windows Server 2008R2 EN
)
[22] => Array
(
[isoid] => 7
[omschrijving] => Microsoft Windows Server 2008R2 NL
)
[23] => Array
(
[isoid] => 70
[omschrijving] => Microsoft Windows Server 2012 NL 64b
)
[24] => Array
(
[isoid] => 84
[omschrijving] => Microsoft Windows Server 2012R2 NL
)
[25] => Array
(
[isoid] => 83
[omschrijving] => NOC PS 1.0r11
)
[26] => Array
(
[isoid] => 11
[omschrijving] => OpenBSD 5.2
)
[27] => Array
(
[isoid] => 80
[omschrijving] => OpenBSD 5.4
)
[28] => Array
(
[isoid] => 94
[omschrijving] => OpenBSD 5.5 64b
)
[29] => Array
(
[isoid] => 72
[omschrijving] => OpenSUSE 12.3 64b
)
[30] => Array
(
[isoid] => 95
[omschrijving] => Slackware 13.37
)
[31] => Array
(
[isoid] => 12
[omschrijving] => System Rescue CD
)
[32] => Array
(
[isoid] => 18
[omschrijving] => Turnkey Appflower
)
[33] => Array
(
[isoid] => 19
[omschrijving] => Turnkey ASP.net/Apache
)
[34] => Array
(
[isoid] => 20
[omschrijving] => Turnkey Bugzilla
)
[35] => Array
(
[isoid] => 21
[omschrijving] => Turnkey CodeIgniter
)
[36] => Array
(
[isoid] => 22
[omschrijving] => Turnkey Django
)
[37] => Array
(
[isoid] => 23
[omschrijving] => Turnkey Dokuwiki
)
[38] => Array
(
[isoid] => 24
[omschrijving] => Turnkey DomainControler
)
[39] => Array
(
[isoid] => 25
[omschrijving] => Turnkey Drupal7
)
[40] => Array
(
[isoid] => 26
[omschrijving] => Turnkey Fileserver
)
[41] => Array
(
[isoid] => 27
[omschrijving] => Turnkey Gallery
)
[42] => Array
(
[isoid] => 28
[omschrijving] => Turnkey Gitlab
)
[43] => Array
(
[isoid] => 15
[omschrijving] => Turnkey Google AppEngine Go
)
[44] => Array
(
[isoid] => 16
[omschrijving] => Turnkey Google AppEngine Java
)
[45] => Array
(
[isoid] => 17
[omschrijving] => Turnkey Google AppEngine Python
)
[46] => Array
(
[isoid] => 29
[omschrijving] => Turnkey IceScrum
)
[47] => Array
(
[isoid] => 30
[omschrijving] => Turnkey Joomla2.5
)
[48] => Array
(
[isoid] => 31
[omschrijving] => Turnkey LAMP
)
[49] => Array
(
[isoid] => 32
[omschrijving] => Turnkey Lighttpd/PHP/FastCGI
)
[50] => Array
(
[isoid] => 33
[omschrijving] => Turnkey Magento
)
[51] => Array
(
[isoid] => 34
[omschrijving] => Turnkey Mediawiki
)
[52] => Array
(
[isoid] => 35
[omschrijving] => Turnkey MongoDB
)
[53] => Array
(
[isoid] => 36
[omschrijving] => Turnkey MySQL
)
[54] => Array
(
[isoid] => 37
[omschrijving] => Turnkey NGINX/PHP/FastCGI
)
[55] => Array
(
[isoid] => 38
[omschrijving] => Turnkey OpenLDAP
)
[56] => Array
(
[isoid] => 39
[omschrijving] => Turnkey OpenPhoto
)
[57] => Array
(
[isoid] => 40
[omschrijving] => Turnkey OSCommerce
)
[58] => Array
(
[isoid] => 41
[omschrijving] => Turnkey OTRS
)
[59] => Array
(
[isoid] => 42
[omschrijving] => Turnkey Owncloud
)
[60] => Array
(
[isoid] => 43
[omschrijving] => Turnkey PHPBB
)
[61] => Array
(
[isoid] => 44
[omschrijving] => Turnkey PHPList
)
[62] => Array
(
[isoid] => 45
[omschrijving] => Turnkey PHPNuke
)
[63] => Array
(
[isoid] => 46
[omschrijving] => Turnkey Postgresql
)
[64] => Array
(
[isoid] => 47
[omschrijving] => Turnkey Prestashop
)
[65] => Array
(
[isoid] => 48
[omschrijving] => Turnkey Rails
)
[66] => Array
(
[isoid] => 49
[omschrijving] => Turnkey Redmine
)
[67] => Array
(
[isoid] => 50
[omschrijving] => Turnkey SiTracker
)
[68] => Array
(
[isoid] => 51
[omschrijving] => Turnkey StatusNET
)
[69] => Array
(
[isoid] => 52
[omschrijving] => Turnkey SugarCRM
)
[70] => Array
(
[isoid] => 53
[omschrijving] => Turnkey Symfony
)
[71] => Array
(
[isoid] => 54
[omschrijving] => Turnkey Tomcat
)
[72] => Array
(
[isoid] => 55
[omschrijving] => Turnkey Tomcat/Apache
)
[73] => Array
(
[isoid] => 56
[omschrijving] => Turnkey TRAC
)
[74] => Array
(
[isoid] => 57
[omschrijving] => Turnkey TWiki
)
[75] => Array
(
[isoid] => 58
[omschrijving] => Turnkey Typo3
)
[76] => Array
(
[isoid] => 59
[omschrijving] => Turnkey Wordpress
)
[77] => Array
(
[isoid] => 60
[omschrijving] => Turnkey Zencart
)
[78] => Array
(
[isoid] => 13
[omschrijving] => Ubuntu 10.04 32b
)
[79] => Array
(
[isoid] => 6
[omschrijving] => Ubuntu 10.04 64b
)
[80] => Array
(
[isoid] => 14
[omschrijving] => Ubuntu 12.04 32b
)
[81] => Array
(
[isoid] => 61
[omschrijving] => Ubuntu 12.04 64b
)
[82] => Array
(
[isoid] => 62
[omschrijving] => Ubuntu 12.10 64b
)
[83] => Array
(
[isoid] => 89
[omschrijving] => Ubuntu 14.04 LTS 64b
)
[84] => Array
(
[isoid] => 5
[omschrijving] => Windows Password Reset
)
[85] => Array
(
[isoid] => 81
[omschrijving] => Zen Loadbalancer 3.03
)
[86] => Array
(
[isoid] => 74
[omschrijving] => Zentyal 3.2
)
)
how would i go to fill it automatically in a option value like
<option value='74'>Zentyal 3.2</option>Thank you in advance Hello all. How would I loop through this array and find each "DTM" value? I want to be able to loop thru this array so that I can determine when to add 123, 456, ... 789, 1012 ... 123, 456 to a database. Hope this makes some sense... Thanks for any help on this one. Code: [Select] <?php $aryValues = array('DTM', '123', '456', 'DTM', '789', '1012', 'DTM', '123', '456'); ?> A HTTP request is made to the server, Slim creates a Request and Response object, content in the Request is sent to another server using cURL via Guzzle, Guzzle returns its own Response, and content from Guzzle's response must be returned by the original Slim response. Would you recommend white-listing or black-listing response headers, and which specific headers? Similarly, would you recommend white-listing or black-listing the request headers sent via cURL, and which specific headers? Thanks
<?php
use Psr\Http\Message\ResponseInterface as Response;
use GuzzleHttp\Psr7\Response as CurlResponse;
class ApiResponder
{
public function delete(Response $httpResponse, CurlResponse $curlResponse) {
return $this->proxy($httpResponse, $curlResponse);
}
//other public methods...
private function proxy(Response $httpResponse, CurlResponse $curlResponse) {
foreach($this->getResponseHeaders($curlResponse) as $name=>$value) {
$httpResponse=$httpResponse->withHeader($name, $value);
}
return $httpResponse->withBody($curlResponse->getBody())->withStatus($curlResponse->getStatusCode());
}
private function getResponseHeaders(Response $httpResponse):array
{
//Blacklist headers which should be returned to original client. TBD whether I should whitelist headers instead.
$blacklist=['Date'=>null, 'Server'=>null, 'X-Powered-By'=>null, 'Access-Control-Allow-Origin'=>null, 'Access-Control-Allow-Methods'=>null, 'Access-Control-Allow-Headers'=>null, 'Set-Cookie'=>null];
return array_diff_key($curlResponse->getHeaders(), $blacklist);
}
/**
* This method doesn't really exist in this class, but is just included to show which headers I am forwarding in the cURL request.
*/
private function getRequestHeaders($clientRequest):array
{
$whitelist=['connection'=>null,'accept'=>null,'accept-encoding'=>null,'accept-language'=>null,'content-type'=>null,'content-length'=>null];
return array_intersect_key($clientRequest->getHeaders(), $whitelist);
}
}
Hi all,
I have a looping error in my PHP.
I am trying to add use a while statement to gather the users first and last name in to a string, add them to an array called $friendname, then check that the $friendname[] is only output/echoed once.
At the moment the code looks good to me but with multiple rows with the same name associated, the name is echoed the same amount of times as rows, instead of once as it is supposed to be.
Any ideas anyone?
while($row2 = mysqli_fetch_assoc($result2)) {
$friendcode = $row2['Code'];
$names = "SELECT FirstName, LastName from users WHERE Code = '$friendcode' AND Code != '$crewcode'";
$resultnames = mysqli_query($cxn,$names)
or die ("Can't get friends names.");
while($rownames = mysqli_fetch_assoc($resultnames)) {
$friendname = array();
$newfriendname = ($rownames['FirstName'].' '.$rownames['LastName']);
if (!in_array($newfriendname, $friendname)) {
array_push($friendname, "$newfriendname");
echo $newfriendname;
}
}
}
<?php
$_SESSION["cart_item"] = array(
'cart_item' => array(
'id' => $id,
'product_name' => $product_name
));
}
$cart_items = $_SESSION["cart_item"];
foreach ($cart_items as $cart_item) {
echo $cart_item["id"] . $cart_item["product_name"];
}
?>
I have tried several variations of the foreach loop like the one above and I mostly get the error message: Notice: Array to string conversion. When I use: I get the following output: array(1) { ["cart_item"]=> array(2) { ["id"]=> array(2) { [0]=> string(1) "2" [1]=> string(1) "3" } ["product_name"]=> array(2) { [0]=> string(19) "Adult Female Bike" [1]=> string(18) "Kids Unisex Bike" } } } I've got a data array that looks like this: $arraylist = ('00101001','10001010','00010100','01100101'); And another that looks like this: $arrayposition = (0,3); The idea is to loop through $arraylist and when the loop gets to the indexes/positions listed in the $arrayposition array, to change all of the 1's to 0's, then put the values back into a string variable. I have something like this at the moment: $chores = 1; $arraylist_new = ''; foreach ($arrayposition as $value) { if ($chores != '') { $oldvalnum = 0; foreach($arraylist as $string) { if ($value == $oldvalnum) { $string = str_replace("1", "0", $string); if ($arraylist_new == '') {$arraylist_new = $string;} else {$arraylist_new .= ', ' . $string;} } else { if ($arraylist_new == '') {$arraylist_new = $string;} else {$arraylist_new .= ', ' . $string;} } $oldvalnum++; } } } echo $arraylist_new; The idea is for the output to be: 00000000, 10001010, 00000000, 01100101. I know the code is hinda hectic, but could someone please help?? Thanks in advance! Hello, I'm taking values for various cities/areas my members live in. One member can be placed in many cities and on registering they are required to input one city but are allowed to enter a maximum of 6 cities. So, from my posted form I have; //member ID (numeric) $MemID; $City=$_Post['City']; $City2=$_Post['City2']; $City3=$_Post['City3']; $City4=$_Post['City4']; $City5=$_Post['City5']; $City6=$_Post['City6']; Where $City must be set, but any of the other $City'x' may or may not be empty. There are two tables, 1) Cities (CityID,City) 2) Mem-Cities (MemID,CityID). I have some SQL statements which check if the city exists and if it doesn't inserts it. Then adds the $MemID to that $CityID. The way im doing this now is not very efficient like this; if(!empty($City)) { $sql="SELECT COUNT(City) AS Count FROM Cities WHERE City='$City'"; $query=mysql_query($sql); $row=mysql_fetch_array($query); if($row['Count'] == 0) { $insert="INSERT INTO Cities (City) VALUES ('$City')"; mysql_query($insert) OR die('<h1>There was an error adding into Cities</h1>' .mysql_error()); //inserting additional City } $insert="INSERT INTO Mem-Cities (MemID,CityID) SELECT '$MemID',CityID FROM Cities WHERE City='$City' LIMIT 1"; mysql_query($insert) OR die('<h1>There was an adding additional City Cities to members</h1>' .mysql_error()); //inserting additional city into Cities to Members } And repeating the code above for each city. How can I loop through each city and optimise this code? Steps 1) if $City'x' is not empty and doesn't exist in DB insert it 2) add the $MemID to that CityID Thanks! I have a array as follows and I want to look by key where the key is 'ABCD', 'EFGH', etc.. I am using foreach but it is not working. How can I accomplish this? Code: [Select] Array ( [0] => Array ( [ABCD] => Array ( [venue_id] => 1003 [has_dining] => X [table_count] => 0 [serves_alcohol] => X ) ) [1] => Array ( [EFGH] => Array ( [venue_id] => 1003 [has_dining] => X [table_count] => 0 [serves_alcohol] => X ) ) ) hello freaks,
I have a four-element array, which is the result of a mysql query. The array is like below. (This is of course just a snippet to show the structure; the hours of course go up to 24, then repeat; there are about ten days' worth of data.)
Array ( [dayname] => day1 [hour] => 1 [widtype] => type1 [Output] => 20 ) Array ( [dayname] => day1 [hour] => 2 [widtype] => type1 [Output] => 9 ) Array ( [dayname] => day1 [hour] => 1 [widtype] => type2 [Output] => 450 ) Array ( [dayname] => day1 [hour] => 2 [widtype] => type2 [Output] => 650 ) I want to loop through this data and output each hour's data in a separate line, like below (I included the headings just for clarity): Day Hour Type1_total Type2_total day1 1 20 450 day1 2 9 650 ... and can't seem to make this happen. Here's the code I've written:
$prevday = '';
while ( $row = mysql_fetch_assoc($result))
{
extract($row);
$currentday = $row['dayname'];
$currenthour = $row['hour'];
$currentwid = $row['widtype'];
while($currentday !== $prevday){
for($currenthour = 1; $currenthour <=24; $currenthour++){
if($row['widtype'] == 'type1'){ $type1_total = $row['Output'];}
if($row['fuel'] == 'type2'){$type2_total = $row['Output'];}
print "<pre>";
echo "$currentday, $currenthour, $type1_total, $type2_total";
print "</pre>";
}
$prevday = $currentday;
}
}
... and here's what it outputs:
day1, 1, 20, ,day1, 2, 20, , Clearly I have written this loop wrong but have banged my head against it for a while and wonder if it's just not possible to do what I want. Any suggestions would be hugely appreciated! Hi everyone, I am very new to PHP and trying to learn so please bear with me. I have a simple form which passes fields to a PHP script: <form method="post" action="cartaction.php"> <p> <input type="submit" name="submit" value="Buy" /> <input type="hidden" name="cartaction" value="add" /> <input type="hidden" name="item" value="steelcasserole" /> </p> </form> I am trying to produce a shopping cart type page which will display the item(s) purchased. The problem is I have more than one submit button on the page for different products but with the same fields. I have tried to create the cartaction.php script to save the information from the form in a session variable which will allow me to output the item(s) purchased into this page prior to sending everything to a checkout page. I can get the information to appear for a single item but the problem is I want to output the details for each product added to the cart. At the moment, when I go back to the products page and try to add a new item to the shopping cart it just replaces the previous item that was there rather than retaining it and adding a new item underneath. I realise its probably really obvious but I am really new to this and getting myself confused! Any help on how to add an item then be able to go back to the products page (with the submit buttons for each product) and add a new item underneath the existing item in the shopping cart would be much appreciated! The code I have so far is: $submit = $_POST["submit"]; //If form is submitted, call the function and save all data into the array $_SESSION['form'] if($submit = "Buy"){setSessionVars();} function setSessionVars() { foreach($_POST as $fieldname => $fieldvalue) { $_SESSION['form'][$fieldname] = $fieldvalue; } echo "<table> <tr> <td>" .'<img src="images/'.$_SESSION['form']['item'].'.jpg"' . "<td/> <td>" . $_SESSION['form']['item'] . "</td> <td>" . '<input type="text(30)" name="value" value="1" /> <input type="submit" name="puchasednum" value="Update This One Item" />' . "</td> </tr> </table>"; }; ?> I have the session_start() function at the very top of every page. I have also attached the entire files for the two pages I talk about above. Thanks Graham I have an array which I contains multiple arrays, I would like to loop through and run a function on a certain key within the array I have the following code which works but I was wondering if there was a better method? $i = 0; foreach($Items as $Item) { $Items[$i]['key'] = custom_function($Item['key']); $i++; } The array $Items structure is as follows Code: [Select] array ( [0] => array ( [key] => 'blah' ) [1] => array ( [key] => 'blah' ) [2] => array ( [key] => 'blah' ) ) Hi there, I have the following PHP code: <?php $books = array( array("title"=>"Book Title 1", "author"=>"Author 1", "publisher"=>"Publisher 1"), array("title"=>"Book Title 2", "author"=>"Author 2", "publisher"=>"Publisher 2"), array("title"=>"Book Title 3", "author"=>"Author 3", "publisher"=>"Publisher 3"), ); foreach ($books as $key => $value) { echo "$key : $value<br>"; } ?> I'm trying to loop through this code, but all it outputs is: 0: ARRAY 1: ARRAY 2: ARRAY -- It's not even pulling the proper $keys and $values. It works when there's just ONE array -- but not with this multidimensional array. Any ideas? Thanks! J Hello all.. This one's sort of difficult to explain, but yet it should be a pretty simple solution.. What I'm trying to do is loop through an array that has either single event id's or a group of event id's, and run a condition on the change of id's while looping.. Sort of grouping each set if unique id's within a new event section.. Here's sort of a test code I put together: Code: [Select] <?php $result = array( array('event_id' => 70), array('event_id' => 70), array('event_id' => 70), array('event_id' => 95), array('event_id' => 96), array('event_id' => 97), array('event_id' => 98), array('event_id' => 99), array('event_id' => 145), array('event_id' => 145), array('event_id' => 145), array('event_id' => 145), array('event_id' => 166), array('event_id' => 166), array('event_id' => 177), array('event_id' => 200), array('event_id' => 200), array('event_id' => 200) ); $previous_id = ''; foreach($result as $row){ if ($row['event_id'] != $previous_id) { echo '<div style="background:#ccc;">New Event</div>'; } if ($previous_id > 0 && $row['event_id'] != $previous_id) { echo '<table border="1"><tr><td>'.$row['event_id'].'</td></tr></table>'; $previous_id = ''; } else { echo $row['event_id'].'<br />'; $previous_id = $row['event_id']; } } ?> It's about half way working, but there are issues when the ids change and they are either single event ids in a row, or multiple same event ids in a row.. I can't think how to set the $previous_id variable properly on each loop.. Well, figured I'd throw it out there and see what happens.. Thanks.. Hi all, I'm trying to set up a situation where a function loops through a multidimensional array and echos an html block for each item in the $skus['skunum'] array and also increments $i each time . ( Each is a product on the site) The catch is that I'm trying to have a function within that one that goes through the $skus['sizes'] and echoes an option if the substring (shirt size) exists. The idea being that I can manage products by adding 4 elements, Skunum, name, price and size. And well, I'm failing miserably. At this point it won't even work because of the variable scope, I'm getting Notice: Undefined variable: skus from the functions, but am not sure of the right way to get that information. Am I going about doing this entirely wrong or am I on the right track? Code: [Select] <?php $BANDNAME="Apocalypse"; $BANDCAPS="APOCALYPSE"; $BANDLOWER="apocalypse"; $SKUCAPS="FGD"; $skus = array ( "skunum"=>array ( "101", "102", "103", "104", "105", "106", "107", "108", "109", "110", "111", "112" ), "name"=>array ( "RIDDICK /TSHIRT", "MAFIA / TSHIRT", "ORACLES / TSHIRT", "AGONY / TSHIRT", "BLOODY VIOLINIST / TSHIRT", "THE VIOLATION / TSHIRT", "AGONY-TOUR DATES / TSHIRT", "BAND PHOTO / TSHIRT", "SILVER AGONY LOGO / TSHIRT", "PHOENIX-TOUR DATES / TSHIRT", "PHOENIX / TSHIRT", "BLOODY VIOLINIST / ZIP HOOD" ), "price"=>array ( "15.95", "15.95", "15.95", "15.95", "15.95", "15.95", "15.95", "15.95", "15.95", "15.95", "15.95", "42.95" ), "sizes"=>array ( "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X", "S, M, L, 1X, 2X, 3X, 4X" ) ); function makeProducts() { //Products Sizes $sizes = $skus['sizes'][$i]; $S="S";$M="M";$L="L";$XL="1";$XXL="2";$XXXL="3";$XXXXL="4"; $small = strpos($sizes,$S); $medium = strpos($sizes,$M); $large = strpos($sizes,$L); $xlarge = strpos($sizes,$XL); $xxlarge = strpos($sizes,$XXL); $xxxlarge = strpos($sizes,$XXXL); $xxxxlarge = strpos($sizes,$XXXXL); function sizeOptions () { if($small === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'S">S</OPTION>'; } if($medium === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'M">M</OPTION>'; } if($large === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'L">L</OPTION>'; } if($xlarge === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'X">XL</OPTION>'; } if($xxlarge === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XX">XXL</OPTION>'; } if($xxxlarge === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXX">XXXL</OPTION>'; } if($xxxxxlarge === true) { echo '<OPTION value="'.$SKUCAPS.$skus['skunum'][$i].'XXXX">XXXXL</OPTION>'; } } foreach ( $skus['skunum'] as $value){ echo '<!-- PRODUCT BEGIN --> <li class="product" > <a href="product_files/large/'.$SKUCAPS.$skus['skunum'][$i].'jpg" rel="lightbox"><img src="product_files/'.$SKUCAPS.$skus['skunum'][$i].'.png"></a><br> <strong>'.$skus['name'][$i].'</strong><br>('.$SKUCAPS.$skus['skunum'][$i].')<br>$'.$skus['price'][$i].'<br> <form name="'.$SKUCAPS.$skus['skunum'][$i].'" method="GET" target="_blank" action="http://www.jsrdirect.com/cgi-bin/Make-a-Store.cgi"> <input type="hidden" name="band" value="'.$BANDCAPS.'"> <input type="hidden" name="back" value="http://www.jsrdirect.com/bands/'.$BANDLOWER.'/index.html"> <strong>Qty:</strong> <input type="text" name="quantity" size="1" value="1" > <strong>Size:</strong> <SELECT name="item">' .sizeOptions(); '</SELECT> <br><br> <input type="image" src="images/addtocart.png" value="Add To Cart"> </form> </li> <!-- Product End -->'; } } // End Function ?> -First I want to say that I love this site and always check google before I submit questions but im lost. I'm into security and trying to learn a little Apache, Mysql, and PHP to understand the development cycle better. As practice im creating a notecard test review site. Create notecard Decks, add/delete questions etc. shuffle, then test yourself. I though I was doing good until I got to the page that shows the questions (test.php). Right now I pass the "deck_id" field in a GET to a "test.php?id=" page that runs a script that pulls out all the questions for that deck from my "questions" table and loops to show each question for that "deck". My loop works, (gets array from database and shows questions one by one), but it writes all the questions to the page at the same time. DUH. I want it to show one question with a "NEXT" button to show next question. This button clears the first question and writes the next one until they are all done. No grading or anything needed. Is there a way to do this gracefully? I dont know much javascript but looked up innerHTML and see i can update text that way but the PHP loop I have goes so fast it just end up showing the last question with no way to pause it between questions. Can anyone think of a way to do this? My problem is passing the data from page to page to page (I lose the array data) If this is impossible my other thoughts a 1) store current list of Q/A's in cookie (OR) 2) pass Q/A to another page with POSTS (OR) 3)store Q/A's to temporary sql table and use GETS in loop to show each one by one. "testing.php?question=1" 4) can i set a global variable that can pass the data to separate pages? 5)user iFrame so it looks like one page (dont know how) Im leaning to number 3 but want to hear your suggestions. (sorry very new) I'm pulling a list of topics from my DB and they are structured hierarchally using the typical id | parent_id scheme The array I end up with from the DB is one large one with keys representing the unique id of each data result...The problem is getting past the 2d scope of the array. I know this will require a recursive function and I've been at it for hours but can't seem to wrap my hurting head around it! How do I get my orignal array in this form: Array ( [0] => Array ( [1] => top parent [2] => top parent [3] => top parent [9] => top parent ) [2] => Array ( [4] => #1 child of 2 [5] => #2 child of 2 ) [3] => Array ( [6] => #1 child of 3 ) [4] => Array ( [7] => #1 child(subsub) of 4 [8] => #2 child(subsub) of 4 ) ) To look something more like this? : Array ( [1] => top parent [2] => Array ( [4] => Array ( [7] => #1 child(subsub) of 4 [8] => #2 child(subsub) of 4 ) [5] => #2 child of 2 ) [3] => Array ( [6] => #1 child of 3 ) [9] => top parent ) notice how the 2nd array has all the proper dimensions according the the DB hierarchy. Thank you ps. or maybe I should work from a different array to start from...I'm open to suggestions 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] |
|||||||