submit two forms in one

benracer

hi,
i would like to submit two forms in one or some how combine them..

i need to...
a)add the shopping cart to a database
b)forward the item and total price to paypal

All With one submit button.

the part a ...

<?php
session_start();

$rs = mysql_connect( "xxx" );
$rs = mysql_select_db( "xxx" );

$cart = $_SESSION['cart'];
$total = $_SESSION['total'];
$user = $_SESSION['myusername'];
$final = serialize($cart);
$now_date = date( "D dS M,Y h:i a Z", time()+3600 ); 

$sql = "INSERT INTO orders (items,total,user,time) VALUES ('$final','$total','$user','$now_date')";
$rs = mysql_query( $sql ) or die('Query:<br />' . $sql . '<br /><br />Error:<br />' . mysql_error());


$data = mysql_query("SELECT * FROM orders WHERE items='$final' and total='$total' and user='$user'") or die(mysql_error());

$info = mysql_fetch_array( $data ); 

$id = $info['order_id'];

$_SESSION["id"] = $id;

unset($_SESSION['cart']);

header("location:pay.php");
?>

part B...

<form action="https://www.paypal.com/cgi-bin/webscr" method="post" style="display:inline">
                  <input type="hidden" name="cmd" value="_xclick" />
                  <input name="return" type="hidden" id="return" value="http://example.com/cart/ordercompleted.php" />
                  <input type="hidden" name="business" value="sales@example.co.uk" />
                  <input type="hidden" name="item_name" value="Order..." />
                  <input type="hidden" name="amount" value="<?php echo $total_price; ?>" />
                  <input type="hidden" name="currency_code" value="GBP" />
				  <input type="hidden" name="shipping" value="0.00">
				  <input type="hidden" name="no_shipping" value="2">
                  <input type="image" name="submit" src="/images/checkout.png" alt="Pay Now" />
                </form>

benracer

also i would like to avoid using javascript as some customers have this disabled.

stijnm

Think you can add an onSubmit event to your first form, submitting the second one. something like this:

<form name="form_1" id="form_1" onSubmit="document.forms['form_2'].submit();"></form>
<form name="form_2" id="form_2"></form>

stijnm

Tested it like so:

<form name="form1" id="form1" action="formReader.php" target="f1" method="post" onsubmit="document.forms['form2'].submit();">
<input type="text" name="field1" id="field1" value="form 1 field value" />
<input type="submit" value="sub f1" />
</form>

<form name="form2" id="form2" action="formReader.php" target="f2" method="post">
<input type="text" name="field2" id="field2" value="form 2 field value" />
<input type="submit" value="sub f2" />
</form>

where formReader.php is:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html><head><title>form reader</title></head><body>
POST :<br /><br />
<?php
foreach($_POST as $key => $entry) {
	print($key . ' => ');
	print_r($entry);
	print('<br /><br />');
}
?>
<br /><br /><hr /><br /><br />
GET :<br /><br />
<?php
foreach($_GET as $key => $entry) {
	print($key . ' => ');
	print_r($entry);
	print('<br /><br />');
}
?>
</body></html>

But of course, this does use some basic client sided scripting. Don't think you can do without.

Weedpacket

Have a look at [man]cURL[/man]. They submit the form to you, and you submit to Paypal.

One advantage of this is of course that

<input type="hidden" name="amount" value="<?php echo $total_price; ?>" />

they can't edit the form to set any of the fields you're sending to paypal to whatever values they like.