сделать, а можно ли так? да и поидее этот клас можно разбить на 3 по
методам...поправьте меня если что не так
class GbookDB implements IGbookDB {
const DB_NAME = "gbook";
const HOST = "localhost";
const USER = "root";
const PASS = "";
protected $_db;
function __construct(){
$this->_db = mysqli_connect(
"self::HOST",
"self::USER",
"self::PASS",
"self::DB_NAME");
if(!$this->$_db)
{
die(mysqli_error());
}
}
function __destruct() {
mysqli_close($this->$_db);
}
function savePost($name, $email, $msg) {
$sql = "INSERT INTO gbook(
name,
email,
msg
) VALUES(
'$name',
'$email',
'$msg')";
$result = mysqli_query($this->_db,$sql);
}
function getAll() {
$sql = "SELECT * FROM gbook ORDER BY id DESC";
$result = mysqli_query($this->_db,$sql);
}
function deletePost($id){
$sql = "DELETE FROM msgs WHERE id = $id";
$result = mysqli_query($this->_db,$sql);
}
}