Presentation

1.

Project name: "Online IT Courses Platform"
Author: Aisamzhan Ravil and Bazarbayev Galymzhan Date: 2024

2.

How is the project structured?
IT_courses/
│
├── css/
│ └── style.css # Interface styling
│
├── js/
│ └── script.js # Modal window and search logic
│
├── index.php # Main page with course catalog
├── login.php # Authorization page
├── signup.php # Registration page
├── course.php # Page with course information
├── review.php # Adding and viewing reviews
├── profile.php # User profile
├── logout.php # Ending user session
└── submit.php # Processing registration requests
2

3.

How did we connect the database to the project?
3

4.

What does the main page look like?
4

5.

Database architecture
The diagram
illustrates the
structure of the
database used in
the online course
project. It consists
of seven
interconnected
tables:
1)Users
2)Teachears
3) Courses
4) Clients
5) Enrollments
6) Grades
7) Reviews
5

6.

Main functionality
Main functionality: User registration
New user registration:
The user enters the username, password, and email in the
registration form.
The data is checked for correctness before being saved.
Password security:
Passwords are encrypted using the bcrypt hash function before
being saved to the database, ensuring the security of user data.
Saving to the database:
The user data is saved in the users table of the PostgreSQL
database.
The SQL query SELECT * FROM users demonstrates the successful
addition of a user to the database.
6

7.

Main functionality
You can log in after you
have registered on the site.
You can only log in with an
existing account
7

8.

Main functionality
Choose any course, leave
your phone number. After
that, your phone number
is saved in the clients
table.
8

9.

Main functionality
9

10.

Main functionality
If we want to delete a review, the following happens:
Deleting a review:
Checking if the review belongs to the current
user.
Deleting a review from the database.
Redirecting to the course page to prevent
resubmitting the form.
Error handling and protection against deleting
other people's reviews.
10

11.

Conclusion
1) The project implements a functional platform for online
courses using PHP, PostgreSQL and JavaScript.
2) The system allows users to register, leave reviews, enroll in
courses and manage their information.
3) Key security aspects were worked out, including password
protection and data validation.
4) The project demonstrates the basics of building web
applications that can be expanded and integrated with other
services.
11