<?php
$dbname = "mmu0102_"; // database naam
$user = "timo"; // gebruikersnaam van mysql
$pass = "*********"; // wachtwoord van mysql
$host = "localhost"; // host naar mysql
$dbh=mysql_connect("$host","$user","$pass");
mysql_select_db( "$dbname" ) or trigger_error( mysql_error() );
if($_GET['blog']==''){
$query="SELECT * FROM `blog`;";
$res=mysql_query($query);
$fout=mysql_errno($dbh);
if ($fout != 0) {
$fout=mysql_error($dbh);
echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> This was the query: $query</center></font>";
mysql_close($dbh);
echo "</body></html>";
exit;
}
$aantal_loops=mysql_num_rows($res);
for($teller=0;$teller<$aantal_loops;$teller++){
$row=mysql_fetch_assoc($res);
$leesbare_tijd=date("j-m-y h:i:s", $time);
echo "<center><table border='1'>";
echo "<center><table border='1'>";
echo "<tr align='center'><td><a href='index.php?page=default.php&blog=".$row['ID']."'>".$row['title']."<a>";
echo "</table></center>";
}
}else{
$query = "SELECT title, text, time FROM blog WHERE id='". mysql_real_escape_string($_GET['blog'] )."'";
$res=mysql_query($query);
$fout=mysql_errno($dbh);
if ($fout != 0) {
$fout=mysql_error($dbh);
echo "<font color=\#FF0000\"><center>An error occured. This is the error message:$fout. <br> This was the query: $query</center></font>";
mysql_close($dbh);
echo "</body></html>";
exit;
}
$row=mysql_fetch_assoc($res);
$leesbare_tijd=date("j-m-y h:i:s", $row['time']);
echo "<center><table border='1'>";
echo "<tr align='center'><td><h2>".$row['title']."</h2>";
echo "<tr align='center'><td>This post was made on $leesbare_tijd";
echo "<tr align='center'><td>".$row['text'];
echo "</table></center>";
}
?>
