<?php ################################################################## ## re-Autor Vipmaster ## ## email vipmaster@ewdesign.com.br ## ## Copyright VIPMASTER, todos os direitos reservados ao autor. ## ## Modificado por Henrique Recidive. ## ################################################################## //para a sa�da header("Content-type: text/xml"); //to create connection to database $connection = mysql_connect("localhost","usuario","senha") or die ("could not connect to database"); //para criar a conex�o � base de dados $db = mysql_select_db("banco",$connection) or die ("Couldn't select database."); $rs = mysql_query("select * from tabela",$connection) or die ("invalid query"); //conte o n� das colunas na tabela $fcount = mysql_num_fields($rs); //charset para o indioma portugu�s echo ("<".chr(077)."xml version='1.0' encoding='ISO-8859-1'".chr(077).">"); //voc� pode escolher todo o nome para o Tag come�ando echo ("<resultado>"); while($row = mysql_fetch_array( $rs ) ) { echo ("<linha>"); for($i=0; $i< $fcount; $i++) { $tag = mysql_field_name( $rs, $i ); echo ("<$tag>". $row[$i]. "</$tag>"); } echo ("</linha>"); } echo ("</resultado>"); ?>