<?php
            if(isset($_POST['submit']))  {
                $name = $_POST['name'];
                $matNo = $_POST['mat_number'];
                $age = $_POST['age'];
                $specialty = $_POST['specialty'];
                $gender = $_POST['gender'];

                if(!empty($name) && !empty($matNo) && !empty($age) &&
                        !empty($specialty) && !empty($gender))
            {

                $sql = "INSERT INTO `student`(`name`, `UB_number`, `age`,
                                      `sex`, `specialty`)
                VALUES ('$name', '$matNo', '$age', '$gender', '$specialty')";
                $conn->query($sql);
                header("Location: index.php");
            }
            else{
                echo "Error: Complete all records";
            }
            }

        ?>