Code: Select all
if ($resultMsg == "APPROVED") {
mysql_select_db ("db");
$query = mysql_query ("SELECT * FROM db");
$row_RR = mysql_fetch_assoc($query);
mysql_query ("SELECT * FROM db");
mysql_query ("INSERT INTO payers (idNum, fullName, phNum, email, address, city, state, zip, numAdults, numChilds, cardLast4, cardExpM, cardExpY, small, medium, large, xl, 2xl, 3xl, reunionDocumentary) VALUES ('".$payerIdNum."', '".$payerName."', '".$payerPhNum."', '".$payerEmail."', '".$payerAddress."', '".$payerCity."', '".$payerState."', '".$payerZip."', '".$payerNumAdults."', '".$payerNumChilds."', '".$payerCardLast4."', '".$payerCardExpM."', '".$payerCardExpY."', '".$payerSmall."', '".$payerMedium."', '".$payerLarge."', '".$payerXl."', '".$payer2Xl."', '".$payer3Xl."', '".$payerReunionDocumentary.")");
for ($i=1;$i<=$totalPeople;$i++) {
if ($i<=$numAdults) {
$adult_child = "adult";
$fullName = $HTTP_POST_VARS['adultName' . $i];
$parent_guardian = "";
$phNum = $HTTP_POST_VARS['adultPhNum' . $i];
$email = $HTTP_POST_VARS['adultEmail' . $i];
$address = $HTTP_POST_VARS['adultAddress' . $i];
$city = $HTTP_POST_VARS['adultCity' . $i];
$state = $HTTP_POST_VARS['adultState' . $i];
$zip = $HTTP_POST_VARS['adultZip' . $i];
$shirtSize = $HTTP_POST_VARS['adultShirtSize' . $i];
$IdNum;
for ($i=0; $i<30; $i++) {
$IdNum .= chr(mt_rand(35, 126));
}
mysql_query ("INSERT INTO people (IdNum, payerIdNum, adultChild, fullName, parentGuardian, phNum, email, address, city, state, zip, shirtSize) VALUES ('".$IdNum."', '".$payerIdNum."', 'adult', '".$fullName."', '', '".$phNum."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$shirtSize.")");
} else {
$x = $i - $numAdults;
$adult_child = "child";
$fullName = $HTTP_POST_VARS['childName' . $x];
$parent_guardian = $HTTP_POST_VARS['childParent-guardian' . $x];
$phNum = $HTTP_POST_VARS['childPhNum' . $x];
$email = $HTTP_POST_VARS['childEmail' . $x];
$address = $HTTP_POST_VARS['childAddress' . $x];
$city = $HTTP_POST_VARS['childCity' . $x];
$state = $HTTP_POST_VARS['childState' . $x];
$zip = $HTTP_POST_VARS['childZip' . $x];
$shirtSize = $HTTP_POST_VARS['childShirtSize' . $x];
$IdNum;
for ($i=0; $i<30; $i++) {
$IdNum .= chr(mt_rand(35, 126));
}
mysql_query ("INSERT INTO people (IdNum, payerIdNum, adultChild, fullName, parentGuardian, phNum, email, address, city, state, zip, shirtSize) VALUES ('".$IdNum."', '".$payerIdNum."', '".$adult_child."', '".$fullName."', '".$parent_guardian."', '".$phNum."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zip."', '".$shirtSize.")");
}
}
mysql_free_result($row_RR);
}