Databases
StackOverflow2013
Postsdbo
POHelp me xml parsing in php
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHelp me xml parsing in php
    primarykey
    data
    text
    <p>I have an xml response from zoho recruit API. I just need to parse it get values of a few attributes and nodes(whatever you call it). And then update them and submit back. The xml is given below. Like If i want to check what is first name it should return TEst1 and when I want to update it I should get updated and then I have to save it in a string format. Help me to figure this out.</p> <pre><code>&lt;?xml version="1.0" encoding="UTF-8" ?&gt; &lt;response uri="/ats/private/xml/Candidates/getRecords"&gt; &lt;result&gt; &lt;Candidates&gt; &lt;row no="1"&gt; &lt;FL val="RESUMEID"&gt;&lt;![CDATA[93327000000109297]]&gt;&lt;/FL&gt; &lt;FL val="Modified by"&gt;&lt;![CDATA[Not specified]]&gt;&lt;/FL&gt; &lt;FL val="Modified time"&gt;&lt;![CDATA[Yesterday]]&gt;&lt;/FL&gt; &lt;FL val="Candidate ID"&gt;&lt;![CDATA[677]]&gt;&lt;/FL&gt; &lt;FL val="First name"&gt;&lt;![CDATA[TEst1]]&gt;&lt;/FL&gt; &lt;FL val="Last name"&gt;&lt;![CDATA[TEst2]]&gt;&lt;/FL&gt; &lt;FL val="Residental Address"&gt;&lt;![CDATA[TESTing res address]]&gt;&lt;/FL&gt; &lt;FL val="Email ID"&gt;&lt;![CDATA[test1@email.com]]&gt;&lt;/FL&gt; &lt;FL val="Mobile Phone"&gt;&lt;![CDATA[123456789]]&gt;&lt;/FL&gt; &lt;FL val="Created On"&gt;&lt;![CDATA[Yesterday]]&gt;&lt;/FL&gt; &lt;FL val="Owner"&gt;&lt;![CDATA[0]]&gt;&lt;/FL&gt; &lt;FL val="Source"&gt;&lt;![CDATA[Embed]]&gt;&lt;/FL&gt; &lt;FL val="Employment Preference"&gt;&lt;![CDATA[Contract (Full Time), Permanent (Full Time), Contract (Part Time), Permanent (Part Time)]]&gt;&lt;/FL&gt; &lt;FL val="Cover Letter" type="url" url="https://recruit.zoho.com/ats/viewPhoto?filename=tVmTJJk2PIGQSgJSgY2fTzZfMgYE*W1ZBQ.KWiE6q68UOoUiAiY8ElcJtvxybS4bvD4mCWuA8aE-"&gt;&lt;![CDATA[samplecoverletter.txt]]&gt;&lt;/FL&gt; &lt;FL val="Total work exp (year)"&gt;&lt;![CDATA[10]]&gt;&lt;/FL&gt; &lt;FL val="Current Role"&gt;&lt;![CDATA[Administrative Officer]]&gt;&lt;/FL&gt; &lt;FL val="Current Role if Other"&gt;&lt;![CDATA[current_role_if_other]]&gt;&lt;/FL&gt; &lt;FL val="Current Employer/Customer"&gt;&lt;![CDATA[Current_employer_name]]&gt;&lt;/FL&gt; &lt;FL val="Skill sets"&gt;&lt;![CDATA[skill_sets_goes_here]]&gt;&lt;/FL&gt; &lt;FL val="Roles"&gt;&lt;![CDATA[Consultant, 93327000000068819, Administrative Officer, Application Developer, Business Analyst, Change Manager, Business Development, Chief Technology Officer, Chief Information Officer, Chief Executive Officer, Data Analyst, Director, IT Manager, Implementation Mgr, Functional Analyst, PMO Manager, Other, Network Admin, Portfolio Manager, Program Manager, Project Admin, Project Manager (Jnr), Project Lead, Project Director, Project Manager (Mid), Project Manager (Snr/Principal), Project Officer, Project Scheduler, Service Delivery Mgr, Release Manager, Quality Manager, Solutions Architect, Systems / Technical Analyst, Systems Administrator, Technical Support, Technical Architect, Systems Engineer, Test Analyst, Test Manager]]&gt;&lt;/FL&gt; &lt;FL val="Role (if "Other")"&gt;&lt;![CDATA[Role_other]]&gt;&lt;/FL&gt; &lt;FL val="Industries"&gt;&lt;![CDATA[93327000000068909, 93327000000070037, Aviation, Consulting, Contact Centres, Construction / Engineering, Council, Defense, Education, Energy, Finance/Banking, Gaming, Government, Health / Medical, Hospitality, ICT, Insurance, Manufacturing, Media, Mining, Other, Rail, Retail, Phamacetical, Telecommunications, Transportation, Utilities]]&gt;&lt;/FL&gt;&lt;FL val="Expected Rate/Salary"&gt;&lt;![CDATA[147852369]]&gt;&lt;/FL&gt; &lt;FL val="Qualifications, Credentials, Memberships"&gt;&lt;![CDATA[93327000000068871, 93327000000101075, AABA Membership, Agile PM Certification, AIPM Membership, CMI Membership, Degree, IIBA Membership, ITIL, Masters Degree, MBA, MSP, PMI Membership, PMP, PRINCE2, RegPM]]&gt;&lt;/FL&gt; &lt;FL val="Additional Information"&gt;&lt;![CDATA[addational_information_goes_here]]&gt;&lt;/FL&gt; &lt;FL val="Attach resume" type="url" url="https://recruit.zoho.com/ats/viewPhoto?filename=tVmTJJk2PIGQSgJSgY2fTzZfMgYE*W1ZBQ.KWiE6q69pGZ2uc5*.nlcJtvxybS4bvD4mCWuA8aE-"&gt;&lt;![CDATA[sampleresume.txt]]&gt;&lt;/FL&gt; &lt;FL val="Photo (for CV)" type="url" url="https://recruit.zoho.com/ats/viewPhoto?filename=tVmTJJk2PIGQSgJSgY2fTzZfMgYE*W1ZBQ.KWiE6q685xDP3Iw.5GlcJtvxybS4bvD4mCWuA8aE-"&gt;&lt;![CDATA[microsoft-gold-partner.png]]&gt;&lt;/FL&gt; &lt;FL val="Candidate status"&gt;&lt;![CDATA[New]]&gt;&lt;/FL&gt;&lt;/row&gt;&lt;/Candidates&gt;&lt;/result&gt;&lt;/response&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USImran Shafqat
    1. USImran Shafqat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHelp me xml parsing in php
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POHelp me xml parsing in php
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHave you already tried anything?
      singulars
      1. POHelp me xml parsing in php
      1. USdeceze
    2. COYes but I can't figure out any thing. All the examples on internet are using different xml formats. So they don't work on my xml file.
      singulars
      1. POHelp me xml parsing in php
      1. USImran Shafqat
    3. COYou know, that the concept of XML is that they can be quite different.. What XML parser are you using? SimpleXML might be a start
      singulars
      1. POHelp me xml parsing in php
      1. USkonsolenfreddy
 

Querying!

 
Guidance
A row detail

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

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

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

SQuiL has stopped working due to an internal error.

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

Reload