class Message extends Zend_Db_Table
{
protected $_name ="message";
protected $_primary = 'id';
/* * 取到所有的留言 */
public function getAllMessage(){
$messageArray=$this->fetchAll("message.pid=0",
"message.id DESC")->toArray();
return $messageArray;
}
/* * 取到所有的回复留言数据 */
public function getAllReMessage(){
$ReArray=$this->fetchAll("message.pid!=0",
"message.id DESC")->toArray();
return $ReArray;
}
/* * 根据ID取留言数据 */
public function getMessageByID($id){
$messageone=$this->fetchAll('id='.$id)->toArray();
return $messageone;
}
/* * 修改留言 */
public function updateMessageByID($array,$id){
$db = $this->getAdapter();
$where=$db->quoteInto('id = ?', $id);
$this->update($array, $where);
}
/* * 删除留言 */
public function delMessageByID($id){
$where = 'id = ' . $id;
$this->delete($where);
return true;
}
}
public function messageAction()
{
if($this->_request->isPost()){
Zend_Loader::loadClass('Zend_Filter_StripTags');
$filter=new Zend_Filter_StripTags();
$username=$filter->filter($this->_request->getPost('username'));
$email=$filter->filter($this->_request->getPost('email'));
$content=$filter->filter($this->_request->getPost('content'));
$title=$filter->filter($this->_request->getPost('title'));
$messageid=$filter->filter($this->_request->getPost('messageid'));
$headimg=$filter->filter($this->_request->getPost('headimg'));
$message=new Message();
$db=$message->getAdapter();
if($username!=''&&$email!=''&&$messageid!=''&&$content!=''){
require_once 'Zend/Validate/EmailAddress.php';
$validator = new Zend_Validate_EmailAddress();
if ($validator->isValid($email)) {
//取IP地址..这里只是简单取IP
$IP=$_SERVER ["REMOTE_ADDR"];
$data=array(
'title'=>$title,
'author'=>$username,
'pid'=>$messageid,
'headimg'=>$headimg,
'email'=>$email,
'show'=>'1',
'content'=>$content,
'ip'=>$IP,
'addtime'=>time(),
'updatetime'=>time()
);
$message->insert($data);
$db->lastInsertId();
unset($data);
//取到所有留言getAllMessage,getAllReMessage
//二个方法在Model(Message.php)里定义的
$this->view->messages=$message->getAllMessage();
//取到所有回复数据
$this->view->arrReviews=$message->getAllReMessage();
$this->view->flag='0';
$this->view->message='您的留言发表成功!';
echo $this->view->render('message/message.phtml');
} else {
$this->view->flag='5';
$this->view->message='对不起!您填写有电子邮箱地址有误!';
echo $this->view->render('message/message.phtml');
}
}elseif($username==''){
$this->view->flag='1';
$this->view->message='对不起!您的大名不能为空!';
echo $this->view->render('message/message.phtml');
}elseif($messageid==''){
$this->view->flag='2';
$this->view->message='对不起!回复留言编号不能为空!';
echo $this->view->render('message/message.phtml');
}elseif($content==''){
$this->view->flag='3';
$this->view->message='对不起!您填写的留言内容不能为空!';
echo $this->view->render('message/message.phtml');
}
}else{
echo $this->view->render('message/index.phtml');
}
}
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有