Comment

<?php

/* The Comment Class */

class Comment {

private $mysqli;

private static $mycomment = null; //It's means that I can add more and more comments

/* Connecting... */

public function __construct() {

$this->mysqli = new Mysqli('localhost', 'root', '', 'cms');

$this->mysqli->query("SET NAMES 'utf8'");

}

public static function getComment() {

if(self::$mycomment === null) self::$mycomment = new Comment();

return self::$mycomment;

}

/*Comment Functions*/

public function viewComment($name, $comment)

{

$result_set = $this->mysqli->query("SELECT * FROM `articles` ORDER BY `id` DESC");

while($result = $result_set->fetch_array()):

print "$result[name] : $result[text_comment]<br>";

endwhile;

}

public function addComment($name, $comment)

{

if($name =="") return false;

if($comment =="") return false;

$this->mysqli->query("UPDATE `articles` SET `name` = '$name', `text_comment` = '$comment' WHERE(`id` = '$id')");

}

/* Closing the connection */

public function __destruct() {

if($this->mysqli) $this->mysqli->close();

}

}

?>