wenda-php/protected/model/VipanswerDao.php

<?php

class VipanswerDao {
	
	public $id;
	
	public $qid;
	
	public $title;
	
	public $time;
	
	public $adopttime;
	
	public $content;
	
	public $comment;
	
	public $status;
	
	public $ip;
	
	public $tag;
	
	public $_table = t_vipanswer;
	
	public $_primarykey = "id";
	
	public $_fields = array ('id', 'qid', 'title', 'time', 'adopttime', 'content', 'comment', 'status', 'ip', 'tag' );
	
	/**
	 * 根据问题ID获取回答
	 * @param unknown_type $id
	 */
	public function get_vip_answer_by_qid($id = 0) {
		$sql = "SELECT * FROM  " . t_vipanswer . " where qid=" . $id . " limit 1";
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetch ();
		
		return $result;
	}
	
	/**
	 * 追加一个名师答疑的追问
	 * @param unknown_type $id
	 * @param unknown_type $tag
	 */
	function do_add_vip_tag($id = 0, $tag = "") {
		$sql = "UPDATE " . t_vipanswer . " SET  tag = '" . $tag . "'  WHERE qid = " . $id;
		
		$query = Doo::db ()->query ( $sql );
	}
	
	/**
	 * 添加评价
	 * @param unknown_type $qid
	 * @param unknown_type $comment
	 */
	function update_vip_answer_comment($qid = 0, $comment = "") {
		$sql = "UPDATE " . t_vipanswer . " SET  comment = '" . $comment . "'  WHERE qid = " . $qid;
		
		$query = Doo::db ()->query ( $sql );
	}

}

?>