The queries within the adddata.php were encountering some issues when information was entered within the register form and submitted only the login details seemed to be stored within the database and echoes out on the following page.
I realised that there were variables that were not labelled properly therefore I adjusted them and attempted to submit the form again. Unfortunately the problem was not solved there seemed to be an undefined variable within the code that code not transfer or receive the information that was being inserted into the register page. After checking and trying to test the code multiple times and discussing the issue with Colin it was suggested that the name "user" for the table might be conflicting with the code. Although I previously checked that the name "user" was not predefined and was appropriate to use it seemed to be the only conflict encountered.
To solve the issue that was occurring within the query I created new columns within the database that stored some of the fields formerly placed within the user table. I also added the fields first name, surname and pnumber to the query and echoes section of the PHP code. This process was a success as the information entered within the register page was transferred and stored within the database.
The details entered into the form have been echoed out within the joined.php page.
Although the issue was solved I decided to keep the original code for the time being, I commented the PHP code so that it does not interfere with the rest.





No comments:
Post a Comment