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; }