I am creating a database project for a student information system for my database class using oracle and SQL. I want to create a login page that would prompt the user for login information so they could acess the student information in my database. Please show me how I would create a page with PHP and HTML to connect to my database to check if the username and password exists that the user provides. If the password and username exist, the page would go to the next page where you could see the information you have previlage for. I also want there to be an option for the user to create new login information (this case would only be for students). Students could see their information in the database only, but administration login could see all students information.

Also if there are any ideas for features I could implement in my site, I would greatly appreciate it. Thanks!