Notes

<?php
/* ======================================== */
// BlueMVC 用戶模組 1.00
// 系統框架開發 : 任家輝
// [email protected]
// 使用JQuery、Smarty等技術開發的MVC框架
// 初次進入請先修改config.php檔案
// 請勿刪除此段版權宣告，否則依法追究
/* ======================================== */
class gbook extends Model
{


public $gbook;

public function __construct()
{
$this->setDB();
}

public function ins($name, $email, $content)
{

$query = $this->_link->prepare('
INSERT INTO `gbook` (`name`, `email`, `content`, `updtime`)
VALUES (:name, :email, :content, CURRENT_TIMESTAMP)');
$query->execute
(
array
(
':name' => $name,
':email' => $email,
':content' => $content
)
);

}
public function index()
{
$query = $this->_link->prepare('SELECT * FROM `gbook`');
$query->execute();
$result = $query->fetchAll(PDO::FETCH_OBJ);

return $result;
}
public function show($id)
{
$query = $this->_link->prepare('SELECT * FROM `gbook` WHERE `id` = :id');
$query->execute(array(':id' => $id));
$result = $query->fetch(PDO::FETCH_OBJ);
return $result;
}

public function upd($id, $name, $email, $content)
{
var_dump($id);
var_dump($name);
var_dump($email);
var_dump($content);
$query = $this->_link->prepare('UPDATE `gbook` SET
`name` = :name,
`email` = :email,
`content` = :content
WHERE `id` = :id'
);
$query->execute(array(':name' => $name, ':email' => $email, ':content' => $content, ':id' => $id));
var_dump($query->errorinfo());
}

public function __destruct()
{
$this->gbook = null;
$this->_link = null;
}

}