473,324 Members | 2,548 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

form registration design...

Hi,

I am making a small registration form about cars in three steps. The
first step is to fill in member data. After filled out the member data
hit "next" and enter car information. Hit "next" and upload pictures
of the cars which is step 3.

I have 2 database tables in mysql "member" and "cars". "member" is
used in step 1 and "cars" is used in step 2 and step 3.
What is proper design of making this work.

1. Is it to store the data in the database after finnishing each step?
If it is how do I handle cases when the user hit "back" and want to
change something on a prior step of the registration. How do I handle
if the user finnish step 1 och step 2 but exit and never do step 3?
etc..

2. or is it to validate the data and write it all down after
finnishing step 3. If this is the way to do it, how do I store
data(all variables used in step 1 and step 2) so I can fetch it in the
end of step 3 for write down in my database.

is there another way to do it? please help me to do this right...

I am writing this in PHP. Is there any praxis how to do registration
forms?
Is there any tutorial on this subject that I can read?

thanks

karolina
Jul 17 '05 #1
4 3015
karolina a écrit le 19/01/2004 :
Hi, Hello,
I am making a small registration form about cars in three steps. The
first step is to fill in member data. After filled out the member data
hit "next" and enter car information. Hit "next" and upload pictures
of the cars which is step 3. You can also combine Steps 2 and 3 in the same form.
I have 2 database tables in mysql "member" and "cars". "member" is
used in step 1 and "cars" is used in step 2 and step 3.
What is proper design of making this work. This seems OK to me. I guess one member can manage multiples cars.
1. Is it to store the data in the database after finnishing each step?
If it is how do I handle cases when the user hit "back" and want to
change something on a prior step of the registration. How do I handle
if the user finnish step 1 och step 2 but exit and never do step 3?
etc.. For me, I would say "Registration" is just the step concerning
Membership. The car things are the "normal use" of your service.
Therefore, registration is OK because in only one step. It is done or
not no half measure. For the car part, you can add a flag in your db to
tell if data input is completed or not. Then depending on the value of
this flag you can choose to resume where the user was.
2. or is it to validate the data and write it all down after
finnishing step 3. If this is the way to do it, how do I store
data(all variables used in step 1 and step 2) so I can fetch it in the
end of step 3 for write down in my database.

is there another way to do it? please help me to do this right... There are surely many ways to do the same thing. Yours is not bad IMHO.
I am writing this in PHP. Is there any praxis how to do registration
forms?
Is there any tutorial on this subject that I can read? Google and some PHP scripts related sites.
thanks You're welcome ;)
karolina

Ben.
Jul 17 '05 #2
Jedi121 <je*********@free.fr.Removethis> wrote in message news:<me********************************@free.fr.R emovethis>...
karolina a écrit le 19/01/2004 :
Hi, Hello,

Hi again!
I am making a small registration form about cars in three steps. The
first step is to fill in member data. After filled out the member data
hit "next" and enter car information. Hit "next" and upload pictures
of the cars which is step 3.

You can also combine Steps 2 and 3 in the same form.


Interesting. How can I do that since the pictures must be posted with
enctype="multipart/form-data" and that makes my other values in my
form to NOT be posted.
I have 2 database tables in mysql "member" and "cars". "member" is
used in step 1 and "cars" is used in step 2 and step 3.
What is proper design of making this work.

This seems OK to me. I guess one member can manage multiples cars.


Yes, but step 2 is a "INSERT INTO CARS" and step 3 is a "UPDATE CARS"
SQL statement.
1. Is it to store the data in the database after finnishing each step?
If it is how do I handle cases when the user hit "back" and want to
change something on a prior step of the registration. How do I handle
if the user finnish step 1 och step 2 but exit and never do step 3?
etc..

For me, I would say "Registration" is just the step concerning
Membership. The car things are the "normal use" of your service.
Therefore, registration is OK because in only one step. It is done or
not no half measure. For the car part, you can add a flag in your db to
tell if data input is completed or not. Then depending on the value of
this flag you can choose to resume where the user was.


So, what you say is to first complete step 1 and write the user to the
database. Complete step 2 and write and last update cars with step 3.
What should happen if the user hit "back" from step 3 or step 2 to
correct some input he/she did wrong?
Is the fallback to reload the data from db and "UPDATE" it with the
changed values?
2. or is it to validate the data and write it all down after
finnishing step 3. If this is the way to do it, how do I store
data(all variables used in step 1 and step 2) so I can fetch it in the
end of step 3 for write down in my database.

is there another way to do it? please help me to do this right...

There are surely many ways to do the same thing. Yours is not bad IMHO.
I am writing this in PHP. Is there any praxis how to do registration
forms?
Is there any tutorial on this subject that I can read?

Google and some PHP scripts related sites.
thanks

You're welcome ;)
karolina

Ben.

karolina
Jul 17 '05 #3
karolina a écrit le 20/01/2004 :
Hi again! Hi,
Interesting. How can I do that since the pictures must be posted with
enctype="multipart/form-data" and that makes my other values in my
form to NOT be posted. No it doesn't, I designed such a script and other values are well
passed. Try you'll see!
I have a form containing input types 'file', 'hidden', 'text' and
'textarea' without problems.
Yes, but step 2 is a "INSERT INTO CARS" and step 3 is a "UPDATE CARS"
SQL statement. I assume you identify cars by an Id. Look for this ID in the DB then
choose if it is an update (ID exists) or an insert (ID not found).

So, what you say is to first complete step 1 and write the user to the
database. Complete step 2 and write and last update cars with step 3.
What should happen if the user hit "back" from step 3 or step 2 to
correct some input he/she did wrong?
Is the fallback to reload the data from db and "UPDATE" it with the
changed values?

No it was a possible choise if your prefer to stay with 2 steps. I
would prefer one step or maybe separate the photo upload.

Hope you'll manage to sort out ;)
Jul 17 '05 #4
Hello

If you are willing to take the overhead then pass on some of the
information from the first form to the next in HTML hidden fields.. i
use this to keep track of users without using sessions when filling
out a multi-part form.

You can also create a temporary database to use for registration, keep
inputting the user information except for any one unique field that
you can pass from one form to the next and in the final Submit click
you can then transfer the complete data to the permanent database.

hope this helps

bye
Arvind

ra********@hotmail.com (karolina) wrote in message news:<c8**************************@posting.google. com>...
Hi,

I am making a small registration form about cars in three steps. The
first step is to fill in member data. After filled out the member data
hit "next" and enter car information. Hit "next" and upload pictures
of the cars which is step 3.

I have 2 database tables in mysql "member" and "cars". "member" is
used in step 1 and "cars" is used in step 2 and step 3.
What is proper design of making this work.

1. Is it to store the data in the database after finnishing each step?
If it is how do I handle cases when the user hit "back" and want to
change something on a prior step of the registration. How do I handle
if the user finnish step 1 och step 2 but exit and never do step 3?
etc..

2. or is it to validate the data and write it all down after
finnishing step 3. If this is the way to do it, how do I store
data(all variables used in step 1 and step 2) so I can fetch it in the
end of step 3 for write down in my database.

is there another way to do it? please help me to do this right...

I am writing this in PHP. Is there any praxis how to do registration
forms?
Is there any tutorial on this subject that I can read?

thanks

karolina

Jul 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Norman Bird | last post by:
I have a form i will use to register new people and when I click the submit button, the form just shows itself. It is supposed to show a message showing field errors if you leave fields blank etc....
0
by: jpatrick | last post by:
I had a very large number of query statements that I had converted to SQL a long time ago aticipating that I would some day upsize my application. Every now and then when I do an import to a new...
0
by: jphelan | last post by:
I have a subform that works fine until you import it into a new database when it crashes if you try to open it in either disign or form view. The form, "Attendees_Subform" in my application was...
1
by: mplutodh1 | last post by:
This may seem like an odd thing to do, but is there a way to blindly post to a form. By that I mean, sending data (First_Name=John) without actually having the browser go to that page? I am...
3
by: raj chahal | last post by:
Hi there i have created a registration page containing a form than sends username password to an asp processing page. If the user exists it sends the user back to the registration page with...
2
tolkienarda
by: tolkienarda | last post by:
hi all i've been beating my brains out on my moniter because i cant figure out what is wrong with my code. what i am doing is checking input from a form to make sure it is accurate and if it isn't...
6
by: anurathna1971 | last post by:
1.create a registration form in vb in which first name,last name,username,password and confirm password fields should not be left blank and email address should contain@symbol. 2.design a form...
24
by: jerrydigital | last post by:
Hello, I am new to this forum but have read several posts and I thank you for your great assistance. I am stumped right now. I have a user registration form in asp that is set to a form...
1
by: geetamadhavi | last post by:
Hi All, I have developed a php applciaiton where a new window is opening on checking the whether valid user orntot how to make that in same window after checking i have die(' not valid user ' ); i...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.