Student Database Viewer is a lightweight web-based application that allows users to view student information stored in a MySQL database table. The application is built using PHP for server-side scripting and HTML for the user interface. It provides a simple and user-friendly interface to access student records efficiently.
- View student information from the database in a tabular format.
- Database table with the following fields:
rollNo
: Unique identifier for each student (integer or string).studName
: Name of the student (string).studDept
: Department in which the student is enrolled (string).passingYear
: Year in which the student is expected to graduate (integer).classGrades
: Grades achieved by the student (string), with possible values: "First Class", "Second Class", or "Pass".
Before using the Student Database Viewer, ensure you have the following:
- PHP (version 7.0 or higher) installed.
- MySQL server (version 5.6 or higher) with a database created and configured.
- A web server (e.g., Apache or Nginx) to host the application.
- Web browser to access and interact with the UI.
-
Clone this repository to your local machine or web server.
git clone https://github.com/aadithlasar/SDV-V1.git
-
Import the
database.sql
file into your MySQL database to create the required table and entries. -
Configure the database connection in the
config.php
file. Provide the appropriate database credentials (hostname, username, password, database name) as per your MySQL setup.
-
Ensure your web server is running and configured correctly.
-
Open your web browser and navigate to the location where you placed the application files (e.g.,
http://localhost/student-database-viewer
). -
The main page will display a list of all student records in the database.
-
Use the table to view student information, including roll number, name, department, passing year, and grades.
Contributions are welcome to improve the application's functionality, UI/UX, or to fix any issues. If you want to contribute, follow these steps:
-
Fork the repository.
-
Create a new branch for your feature or bug fix.
-
Make your changes and commit them with descriptive commit messages.
-
Push the changes to your fork.
-
Submit a pull request to the main repository.
This project is open-source and licensed under the MIT License. You are free to use, modify, and distribute the code for personal or commercial purposes
Feel free to explore and use the Student Database Viewer to efficiently access and display student information. If you encounter any issues or have suggestions for improvement, please don't hesitate to reach out. Happy viewing!