Blogging System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Blogging System

Blogging System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Blog,Blog Category,Blog Type,Comment,Technology Blog. Admin user can manage all the operations of Comment,Technology Blog,Blog,Create Blog,Blog Category and their details. Admin can create different type of reports of Blog,Blog Category,Blog Type,Comment,Technology Blog according to their choise and filters. You can Download PHP and MySQL Project Blogging System with source code and database from this site. We also provide Project Report of Blogging System.

Functionalities and their descriptions of Blogging System are as follows:

  • You can search records on various criterias. Such as Blog, Blog Type, Comment, Technology Blog
  • Create, read, update and delete (CRUD) application has been implemented on Blog,Blog Category,Blog Type,Comment,Technology Blog
  • Keep the track logs of Blog Category, Create Blog, Comment ect
  • Advance search has been implemented on Blog Category,Create Blog, Comment
  • You can see all the details of the Blog, Blog Type, Create Blog, Comment
  • All the modules Create Blog, Comment, Blog Category,Technology Blog, Blog are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Comment.
  • All the Blog Category,Create Blog, Comment modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Blog data.

Modules of Blogging System and their descriptions:

  • Blog Module : Manage all the operations of Blog
  • Blog Category Module : Manage all the operations of Blog Category
  • Create Blog Module : Manage all the operations of Create Blog
  • Blog Type Module : Manage all the operations of Blog Type
  • Comment Module : Manage all the operations of Comment
  • Technology Blog Module : Manage all the operations of Technology Blog

Classes and their methods of Blogging System:

  • Blog Methods : addBlog(), editBlog(), deleteBlog(), updateBlog(), saveBlog(), searchBlog()
  • Blog Category Methods : addBlog Category(), editBlog Category(), deleteBlog Category(), updateBlog Category(), saveBlog Category(), searchBlog Category()
  • Create Blog Methods : addCreate Blog(), editCreate Blog(), deleteCreate Blog(), updateCreate Blog(), saveCreate Blog(), searchCreate Blog()
  • Blog Type Methods : addBlog Type(), editBlog Type(), deleteBlog Type(), updateBlog Type(), saveBlog Type(), searchBlog Type()
  • Comment Methods : addComment(), editComment(), deleteComment(), updateComment(), saveComment(), searchComment()
  • Technology Blog Methods : addTechnology Blog(), editTechnology Blog(), deleteTechnology Blog(), updateTechnology Blog(), saveTechnology Blog(), searchTechnology Blog()

Database tables and attributes of the Blogging System:

  • Blog Entity : Attributes of Blog are blog_id, blog_user_id blog_title, blog_type, blog_content, blog_description
  • Blog Category Entity : Attributes of Blog Category are blog_category_id, blog_category, blog_category_title, blog_category_type, blog_category_content, blog_category_description
  • Create Blog Entity : Attributes of Create Blog are blog_id, blog_user_id blog_title, blog_type, blog_content, blog_description
  • Blog Type Entity : Attributes of Blog Type are blog_type_id, blog_type_name, blog_type_description
  • Comment Entity : Attributes of Comment are comment_id, comment_user_id, comment_type, comment_title, comment_description
  • Technology Blog Entity : Attributes of Technology Blog are techonology_blog_id, techonology_blog_user_id, techonology_blog_title, techonology_blog_type, techonology_blog_content, techonology_blog_description

Database definition of Blogging System:

  • The details of Blog is store into the Blog tables respective with all tables
  • Each entity (Technology Blog, Create Blog, Comment, Blog Category, Blog) contains primary key and unique keys.
  • The entity Create Blog, Comment has binded with Blog, Blog Category entities with foreign key
  • There is one-to-one and one-to-many relationships available between Comment, Blog Type, Technology Blog, Blog
  • All the entities Blog, Comment, Create Blog, Technology Blog are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Blogging System tables for fast query execution.

Super admin functionality of Blogging System:

  • Admin can add, edit, delete and view the records of Blog, Comment, Create Blog, Technology Blog
  • Admin can manage all the details of Blog Category, Create Blog, Blog Type, Comment
  • Admin can also generate reports of Blog, Blog Category, Create Blog, Blog Type
  • Admin can search the details of Blog, Comment, Create Blog, Technology Blog
  • Admin can apply different level of filters on report of Blog, Create Blog, Technology Blog
  • Admin can tracks the detailed information of Comment, Technology Blog, Blog, Blog Category

Report of Blogging System:

  • Generates the report on Create Blog,Blog Type,Blog,Blog Category,Comment,Technology Blog,
  • Blog Type,Comment,Technology Blog has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Blog Type,Comment,Technology Blog
  • Excel Sheet report has also been integrated for Blog Category,Blog Type,Technology Blog
  • You can create the CSV reports for Blog,Comment,Create Blog

Limitation of Blogging System

  • Run time report generation is not available in Blogging System.
  • We have not implemented the dynamic report for Blog,Blog Type,Comment,Blog Category,Create Blog,Technology Blog
  • This project Blogging System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Blog, Blog Type, Technology Blog cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Blogging System

  • We have added all the validations for input value on the modules Blog,Blog Category,Create Blog
  • Blog Type,Comment,Technology Blog can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Blog,Create Blog,Technology Blog
  • CSRF token has also been implemented on Blog Type,Blog Category,Blog, Comment,Technology Blog
  • All the Blog,Blog Type,Comment,Blog Category,Create Blog,Technology Blog has integrated with captcha for spam protections
  • Access level validation has been implemented on Technology Blog,Comment,Blog Type
  • Number and character validation has also been implemented on Create Blog,Comment,Blog

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database