1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| <?php
header('Content-Type: text/xml; charset=UTF-8');
$xml = "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>";
$xml .= '<rprodlist>';
$sql = 'SELECT 100R_ID, 100R_TYPE, 100R_MARQUE, 100R_NOMPROD, 100R_PRIX, 100R_DATELIMITE, 100R_COUPON, 100R_INFOCOMPL, 100R_ADRESSE, 100R_END '
. 'FROM phpbb3_100R '
. 'WHERE 100R_END = 0';
//echo "DEBUG sql = " . $sql;
if(!$result = $db->sql_query($sql))
//if(!$result = $db->sql_query_limit($sql,5))
{
trigger_error("Erreur SQL");
}
function parseForEuro($text)
{
//echo "<br/>Texte avant : " . $text;
$text = str_replace ( "", "", $text);
return $text;
}
while($row = $db->sql_fetchrow($result))
{
$id = $row['100R_ID'];
$type = $row['100R_TYPE'];
$marque = $row['100R_MARQUE'];
$nomprod = $row['100R_NOMPROD'];
$prix = parseForEuro($row['100R_PRIX']);
$datelimite = $row['100R_DATELIMITE'];
$coupon = $row['100R_COUPON'];
$infocompl = parseForEuro($row['100R_INFOCOMPL']);
$adresse = $row['100R_ADRESSE'];
$end = $row['100R_END'];
//echo $infocompl;
$xml .= '<item>';
$xml .= '<id>'.$id.'</id>';
$xml .= '<type>'.$type.'</type>';
$xml .= '<marque>'.$marque.'</marque>';
$xml .= '<nomprod>'.$nomprod.'</nomprod>';
$xml .= '<prix>'.$prix.'</prix>';
$xml .= '<datelimite>'.$datelimite.'</datelimite>';
$xml .= '<coupon>'.$coupon.'</coupon>';
$xml .= '<infocompl>'.$infocompl.'</infocompl>';
$xml .= '<adresse>'.$adresse.'</adresse>';
$xml .= '<end>'.$end.'</end>';
$xml .= '</item>';
}
$xml .= '</rprodlist>';
echo $xml;
$db->sql_freeresult($result);
?> |
Partager