New to PHP - need help to formulate an idea please!!
I am currently a teacher at a college in the UK. I am exploring new ways in which learning can be enhanced. I have had the idea of developing a simple web based register system whereby I can add students/delete students etc and simply enter a mark against their name. If I get to grips with this, I would then like to be able to retrieve percentages etc. Can anyone help me in pointing me in the right direction?
I am quite new to php, and really don't know where to start in terms of creating a template?
Break it down into parts, and try finding tutorials on how to do one step at the time, until you have a good enough understanding on how things work to rely on the [url=http://www.php.net/manual/en/]PHP[/php] and MySQL (or whatever DBMS you choose) documentation.
Html form to enter data for a new student.
PHP to parse form and perform INSERT query against the DBMS.
List students, in one or more ways. Perhaps pagination by initial letter of name. Possibility to sort by grade?
Search student. Html form to enter (part of) student name
PHP code to parse post data, construct SQL query, and execute it against the DBMS.
Update (modify) or delete student. Turn each "student output" into a link (<a>..</a> element) that goes to a page showing the same form as in Part 1, but with preset values for this particular student. Keep track of this student's ID and use an update or delete query.