I have a database created in MYsql on my Ubuntu 10.10 box. I have Php5. My biggest problem is trying to create the index.html code to create/enter and validate data in the data base.
In my database I have 8 fields. id, username, ,password, sign_u_date, email, bio, account permissions"0","1" and email acctivation "0","1".
Now obviously some of these fields the form/database should populate its self, like ID, SignUpDate and account permissions.
If I create a page for a user to enter info for the rest of the fields like so:
Desired UserName: _____________ <This field would need to confirm is if it is available, That no one else already has the same name.
Password:____________________ < The second password field I would like it to confirm that the txt is the same on both password fields.
Email: _______________________ <Will need to confirm no one has already signed up with the entered address. will also need to send an email where a user will confirm the address changing the account permissions from a "0" to a "1" which I have set up in the database side.
and a Bio Section which could be blank.
If someone could explain or give me an example of how the index, php, mysql files should be set up to perform all these tasks, and what the code should look like would be a HUGE help... I would appreciate any help... I have many years in the data field but web creating is very new to me....
Thanks in advance....