Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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, $usr) {
- $date = time();
- $date = date("Y-m-d", $date);
- $query = "INSERT INTO posts (
- id,
- `date`,
- `title`,
- `thetext`,
- `usr`
- ) VALUES (
- NULL,
- '$date',
- '$title',
- '$thetext',
- '$usr'
- )";
- $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();
- $usr = "Lovisa";
- $title = "En blogg";
- $thetext = "Min bloggtext...";
- $blogs->postPost($title, $thetext, $usr);
- $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"];
- $usr = $each_post["usr"];
- ?>
- <div>
- <?=$id?>, <?=$date?>, <?=$title?>, <?=$thetext?>, <?=$usr?>
- </div>
- <?php
- }
- }
- ?>
- <!DOCTYPE HTML>
- <html lang="sv">
- <head>
- <title></title>
- </head>
- <body>
- <?php showPosts(); ?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment