Link XML documents to a foreign key

I created XML files from my database table, but I cannot link documents with foreign keys like in a database. It may be simple, but I'm new to this and want an idea for it.

XML files from the first table

<?xml version="1.0" encoding="utf-8"?>
<Students>
    <Student>
        <ID>1</ID>
        <Name>Student1</Name>
        <Roll>21</Roll>
    </Student>
...
</Student>

      

And the second XML file

<?xml version="1.0" encoding="utf-8"?>
<PhoneNumbers>
    <PhoneNumber>
        <ID>1</ID>
        <StudentID>ISA</StudentID>
        <Number>12345</Number>
    </PhoneNumber>
...
</PhoneNumbers>

      

I need to link the studentID

second xml to the ID

first xml.

I am assuming to use different xml files as I have a huge amount of data in the database. Everything is good?

+3
xml


source to share


No one has answered this question yet

Check out similar questions:

2024
How do you parse and process HTML / XML in PHP?
863
How do I process XML in Python?
822
What does <! [CDATA []]> in XML?
797
What characters do I need to hide in XML documents?
442
How to deserialize an XML document
3
Delphi: XML data binding (encoding)
2
Degree icon not displaying correctly in XML file using TXML document object in Delphi XE7
2
Html.fromHtml () removes carriage return "& # xD", "\ n"
1
Get the version, encoding of an XML document
1
WSO2 how to change response from string to xml



All Articles
Loading...
X
Show
Funny
Dev
Pics