تفضل هذا الكلاس الي كتبته
كود PHP:
<?php
class Guestbook
{
function AddNewRecord($name,$email,$comment,$date)
{
global $db,$modules;
$date=date("Y-m-d H:i:s");
$sSQL ="(INSERT INTO ".PREFIX."gustbook (name, email, comment, date) VALUES ($name,$email,$comment,$date))";
$db->query($sSQL);
RETURN;
}
function DeleteRecord($id)
{
global $db;
$sSQL = "DELETE FROM ".PREFIX."gustbook WHERE id=".$id." LIMIT 1";
$db->query($sSQL);
RETURN;
}
function GetRecord()
{
global $db,$class_tpl;
$sSQL="SELECT * FROM ".PREFIX."gustbook";
$result=$db->query($sSQL);
$rs=$result->fetch();
$class_tpl->assign('id', $rs['id']);
$class_tpl->assign('name', $rs['name']);
$class_tpl->assign('email', $rs['email']);
$class_tpl->assign('comment', safeStripSlashes($rs['comment']));
$class_tpl->assign('date', $rs['date']);
RETURN;
}
}
?>