<?php
header ( 'Content-Type: text/xml; charset=utf-8' );
$con = @mysql_connect( "localhost", "root", "" ) or die ( "Couldn't connect to database" );
mysql_select_db( "dw00154727" );

if (isset($_GET["name"])) {
	$ingredient = $_GET["name"];
	$query = "INSERT INTO ingredient VALUES('$ingredient')";
	mysql_query( $query, $con );
	
	$query = "SELECT * FROM ingredient WHERE name='$ingredient'";
	$result = mysql_query ( $query, $con );
	$num_results = mysql_num_rows( $result );
} else {
	$query = "SELECT * FROM ingredient";
	$result = mysql_query ( $query, $con );
	$num_results = mysql_num_rows( $result );
}

$doc = new DOMDocument (); // create the DOM document
$doc->formatOutput = true; // generate formatted XML
$root = $doc->createElement( "ingredients" ); // create root element

//$testArray = array( 0 => array('name' => 'testName1'), 1 => array('name' => 'testName2'), 2 => array('name' => 'testName3'), 3 => array('name' => 'testName4') );
while($row = mysql_fetch_array ( $result )) {
//foreach($testArray as $row){
	$node = $doc->createElement( "ingredient" ); // create child element of root
                               
	// create child element of 'eventlist'
	$name = $doc->createElement( "name" );

	// create text node with the value of database attributes,
	// then append them to PHP variables
	$name->appendChild ( $doc->createTextNode ( $row["name"] ) );
	
	$node->appendChild ( $name );
	
	$root->appendChild ( $node ); // append child element to root
}
$doc->appendChild( $root ); // append root to DOM document


mysql_close( $con );
echo $doc->saveXML (); // parse the XML
?>