"php-practice-project" is a student management system showcasing PHP and MySQL skills. This project provides a comprehensive opportunity to learn and practice basic backend development with PHP, database management with MySQL, and frontend functionalities. It features user authentication, record management, search functionality, and notes updating."
The "php-practice-project" is designed as a practical learning platform to help you become familiar with key aspects of web development. By creating a student management system, this project demonstrates how PHP, MySQL, and frontend technologies can work together to build a functional web application.
-
User Authentication: Users can log in with different access levels (administrator or user).
-
Record Management: The application allows adding, viewing, editing, and deleting student records.
-
Search Functionality: Users can search for students by first name or last name.
-
Notes Updating: Users (both administrators and users) can update notes for individual students.
-
Download CSV: Administrators can download student records as CSV files.
The project follows a structured approach to separate different functionalities:
-
Database: The project utilizes a MySQL database to store student records and user credentials.
-
Backend (PHP): PHP scripts handle user authentication, database interactions, and dynamic content generation.
-
Frontend (HTML/CSS/JavaScript): The frontend provides a user-friendly interface for interacting with the application.
Follow these steps to set up and run the "php-practice-project" on your local machine:
-
Prerequisites: Make sure you have a web server (such as Apache), PHP, and MySQL installed.
-
Clone or Download: Clone this repository to your local machine or download the ZIP file.
-
Database Setup: Create a MySQL database named
student_system
. Import the provided SQL files (student_list.sql
andstudent_users.sql
) to set up the necessary tables and sample data. -
Configure Database Connection: Open
connections/connection.php
and update the database connection credentials. -
Web Server Setup: Place the project files in your web server's directory (e.g.,
htdocs
for XAMPP/WAMP). -
Access the Application: Open a web browser and enter the project's URL. You'll be directed to the login page.
-
Login: Log in using the provided credentials:
- Administrator: Username:
admin
, Password:admin1
- User: Username:
user
, Password:user1
- Administrator: Username:
-
Explore the Project: Navigate through the dashboard, search for students, view details, and update notes.
Continue reading the next section for more detailed instructions on setting up and running the project.
Enjoy learning and experimenting with PHP, MySQL, and frontend development in this practical project!
Welcome to the php-practice-project! This project serves as a practical platform to learn and practice PHP programming, MySQL database management, and basic frontend development. It features a student management system with user authentication, record management, search functionality, and notes updating.
- Web Server: You'll need a web server to run PHP scripts. You can use Apache, Nginx, or XAMPP/WAMP for an all-in-one solution.
-
PHP and MySQL: Ensure that PHP and MySQL are installed on your system.
-
Text Editor or IDE: Choose a text editor or integrated development environment (IDE) to edit and manage the project files.
- Clone or Download the Repository: Start by cloning this repository to your local machine or downloading the ZIP file and extracting it.
-
Database Setup:
- Open a MySQL client (phpMyAdmin or MySQL command line).
- Create a new database named
student_system
. - Import the provided SQL files (
student_list.sql
andstudent_users.sql
) into thestudent_system
database. These files contain the table structures and sample data.
-
Configure Database Connection:
- Navigate to the
connections
directory and open theconnection.php
file. - Update the database connection credentials (hostname, username, password) based on your local MySQL setup.
- Navigate to the
-
Web Server Setup:
- Place the project files in the appropriate directory of your web server (e.g.,
htdocs
for XAMPP or WAMP). - Start your web server.
- Place the project files in the appropriate directory of your web server (e.g.,
-
Access the Application:
- Open a web browser and enter the URL of the project's directory (e.g.,
http://localhost/php-practice-project
). - You'll be redirected to the login page.
- Open a web browser and enter the URL of the project's directory (e.g.,
-
Login:
- Log in using the provided credentials:
- For administrators: Username:
admin
, Password:admin1
- For users: Username:
user
, Password:user1
- For administrators: Username:
- Log in using the provided credentials:
Once logged in, you can explore the project and interact with its features:
- Dashboard: After logging in, you'll be taken to the dashboard where you can view the list of students and perform various actions.
- Search: Use the search bar to search for students based on their first name or last name.
- View and Edit Student Details: Click on the "View" button to see detailed information about a student. Administrators can also edit student details on this page.
- Update Notes: On the student details page, administrators and users can update notes for the student.
- Add New Student: Administrators can add new students by clicking the "Add New" button on the dashboard.
- Download CSV: Administrators can download the student records in CSV format by clicking the "Download as .csv" button.
Congratulations! You've successfully set up and run the php-practice-project on your local machine. This project provides a practical opportunity to learn and practice PHP programming, MySQL database management, and basic frontend development. As you explore the different functionalities of the application, consider the areas for improvement mentioned in the documentation to enhance the project's security, usability, and overall functionality.
Feel free to experiment, make modifications, and further develop the project to solidify your skills and gain valuable hands-on experience in web development.
If you have any questions or need assistance, refer to the documentation or reach out to the project creators for guidance.
Happy learning and coding!