ChidoriSoul Posted May 23, 2009 Share Posted May 23, 2009 Hey, I need some help for my Tables on my RPG. Just some questions. I am using the DB for my Register Page, and here they are.1. Do I use multiple tables or 1 per each part of the registration page?RegisterAlso, if I need one table, with 7 different forms, then how do i fill these out with each of the parts in the link I mentioned above.Field: UsernameType: Length/Values: Collation: Attributes: Null: Yes/NoDefault **: ?Extra: ?Same thing withPassEmailShow EmailGenderStarter Link to comment Share on other sites More sharing options...
shakti Posted May 23, 2009 Share Posted May 23, 2009 Just make a table for register DB.Actually database table configaration depends on 'what you want'. Though I give some which you can use.You should also make a fields called "ID" which may contain users identity by INT. So I also give the configure for IDField: IDType: INTLength/Value: 11Collation: //Leave it blankAttributes: //Leave it blankNull: NoDefault: //Leave it blankExtra: auto_incrementSelect this as a Primary KeyField: UsernameType: varcharLength/Values: 50 //This is your choice that how much long username you will allow for users.Collation: utf8_general_ci // The default it will be latin1_swedish_ci. But Most of time I use utf8_general_ci because it is multilingualAttributes: // leave it blankNull: NoDefault **: // Leave it blankExtra: // Leave it blankField: PassType: varcharLength/Values: 64 // 32 is enough for md5Collation: utf8_general_ciAttributes: // Leave it blankNull: NoDefault : //leave it blankExtra: //leave it blankField: EmailType: varcharLength/Values: : 100Collation: utf8_general_ciAttributes: //Leave it blankNull: NoDefault: //Leave it blankExtra: //Leave it blankField: Show EmailType: ENUMLength/Values: 'Yes','No'Collation: utf8_general_ciAttributes: //Leave it blankNull: NoDefault: NoExtra: //Leave it blankField: GenderType: ENUMLength/Value: 'M','F' //M for male and F for female, if you want you can use 'Male','Female' Collation: utf8_general_ciAttributes: //Leave it blankNull: NoDefault: //Leave it blankExtra: //Leave it blankField: StarterType: varchar //You can use this also as ENUMLength/Value: 50 //If you want to use ENUM then you should write all your desired value here as like 'Bulbasaur','Charmander'Collation: utf8_general_ciAttributes: //Leave it blankNull: NoDefault: //Leave it blankExtra: //leave it blank Link to comment Share on other sites More sharing options...
ChidoriSoul Posted May 23, 2009 Author Share Posted May 23, 2009 Ok, now that I have that made, how do I connect it to each part of the Register PageOh, I have the PHP code for it, now where do I put that on the Register Page? Link to comment Share on other sites More sharing options...
ChidoriSoul Posted May 24, 2009 Author Share Posted May 24, 2009 hello? can anyone give me somes help here Link to comment Share on other sites More sharing options...
justsomeguy Posted May 26, 2009 Share Posted May 26, 2009 Oh, I have the PHP code for it, now where do I put that on the Register Page?Where do you put what on the register page? If you have the PHP code, what else do you need? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.