Learn VBA & Macros in 1 Week!

PHP - Looping Through An Ajax Response And Put It To A Table

Full Excel VBA Course - Beginner to Expert

Looping Through An Ajax Response And Put It To A Table	View Content

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 &quot;a&quot;" 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.

Full Excel VBA Course - Beginner to Expert

Looping Through Returned Response From Api

Similar Tutorials

View Content

It'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

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

How To Debug/log 500 Error In Ajax Response

Similar Tutorials

View Content

I'm trying to debug a sporadic 500 error which users occasionally get when filling out form sections on my site. Whenever it happens, I try to recreate their environment and fill out the form exactly as they have done, but can never recreate the issue. I have checked my application logs for the framework I am using, but they report nothing related to the error. I'm hoping someone here might be able to help me catch this. This is where the 500 error is sometimes happening and this triggers the error which users report:

Code: [Select]
//In jquery AJAX function, which submits data to PHP form for processing
error: function(data,transport){
$.validationEngine.debug("error in ajax response: "+data.status+" "+transport)
}
Is there a way for me to try and catch what the exact error is here? The problem is I can't recreate the error, either using an AJAX call or not to call the PHP script. I need to catch the error response from the PHP script being called, but I never get an error when trying to recreate the user issue, i.e same OS/browser/form answers. The Apache error logs for the site have very little - unless I'm looking in the wrong place. I'm on CentOS, ran locate error_log and got an error_log.txt file in my vhosts directory for my site, but this just contained a 302 message log, nothing else. I also tried locate error | grep mysite.

Creating Some Arrays From Ajax Response Text

Similar Tutorials

View Content

Hi,

I have an ajax response text string that looks something like this: "part2=true;part7=false;part9=false;..."
I would like to turn this string into an array, that looks like this:

part2 = true
part7 = false
part9 = false

I know to use the explode function, but that will only break it into an array either by using the "=" or ";" as a delimiter....
Thank you for any help.

Setting Response Headers Based On Curl Response

Similar Tutorials

View Content

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);
    }
}

Looping Through Mysql Table Columns

Similar Tutorials

View Content

So I have a database that is structured like this: https://imgur.com/a/DdyTqiE
Sample data: https://imgur.com/a/kYwmuO1
For each appointment, a student can have multiple categories, such as 'Academic Probation, Re-Admit' etc...

I would like to loop through this table, and get a count of how many were 'is_no_show' and 'is_cancelled' per (unique) category with respect to 'scheduled_student_services.'
For example, in the sample data, we see that the first appointment has 4 categories (Academic Probation, Entering Cohort Year 20051, First Generation, and Re-Admit'). Now one of these categories - Academic Probation matches up with what they were scheduled for - '1st Term Probation Advising'. And they cancelled this appointment, so we want the count of cancellations under Academic Probation to go up by 1.

How would I approach this? I know I probably need to do two loops but I'm not sure the PHP syntax for this. Any suggestions or tips would be helpful. Thank you for your time!

Looping Through 2 Mysql Tables And Update One Table

Similar Tutorials

View Content

Hi all

I have 2 tables:
1. is a tables full of images that have an id, a src and a title (images_table).
2. table is a list of records with an id, a description and an images_id (records_table)

What I'm looking to do is:

Loop through the records in the records_table and find the description, the description is something like this 'Welcome to Kansas'. Then, I want to loop through the images_table and find the associated image of Kansas, based on a MySQL LIKE statement.

This is because the images_table has a title of 'Kansas', for example. Once this has been done, I then need to insert the id of Kansas into the images_id in the records_table a possible MySQL UPDATE.

Has anyone got an idea how I could do this?

Thanks

Looping Through A Joined Table Then Inserting Into Two Tables

Similar Tutorials

View Content

No idea what I am doing here. I have a joined table which is:

$sql = "SELECT itemnum, image1, title, close, quantity, bidquantity, ".
          "bidprice, buyitprice, seller, biditem, buser, bidder " .
          "FROM Items LEFT OUTER JOIN Bids " .
          "ON Items.itemnum = Bids.biditem " .
          "WHERE buser != '' and close > '$time' and outbid = '0'".
          #"GROUP BY buser " .
          #"HAVING bidder=$buser or buser=\'$busername\' ".
          "ORDER by buser";
$result = mysqli_query($con, $sql) or die ( mysqli_error());
$row = mysqli_fetch_assoc($result);

I need to loop through the table on buser and insert select data into two other tables. One of the tables is the control table which will only have one row per buser. The other table I guess you would call the data table of the two and may have more than one row depending. The catch is these will be linked together by an invoice number. Table A, the control table has a field for invoice number, table B does not. Of course once the data is inserted into the new tables they will be joined and from there on it should be easy. I just don't know now how to get there. I've thought about using an array to loop through, but I don't know enough about them to make any sense of this. Not even sure the group by may help me in doing this.

Anyone have any ideas on this? I sure do need it and thanks in advance!

Looping Through A Database Table A Limited Number Of Times.

Similar Tutorials

View Content

Hello,

I'm new! I am trying to populate a list of locations based on ratings. I can populate the list just fine but it's displaying every record in the table. Is there a way of only looping 4 times so as to just display the top 4 records?

Here's the code:

Code: [Select]
$result = mysql_query("SELECT * FROM locations ORDER BY rating DESC");

while($row = mysql_fetch_array($result))

{

echo $row['name'];
echo "<br>;

}

Thankyou in advance for any help

Ajax Is A Killer. Can Anyone Help Me Delete A Php Record Using Ajax?

Similar Tutorials

View Content

Right now I redirect to index page after I delete a record. However I am looking to make it so that I can delete a record without redirecting the page. I know this can be accomplised using Ajax. I have spent countless hours before trying to make it work, but it did not work. So here is a basic setup I created. Can you please update it with ajax code so that I can see how it's done properly?

<!DOCTYPE HTML>
<html lang="en"> 
	<head>
		<meta charset="UTF-8">
		<title>Home Page</title>
	</head>
	<body>
	
	<div class="record" >
		<a href="record.php?id=<?php echo $record_id ?>"><?php echo $record_name; ?></a>
		<div class="delete-record">
			<a href="delete.php">Delete Record</a>
		</div>
	</div>	
	
	</body>
</html>

Edited by man5, 18 August 2014 - 08:55 PM.

Problems With Ajax (not Sure But I Think It Might Be Ajax Causing It)

Similar Tutorials

View Content

Now I'm having this strange issue with my website

I'm currently working on a tester system and I've encountered a problem that I'm unable to find the issue, tho I'm thinking my ajax php part of the script to be the thing causing it even tho it seems strange that it would cause it.

The first part which is connected to where the problem occurs is the echo"<form>"; and from there, It should take you to index.php?page=tester&select=answer, now that is where it in the browser goes there tho it still shows the page stuff from the last page which is index.php?page=tester&select=applications, so it's like showing both &select=answer and &select=applications on the same page.
<?php
$q=$_GET["q"];
include'../config/connection.php';
$result = mysql_query("SELECT * FROM applications WHERE id = '$q'");

echo "<center><table border='1'>
<tr>
<th>Account Name</th>
<th>Character Name</th>
<th>Gender</th>
<th>Skin Color</th>
</tr>";

$row = mysql_fetch_array($result);
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['charactername'] . "</td>";
  echo "<td>" . $row['gender'] . "</td>";
  echo "<td>" . $row['race'] . "</td>";
  echo "</tr></table></center>";
  echo"<br/>";
  echo"<table><tr>
  <th>Description</th>
<th>Metagaming</th>
<th>Powergaming</th></tr>";
echo"<tr>";
  echo "<td><textarea readonly='readonly' style='width:22em; height:20em;'>".$row['description']."</textarea></td>";
  echo "<td><textarea readonly='readonly' style='width:22em; height:20em;'>".$row['mg']."</textarea></td>";
  echo "<td><textarea readonly='readonly' style='width:22em; height:20em;'>".$row['pg']."</textarea></td>";
  echo"</tr></table><table><br/><center><h1>Answer</h1><br/><form action='index.php?page=tester&select=answer' method='post'>";
  echo"<textarea name='why' style='height:10em; width:60em;'></textarea><br/>";
  echo"<input type='submit' name='answer' value='Accept' /><a/>";
  echo"<input type='submit' name='answer' value='Decline' /></center>";
  echo"<input type='hidden' name='id' value='$q'/>";
  echo"</form></table>";
?>
Now on &select=answer it included a page which the script of that include consist of the stuff below, it outputs that the query was successfully, and all that.
<?
if(!empty($_POST['why']))
   {

$why = mysql_real_escape_string($_POST['why']);

$answer = trim($_POST['answer']);

$id = $_POST['id'];

if($answer == "Accept")

{

$query1 = mysql_query("UPDATE characters SET accepted = '1' WHERE id = '".$id."'");

echo"Successfully accepted";

$answer = 1;

}

elseif($answer == "Decline")

{

echo"Successfully declined";

$answer = 0;

}

$query = mysql_query("UPDATE applications SET answer = '$why' AND tester = '".$_COOKIE['Username']."' AND accepted = '$answer' AND answered = '1' WHERE cid = '".$id."'") or die('Could not connect: ' . mysql_error());

if($query)

{

echo"<br/>Query went through without problems";

header("Refresh: 5;url=index.php?page=tester");

}
}
?>
This is the ajax part javascript of it which gets the information for index.php?page=tester&select=applications
Code: [Select]
<script type="text/javascript">
function showApplication(str)
{
if (str==""||str==0)
{
document.getElementById("txtHint").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","tester/applications.php?q="+str,true);
xmlhttp.send();
}
</script>If you need any more information feel free to ask for it.
Thanks in advance.

Loop Ajax Call With Data Returned From Previous Ajax Call

Similar Tutorials

View Content

Hello,

I've been trying this for hours now, looking at different examples and trying to change them to work for me, but with no luck...

This is what I am trying to do:

I have a simple form with:
- 1 input field, where I can enter a number
- 1 Submit Button

When I enter a number into the field and click submit, I want that number to be send to the php file that is in the ajax call, then the script will take that number and run a bunch of queries and then return a new number. I want that new number to be used to call the php script via ajax again, until no number is returned, or something else is returned like the word "done" or something like that, at which point is simply makes an alert or populated a div with a message...

The point is, that depending on the number entered it could take up to an hour to complete ALL the queries, so I want the script that is called to only run a fixed amount of queries at a time and then return the number it is currently at (+1), so that it can continue with the next number when it is called again.

I would like to use jquery, but could also be any other way, as long as I get this to work. I already have the php script completed that needs to be called by the ajax, it returns a single number when being called.

Thank you,
vb

Php Performing On Xml Response

Similar Tutorials

View Content

I send off this:

<?php
$data = "<egateway>
<eCardExpiryMonth>01</eCardExpiryMonth>
<eCardExpiryYear>04</eCardExpiryYear>
<eCardHoldersName>Joe Bloke</eCardHoldersName>
<eCardNumber>4444333322221111</eCardNumber>
<eCVN>123</eCVN>
<eTotalAmount>100</eTotalAmount>
</egateway>
";
$ch = curl_init();
curl_setopt($ch, CURLOPT_POSTFIELDS, $edata);
curl_setopt($ch, CURLOPT_URL, "https://www.example.com/gateway_cvn/testpage.asp");
curl_exec($ch);
curl_close($ch);
?>

In return, I get the following XML:

Code: [Select]
<eResponse>
<eTrxnStatus>True</eTrxnStatus>
<eTrxnNumber>20219</eTrxnNumber>
<eAuthCode>123456</eAuthCode>
<eReturnAmount>100</eReturnAmount>
<eTrxnError>00,Transaction Approved(Test CVN Gateway)</eTrxnError>
</eResponse>

Is there a way to make it so this does not show, and instead I can make PHP do something like:

if (eTrxnStatus == True) {// do stuff};

?

2 Responses In The Same Response?

Similar Tutorials

View Content

Hello All, running into a situation that I have not seen before. I have been seeing in multiple areas of my application that the response received from the server has 2 JSON responses in it. Here is a sample function:

private function getCatalogItems(){

$start = ($_REQUEST["start"] == null)? 0 : $_REQUEST["start"];

$count = ($_REQUEST["limit"] == null)? 20 : $_REQUEST["limit"];

$q = "SELECT c.`id`, c.`catalog_number`, c.`long_description`, CONCAT(c.`catalog_number`, ' - ', c.`long_description`) AS `display`

FROM catalog c";

if(!empty($_REQUEST['query'])){

$q .= " WHERE c.`catalog_number` LIKE '%".$_POST['query']."%'";

}

$q .= " ORDER BY c.`catalog_number` ASC LIMIT ".$start.",".$count;

$rs = $this->db->get_results($q);

$total = $this->db->num_rows;

$buff = '{"total":"'.$total.'","data":'.json_encode($rs).'}';

$this->c->returnJSON($buff);

}

The "returnJSON" function looks like this.

public function returnJSON($json){

$contentType = "application/json; charset=utf-8";

header("Content-Type: {$contentType}");

header("Content-Size: " . strlen($json));

echo $json;

}

As you can see this simply sets the headers of the response. It has been a real head scratcher. Anyone come across something like this before?

A Response With No Function?

Similar Tutorials

View Content

How can I receive a response from the server with JSON data, when the function that retrieves the data and returns it to the browser has been completely commented out?

I am making an AJAX request for JSON formatted data and for some reason it returns a response when it shouldn't as there is no function?

Webservice Response In Xml

Similar Tutorials

View Content

Hello,

I'm trying to get webservice response in xml format. I'm getting the response but it's not in xml. It's just text.

Can someone please look at the code ?

<?php

$targeturl="https://api.com";

$DevKey= "xxxxx";

// return xml feed

$ch = curl_init($targeturl);
curl_setopt($ch, CURLOPT_POST, FAlSE);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Authorization: '.$DevKey));
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$response = curl_exec($ch);
$xml = new SimpleXMLElement($response);
curl_close($ch);
echo $response; // will print in browser all country codes in an xml format

/*

ADD YOUR OWN CODE HERE TO DO WHAT YOU WANT WITH THE RESPONSE. MAYBE SAVE RESULTS TO A FILE OR THE PARSE THE RESULTS INTO A DATABASE?

*/

?>

No Response Returned

Similar Tutorials

View Content

When I submit the login form its not returning anything and it was working until I added in the $remember part so I'm wondering why its still not returning TRUE.

Code: [Select]
/**
* Login user on the site. Return TRUE if login is successful
* (user exists and activated, password is correct), otherwise FALSE.
*
* @param string
* @param string
* @param int
* @return bool
*/
function login($username, $password, $remember)
{
$this->ci->load->model('kow_auth/users');
$user_data = $this->ci->users->get_user_by_username($username);

if ($user_data)
{
$regenFromPostPW = $this->ci->genfunc->reGenPassHash($password, $user_data->password2);
if ($regenFromPostPW == $user_data->password)
{
$this->ci->session->set_userdata(array(
'xtr' => 'yes',
'user_id' => $user_data->user_id,
'username' => $user_data->username,
'status' => $user_data->users_statuses_id,
'role' => $user_data->users_roles_id
));
if ($remember == 1)
{
$timeTOexpire = time()+(60*60*24*31*2);
$this->input->set_cookie('xtrcook', '1', $timeTOexpire);
}
else
{
$cookie = trim(get_cookie('xtrcook'));
if ($cookie || is_numeric($cookie))
{
delete_cookie('xtrcook');
}
}
$this->clear_login_attempts($user_data->user_id);
$this->ci->users->insert_session($this->ci->session->userdata('session_id'), $this->ci->session->userdata('user_id'), $this->ci->genfunc->getRealIpAddr(), $this->ci->genfunc->getUserOS());
return TRUE;
}
else
{
$this->increase_login_attempt($user_data->user_id);
}
}
else
{
return NULL;
}
}

Snmpset: No Response

Similar Tutorials

View Content

Hello All,

Just working with PHP's snap v1 functions I can use snmpget fine but snmpset produces the following error;

Warning: snmpset() [function.snmpset]: No response from 192.....

Code

Code: [Select]
<?PHP

echo 'File started <br />';

$ip = '192.168.1.100';
echo 'Read:<br />';
$sysdescr = snmpget($ip, 'public', '.1.3.6.1.4.1.17095.3.4.0', 300);

echo $sysdescr;
echo 'Write Started:<br />';
snmpset("$ip", 'public', '.1.3.6.1.4.1.17095.4.7.2.0', 's', 'sam@samtwilliams.co.uk', 300);

?>
Like i said the get works fine just the set does not.

Does anyone have any ideas?

Sam

Why Mysql Gives No Response ?

Similar Tutorials

View Content

Folks,

I have a mysql tbl called "links".

In it a column named "keywords".

The row 0 has a keyword "search" in the "keywords" column.

I am doing a search for the words "search" in the html form. Clicking the button gives no response! What is wrong ?

I get no mysql connection error. Nor any php error. So it should work and respond!

	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>

Full short code ...

	<?php
//include('error_reporting.php');
ini_set('error_reporting','E_ALL');//Same as: error_reporting(E_ALL);
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
?>
	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['search_links']))
    {
        if(ISSET($_POST['keywords']))
        {
            $keywords = $_POST['keywords'];
        }        
        
        mysqli_report(MYSQLI_REPORT_ALL|MYSQLI_REPORT_STRICT);
        mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
        
        $conn = mysqli_connect("localhost","root","","test");
        $db_server = 'localhost';
        $db_user = 'root';
        $db_password = '';
        $db_database = 'test';
        $conn->set_charset('utf8mb4');//Always use Charset.
        
        if (!$conn)
        {
            //Error Message to show user in technical/development mode to see errors.
            die("Database Error : " . mysqli_error($conn));
            
            //Error Message to show User in Layman's mode to see errors.
            die("Database error.");
            exit();
        }
	        $query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE keywords = ?";
	        $stmt = mysqli_stmt_init($conn);
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
	            $result = mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            mysqli_stmt_execute($stmt);
            
            mysqli_stmt_fetch($stmt);
            
            while(mysqli_stmt_fetch($result))
            {
                echo "url"; echo "<br>";
                echo "anchor_text"; echo "<br>";
                echo "description"; echo "<br>";
                echo "keyphrases"; echo "<br>";
                echo "keywords"; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            echo "1. QUERY failed!";
        }
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
            mysqli_stmt_execute($stmt);
            
            $result = mysqli_stmt_get_result($stmt);
            
            while($row = mysqli_fetch_array($result,mysqli_assoc))
            {
                $page_url = $row['page_url']; echo $page_url; echo "<br>";
                $link_anchor_text = $row['link_anchor_text']; echo $link_anchor_text; echo "<br>";
                $page_description = $row['page_description']; echo $page_description; echo "<br>";
                $keyphrases = $row['keyphrases']; echo $keyphrases; echo "<br>";
                $keywords = $row['keywords']; echo $keywords; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("2. QUERY failed!");
        }
    }
}
	
?>

Blank Json Response

Similar Tutorials

View Content

Hi I'm having this issue, when i put an url who must show me records i have blank html page

<?php
error_reporting(E_ALL | E_NOTICE);
ini_set('display_errors', '1');
require_once 'database_connection.php';
	$post=array(
		'limit'=>(isset($_REQUEST['rows']))?$_REQUEST['rows']:'',
		'page'=>(isset($_REQUEST['page']))?$_REQUEST['page']:'',
		'orderby'=>(isset($_REQUEST['sidx']))?$_REQUEST['sidx']:'',
		'orden'=>(isset($_REQUEST['sord']))?$_REQUEST['sord']:'',
		'search'=>(isset($_REQUEST['_search']))?$_REQUEST['_search']:'',
	);
	$se ="";
	if($post['search'] == 'true'){
		$b = array();
		$search['like']=elements(array('utilizador','email'),$_REQUEST);
		foreach($search['like'] as $key => $value){
			if($value != false) $b[]="$key like '%$value%'";
		}
		$search['where']=elements(array('nome','utilizador','email'),$_REQUEST);
		foreach($search['where'] as $key => $value){
			if($value != false) $b[]="$key = '$value'";
		}
		$se=" where ".implode(' and ',$b );		
	}
	$query = mysql_query("select count(*) as t from utilizador".$se);
	if(!$query)
		echo mysql_error();
	$count = mysql_result($query,0);
	if( $count > 0 && $post['limit'] > 0) {
		$total_pages = ceil($count/$post['limit']);
		if ($post['page'] > $total_pages) $post['page']=$total_pages;
		$post['offset']=$post['limit']*$post['page'] - $post['limit'];
	} else {
		$total_pages = 0;
		$post['page']=0;
		$post['offset']=0;
	}
	$sql = "SELECT idutilizador, nome, utilizador, telefone, email, password FROM utilizador  ".$se;
	if( !empty($post['orden']) && !empty($post['orderby']))
	$sql .= " ORDER BY $post[orderby] $post[orden] ";
	if($post['limit'] && $post['offset']) $sql.=" limit $post[offset], $post[limit]";
	elseif($post['limit']) $sql .=" limit 0,$post[limit]";
	$query = mysql_query($sql);
	if(!$query)
	echo mysql_error();
	$result = array();
	$i = 0;
	while($row = mysql_fetch_object($query)){
		$result[$i]['id']=$row->idutilizador;
		$result[$i]['cell']=array($row->idutilizador,$row->nome,$row->utilizador,$row->telefone,$row->email,$row->password);
		$i++;	
	}
	$json = new stdClass();
	$json->rows=$result;
	$json->total=$total_pages;
	$json->page=$post['page'];
	$json->records=$count;
	echo json_encode($json);	
	function elements($items, $array, $default = FALSE)
	{
		$return = array();
		if ( ! is_array($items)){
			$items = array($items);
		}
		foreach ($items as $item){
			if (isset($array[$item])){
				$return[$item] = $array[$item];
			}else{
				$return[$item] = $default;
			}
		}
		return $return;
	}
?>

*Update It works if i put

$result[$i]['cell']=array($row->idutilizador,$row->telefone,$row->email,$row->password);

So i'm think it's because in $nome(ex: Luis Miguel) and $utlizador(ex Susana Maria) don't accept this (space between words) it is correct?
Edited by alphasil, 19 January 2015 - 08:54 AM.