Blog Community World!

Contents

• About The Project
• About Databases
• Technologies
• About Admin Panel Operations
• Customer Register and Sign-In
• Sports Articles Homepage
• A Sport Article Detail
• Admin Sign-In Panel
• Admin Panel Homepage
• Admin Panel Sports Articles General View
• Admin Panel Add New Sports Articles
• Admin Panel Update Sports Articles
• Admin Panel Remove and Activ Operations For Sports Articles
• Admin Panel - Show Members

About The Project

• This is a dynamic web application publishing new articles about daily topics, and also breaking news especially on the subjects of sports and culture.

• Users can register and sign-in the application.

• Breaking news are published by the admin.

• Any news can be added, updated, deleted, and managed by admin panel based on database operations.

• Users can read whatever they want, and search the topics they would like to read.

About Databases

• Database: customers --> table: customersinfo

All the records about the users of the application are kept here. Admin can see who registered the application to read new articles, using admin panel.

• Database: articles --> tables: sports, culture

All the records about new articles and blogs are kept here. Admin can add new article, update an existing one, delete, make pasive or aktive, using admin panel. And all these operations are provided from MySQL database.

There is one-to-many relations between:

• teams: sports (provided by 'baslik')

• countries: culture (provided by 'baslik')

Technologies That Is Used

• The user interface of the project is designed, conceived and completed by HTML5 - CSS3 and Bootstrap.

• In order to make the application to gain dynamic attributes, PHP - PDO concept has been used. So that we can build the bridge between web application and our database system. The connection between the site and database has been provided by PHP - PDO and MySql technologies. So all the data is stored, kept and managed by MySql.

About Admin Panel Operations

All admin panel operations;

• Admin Homepage

• Show Articles List

• Add New Article

• Update an Article That Exists

• Remove an Article

• Change Activity of an Article

• See All Members

All of this operations are provided by database functionalities which are described above. So the main purpose here is to make the web application dynamic so that the owner of the app can easily manage all functions from admin panel.

The inputs at the interface corresponds to the columns from the related table. The connection between the user interface and the database is provided by PHP-PDO and MySQL technologies.

Customer Register and Sign-In

• Users should reigster and sign-in in order to read articles. This sign-in / register operations is provided by user interface at the front-end and a database system at the back-end.

• Register:

• Sign-In:

Sports Articles Homepage

A Sport Article Detail

Admin Sign-In Panel

Admin Panel Homepage

Admin Panel Sports Articles General View

Admin Panel Add New Sports Articles

Admin Panel Update Sports Articles

Admin Panel Remove and Activ Operations For Sports Articles

Admin Panel - Show Members