# Passing xml tree to php

**URL:** https://forum.kirupa.com/t/passing-xml-tree-to-php/268154
**Category:** flash
**Created:** [August 11, 2008, 1:36am UTC](https://forum.kirupa.com/t/passing-xml-tree-to-php/268154 "2008-08-11T01:36:37Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![r0000](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@r0000](https://forum.kirupa.com/u/r0000)
#### Post date: [August 11, 2008, 1:36am UTC](https://forum.kirupa.com/t/passing-xml-tree-to-php/268154/1 "2008-08-11T01:36:37Z")

</div>

Basicaly I’m passing xml tree to php and having php insert it into a db, no luck yet, I’m not sure where i’m going wrong with this.  
Thanks for any help with this.

Here’s the code i’m using.

//AS3  
var team\_xml:XML = new XML(

```
&lt;league&gt;
    &lt;teams&gt;
        &lt;team&gt;Team 1&lt;/team&gt;
        &lt;team&gt;Team 1&lt;/team&gt;
    &lt;/teams&gt;
&lt;/league&gt;

```

);

var request:URLRequest = new URLRequest(“testing.php”);  
request.method = URLRequestMethod.POST;

var variables:URLVariables = new URLVariables();  
variables.xml = team\_xml;

request.data = variables;  
var loader:URLLoader = new URLLoader();

loader.dataFormat = URLLoaderDataFormat.VARIABLES;  
loader.addEventListener(Event.COMPLETE, teamReturn);  
loader.load(request);

//PHP  
\<?php

$sx = $\_POST[‘xml’];

//DB Connection -------------------------------------------------------------------------------------------------  
$dbhost = “xxx”;  
$dbuser = “xxx”;  
$dbpass = “xxx”;  
$dbname = “xxx”;

$connection = mysqli\_connect($dbhost, $dbuser, $dbpass, $dbname) or die(“Could not connect to host.”);  
mysqli\_select\_db($connection, $dbname) or die (“Error”);

foreach ($sx-\>team as $team){

```
$teamname = $team-&gt;teamname;
mysqli_query($connection, "INSERT INTO teams (teamname) VALUES ('$teamname')");    

```

}

echo “xml=Done”;

?\>