varios registros a base de datos

[matajazz]

Arros:

Gracias por echarme un cable:

El form de arriba recoge los datos del carrito y despues de confirmación los envio a la base de datos.

Aqui al completo:;

<form action="resumen3.php" method="post">

<p><table width="94%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="7" bgcolor="#CCCCCC"><strong>Estos son los datos de Tu pedido:</strong></td>
</tr>
<td colspan="7">&nbsp;</td>
<tr>

<td width="7%" bgcolor="#666"><strong>ref</strong></td>
<td width="10%" bgcolor="#666"><strong>familia</strong></td>
<td width="29%" bgcolor="#666"><strong>poblacion</strong></td>
<td width="7%" align="left" bgcolor="#666"><strong>precio</strong></td>
<td width="19%" align="center" bgcolor="#666"><strong>participantes</strong></td>
<td width="16%" align="right" bgcolor="#666"><div align="center"><strong>total</strong></div></td>
</tr>
<?php

if(isset($_SESSION['carrito'])){
$total=0;
for($i=0;$i<=count($carrito_mio)-1;$i ++){
if($carrito_mio[$i]!=NULL){
?>

<tr>

<td valign="left" bgcolor="#999"><? print $carrito_mio[$i]['ref']; ?></td>
<td align="left" valign="top" bgcolor="#999"><? print $carrito_mio[$i]['familia']; ?></td>
<td align="left" valign="top" bgcolor="#999"><? print $carrito_mio[$i]['poblacion']; ?></td>
<td align="left" valign="top" bgcolor="#999"><? print $carrito_mio[$i]['precio']; ?></td>
<td align="center" valign="top" bgcolor="#999"><? print $carrito_mio[$i]['cantidad']; ?></td>
<td align="right" valign="top" bgcolor="#999"><div align="center">
<? print $carrito_mio[$i]['precio'] * $carrito_mio[$i]['cantidad']; ?>
</div></td>
</tr>
<?
$total=$total + ($carrito_mio[$i]['precio'] * $carrito_mio[$i]['cantidad']);
}
}
}
?>
<tr>

<td>&nbsp;</td>

<td>&nbsp;</td>
<td><strong>total:</strong></td>
<td align="right"><?
if(isset($_SESSION['carrito'])){
print $total;
}
?> Euros </td>
</tr>
<tr>


<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td align="right"><input type="submit" name="Submit" value="Enviar pedido a PayPal" /></td>
</tr>
</table>
</p></form>


ENVIO A BASE DE DATOS:

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

$insertSQL = sprintf("INSERT INTO bonocompra (numeroPedido, ref, familia, totalPedido, precio, cantidad, nombreUsuario, pagado) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($numPedido, "int"),
GetSQLValueString($ref, "int"),
GetSQLValueString($familia, "text"),
GetSQLValueString($total, "int"),
GetSQLValueString($precio, "int"),
GetSQLValueString($cantidad, "int"),
GetSQLValueString($nombreUsuario, "text"),
GetSQLValueString('n', "text"));

mysql_select_db($database_cnxaventuras, $cnxaventuras);
$Result1 = mysql_query($insertSQL, $cnxaventuras) or die(mysql_error());

?>