public static function addReviews($articleId, $userName, $body, $face)
{
$sql = "insert into reviews(articleId,userName,body,face)values({$articleId},'{$userName}','{$body}','{$face}')";
$conn = new DbConn();
$row = $conn->executeUpdate($sql);
$conn->close();
return $row;
}
public static function addNews($content, $title, $typeId, $userName, $writer, $source, $imagepath)
{
$sql = "insert into newsArticles(content,title,typeId,userName,writer,source,imagepath)values('{$content}','{$title}',{$typeId},'{$userName}','{$writer}','{$source}','{$imagepath}')";
$conn = new DbConn();
$result = $conn->executeUpdate("update newsTypes set articleNums=articleNums+1 where typeId={$typeId}");
$result = $conn->executeUpdate($sql);
$conn->close();
return $result;
}
public static function addType($typeName)
{
$sql = "insert into newsTypes(typeName)values('{$typeName}')";
$conn = new DbConn();
$result = $conn->executeUpdate($sql);
$conn->close();
return $result;
}
