How to get results from my database displayed onto my webpage?

[jekwumoore]

Hello. I would like an example of how to get results stored in my database to be displayed on my webpage by an action to be performed by a visitor to my website.

I have created a database

database is africadi_students

username: africadi_openme

password: meandme

below are the fields in a table I created in my database named filestudent(filestudent is the name of my table)

ID first name last name phone number matricno scores





so I will need the format of the html page
and I will also need the format of the php(mysql) code that will make results to be displayed on my website

My aim is that students will enter their matric no, first name or last name in a search box and when they perform the search function, their scores will be displayed.

 

[v2Media]

FYI, in AU, this would be considered a breach of privacy. Student results are not considered public knowledge.

A more appropriate system would be for each student to get a password to logon to the site. After logging on, the student could visit the results page to view their scores.

 

[jekwumoore]

I am only learning
whats has FYI got to do with my learning web designing?

I want to use the format for other types of database