Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is probably what you are looking for.</p> <pre><code> //Creates XML string and XML document using the DOM $dom = new DomDocument('1.0', 'UTF-8'); //add root $root = $dom->appendChild($dom->createElement('Root')); //add NodeA element to Root $nodeA = $dom->createElement('NodeA'); $root->appendChild($nodeA); // Appending attr1 and attr2 to the NodeA element $attr = $dom->createAttribute('attr1'); $attr->appendChild($dom->createTextNode('some text')); $nodeA->appendChild($attr); /* ** insert more nodes */ $dom->formatOutput = true; // set the formatOutput attribute of domDocument to true // save XML as string or file $test1 = $dom->saveXML(); // put string in test1 $dom->save('test1.xml'); // save as file </code></pre> <p>For more information, have a look at the <a href="http://www.php.net/manual/en/book.dom.php" rel="noreferrer">DOM Documentation</a>.</p> <p>To do what you want:</p> <pre><code> //Creates XML string and XML document using the DOM $dom = new DomDocument('1.0', 'UTF-8'); //add root == jukebox $jukebox = $dom->appendChild($dom->createElement('jukebox')); for ($i = 0; $i &lt; count($arrayWithTracks); $i++) { //add track element to jukebox $track = $dom->createElement('track'); $jukebox->appendChild($track); // Appending attributes to track $attr = $dom->createAttribute('source'); $attr->appendChild($dom->createTextNode($arrayWithTracks[$i]['source'])); $track->appendChild($attr); $attr = $dom->createAttribute('artist'); $attr->appendChild($dom->createTextNode($arrayWithTracks[$i]['artist'])); $track->appendChild($attr); $attr = $dom->createAttribute('album'); $attr->appendChild($dom->createTextNode($arrayWithTracks[$i]['album'])); $track->appendChild($attr); $attr = $dom->createAttribute('title'); $attr->appendChild($dom->createTextNode($arrayWithTracks[$i]['title'])); $track->appendChild($attr); } $dom->formatOutput = true; // set the formatOutput attribute of domDocument to true // save XML as string or file $test1 = $dom->saveXML(); // put string in test1 $dom->save('test1.xml'); // save as file </code></pre> <p>Cheers</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to save XML using PHP
      singulars
      1. PTQuestion
    1. PTAnswer
    1. UStaswyn
    1. USvfn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to save XML using PHP
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank's vfn thats exactly what I want and so quick Thank's
      singulars
      1. PO
      1. USMalcolm
    2. COHi vfn, thanks again for your response and solution to my question, however if it's ok with you can I pick at your brains a little bit more. The XML file you helped me with would normally be populated with music files "MP3" in a directory that is called using PHP, I can get a list of all the files in a directory using PHP but how would I then add that information to the XML file? the only information I would really need is the source/location of the file's as for the rest I will be using an MP3 metadata class, any help would be greatly appreciated.
      singulars
      1. PO
      1. USMalcolm
    3. COWhat do you mean? I couldn't understand the your question!
      singulars
      1. PO
      1. USvfn
 

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