Insert record & Pass querystring

paulboreham

Hi All,

I am trying to insert a record into an mySQL database and also to pass the results to a second page (a Thanks For Registering type page).

I could do this in ASP by changing the redirect behaviour code by hand from Request.Querystring to Request.Form.

I am now having the same trouble in PHP - I think I have found the code that does the same thing as above in ASP ...

    $insertGoTo = "membership_ok.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }

But I am not sure what to change to enable the form variables to be used on the 2nd page.

Anybody know?!

Cheers, Paul

laserlight

and also to pass the results to a second page

Cant you display the message on the current page?

paulboreham

Not quite sure what you mean... :bemused:

Anyway, looks like I've just fixed it. Had a read through my "PHP/SQL Bible" (great book 😃 ) and found the info about Sessions. Used a session variable from the insert statement and that now appears ok - created a cookie on the 2nd page from it too.

Thanks for your help tho - do you think this is the best way to do it?

Cheers, Paul

davidjam

I'm fairly new to PHP but why not just read the data into the "thank you" page from the database if it's already there. As far as the id number for the user you should be able to use mysql_insert_id() and then just tack that onto your redirect. For instance:

if($validated) {
    // insert queries here
    if($successful) {
        header("Location: thankyou.php?id=".mysql_insert_id());
        die();
    }
}

Untested. I plan on using this myself eventually. You see, originally I had this huge $_SESSION array that contained all the data from all the pages that preceded the "thank you for registering" page. Now I just use the database on every page. The first page will be inserts and subsequent pages will be updates:

 .. where id={$_GET['id']}

But your definitely in the right place to find help. So many people have helped me here I just wanted to pitch in. 🙂

paulboreham

Hmm, thats a nice tip David, thanks alot! I'll try that out too as that makes a lot of sense.

Didnt even consider that as you cannot (as far as I know!) do it in ASP...

Great quote BTW, I love the Marx Bros... 😃

davidjam

You must have an auto-increment column in your database table for mysql_insert_id() to work.

Furthermore, this function should be multi-user safe as long as it follows the same standard as the MySQL function last_insert_id() of which the MySQL manual says:

The last ID that was generated is maintained in the server on a per-connection basis. This means the value the function returns to a given client is the most recent AUTO_INCREMENT value generated by that client. The value cannot be affected by other clients, even if they generate AUTO_INCREMENT values of their own.