School Management System IN PHP, MYSQL, BOOTSTRAP, and AJAX JQUERY | FREE DOWNLOAD

By | July 7, 2023

School Management System is a complete school management software design to automate a school’s diverse operations from classes, exams to school events. This project is written by PHP and MYSQL.

School Management System you can see the Front Page where all the details are shown and you can service teams, gallery, about us. You can even Enter the admission form. Firstly, Students are provided with their username and Password where they can enter their own page . Which contain student information such as name, roll no, slandered, Gender, Date of birth. Inside the student page the student can also change the passwords, see the teachers details, Subjects and their results. This project is based on User Interface.

 For the database connection in School Management System first you need create the database named project2.sql in the localhost/phpmyadmin/ and then you can import the database which is found inside the  project2.sql file .

The technologies used in this project are:

  • HTML: Page layout and design
  • CSS: Design
  • JS: Fontend
  • PHP: Backend

Supported Operating Systems:

You can run this project in the following operating systems:

  • Windows:
  • MAC:
  • Linux:

How To Run??

To run this project you must have installed a virtual server i.e XAMPP on your PC. School Management System in PHP with source code is free to download, Use for educational purposes only!

After Starting Apache and MySQL in XAMPP, follow the following steps

1st Step: Extract file
2nd Step: Copy the main project folder
3rd Step: Paste in xampp/htdocs/

Now Connecting Database

4th Step: Open a browser and go to URL “http://localhost/phpmyadmin/”
5th Step: Then, click on the databases tab
6th Step: Create a database naming “project2” and then click on the import tab
7th Step: Click on browse file and select “project2.sql” file which is inside the “education” folder
8th Step: Click on go.

After Creating Database,

9th Step: Open a browser and go to URL “http://localhost/education”

Project Demo

Download Source Code of School Management SITE IN PHP, CSS, JS, AND MYSQL


5 thoughts on “School Management System IN PHP, MYSQL, BOOTSTRAP, and AJAX JQUERY | FREE DOWNLOAD

  1. Kristof Mackson Laurent

    Error
    SQL query:

    CREATE TABLE IF NOT EXISTS `branch` (
    `id` int(10) unsigned NOT NULL,
    `Name` varchar(40) NOT NULL,
    `AccountNumber` varchar(40) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8
    MySQL said: Documentation

    #1046 – No database selected

    Hello i got error here when i important on localhost? please help me thank you

    Reply
  2. Double G

    The admin channel is have some error please I really need it fixed please

    Reply
  3. ssvm

    <?php

     
    class project2
       
    {
        public $server = “localhost”;
        public $username = “root”;
        public $password = “”;
        public $dbname = “project2”;
        public $connectdb;
       
        function __construct()
        {
            $this->connectdb = new mysqli($this->server,$this->username,$this->password,$this->dbname);
            if($this->connectdb->connect_error)
            {
                die(“connection failed”);
            }
        }
       
        public function hackme()
        {
            $this->connectdb = new mysqli($this->server,$this->username,$this->password,$this->dbname);
            return $this->connectdb;
        }
        public function student_login_check($st_username,$st_password)
        {
            $st_login_check = “select  * from st_info where st_username = ‘$st_username‘ and st_password=’$st_password‘”;
            $st_login_run = $this->connectdb->query($st_login_check);
            $st_login_num = $st_login_run->num_rows;
            return $st_login_num;
        }

        public function student_info_select($st_username)
        {
            $student_info_sel = “select * from st_info where st_username=’$st_username‘”;
            $student_info_run = $this->connectdb->query($student_info_sel);
           
            return $student_info_run;
        }
           
       
        /////////////////////////////// ADMINNNNNNNNNNNNNNNNN————————–
       
        public function meadmin_check($admin_username,$admin_password)
        {
            $meadin_login_select = “select * from meadmin where admin_username=’$admin_username‘ AND admin_password=’$admin_password‘”;
            $meadmin_login_run = $this->connectdb->query($meadin_login_select);
            $meadmin_login_num = $meadmin_login_run->num_rows;
            return $meadmin_login_num;
        }
        public function meadmin_username($adminname)
        {
            $meadmin_username_select = “select * from meadmin where admin_username=’$adminname‘”;
            $meadmin_username_run = $this->connectdb->query($meadmin_username_select);
            return $meadmin_username_run;
        }
       
        //////////////////////////////////Teacher Info ////////////////////////////////
        public function teacher_info($adminname,$t_staff_type)
        {
            switch($t_staff_type)
            {
                case “Admin”:
                $teacher_info_select = “select * from teacher_info where t_staff_type=’$t_staff_type‘ AND t_username=’$adminname‘”;
                break;
                case “Teacher”:
                $teacher_info_select = “select * from teacher_info where t_staff_type=’$t_staff_type‘ AND t_username=’$adminname‘”;
                break;
                default :
                    echo “no teacher found”;
            }
            $teacher_info_select_run = $this->connectdb->query($teacher_info_select);
            return $teacher_info_select_run;
           
       
           
        }
        public function teacher_info_display_admin()
        {
            $teacher_info_admin = “select * from teacher_info”;
            $teacher_info_admin_run = $this->connectdb->query($teacher_info_admin);
            return $teacher_info_admin_run;
        }
        ///// display teacher info in  student panel
        public function teacher_info_instudent($st_grade)
        {
            $teacher_info_instudent_select = “select * from subjects_info where grade=’$st_grade‘”;
            $teacher_info_instudent_run = $this->connectdb->query($teacher_info_instudent_select);
            return $teacher_info_instudent_run;
           
        }
        ////////////////////////End Teacher Info ————//////////////////////
       
        ///////////////////////// student password update //////////
       
        public function student_password_change($st_password_update,$st_username)
        {
            $student_password_update = “update st_info set st_password=’$st_password_update‘ where st_username=’$st_username‘”;
            $student_password_update_run = $this->connectdb->query($student_password_update);
            return $student_password_update_run;
        }
       
       
       
        ///////////////////——- end student password update ————–//////////////
       
        ///////////////////——– display subject in admin —————-////////
        public function subject_info()
        {
           
            $subject_info_admin = “select * from subjects_info”;
            $subject_info_admin_run = $this->connectdb->query($subject_info_admin);
            return $subject_info_admin_run;
        }
       
        ////////////  edit teacher information ////////////////////
       
        public function edit_teacherid($teacher_id)
        {
            $edit_teacherid = “select * from teacher_info where t_id=’$teacher_id‘”;
            $edit_teacherid_run = $this->connectdb->query($edit_teacherid);
            return $edit_teacherid_run;
        }
        ///////////////// update teacher info from admin/////////////
        public function update_teacher_info($up_fullname,$up_address,$up_email,$up_father,$up_mother,$up_dob,$up_qualification,$up_contact,$up_staff,$up_gender,$teacher_id)
        {
            $update_teacher_info_select = “update teacher_info set t_fullname=’$up_fullname‘,t_address=’$up_address‘,t_email=’$up_email‘,t_father=’$up_father‘,t_mother=’$up_mother‘,t_dob=’$up_dob‘,t_qualification=’$up_qualification‘,t_contact=’$up_contact‘,t_staff_type=’$up_staff‘,t_gender=’$up_gender‘ where t_id=’$teacher_id‘”;
            $update_teacher_info_run = $this->connectdb->query($update_teacher_info_select);
            return $update_teacher_info_run;
        }
       
        ////////// add new teacher form admin ////////////////////////
        public function add_teacher($add_t_fullname,$add_t_address,$add_t_email,$add_t_username,$add_t_pass,$add_t_father,$add_t_mother,$add_t_dob,$add_t_qualification,$add_t_contact,$add_t_staff,$add_t_gender)
        {
        $add_teacher = “insert into teacher_info(t_fullname,t_address,t_email,t_username,t_pass,t_father,t_mother,t_dob,t_qualification,t_contact,t_staff_type,t_gender) value(‘$add_t_fullname‘,’$add_t_address‘,’$add_t_email‘,’$add_t_username‘,’$add_t_pass‘,’$add_t_father‘,’$add_t_mother‘,’$add_t_dob‘,’$add_t_qualification‘,’$add_t_contact‘,’$add_t_staff‘,’$add_t_gender‘)”;
        $add_teacher_run = $this->connectdb->query($add_teacher);
            return $add_teacher_run;
        }
       
        //////// delete teacher form admin //////////////////////
        public function delete_teacher($del_teacher)
        {
        $delete_teacher_info = ” delete from teacher_info where t_id=’$del_teacher‘”;
        $delete_teacher_info_run = $this->connectdb->query($delete_teacher_info);
        return $delete_teacher_info_run;
        }
        ////////////////////// looping class from subject info table////////////////
        public function grade($grade)
        {
            $grade_select = “select class from sub_class_name”;
            $grade_run = $this->connectdb->query($grade_select);
            return $grade_run;
        }
       
        ///////////// display data from st_info select st-grade ///////////
        public function grade_st_info($grade_st_data)
        {
            $grade_st_info_select = “select * from st_info where st_grade=’$grade_st_data‘”;
            $grade_st_info_run = $this->connectdb->query($grade_st_info_select);
            return $grade_st_info_run;
        }
        ////////// student info display by admin //////////////////////////
        public function student_info_display_admin($class_students_data)
        {
            $student_info_display_admin_select = “select * from st_info where st_grade=’$class_students_data‘”;
            $student_info_display_admin_run = $this->connectdb->query($student_info_display_admin_select);
            return $student_info_display_admin_run;
        }
        /////////// add student from admin panel /////////////////////
        public function add_student($std_fullname,$std_username,$std_password,$std_grade,$std_roll,$std_dob,$std_address,$std_district,$std_gender,$std_father,$std_mother,$std_parent_contact)
        {
            $add_student_insert = “insert into st_info(st_fullname,st_username,st_password,st_grade,roll_no,st_dob,st_address,st_district,st_gender,st_father,st_mother,st_parents_contact) value(‘$std_fullname‘,’$std_username‘,’$std_password‘,’$std_grade‘,’$std_roll‘,’$std_dob‘,’$std_address‘,’$std_district‘,’$std_gender‘,’$std_father‘,’$std_mother‘,’$std_parent_contact‘)”;
            $add_student_run = $this->connectdb->query($add_student_insert);
            return $add_student_run;
        }
       
        ///////////// General Information about website ///////////
        public function general_setting($web_name,$web_address,$web_phone1,$web_phone2,$web_email1,$web_email2,$web_start,$web_about)
        {
            $general_setting_insert = “insert into general_setting(website_name,website_address,website_phone1,website_phone2,website_email1,website_email2,website_start,web_about) value(‘$web_name‘,’$web_address‘,’$web_phone1‘,’$web_phone2‘,’$web_email1‘,’$web_email2‘,’$web_start‘,’$web_about‘)”;
            $general_setting_run = $this->connectdb->query($general_setting_insert);
            return $general_setting_run;
        }
        public function general_setting_check()
        {
            $general_setting_check = “select * from general_setting”;
            $general_setting_run = $this->connectdb->query($general_setting_check);
            return $general_setting_run;
        }
        public function general_setting_update($upweb_name,$upweb_address,$upweb_phone1,$upweb_phone2,$upweb_email1,$upweb_email2,$upweb_start,$upweb_about)
        {
            $update_general_setting = “update general_setting set website_name=’$upweb_name‘,website_address=’$upweb_address‘,website_phone1=’$upweb_phone1‘,website_phone2=’$upweb_phone2‘,website_email1=’$upweb_email1‘,website_email2=’$upweb_email2‘,website_start=’$upweb_start‘,web_about=’$upweb_about‘”;
         $update_general_run = $this->connectdb->query($update_general_setting);
            return $update_general_run;
        }
        public function meravi_add_table($Nepdev_table_Name,$Nepdev_student_name,$Nepdev_student_grade,$Nepdev_subject1,$Nepdev_subject2,$Nepdev_subject3,$Nepdev_subject4,$Nepdev_subject5,$Nepdev_subject6,$Nepdev_subject7,$Nepdev_subject8,$Nepdev_subject9,$Nepdev_subject10,$Nepdev_subject11)
        {
            $Meravi_database = CREATE TABLE $Nepdev_table_Name(id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,$Nepdev_student_name varchar(250) Null,$Nepdev_student_grade varchar(10) null,$Nepdev_subject1 varchar(250) null,$Nepdev_subject2 varchar(250) null,$Nepdev_subject3 varchar(250) null,$Nepdev_subject4 varchar(250) null,$Nepdev_subject5 varchar(250) null,$Nepdev_subject6 varchar(250) null,$Nepdev_subject7 varchar(250) null,$Nepdev_subject8 varchar(250) null,$Nepdev_subject9 varchar(250) null,$Nepdev_subject10 varchar(250) null,$Nepdev_subject11 varchar(250) null)”;
            $Meravi_run = $this->connectdb->query($Meravi_database);
            return $Meravi_run;
        }
        public function Nepdev_Exam_Term($Nepdev_exam_term)
        {
            $Nepdev_Select = SELECT * FROM exam_term where name=$Nepdev_exam_term‘”;
            $Nepdev_Run = $this->connectdb->query($Nepdev_Select);
            if($Nepdev_Run->num_rows>0)
            {
                echo “<script>alert(‘You Have ALready Added $Nepdev_exam_term‘);</script>”;
            }
            else
            {
                $Nepdev_Add = INSERT INTO exam_term(name) VALUES(‘$Nepdev_exam_term‘)”;
                $Nedev_Add_Run = $this->connectdb->query($Nepdev_Add);
                if($Nedev_Add_Run==true)
                {
                    echo “<script>alert(‘Success Added $Nepdev_exam_term‘);</script>”;
                    }
                }
                return  $Nepdev_Run;
        }
        }
    $ravi = new project2;

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *