wenda-php/protected/model/DiscussDao.php

<?php

class DiscussDao {
	
	public $id;
	
	public $uid;
	
	public $qid;
	
	public $cid;
	
	public $content;
	
	public $time;
	
	public $discuss;
	
	public $_table = t_discuss;
	
	public $_primarykey = "id";
	
	public $_fields = array ('id', 'uid', 'qid', 'cid', 'content', 'time', 'discuss' );
	
	/**
	 * 获取讨论
	 * @param unknown_type $id
	 */
	function get_discuss_by_qid($id) {
		$sql = "select * from " . t_discuss . " where cid=0 and qid=" . $id;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}
	
	/**
	 * 获取子评论
	 * @param unknown_type $id
	 */
	function get_discuss_by_cid ( $id=0 ){
		$sql = "select * from " . t_discuss . " where cid=" . $id;
		
		$query = Doo::db ()->query ( $sql );
		
		$result = $query->fetchAll ();
		
		return $result;
	}
	
	/**
	 * 更新讨论数
	 * @param unknown_type $cid
	 */
	function update_discuss($cid = 0) {
		$sql = "UPDATE `" . t_discuss . "` SET  `discuss` = `discuss` + 1 WHERE `id` = " . $cid;
		
		$query = Doo::db ()->query ( $sql );
	}
}

?>