Sortera data med hjälp av PHP och XML

<Row RowNumber="20" RowType="1"><Part PartNumber="077-10468" SupplierPartNumber="35515" /><Text /><ReferenceNumber /><Quantity>15.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>120.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="30" RowType="1"><Part PartNumber="078-0046-1" SupplierPartNumber="35515" /><Text>LOCK Skuren</Text><ReferenceNumber /><Quantity>5.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>145.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="40" RowType="1"><Part PartNumber="095-29745-1" SupplierPartNumber="35550" /><Text>CYLINDERGAVEL Skuren</Text><ReferenceNumber /><Quantity>100.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>528.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="50" RowType="1"><Part PartNumber="096-24204-1" SupplierPartNumber="D4206" /><Text>FÄSTKLAMMA Skuren</Text><ReferenceNumber /><Quantity>50.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>47.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="60" RowType="1"><Part PartNumber="097-55146" SupplierPartNumber="BET3" /><Text /><ReferenceNumber /><Quantity>20.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-20</DeliveryPeriod><Each>16.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="70" RowType="1"><Part PartNumber="098-36032" SupplierPartNumber="BET3" /><Text /><ReferenceNumber /><Quantity>40.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>16.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="80" RowType="1"><Part PartNumber="100-21288-1" SupplierPartNumber="35520" /><Text>ÖRA   (KONSOL,HYTTFUNDAMENT) Skuren</Text><ReferenceNumber /><Quantity>20.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>114.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="90" RowType="1"><Part PartNumber="100-21289-1" SupplierPartNumber="35520" /><Text>PLÅT  (KONSOL,HYTTFUNDAMENT) Skuren</Text><ReferenceNumber /><Quantity>15.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-29</DeliveryPeriod><Each>598.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>
<Row RowNumber="100" RowType="1"><Part PartNumber="100-22035" SupplierPartNumber="W7010" /><Text /><ReferenceNumber /><Quantity>15.00</Quantity><Unit>st</Unit><DeliveryPeriod>2023-06-20</DeliveryPeriod><Each>32.00</Each><Discount>0.00</Discount><Setup /><Alloy>0.00</Alloy></Row>

<?php
$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");
foreach($xml->children() as $books) {
  echo $books->title . ", ";
  echo $books->author . ", ";
  echo $books->year . ", ";
  echo $books->price . "<br>";
}
?>

<?php
$array[0] = array('key_a' => 'z', 'key_b' => 'c');
$array[1] = array('key_a' => 'x', 'key_b' => 'b');
$array[2] = array('key_a' => 'y', 'key_b' => 'a');

function build_sorter($key) {
    return function ($a, $b) use ($key) {
        return strnatcmp($a[$key], $b[$key]);
    };
}

usort($array, build_sorter('key_b'));

foreach ($array as $item) {
    echo $item['key_a'] . ', ' . $item['key_b'] . "\n";
}
?>

$xml = '<?xml version="1.0"?>
<step number="9">
    <s_name>test</s_name>
    <b_sel>12345</b_sel>
    <b_ind>7</b_ind>
</step>';

function convertStepInformationToArray($stepInformation) {
    $dom = new DOMDocument();
    $dom->loadXML($stepInformation);
    $domx = new DOMXPath($dom);
    $entries = $domx->evaluate("//step");
    return $entries;
}

print_r(convertStepInformationToArray($xml));

foreach ($xml->children() as $row) {
    $title = $row->PartNumber;
    $link = $row->SupplierPartNumber;
    $description = $row->Quantity;
    $keywords = $row->DeliveryPeriod;

<Row RowNumber="20" RowType="1">
 <Part PartNumber="078-10218" SupplierPartNumber="35515" />
  <Text />
   <ReferenceNumber />
    <Quantity>15.00</Quantity>
   <Unit>st</Unit>
    <DeliveryPeriod>2023-06-29</DeliveryPeriod>
     <Each>120.00</Each>
      <Discount>0.00</Discount>
       <Setup />
        <Alloy>0.00</Alloy>
 
</Row>

foreach ($xml->children() as $row) {
    $title = $row->Part['PartNumber'];
    $link = $row->Part['SupplierPartNumber'];
    $description = $row->Quantity;
    $keywords = $row->DeliveryPeriod;

<?xml version="1.0" encoding="utf-8"?>
<ORDERS420 SoftwareManufacturer="" SoftwareName="MONITOR" SoftwareVersion="23.4.3.22198">
<Order OrderNumber="83">
<Head>
<Supplier SupplierCodeEdi="77">
<Name></Name>
<StreetBox1></StreetBox1>
<StreetBox2></StreetBox2>
<ZipCity1></ZipCity1>
<ZipCity2 />
<Country>Sverige</Country>
</Supplier>
<Buyer BuyerCodeEdi="13">
<Name></Name>
<StreetBox1></StreetBox1>
<StreetBox2 /><ZipCity1></ZipCity1><ZipCity2 /><Country></Country></Buyer><References><BuyerReference></BuyerReference><BuyerComment /><GoodsLabeling><Row1 /><Row2 /></GoodsLabeling></References><DeliveryAddress><Name></Name><StreetBox1></StreetBox1><StreetBox2 /><ZipCity1></ZipCity1><ZipCity2 /><Country>Sverige</Country><CompanyAdressFlag>1</CompanyAdressFlag></DeliveryAddress><Terms><DeliveryTerms><IncoTermCombiTerm> </IncoTermCombiTerm><DeliveryMethod>Ändra leveranssätt</DeliveryMethod><TransportPayer>C</TransportPayer><CustomerTransportTimeDays>0</CustomerTransportTimeDays></DeliveryTerms><CustomerInvoiceCode>183</CustomerInvoiceCode><OrderDate>2023-06-14</OrderDate><PaymentTerms><TermsOfPaymentDays>30</TermsOfPaymentDays></PaymentTerms></Terms><Export><Currency>SEK</Currency></Export></Head>

<Rows>

<Row RowNumber="10" RowType="1">
<Part PartNumber="007-7212-0" SupplierPartNumber="BET3" />
<Text>TEXT, LÅDA</Text>
<ReferenceNumber />
<Quantity>20.00</Quantity>
<Unit>st</Unit>
<DeliveryPeriod>2023-06-20</DeliveryPeriod>
<Each>24.00</Each>
<Discount>0.00</Discount>
<Setup />
<Alloy>0.00</Alloy>
</Row>

<Row RowNumber="20" RowType="1">
<Part PartNumber="004-7212-0" SupplierPartNumber="BET3" />
<Text>LÅDA</Text>
<ReferenceNumber />
<Quantity>30.00</Quantity>
<Unit>st</Unit>
<DeliveryPeriod>2023-06-21</DeliveryPeriod>
<Each>24.00</Each>
<Discount>0.00</Discount>
<Setup />
<Alloy>0.00</Alloy>
</Row>

</Rows>

$data = "data.xml";

// Load xml file else check connection
$xml = simplexml_load_file($data)
    or die("Error: Cannot create object");
 
// Assign values
foreach ($xml->children() as $row) {
    $title = $row->Part['PartNumber'];
    $link = $row->Part['SupplierPartNumber'];
    $description = $row->Quantity;
    $keywords = $row->DeliveryPeriod;

foreach ($xml->children() as $order) {
  foreach ($order->Rows->children() as $row) {
    $title = $row->Part['PartNumber'];
    $link = $row->Part['SupplierPartNumber'];
    $description = $row->Quantity;
    $keywords = $row->DeliveryPeriod;
    echo("$title, $link, $description, $keywords\n<br>");
     
    // SQL query to insert data into xml table
    $sql = "INSERT INTO xml(PartNumber, SupplierPartNumber,
        Quantity, DeliveryPeriod) VALUES ('"
        . $title . "','" . $link . "','"
        . $description . "','" . $keywords . "')";
     
    $result = mysqli_query($conn, $sql);

}

$data = "data.xml";

$xml = simplexml_load_file($data)
    or die("Error: Cannot create object");
 
foreach ($xml->children() as $order) {
  foreach ($order->Rows->children() as $row) {
    $title = $row->Part['PartNumber'];
    $link = $row->Part['SupplierPartNumber'];
    $description = $row->Quantity;
    $keywords = $row->DeliveryPeriod;
    echo("Artikel: ".$title." Material: ". $link." Antal: ". $description." Datum: ". $keywords."<br>");
  
    $sql = "INSERT INTO xml(PartNumber, SupplierPartNumber,
        Quantity, DeliveryPeriod) VALUES ('"
        . $title . "','" . $link . "','"
        . $description . "','" . $keywords . "')";
     
    $result = mysqli_query($conn, $sql);
     
    if (! empty($result)) {
        $affectedRow ++;
    } else {
        $error_message = mysqli_error($conn) . "\n";
    }
}}
?>
 
<center><h2>Företagsnamnet</h2></center>
<center><h1>XML Data storing in MySQL Database</h1></center>
<?php
if ($affectedRow > 0) {
    $message = $affectedRow . " records inserted";
} else {
    $message = "No records inserted";
}
 
$sql2 = "SELECT * FROM xml ORDER BY DeliveryPeriod, SupplierPartNumber";
$result2 = mysqli_query($conn, $sql2);
while ($row = mysqli_fetch_assoc($result2)) {
    echo "Artikel: " . $row['PartNumber'] . "<br> Material: " . $row['SupplierPartNumber'] . "<br> Leveransdatum: " . $row['DeliveryPeriod']."<br> Antal: ".$row['Quantity']."<br><br>";
}

?>