vendredi 9 novembre 2018

How to get the xml data in the form of array using php

<TimeSheets><TimePeriod><Start weekdayStart="Monday" xmlns="">10/29/2018</Start><End weekdayEnd="Sunday" xmlns="">11/04/2018</End><StatementDate weekdayStatement="Wednesday" xmlns="">11/07/2018</StatementDate><LastRunDate weekdayLastRun="Saturday" xmlns="">12/28/2018</LastRunDate><SystemDate xmlns="">11/07/2018 00:51:43</SystemDate></TimePeriod><Client organization="abc">abc</Client><Supplier organization="fsdf, Inc." name="fsdf, Inc.">fsdf, Inc.

<ConsultantTime>
<XConsultant id="27189"><ClientXrefNbr1></ClientXrefNbr1><PersonID>24799</PersonID><PersonCode>DHinkle12345</PersonCode><Email>test1@gmail.com</Email><FirstName>David</FirstName><MiddleInitial></MiddleInitial><LastName>hennry</LastName><VendorXRefNbr1></VendorXRefNbr1><VendorXRefNbr2></VendorXRefNbr2></XConsultant>
<TimeSheet WeekEnd="10/28/2018" WeekBegin="10/22/2018">
<ApprovalHistory><Activity status="SUBMITTED" datetime="10/26/2018  7:30PM" person="David hennry" role="TimeSheetUser" comment="" /><Activity status="COMPLETED" datetime="10/29/2018 11:56AM" person="David hennry" role="TimeSheetUser" comment="" /><Activity status="LOCKED" datetime="11/01/2018  5:05AM" person="David hennry" role="TimeSheetUser" comment="Locked By System [4667]" /></ApprovalHistory>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/22/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/23/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/24/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/25/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/26/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
</TimeSheet>
</ConsultantTime>




</Supplier></TimeSheets>

I want to get the values of below XML which has time sheet details

like XConsultant,personid,TimeSheet.WeekEnd ,TimeRecord.WeekEnd and so on.. I had tried with

$fileData = simplexml_load_file($fileName);//where file name is the destination of my file url ..

I had used foreach and associative array key condition also but i am unable to fetch the records..where <ConsultantTime>I have many consult time data where i need to have foreach loop. </ConsultantTime> I request someone to help me out.

Thanks in advance.

<TimeSheets><TimePeriod><Start weekdayStart="Monday" xmlns="">10/29/2018</Start><End weekdayEnd="Sunday" xmlns="">11/04/2018</End><StatementDate weekdayStatement="Wednesday" xmlns="">11/07/2018</StatementDate><LastRunDate weekdayLastRun="Saturday" xmlns="">12/28/2018</LastRunDate><SystemDate xmlns="">11/07/2018 00:51:43</SystemDate></TimePeriod><Client organization="abc">abc</Client><Supplier organization="fsdf, Inc." name="fsdf, Inc.">fsdf, Inc.

<ConsultantTime>
<XConsultant id="27189"><ClientXrefNbr1></ClientXrefNbr1><PersonID>24799</PersonID><PersonCode>DHinkle12345</PersonCode><Email>test1@gmail.com</Email><FirstName>David</FirstName><MiddleInitial></MiddleInitial><LastName>hennry</LastName><VendorXRefNbr1></VendorXRefNbr1><VendorXRefNbr2></VendorXRefNbr2></XConsultant>
<TimeSheet WeekEnd="10/28/2018" WeekBegin="10/22/2018">
<ApprovalHistory><Activity status="SUBMITTED" datetime="10/26/2018  7:30PM" person="David hennry" role="TimeSheetUser" comment="" /><Activity status="COMPLETED" datetime="10/29/2018 11:56AM" person="David hennry" role="TimeSheetUser" comment="" /><Activity status="LOCKED" datetime="11/01/2018  5:05AM" person="David hennry" role="TimeSheetUser" comment="Locked By System [4667]" /></ApprovalHistory>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/22/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/23/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/24/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/25/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
<TimeRecord WeekEnd="10/28/2018" WeekBegin="10/22/2018" workdate="10/26/2018" payCode="RT" projectID="Default" projectType="T&amp;M" ProjectCode="N/A" PrjMgrLastName="" PrjMgrFirstName="" PrjMgrEmail="" TimeHeaderKey="361511" TaskID="10323" TaskName="Operating Expense" MSTaskID="Default-Operating Expense" MSProjID="Default" FinTaskNumber="Default" ProjectFinTaskNumber1="Default" ProjectFinTaskNumber2="" ResourceFinTaskNumber1="" ResourceFinTaskNumber2="" MasterProjectID="0" MasterProjectName="" SOP98="N" TaskWBSCode="60041" TimeSystemCostCenter="4200G" ExpOrgType="" AccruedTime="0" Comments="Time In: 8:00 AM&#xD;&#xA;Time Out: 12:00 PM&#xD;&#xA;Comments: &#xD;&#xA;&#xD;&#xA;Time In: 12:30 PM&#xD;&#xA;Time Out: 4:30 PM&#xD;&#xA;Comments: " ApproverName="" BillToOrganization="BSC" VendorXRefNbr1="" VendorXRefNbr2="" VendorXRefNbr3="" VendorXRefNbr4="" VendorXRefNbr5="" VendorXRefNbr6="" VendorXRefNbr7="" VendorXRefNbr8="" VendorXRefNbr9="" VendorXRefNbr10="">8.0000</TimeRecord>
</TimeSheet>
</ConsultantTime>




</Supplier></TimeSheets>


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire