Tom
|
| Posted: 08/27/2001, 11:35 AM |
|
Hallo,
I am just trying to develop a multiple page entry form, but I do not know how
to manage it. Is there anyone who can solve the problem? I am still using PHP4
with templates. For imediate help, lotta thx. tom
|
|
|
 |
David A. Lee
|
| Posted: 08/27/2001, 2:10 PM |
|
> Hallo,
> I am just trying to develop a multiple page entry form, but I do not know
how
> to manage it. Is there anyone who can solve the problem? I am still using
PHP4
> with templates. For imediate help, lotta thx. tom
>
What I do for this (and you can see from http://www.newageinfo.com/user/
if you want to make an account and try ...)
Is to make the first page a very simplistic form with just the bare
necessary
fields to insert a record. The trick is you need to create a record in
the first page ... that way the remaining pages all do "Update" instead of
"Insert"
You have the "Action" for the first page lead to the 2nd page ...
In the "After Insert" event I needed to add the newly created ID from the
insert.
In Mysql this is done with the "LAST_INSERT_ID()" function ... other DB's
use different methods.
Example:
Page1:
Name, Email
[INSERT] [ CANCEL ]
< Event After Insert >
$sParams .= "&c_id=" . Common::GetLastID() ;
(GetLastID() I defined in the Modules section to return the last inserted ID
sub LastInsertID {
my $ary_ref = $dbh->selectcol_arrayref( "select LAST_INSERT_ID()" );
return $ary_ref->[0]
}
With other languages and DB's there are other ways of getting this ..
)
Page 2:
< Requires c_id >
Detail Fields ...
[ UPDATE ] [DELETE] [ CANCEL ]
|
|
|
|
|
