Form question...

[Anon]

How should I pass variables on?

Could you take a look at http://192.168.13.182/horse-3/do_form.txt (source).
This is file nr. 2 I post from index.php3 and this is sort of confirm, but I want to post this to page 3 to insert data to mySQL...

Any suggestions?

[Anon]

This question crops up often, so here's a generic answer.

Let's say you have a html page (input.html), which contains a form, which contains just one field (username). This form calls a php page, (confirm.php). You want this page to display the field again, so the user can recheck it,a nd hit "commit" if they are happy. Hitting "commit" passes the field to a third page (update.php) to do the update.

input.html

Standard html form which calls confirm.php. Contains a field called username.

confirm.php

When this file is called, the value of $username is already filled in with the name of the value typed in in the previous page. You can now have something like:

<FORM action="update.php">
<input type="hidden" name="username" value=<?php echo($username) ?>>

You have entered <?php echo($username) ?>,<BR>
If this is correct, press "Submit".
<input type="Submit" value="Submit">
</FORM>

update.php

Now, when update.php is run, it also has a value for $username. You can use this to do whatever update you wanted.

This is a simple one-field example, but you should be able to see how you can pass the values along in hidden fields.

Remember, though, that this is not secure. It would be possible for someone to interfere with the hidden fields. If this is an issue, you will have to code around it. One solution would be to have confirm.php store the value in a database, mark it as unconfirmed, and pass a lookup key to the next page instead. But that's for another day!

Cheers,

Jack

(Free PHP hosting! - www.combustion.ie)

[Anon]

That wasn't what I was talking about... 🙂
That's why this question crops up here often...
If you really want to help could I just get your email, email you the files and maybe you'll see what I'm talking about...
But if you don't want to that's no problem 🙂

Thanks, Arni

[Anon]

The url supplied gives me a time-out error so I can't see the do_form.txt source.

Basically if I understand you correctly:

• index
  user fills in data
• do_form
  confirm of data supplied
• page to insert data in MySQL database.

What I would do is merge step 1 and 2 in this way:
<?

if ( $action == "" ) {
?>
// present form to fill in data
<?
} else {
?>
// Again the same form, but this time fill
// in value=... inside the input tags.
// form submits to page 2
<?
}
?>

Say your form has a input field named "email" on the first page within the action == "" you say:

<input type="hidden" name="action" value="show" />
<input type="text" name="email" />

The "hidden" tag triggers the action if clause. So when the user submits, action is no longer empty and the "confirm" form will be shown.

Use the same fields there except for this little addition "value" :

<input type="text" name="c_email" value="email" />

As you see, this time I used name="c_email" as in "confirmed email" to keep the vars apart more easily.

The first form submits to itself, because of the action is not empty, the second form will be shown. The second form actually submits to page 2.

On page 2 you can simply say:

$sql = "INSERT INTO [database].[table] SET email = '$c_email' ";

$result = mysql_query($sql);

Of course this can also be put into one page with the same "action" var.

[Anon]

Sure thing.

I'm a little busy at the moment, so I mightn't be able to get back to you for a day or two. But if that's ok by you, feel free to contact me at jh (at) combustion.ie

Sorry if I misunderstood you, but maybe we can sort it out in email.

Cheers!

Jack