University Bulletin Board

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of University Bulletin Board

University Bulletin Board 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 University,University News,News Category,System State,Result News. Admin user can manage all the operations of System State,Result News,University,News Comments,University News and their details. Admin can create different type of reports of University,University News,News Category,System State,Result News according to their choise and filters. You can Download PHP and MySQL Project University Bulletin Board with source code and database from this site. We also provide Project Report of University Bulletin Board.

Functionalities and their descriptions of University Bulletin Board are as follows:

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

Modules of University Bulletin Board and their descriptions:

  • University Module : Manage all the operations of University
  • University News Module : Manage all the operations of University News
  • News Comments Module : Manage all the operations of News Comments
  • News Category Module : Manage all the operations of News Category
  • System State Module : Manage all the operations of System State
  • Result News Module : Manage all the operations of Result News

Classes and their methods of University Bulletin Board:

  • University Methods : addUniversity(), editUniversity(), deleteUniversity(), updateUniversity(), saveUniversity(), searchUniversity()
  • University News Methods : addUniversity News(), editUniversity News(), deleteUniversity News(), updateUniversity News(), saveUniversity News(), searchUniversity News()
  • News Comments Methods : addNews Comments(), editNews Comments(), deleteNews Comments(), updateNews Comments(), saveNews Comments(), searchNews Comments()
  • News Category Methods : addNews Category(), editNews Category(), deleteNews Category(), updateNews Category(), saveNews Category(), searchNews Category()
  • System State Methods : addSystem State(), editSystem State(), deleteSystem State(), updateSystem State(), saveSystem State(), searchSystem State()
  • Result News Methods : addResult News(), editResult News(), deleteResult News(), updateResult News(), saveResult News(), searchResult News()

Database tables and attributes of the University Bulletin Board:

  • University Entity : Attributes of University are university_id, university_name, university_place, university_type, university_description, university_address
  • University News Entity : Attributes of University News are university_news_id, university_news_university_id, university_news_title, university_news_type, university_news_description
  • News Comments Entity : Attributes of News Comments are comment_id, comment_user_id, comment_type, comment_title, comment_description
  • News Category Entity : Attributes of News Category are category_id, category_news_id, _category_type, category_description
  • System State Entity : Attributes of System State are system_state_id, system_state_name, system_state_type, system_state_description
  • Result News Entity : Attributes of Result News are result_news_id, result_news_student_id, result_news_name, result_news_type, result_news_description

Database definition of University Bulletin Board:

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

Super admin functionality of University Bulletin Board:

  • Admin can add, edit, delete and view the records of University, System State, News Comments, Result News
  • Admin can manage all the details of University News, News Comments, News Category, System State
  • Admin can also generate reports of University, University News, News Comments, News Category
  • Admin can search the details of University, System State, News Comments, Result News
  • Admin can apply different level of filters on report of University, News Comments, Result News
  • Admin can tracks the detailed information of System State, Result News, University, University News

Report of University Bulletin Board:

  • Generates the report on News Comments,News Category,University,University News,System State,Result News,
  • News Category,System State,Result News 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 News Category,System State,Result News
  • Excel Sheet report has also been integrated for University News,News Category,Result News
  • You can create the CSV reports for University,System State,News Comments

Limitation of University Bulletin Board

  • Run time report generation is not available in University Bulletin Board.
  • We have not implemented the dynamic report for University,News Category,System State,University News,News Comments,Result News
  • This project University Bulletin Board has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of University, News Category, Result News cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of University Bulletin Board

  • We have added all the validations for input value on the modules University,University News,News Comments
  • News Category,System State,Result News can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on University,News Comments,Result News
  • CSRF token has also been implemented on News Category,University News,University, System State,Result News
  • All the University,News Category,System State,University News,News Comments,Result News has integrated with captcha for spam protections
  • Access level validation has been implemented on Result News,System State,News Category
  • Number and character validation has also been implemented on News Comments,System State,University

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database