I need help creating a multistep DATA input page in php & mysql environment.

Discussion in 'PHP' started by babyphp, Apr 10, 2008.

  1. #1
    I need help creating a multistep DATA input page in php & mysql environment.
    i can only create a single form that input data into one database table

    what am trying to achieve is
    create a php page that can input data into more than one database table

    this is in form of a registration page where the user can click on the first page they fill that out then click on the next link that say page 2 then fill that out then do so for up to 5 pages the last page wil have the summit button

    each php page has their own database table, page1 data get store on page1 database table and so on with the rest page


    can any body help me

    if its a used code or tutorila i will appreciate
     
    babyphp, Apr 10, 2008 IP
  2. c4st

    c4st Peon

    Messages:
    41
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Do you know how to submit data to a database from one page? If so, I don't see the problem, just do it 5 times... Now, If you want to submit all the data into one database, I would recommend storing the form data in sessions up until the point where you commit the information to database. Multi-step (wizard) from systems are pretty complex and prone to be very inefficient, and for that reason many developers tend to avoid them.
     
    c4st, Apr 10, 2008 IP
  3. Oreamnos

    Oreamnos Well-Known Member

    Messages:
    154
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    101
    #3
    I would try $_SESSIONS. They are very easy to use and make it easy to track info someone is putting in without having them login.

    It's hard to give examples or ideas without knowing what your tables look like but I might do something like this:

    INSERT into table 1
    Store the mysql_insert_id() of that INSERT via a session variable
    proceed to step 2 and INSERT into table 2
    etc...

    That way, at the end of the 5 steps, you have tracked all of the info in session variables and it will be easy to tag those to the users account or pull info from them or do whatever you need to do.
     
    Oreamnos, Apr 10, 2008 IP