Advertisement Management System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Advertisement Management System

Advertisement Management 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 Advertisement,Advertisement Types,Payments,Customers,Places. Admin user can manage all the operations of Customers,Places,Advertisement,Sizes,Advertisement Types and their details. Admin can create different type of reports of Advertisement,Advertisement Types,Payments,Customers,Places according to their choise and filters. You can Download PHP and MySQL Project Advertisement Management System with source code and database from this site. We also provide Project Report of Advertisement Management System.

Functionalities and their descriptions of Advertisement Management System are as follows:

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

Modules of Advertisement Management System and their descriptions:

  • Advertisement Module : Manage all the operations of Advertisement
  • Advertisement Types Module : Manage all the operations of Advertisement Types
  • Sizes Module : Manage all the operations of Sizes
  • Payments Module : Manage all the operations of Payments
  • Customers Module : Manage all the operations of Customers
  • Places Module : Manage all the operations of Places

Classes and their methods of Advertisement Management System:

  • Advertisement Methods : addAdvertisement(), editAdvertisement(), deleteAdvertisement(), updateAdvertisement(), saveAdvertisement(), searchAdvertisement()
  • Advertisement Types Methods : addAdvertisement Types(), editAdvertisement Types(), deleteAdvertisement Types(), updateAdvertisement Types(), saveAdvertisement Types(), searchAdvertisement Types()
  • Sizes Methods : addSizes(), editSizes(), deleteSizes(), updateSizes(), saveSizes(), searchSizes()
  • Payments Methods : addPayments(), editPayments(), deletePayments(), updatePayments(), savePayments(), searchPayments()
  • Customers Methods : addCustomers(), editCustomers(), deleteCustomers(), updateCustomers(), saveCustomers(), searchCustomers()
  • Places Methods : addPlaces(), editPlaces(), deletePlaces(), updatePlaces(), savePlaces(), searchPlaces()

Database tables and attributes of the Advertisement Management System:

  • Advertisement Entity : Attributes of Advertisement are advertisement_id, advertisement_title, advertisement_Type, advertisement_description
  • Advertisement Types Entity : Attributes of Advertisement Types are advertisement types_id, advertisement Types_title, advertisement types_description
  • Sizes Entity : Attributes of Sizes are sizes_advertisement_id, size_description
  • Payments Entity : Attributes of Payments are payment_id, payment_customer_id, payment_date, payment_amount, payment_description
  • Customers Entity : Attributes of Customers are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
  • Places Entity : Attributes of Places are place_id, place_name, place_address, place_description

Database definition of Advertisement Management System:

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

Super admin functionality of Advertisement Management System:

  • Admin can add, edit, delete and view the records of Advertisement, Customers, Sizes, Places
  • Admin can manage all the details of Advertisement Types, Sizes, Payments, Customers
  • Admin can also generate reports of Advertisement, Advertisement Types, Sizes, Payments
  • Admin can search the details of Advertisement, Customers, Sizes, Places
  • Admin can apply different level of filters on report of Advertisement, Sizes, Places
  • Admin can tracks the detailed information of Customers, Places, Advertisement, Advertisement Types

Report of Advertisement Management System:

  • Generates the report on Sizes,Payments,Advertisement,Advertisement Types,Customers,Places,
  • Payments,Customers,Places 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 Payments,Customers,Places
  • Excel Sheet report has also been integrated for Advertisement Types,Payments,Places
  • You can create the CSV reports for Advertisement,Customers,Sizes

Limitation of Advertisement Management System

  • Run time report generation is not available in Advertisement Management System.
  • We have not implemented the dynamic report for Advertisement,Payments,Customers,Advertisement Types,Sizes,Places
  • This project Advertisement Management System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Advertisement, Payments, Places cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Advertisement Management System

  • We have added all the validations for input value on the modules Advertisement,Advertisement Types,Sizes
  • Payments,Customers,Places can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Advertisement,Sizes,Places
  • CSRF token has also been implemented on Payments,Advertisement Types,Advertisement, Customers,Places
  • All the Advertisement,Payments,Customers,Advertisement Types,Sizes,Places has integrated with captcha for spam protections
  • Access level validation has been implemented on Places,Customers,Payments
  • Number and character validation has also been implemented on Sizes,Customers,Advertisement

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database