<?php
include "lib/config.php";

// Buat database connection.
if(!$db= @mysql_connect("$dbhost", "$dbuser", "$dbpasswd"))
die('<font size=+1>An Error Occured</font><hr>$nmsekolah gagal koneksi dengan server <BR>Silahkah rubah variabel $dbhost, $dbuser, dan $dbpasswd ');
if(!@mysql_select_db("$dbname",$db))
die ("<font>Database belum ada </font>");

$sql = mysql_query("SELECT * FROM t_news ORDER BY id DESC LIMIT 3");
$sql2 = mysql_query("SELECT * FROM t_info ORDER BY id DESC LIMIT 3");
$sql3 = mysql_query("SELECT * FROM t_artikel ORDER BY id DESC LIMIT 3");
$file = fopen("rss.xml", "w");

fwrite($file, '<?xml version="1.0"?>
<rss version="2.0">
<channel>
<title>CMS Balitbang Indonesia Feed</title>
<link>http://localhost/cmsbalitbang352</link>
<description>Feed CMS Balitbang Kemdikbud Indonesia by Ansari Saleh Ahmar</description>
<language>en-us</language>');
while($rs=mysql_fetch_array($sql2)){
$isi_info = htmlentities(strip_tags(nl2br($rs[isi]))); // membuat paragraf pada isi berita dan mengabaikan tag html
$isi2 = substr($isi_info,0,220); // ambil sebanyak 220 karakter
$isi2 = substr($isi_info,0,strrpos($isi2," ")); // potong per spasi kalimat
fwrite($file, "<item>
<title>Info Sekolah -- $rs[subject]</title>
<description>$isi2 ...</description>
</item>");
}
while($r=mysql_fetch_array($sql)){
$isi_berita = htmlentities(strip_tags(nl2br($r[isi]))); // membuat paragraf pada isi berita dan mengabaikan tag html
$isi = substr($isi_berita,0,220); // ambil sebanyak 220 karakter
$isi = substr($isi_berita,0,strrpos($isi," ")); // potong per spasi kalimat
fwrite($file, "<item>
<title>Berita Baru -- $r[subject]</title>
<description>$isi ...</description>
</item>");
}
while($rk=mysql_fetch_array($sql3)){
$isi_artikel = htmlentities(strip_tags(nl2br($rk[isi]))); // membuat paragraf pada isi berita dan mengabaikan tag html
$isiq = substr($isi_artikel,0,220); // ambil sebanyak 220 karakter
$isiq = substr($isi_artikel,0,strrpos($isiq," ")); // potong per spasi kalimat
fwrite($file, "<item>
<title>Artikel Baru -- $rk[judul]</title>
<description>$isiq ...</description>
</item>");
}
fwrite($file, "</channel></rss>");
fclose($file);
?>