Online-News-Portal-using-PHP-and-MySQL

所属分类:数据库管理工具
开发工具:PHP
文件大小:30036KB
下载次数:0
上传日期:2021-09-09 20:53:05
上 传 者sh-1993
说明:  在这个存储库中,我演示了一个使用PHP和MySQL的“在线新闻门户”web应用程序。这是一个web数据库...
(In this repository, I demonstrated a "Online News Portal" web application using PHP and MySQL. This is a web database application system that is to be used by the public to read and search news. The system keeps the record of all the admin, authenticated viewer. This system also has the ability to keep track of the news as well as comment)

文件列表:
ER Diagram.png (174139, 2021-09-10)
LICENSE (1074, 2021-09-10)
Online News Portal.zip (14226352, 2021-09-10)
Online News Portal (0, 2021-09-10)
Online News Portal\Admin (0, 2021-09-10)
Online News Portal\Admin\AdminBangladeshPage.php (10036, 2021-09-10)
Online News Portal\Admin\AdminBusinessPage.php (10356, 2021-09-10)
Online News Portal\Admin\AdminEntertainmentPage.php (10364, 2021-09-10)
Online News Portal\Admin\AdminHomepage.php (10280, 2021-09-10)
Online News Portal\Admin\AdminInternationalPage.php (10354, 2021-09-10)
Online News Portal\Admin\AdminJobPage.php (10016, 2021-09-10)
Online News Portal\Admin\AdminLifestylePage.php (10361, 2021-09-10)
Online News Portal\Admin\AdminProfile.php (13400, 2021-09-10)
Online News Portal\Admin\AdminSignIn.php (7112, 2021-09-10)
Online News Portal\Admin\AdminSinglePageNewsViewModule.php (12826, 2021-09-10)
Online News Portal\Admin\AdminSportsPage.php (10360, 2021-09-10)
Online News Portal\Admin\ConnectAdminDeleteComments.php (364, 2021-09-10)
Online News Portal\Admin\ConnectAdminSignIn.php (614, 2021-09-10)
Online News Portal\Admin\ConnectEditAdminProfile.php (1983, 2021-09-10)
Online News Portal\ConnectSearch.php (35831, 2021-09-10)
Online News Portal\DatabaseConnection.php (289, 2021-09-10)
Online News Portal\Images (0, 2021-09-10)
Online News Portal\Images\1C64Qmq.jpg (434858, 2021-09-10)
Online News Portal\Images\AAFRWoj.jpg (285686, 2021-09-10)
Online News Portal\Images\CzUSwWl.jpeg (361744, 2021-09-10)
Online News Portal\Images\EditIcon.PNG (2877, 2021-09-10)
Online News Portal\Images\FacebookIcon.PNG (545, 2021-09-10)
Online News Portal\Images\GJd9sZn.jpg (130825, 2021-09-10)
Online News Portal\Images\InstaIcon.PNG (1222, 2021-09-10)
Online News Portal\Images\K8MiLVo.png (419218, 2021-09-10)
Online News Portal\Images\SearchIcon.PNG (290, 2021-09-10)
Online News Portal\Images\TwitterIcon.PNG (973, 2021-09-10)
Online News Portal\Images\Upazila-Parishad-Job-Circular-2020.jpg (189010, 2021-09-10)
Online News Portal\Images\UserIcon.PNG (488, 2021-09-10)
Online News Portal\Images\WBIbTwt.png (548619, 2021-09-10)
Online News Portal\Images\YoutubeIcon.PNG (1217, 2021-09-10)
Online News Portal\Images\bangladesh_under_19.jpg (61743, 2021-09-10)
Online News Portal\Images\d7EsHsl.jpg (274175, 2021-09-10)
Online News Portal\Images\efece96b40a6c9bde4cd900d5a41bc15-45ee44a422473458301443f707cbd12d-5940d983649a5.jpg (21293, 2021-09-10)
... ...

Online-News-Portal-using-PHP-and-MySQL

Project Purpose:

The purpose of the online news portal is to give the public the opportunity to read and search up-to-date news, as well as to give authenticated users the opportunity to comment on specific news.

Project Goals and Objectives:

  • To provide immediate storage and retrieval of data and information to get all kinds of instant and important news for all viewers.
  • To provide a free text search function facility for all news seeker.
  • To provide a secure account management function for admin and viewers.
  • To allow authenticated viewers to comment on specific news.
  • To provide an efficient news management functions to the admin panel to publish news as well as delete and update news.

Project Description:

This is a database application system that is to be used by the public to read and search news in anytime and anywhere. The system keeps the record of all the admin, authenticated viewer. This system also has the ability to keep track of the news as well as comment record. This project intends to computerize online news portal system in order to provide the instant and important news and also to provide searching facility due to the grown size of records of news. As well as this project have the intention to publish all kinds of important and breaking news in order to expose the truth to everyone due to the grown size of fake and biased newspaper.

System Users:

  • Administrator: Has full privilege on the system's functions including admin panel maintenance.
  • Admin Panel: Has full privilege on the news and comments functions.
  • Authenticated Viewers: Has privilege in own comments function.

Language:

  • Frontend Design: HTML5, CSS, Boostrap4, JavaScript.
  • Scripting Language: PHP.
  • Database: MySQL.
  • Server: Apache.

ER Diagram:

  • A complete ER Diagram for the system:

Processes

  • Login: The system provides security features through username-password matching where only authorized user can access the system with different authorization level. This system has three authorization level. Administrator, Admin Panel and Viewer.
    Log In page of administrator     Log In page of Admin Panel       Log In page of Viewers
              
    
  • Viewer Profile Registration: This system allows to register as viewer to read as well as comment on news.
    Viewer Registration Page         Viewer Comment Box
         
    
  • News Management: The admin panel can manage the news to add, update, delete news through this system. Each process or work-flow can be traced from the database. The admin panel can also control the comments on news through this system.
    News management Functions        Admin Comment Box
         
    
  • Admin Panel Management: The records of all admin panel and viewers are kept in one centralized database. The record of admin panel is maintained by the administrator through this system.
    Admin Panel Management Box
    
    
  • Search: All users can search with any key value for the news through this system. Also users can search with news category, reporter name, date, time etc.
    Search Result Box
    
    
  • Single Page News View Module: Users can view a specific news in a single page through this system.
    Single page news view module
    
    

Important guidelines for project management:

  • Unzip "Online News Portal.zip" file.
  • Copy "Online News Portal" folder and paste it into your localhost folder.
  • "Online News Portal/Public/Homepage.php" This is the first homepage for public.
  • Email: admin@gmail.com
    Password: @admin123
    • This is the email and password for administrator.
    • Administrator can change his password after log in.
    • After log in as a administrator he can manage admin panel.
  • Given sql file has to be import in localhost and it must be named "online news portal" when importing.


近期下载者

相关文件


收藏者