how do I post information of this form

seanpaulcail

The form currently gets info from a UPS server thereby calculating shipping rates.

After I get the information I want to post it so that I can later retrieve it and send it to the database.

How can I do this since the command of the form is "get"?

View the form at the following url

http://www.caillouette.com/ups/ups/example_ups_form.html

stolzyboy

do you have to use get??? and why???

seanpaulcail

the form gets info from the UPS server
and displays the current cost of shipping.

I then want to post the information to be stored in the database when the viewer fills out their credit card information.

SO I think get is necessary.

I've tried to use post and it doesn't work for the aforementioned reasons

stolzyboy

your form works fine getting the information from ups now all you have to do is get the information to the next page or whatever, and you can use post it to the next page the use the insert statement to get it into your database, you may have to use variables differently depending on server settings, but if register_globals is on you can do it this way

<?
								$conn = mysql_connect("localhost", "user", "pass") or die ("Could not connect to database!");
								$db = mysql_select_db("database") or die ("Could not select database");

$query = "insert into table tablename (field1, field2) values
('$formfieldname1', '$formfieldname2');";
$result = mysql_query($result);

seanpaulcail

I don't want to write the info to the database until the viewer enters credit card details.

So how do I post the info, or do I need to?

Since I'm using sessions are the variables automatically saved and all I have to do is post a link to the credit card page?

thanks
stolzyboy

stolzyboy

well in that case you can do what i do: i input all the information in the database, then send the user for CC stuff, and with verisign anyway you can pass back variables to your page of choice, so i then pass back a variable with the value of yes, initially it is put in the database as no, then when it gets sent back it updates to say yes, then you can do what you need to do after that, then i have a script run that deletes entries into the database that have a value of no in the certain field that are older than a day old, this will give time for the variable to be posted back to your site, that should be pretty much instantaneous, but you never know