News Portal System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of News Portal System

News Portal 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 News,Contents,Advertisement,Latest Posts,News Tupe. Admin user can manage all the operations of Latest Posts,News Tupe,News,Media,Contents and their details. Admin can create different type of reports of News,Contents,Advertisement,Latest Posts,News Tupe according to their choise and filters. You can Download PHP and MySQL Project News Portal System with source code and database from this site. We also provide Project Report of News Portal System.

Functionalities and their descriptions of News Portal System are as follows:

  • You can search records on various criterias. Such as News, Advertisement, Latest Posts, News Tupe
  • Create, read, update and delete (CRUD) application has been implemented on News,Contents,Advertisement,Latest Posts,News Tupe
  • Keep the track logs of Contents, Media, Latest Posts ect
  • Advance search has been implemented on Contents,Media, Latest Posts
  • You can see all the details of the News, Advertisement, Media, Latest Posts
  • All the modules Media, Latest Posts, Contents,News Tupe, News are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Latest Posts.
  • All the Contents,Media, Latest Posts 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 News data.

Modules of News Portal System and their descriptions:

  • News Module : Manage all the operations of News
  • Contents Module : Manage all the operations of Contents
  • Media Module : Manage all the operations of Media
  • Advertisement Module : Manage all the operations of Advertisement
  • Latest Posts Module : Manage all the operations of Latest Posts
  • News Tupe Module : Manage all the operations of News Tupe

Classes and their methods of News Portal System:

  • News Methods : addNews(), editNews(), deleteNews(), updateNews(), saveNews(), searchNews()
  • Contents Methods : addContents(), editContents(), deleteContents(), updateContents(), saveContents(), searchContents()
  • Media Methods : addMedia(), editMedia(), deleteMedia(), updateMedia(), saveMedia(), searchMedia()
  • Advertisement Methods : addAdvertisement(), editAdvertisement(), deleteAdvertisement(), updateAdvertisement(), saveAdvertisement(), searchAdvertisement()
  • Latest Posts Methods : addLatest Posts(), editLatest Posts(), deleteLatest Posts(), updateLatest Posts(), saveLatest Posts(), searchLatest Posts()
  • News Tupe Methods : addNews Tupe(), editNews Tupe(), deleteNews Tupe(), updateNews Tupe(), saveNews Tupe(), searchNews Tupe()

Database tables and attributes of the News Portal System:

  • News Entity : Attributes of News are news_id, news_title, news_type, news_description
  • Contents Entity : Attributes of Contents are content_id, content_news_id, content_title, content_type, content_description
  • Media Entity : Attributes of Media are media_id, media_name, vtype, media_description
  • Advertisement Entity : Attributes of Advertisement are advertisement_id, advertisement_title, advertisement_Type, advertisement_description
  • Latest Posts Entity : Attributes of Latest Posts are post_id, post_name, post_type, post_description
  • News Tupe Entity : Attributes of News Tupe are news_type_id, news_type_news_id, news_type_name, news_type_description

Database definition of News Portal System:

  • The details of News is store into the News tables respective with all tables
  • Each entity (News Tupe, Media, Latest Posts, Contents, News) contains primary key and unique keys.
  • The entity Media, Latest Posts has binded with News, Contents entities with foreign key
  • There is one-to-one and one-to-many relationships available between Latest Posts, Advertisement, News Tupe, News
  • All the entities News, Latest Posts, Media, News Tupe are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of News Portal System tables for fast query execution.

Super admin functionality of News Portal System:

  • Admin can add, edit, delete and view the records of News, Latest Posts, Media, News Tupe
  • Admin can manage all the details of Contents, Media, Advertisement, Latest Posts
  • Admin can also generate reports of News, Contents, Media, Advertisement
  • Admin can search the details of News, Latest Posts, Media, News Tupe
  • Admin can apply different level of filters on report of News, Media, News Tupe
  • Admin can tracks the detailed information of Latest Posts, News Tupe, News, Contents

Report of News Portal System:

  • Generates the report on Media,Advertisement,News,Contents,Latest Posts,News Tupe,
  • Advertisement,Latest Posts,News Tupe 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 Advertisement,Latest Posts,News Tupe
  • Excel Sheet report has also been integrated for Contents,Advertisement,News Tupe
  • You can create the CSV reports for News,Latest Posts,Media

Limitation of News Portal System

  • Run time report generation is not available in News Portal System.
  • We have not implemented the dynamic report for News,Advertisement,Latest Posts,Contents,Media,News Tupe
  • This project News Portal System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of News, Advertisement, News Tupe cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of News Portal System

  • We have added all the validations for input value on the modules News,Contents,Media
  • Advertisement,Latest Posts,News Tupe can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on News,Media,News Tupe
  • CSRF token has also been implemented on Advertisement,Contents,News, Latest Posts,News Tupe
  • All the News,Advertisement,Latest Posts,Contents,Media,News Tupe has integrated with captcha for spam protections
  • Access level validation has been implemented on News Tupe,Latest Posts,Advertisement
  • Number and character validation has also been implemented on Media,Latest Posts,News

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database