Help Needed In creating Admin page

Question

I am creating a portal. for staff and student. I am done with the student page.. I am building the Staff page where the Staff can view student profile, add and edit information. The staff Will view all his student names as links... when he clicks on them he can view the profile of the particular student he clicks... please how can I link the information from the database to that particular student he clicks... with PHP and MYSQL.. sorry if I didn't ask the question well... thank You.

Answer 1

do you already have the database? do your entries have an id as primary key? use the id to get the information.

select * from students where id=$id;

put the id in the link

<a href="edit_student.php?id=$id"> John Doe </a>

and take it on the edit page: $_GET["id"];

Answer 2

Yeah. Thanks Very much.