Somehow I am stuck now. I know there is an error in my thinking but I do not come out:
Entering data via a form and the data is recorded in a MySQL database
When looking at Apply your knowledge 6-2 on page 84 I find two files 'add-record_form.php' and 'via_browser.php'. Now I come to the problem in the final prac: whenever I enter data in my studentregistration form via the browser there is only a new record added to the database 'registration' - table 'student'- yes a new student no. is given since this is the primary key but the other fields remain empty. When I enter the data which I entered in the form now in the second file like 'via_browser.php' then the fields are filled with those data. But this would make no sense since the database should be automatically filled when entering data in the form fields without involving another php file.
So, there must be something wrong in my thinking but I cannot figure it out.
Hope I could be clear enough...
Does anybody has an idea?
Greetings from foggy Germany
Thanks for your prompt response - now I could solve the problem.
Just one other question:
In your project information you indicate 'Course name' as the first field in the student registration form. I am just wondering because this field is not in the student table but in the course table.
Hence we have to insert data into both DBs 'student' and 'course', right? I am not sure about the statement [(RP 1 Collect course name) from the database] in your project information - for what purpose should the course name be collected?