Insert Record and pass url variables

[brianevans5179]

Using PHP and MySQL, I want to set up a form that inserts a new record into the
database, and on the redirect page, i want it to have a url variable with the
"id" of the record so it can pull up that information on the second page - like
a confirmation page.

Any ideas?

[brianevans5179]

How about an 'Insert Record and Set Cookie" - how would i do that?

[Jeremy]

don't know about php i know asp but this may help"
look for this:
' *** Insert Record: set variables

If (CStr(Request("MM_insert")) = "form1") Then

And insert this:
Session("AnySessionName") = Request("NameOfHiddenFieldWithTheIdBoundToIt")

so it looks like this:
' *** Insert Record: set variables

If (CStr(Request("MM_insert")) = "form1") Then
Session("AnySessionName") = Request("NameOfHiddenFieldWithTheIdBoundToIt")

this will create a session named "AnySessionName" with the value of the
hidden field, upon record insert
you can retrieve that session on another page.
or go to
Bindings > + > session variable

[Alexandro Colorado]

On Wed, 30 Mar 2005 00:21:16 +0000 (UTC), brianevans5179
<webforumsuser@macromedia.com> wrote:

> Using PHP and MySQL, I want to set up a form that inserts a new record
> into the
> database, and on the redirect page, i want it to have a url variable
> with the
> "id" of the record so it can pull up that information on the second page
> - like
> a confirmation page.
>
> Any ideas?
>

You can use ImpAKT which is an extension we made to do this processes
almost automatically. Check the flash demo's to see the speedness of it:
[url]http://www.interaktonline.com/Products/Dreamweaver-Extensions/ImpAKT/Overview/[/url]


--
Alexandro Colorado
------------------------------
Support Engineer
InterAKT Online
[url]http://www.interaktonline.com[/url]
Tel: 40(21) 312.5312

[David Powers]

brianevans5179 wrote:

> Using PHP and MySQL, I want to set up a form that inserts a new record into the
> database, and on the redirect page, i want it to have a url variable with the
> "id" of the record so it can pull up that information on the second page - like
> a confirmation page.

It's very simple, but requires a little digging in Code view. Locate the
SQL statement that inserts your data into the database. It will begin with:

$insertSQL = sprintf("INSERT INTO

A few lines further down, you will see something like this (the names of
the variables are likely to be different, but the pattern will be the same):

$Result1 = mysql_query($insertSQL, $myConn) or die(mysql_error());

$insertGoTo = "mynewpage.php";

Change those lines like this:

$Result1 = mysql_query($insertSQL, $myConn) or die(mysql_error());
$theID = mysql_insert_id();

$insertGoTo = "mynewpage.php?id={$theID}";

This will send the ID as a query string to mynewpage.php. You can then
use the ID to create a Recordset containing the details of the record
you have just inserted. Set Filter in the Recordset dialog box to the
name of your primary key, select = URL Parameter and type "id" into the
box next to URL Parameter.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[brianevans5179]

Thanks David. That was just want I was looking for. Your The Man! Works
Great!

Originally posted by: Newsgroup User
brianevans5179 wrote:

> Using PHP and MySQL, I want to set up a form that inserts a new record into

the

> database, and on the redirect page, i want it to have a url variable with

the

> "id" of the record so it can pull up that information on the second page -

like

> a confirmation page.

It's very simple, but requires a little digging in Code view. Locate the
SQL statement that inserts your data into the database. It will begin with:

$insertSQL = sprintf("INSERT INTO

A few lines further down, you will see something like this (the names of
the variables are likely to be different, but the pattern will be the same):

$Result1 = mysql_query($insertSQL, $myConn) or die(mysql_error());

$insertGoTo = "mynewpage.php";

Change those lines like this:

$Result1 = mysql_query($insertSQL, $myConn) or die(mysql_error());
$theID = mysql_insert_id();

$insertGoTo = "mynewpage.php?id={$theID}";

This will send the ID as a query string to mynewpage.php. You can then
use the ID to create a Recordset containing the details of the record
you have just inserted. Set Filter in the Recordset dialog box to the
name of your primary key, select = URL Parameter and type "id" into the
box next to URL Parameter.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

[David Powers]

brianevans5179 wrote:

> Thanks David. That was just want I was looking for. Your The Man! Works
> Great!

Glad to have been of help, Brian.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]