header('Content-Type: text/html; charset=ISO-8859-1');
$newslang="";
// Establish dataBase link
$mysqli = mysqli_connect("db13.zim.uni-duisburg-essen.de","hp0052","Mvxod0n7rzuB","hp0052_1");
if (!mysqli_connect_errno())
{
echo '
';
echo '
';
$lawhitelist = array('DEU','ENU');
if (isset($_GET["newslang"]) && in_array($_GET["newslang"], $lawhitelist))
{
$newslang=$_GET["newslang"];
}
echo '| ';
$zzz=0;
$SelectString = 'SELECT * FROM `News` WHERE von < NOW() AND termin ="0" ORDER BY von DESC';
if(strlen($newslang)>0)
{
if($newslang=="DEU")
{
$SelectString = 'SELECT * FROM `News` WHERE von < NOW() AND termin ="0" AND sprache="DEU" ORDER BY von DESC';
}
elseif($newslang=="ENU")
{
$SelectString = 'SELECT * FROM `News` WHERE von < NOW() AND termin ="0" AND sprache="ENU" ORDER BY von DESC';
}
}
$ergebnis = mysqli_query($mysqli, $SelectString);
while (($News=mysqli_fetch_assoc($ergebnis)) and ($zzz<6) )
{
$zzz=$zzz+1;
echo ' |
';
echo ''.substr($News["wann"],0,10).': '.$News["Ueberschrift"]. '';
echo ' '.$News["news"];
echo ' |
';
}
echo '
';
mysqli_close($mysqli);
}
else echo '
Database issue!
Please try again later!
';
?>
More news