include_once ROOT_DIR . 'lib/class/member.class.php';
$this->member = new member();
$members = $this->member->getMemberById($row['member_id']);
//对应user的键值
foreach ($members as $key => $values) {
$mem[$values['id']] = $values;
}
//查询表中是否已经存在这样一条记录
$sql = "SELECT * FROM " . DB_PREFIX . "status_favorites WHERE status_id =" . $this->input['id'] . " and member_id =" . $this->user['user_id'];
$rowf = $this->db->query_first($sql);
if ($rowf) {
$this->errorOutput(INSERT_EXIT);
}
//收藏表中记录一条数据
$sql = "INSERT " . DB_PREFIX . "status_favorites(\r\n\t\t\t\t\tstatus_id,\r\n\t\t\t\t\tmember_id,\r\n\t\t\t\t\tfavorite_time\r\n\t\t\t\t\t)\r\n\t\t\t\t\tVALUES(\r\n\t\t\t\t\t" . $this->input['id'] . ",\r\n\t\t\t\t\t'" . $this->user['user_id'] . "',\r\n\t\t\t\t\t" . TIMENOW . "\t\t\t\t\r\n\t\t\t\t\t)\r\n\t\t\t\t\t";
$rowd = $this->db->query($sql);
//如果删除成功则返回删除的数据
if ($rowd) {
//博客信息和用户信息合并
$this->setXmlNode('statuses', 'status');
$row['user'] = $mem[$row['member_id']];
$this->addItem($row);
$this->output();
} else {
$this->errorOutput(INSERT_FASLE);
}
}
}
$out = new create();
$out->create();
