signup page help

[keepitsimple]

I want to build double opt in signup page
this is my first php script after creating few scripts using w3 site

now I need help in creating db

in mysql I was not able to create fields /table

whenever i create table i gives me one or other error

Fields i will be inserting are

userid //primary key >> 8>> i think i made it primary key // will autoincrement >. check>> a_i
name, varchar >>20
emailid, varchar >> 30
confirmationcode, varchar 20
ipaddresssignup, varcahr 20
datetime, date

i dont what to enter for length and values so entered above numbers

I have created first page form with name and email id
with post method

then I have to create mysql connection and insert data

thankyou in advance 🙂

[JVassie]

Which bit of software are you using to manage your database? PHPMyAdmin

whenever i create table i gives me one or other error

What exact error messages were they?

[keepitsimple]

thankyou very much 🙂 for dropping by my thread.

yes i am using phpmyadmin

and table creation error has been resolved.
it was actually I was giving initial value .. when I set it to none then table was created.

done mysql insertion also.
next i have to try

I have to send email confirmation link
and then activating them
create a unique username << which I will use as referral ID

i also have to send activation code thru sms also

[JVassie]

Glad you got the database problems sorted 🙂

As for sending emails, it is very simple to do, either by using the simple mail() function, or alternatively using a free php email class like PHPMailer

As for sending SMS through PHP, you will need an SMS gateway, such as http://www.tm4b.com/

You mention a unique username, is this something they pick?

[keepitsimple]

for unique user name it can be something they pick or i can assign
as I am going to use it for referral
and i dont want them to know how many user have registered.
I have userid assigned as primary key