1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| <?php
$database = "database";
$dbconnect = mysql_pconnect(localhost, dbuser, dbpassword);
mysql_select_db($database, $dbconnect);
$newsnumber = "1,1";
$result = mysql_query("SELECT id,title,news_head,uploadfile,catmig FROM r_news where allow='yes' ORDER BY id DESC limit $newsnumber") or die("erreur sur requete:" . mysql_error());
$content = "<?xml version=\"1.0\"?>
<album
showbuttons=\"yes\"
showtitles=\"yes\"
randomstart=\"yes\"
timer=\"5\"
aligntitles=\"bottom\"
alignbuttons=\"bottom\"
transition=\"push\"
speed=\"20\">";
while($row = mysql_fetch_array($result))
{
$content .= "<img src=".htmlentities($row['uploadfile'])." title=".htmlentities($row['title'])." href=news.php?action=view&id=".$row['id']."/>";
}
$content .= "</album>";
header("Content-Type: application/xml");
echo $content;
?> |
Partager