Problem to show "players_xml" in a php web

[Sylvert]

Hello, I had a problem trying to load the column "players_xml" table "tc_game_service_live_stats" to show the players in a php page.

 

Does anyone could explain how I would have to do to upload a php website and display it?

[LFA]

You need to use PHP's xml functions to parse the contents and read the player values.

[Sylvert]

You need to use PHP's xml functions to parse the contents and read the player values.

 

I try to do the following:

 

if( mysql_num_rows( $r ) )
 if( $m = mysql_fetch_array( $r ) )
      $xml = $m['players_xml']

foreach( $xml as $item )
{
  echo( 'Name: '. $item->name );
}

 

It does not work, get the following error

 

Warning: Invalid argument supplied for foreach() in servers.php on line 52

Edited October 6, 2011 by Sylvert

[LFA]

You can see an example using xml with php here:

http://www.w3schools.com/php/php_xml_simplexml.asp

 

You will have to use simplexml_load_string instead of simplexml_load_file

 

and documentation here:

http://us2.php.net/manual/en/book.simplexml.php

[Sylvert]

thank you and I do

 

if( mysql_num_rows( $r ) )
{
 	if( $m = mysql_fetch_array( $r ) )
{
      	         $xml = simplexml_load_string($m['players_xml']);
}
}