FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Help for sign_up form





jcvincent
Hello guys! i'm just wondering how can i create a singup form for my websit? i already know how to create a form, but i don't know how to give the user a primary key with a CHAR data type. Whats your suggestions about this?

I'm not going to use the (INT not null auto_increment) thing because I want the users to have a unique UserID using the data type CHAR. Please help.

Thank you so much!
Roald
It's very simple
Code:
CREATE TABLE 'members' (
'name' CHAR( 20 ) NOT NULL ,
PRIMARY KEY ( 'name' )
)
jcvincent
Roald wrote:
It's very simple
Code:
CREATE TABLE 'members' (
'name' CHAR( 20 ) NOT NULL ,
PRIMARY KEY ( 'name' )
)


This is not what I mean:

This is the table:

Create table TBL_User
(
userID char(10) not null primary key,
userName varchar(50) not null
);


Now, how can I give the user a userID automatically without having to encode its user ID? I'm using php 4, mysql 4, and an apache server.
SlowWalkere
Do you mean you want to generate a random 10-char id each time a user is registered? Seems a bit strange, but it's do-able...

Code:

$letters = array ('a', 'b', 'c', 'd', ... 'z');    // Define 26 letters into an array
$uid = "";    Initialize $uid to a blank string

$col = 0;
while ($col++ < 10)
{
  $slot = rand(0, 25);    //  Loop ten times, add a random char
  $uid = $uid . $letters["$slot"];
}

// Connect to DB here, check if $uid already exists, and then upload


Or, instead of a random generator, you could have the user supply an id in the registration form. Then, check the DB to see if a row already exists with that id. If it doesn't, the registration is uploaded successfully, otherwise an error is printed and the user is sent back to the registration form.
Related topics
How did you come up with your username?
Help with upload form script! [RESOLVED]
Please Help? CGI form mail on my site... only 2 questions!
Uplaoding images using php form :::: Help needed
Anyone care to help me with a simple PHP Form ?
form mail problems (quality help=frih$)
If you have created a form on your site you can help...
Form Processing Help. It is doing my head in
Form Mail help........lol
Need help with a submit form
Any DIABLO 2 LOD fans out there?
help getting form info into mysql db
Direct Action To Stop The War Reemerges
Need Help-- Order Form in Flash
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.