Untitled

<?php

class MySQLDatabase{

	private $con;
	private $database="localhost";
	private $username="root";
	private $password="root";
	private $databasename="blog";

	function __construct(){
		$this->open_connection();
	}

	public function open_connection(){

		$this->con=mysql_connect($this->database,$this->username,$this->password);
		if(!$this->con){
			die("Database connection failed: ".mysql_error());

		}else{
			$db_select=mysql_select_db($this->databasename,$this->con);
			if(!$db_select){
				die("Database selection failed: ".mysql_error());
			}
		}
	}
	/*public function close_connection(){
		if(isset($this->con)){
			mysql_close($this->con);
			unset($this->con);
		}
	}*/
}

$database=new MySQLDatabase();
//$database->close_connection();

class Posts {
        private $posts;

        function postPost($title, $thetext, $usrname) {
                $date = time();
                $date = date("Y-m-d", $date);
                $query = "INSERT INTO posts (
                        id,
                        `date`,
                        `title`,
                        `thetext`,
                        `usrname`
                        ) VALUES (
                        NULL,
                        '$date',
                        '$title',
                        '$thetext',
                        '$usrname'
                )";
                $result = mysql_query($query) or die('Query failed: ' . mysql_error());
        }

        function getPosts() {
                $query = "SELECT * FROM posts ORDER BY id DESC";
                $result = mysql_query($query) or die('Query failed: ' . mysql_error());
                while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                        $this->posts[] = $row;
                }
                return $this->posts;
        }
}

$blogs = new Posts();

$usrname = "Lovisa";
$title = "En blogg";
$thetext = "Min bloggtext...";

$blogs->postPost($title, $thetext, $usrname);

$posts = $blogs->getPosts();

function showPosts() {

        foreach($posts as $each_post) {
                $id = $each_post["id"];
                $date = $each_post["date"];
                $title = $each_post["title"];
                $thetext = $each_post["thetext"];
                $usrname = $each_post["usrname"];

                ?>

                <div>
                <?=$id?>, <?=$date?>, <?=$title?>, <?=$thetext?>, <?=$usr?>
                </div>

                <?php
        }
}


?>

<!DOCTYPE HTML>
<html lang="sv">
<head>
        <title>KOMIGENHELVETESKOD</title>
</head>
<body>

<?php showPosts(); ?>

</body>
</html>