Dreamweaver - Form Question

Author

Form Question

plockyer

2004-02-28, 6:29 pm

Alright I have been successful at getting a form to do this.

Input the date in the form.htm page.

Hit the submit button, and the info is processed and displayed at form.php
page.

The user is then able to print the form.

Now my question is if I want the info they submit also to store in a data
base can I have it so when they hit submit the page it not only processes in
the form.php page, but also uploads the info to a data base so I can see
everytime it is used?

So I guess I need to know if a form action can have more then one task.

Paul
Studio MX User

plockyer

2004-02-28, 6:29 pm

Here is the link to my test form. I want the info input and displayed in the
php page to also upload so I can track it. Its a very simple form, but it is
just to test.

http://www.lionedge.com/formscripts...ordercanada.htm

Murray *TMM*

2004-02-28, 8:28 pm

The form page can submit the info and then redirect the page, but wouldn't
you want the data entry to occur after the process page has been approved?

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver MX
(If you *MUST* email me, don't LAUGH when you do so!)
==================
news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
ANSWERS
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"plockyer" <buzzmaster@noreplybuzzardbrain.com> wrote in message
news:c1r3qt$e3l$1@forums.macromedia.com...
> Alright I have been successful at getting a form to do this.
>
> Input the date in the form.htm page.
>
> Hit the submit button, and the info is processed and displayed at form.php
> page.
>
> The user is then able to print the form.
>
> Now my question is if I want the info they submit also to store in a data
> base can I have it so when they hit submit the page it not only processes
in
> the form.php page, but also uploads the info to a data base so I can see
> everytime it is used?
>
> So I guess I need to know if a form action can have more then one task.
>
> Paul
> Studio MX User
>
>

plockyer

2004-02-28, 9:28 pm

This particulair form will be used for people who want to print it and then
either fax or mail it. There will be no approval required... I assuming you
mean credit card approval?

"Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
news:c1r9k3$j9n$1@forums.macromedia.com...
> The form page can submit the info and then redirect the page, but wouldn't
> you want the data entry to occur after the process page has been approved?
>
> --
> Murray --- ICQ 71997575
> Team Macromedia Volunteer for Dreamweaver MX
> (If you *MUST* email me, don't LAUGH when you do so!)
> ==================
> news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
> ANSWERS
> ==================
> http://www.dreamweavermx-templates.com - Template Triage!
> http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
> http://www.dwfaq.com - DW FAQs, Tutorials & Resources
> http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
> ==================
>
> "plockyer" <buzzmaster@noreplybuzzardbrain.com> wrote in message
> news:c1r3qt$e3l$1@forums.macromedia.com...
form.php[color=darkred]
data[color=darkred]
processes[color=darkred]
> in
>
>

Murray *TMM*

2004-02-28, 9:28 pm

No, I meant review and approval by the user. But anyhow, just have the form
page do the data entry, and then redirect to the approval page.

--
Murray --- ICQ 71997575
Team Macromedia Volunteer for Dreamweaver MX
(If you *MUST* email me, don't LAUGH when you do so!)
==================
news://forums.macromedia.com/macromedia.dreamweaver - THE BEST WAY TO GET
ANSWERS
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"plockyer" <buzzmaster@noreplybuzzardbrain.com> wrote in message
news:c1rcaj$lkv$1@forums.macromedia.com...
> This particulair form will be used for people who want to print it and
then
> either fax or mail it. There will be no approval required... I assuming
you
> mean credit card approval?
>
>
>
> "Murray *TMM*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:c1r9k3$j9n$1@forums.macromedia.com...
wouldn't[color=darkred]
approved?[color=darkred]
GET[color=darkred]
> form.php
> data
> processes
see[color=darkred]
task.[color=darkred]
>
>

wildwomank

2004-02-29, 3:28 pm

Hopefully this does not get posted twice...

I believe have a similar problem. I have a form that I wish to not only send
the contents to a database, but also pass the information on to the redirect
page. I can get the form to submit data to the database OR I can get the form
to pass the input information to the redirect page. I CANNOT get the form to
do both.

It appears that I need to implement a session variable in order to do this.
In the Dreamweaver TechNote "How to pass form data from an insert, update or
delete page", it tells me that I need to insert some code in order to
instantiate the session variable.

To do this, it says to look for the following line of code:

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] ==
"myForm")) {

then insert the session code below following the code listed above (with my
own variable info, of course):

$FirstName = $HTTP_POST_VARS['txtFirstName'];
session_register("FirstName");

First off, I could see there was a problem as my code did not match the code
in the technote. My code follows below:

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "add")) {
$insertSQL = sprintf("INSERT INTO events (etitle) VALUES (%s)",
GetSQLValueString($_POST['etitle'], "text"));

I did create a session variable to bind the data. However, when I do the hand
coding as suggested (inserting it right after the first line above), the form
still enters data into the database, but DOES NOT pass the form data to the
redirect page for display. I also get an error message from Dreamweaver after
entering the new code saying that part of my code has been deleted.

I'm about ready to lose it after working on this for two days with absolutely
NO success.

Can someone tell me what I am doing wrong?

Thanks,

K