Pete Winter
asked on
how to use an array?
I'm trying store some code in an array then reuse it further down my page in a repeat region, but not really how to do it.
See code attached.
This is the using to repeat further down the page:
foreach ($paypalquery as $eachquery2) {
$eachquery2;
}
Hope this makes sense? Can you please check the code.
See code attached.
This is the using to repeat further down the page:
foreach ($paypalquery as $eachquery2) {
$eachquery2;
}
Hope this makes sense? Can you please check the code.
$paypalquery = array();
$paypalquery[] = $nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Amount";
$PP_DirectPayment_itemized[1][$nextIndex] = "".number_format(round($price,2), 2) ."";
$nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Name";
$PP_DirectPayment_itemized[1][$nextIndex] = "".$pname ."";
$nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Number";
$PP_DirectPayment_itemized[1][$nextIndex] = "".$product_id ."";
$nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Quantity";
$PP_DirectPayment_itemized[1][$nextIndex] = "".$qty ."";
;
foreach ($paypalquery as $eachquery2) {
$eachquery2;
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry I'm probably confusing the whole problem. All I need to do is repeat the content in this variable $paypalquery further down the page.
Does this make sense?
Does this make sense?
To repeat content? You cam use FOR to do it. It does not make any sense to repeat content. Why do you want to do it?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry my knowledge of this is not great. Many thanks for all your help!
See whole code attached.
I will explain further in next post.
See whole code attached.
I will explain further in next post.
<?php
$orderquery = array();
$paypalquery = array();
while (!$Tech8_Spares_eCart1->EOF()) {
$product_id = $Tech8_Spares_eCart1->DisplayInfo("ID");
$code = $Tech8_Spares_eCart1->DisplayInfo("Code");
$pname = $Tech8_Spares_eCart1->DisplayInfo("Name");
$description = $Tech8_Spares_eCart1->DisplayInfo("Description");
$weight = $Tech8_Spares_eCart1->DisplayInfo("Weight");
$qty = $Tech8_Spares_eCart1->DisplayInfo("Quantity");
$symbol = $row_rs_exchange_rate_selected['symbol'];
if($row_WAATKcustomers['price_level'] == 2) {//outer if block
if($Tech8_Spares_eCart1->DisplayInfo("ID") == 1) {//inner if block
$ResellerDiscount = "450.00";
}//closes the inner if statement
else {
$ResellerDiscount = $Tech8_Spares_eCart1->DisplayInfo("Price") * $row_rs_mark_up_cost['reseller_discount1'];
}//ends the inner if block
}//closes the first if statement
else {
$ResellerDiscount = $Tech8_Spares_eCart1->DisplayInfo("Price");
}//end of outer if block
$price = $ResellerDiscount * $row_rs_exchange_rate_selected['rate'];
$total = number_format(round($price,2), 2) * $qty;
$SubTotal +=$total;
$customer_id = $row_WAATKcustomers['id'];
$order_id = "T8CUST" . $row_WAATKcustomers['id'] . $today;
if($_POST) {
$orderquery[] = "INSERT INTO orders (product_id, code, name, description, weight, quantity, price, customer_id, order_id)
VALUES ('$product_id', '$code', '$pname', '$description', '$weight', '$qty', '$price', '$customer_id', '$order_id')";
}
$tableRows .= "
<tr>
<td bgcolor=\"#E5E8ED\" style=\"border-bottom:none\">{$pname}</td>
<td bgcolor=\"#E5E8ED\" style=\"border-bottom:none\">{$code}</td>
<td bgcolor=\"#E5E8ED\" style=\"border-bottom:none\">{$symbol}" . number_format(round($price,2), 2) . "</td>
<td bgcolor=\"#E5E8ED\" style=\"border-bottom:none\" align=\"center\">{$qty}</td>
<td bgcolor=\"#E5E8ED\" style=\"border-bottom:none\">{$symbol}" . number_format(round($total,2), 2) . "</td>
</tr>
";
$paypalquery[] = $nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Amount";
$PP_DirectPayment_itemized[1][$nextIndex] = "".number_format(round($price,2), 2) ."";
$nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Name";
$PP_DirectPayment_itemized[1][$nextIndex] = "".$pname ."";
$nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Number";
$PP_DirectPayment_itemized[1][$nextIndex] = "".$product_id ."";
$nextIndex = count($PP_DirectPayment_itemized[0]);
$PP_DirectPayment_itemized[0][$nextIndex] = "Quantity";
$PP_DirectPayment_itemized[1][$nextIndex] = "".$qty ."";
;
$Tech8_Spares_eCart1->MoveNext(); } $Tech8_Spares_eCart1->MoveFirst();
?>
<? $TaxConvertion = ((round($SubTotal,2) + round($delivery,2)) * ($tax / 100)); ?>
<? if($row_WAATKcustomers['country'] == 2) { $VAT = $TaxConvertion; } else { $VAT = 0; } ?>
<? $GrandTotal = $SubTotal - $discount + $charges + $VAT + $delivery; ?>
<?php
if (($_SERVER["REQUEST_METHOD"] == "POST") && (isset($_SERVER["HTTP_REFERER"]) && strpos(urldecode($_SERVER["HTTP_REFERER"]), urldecode($_SERVER["SERVER_NAME"].$_SERVER["PHP_SELF"])) > 0) && isset($_POST)) {
$PP_DirectPayment_required = array();
$PP_DirectPayment_required[0] = array();
$PP_DirectPayment_required[1] = array();
$PP_DirectPayment_itemized = array();
$PP_DirectPayment_itemized[0] = array();
$PP_DirectPayment_itemized[1] = array();
$PP_DirectPayment_optional = array();
$PP_DirectPayment_optional[0] = array();
$PP_DirectPayment_optional[1] = array();
$cartIndex = 0;
$nextIndex = 0;
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "Username";
$PP_DirectPayment_required[1][$nextIndex] = "";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "Password";
$PP_DirectPayment_required[1][$nextIndex] = "";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "Signature";
$PP_DirectPayment_required[1][$nextIndex] = "";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "PaymentAction";
$PP_DirectPayment_required[1][$nextIndex] = "Sale";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "Currency";
$PP_DirectPayment_required[1][$nextIndex] = "".$CurrencyCode ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "IPAddress";
$PP_DirectPayment_required[1][$nextIndex] = "".$_SERVER["REMOTE_ADDR"] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "CreditCardType";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['cc_type'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "CreditCardNumber";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['cc_number'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "ExpMonth";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['exp_month'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "ExpYear";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['exp_year'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "FirstName";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['first_name'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "LastName";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['last_name'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "Street1";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['address1'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "CityName";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['town_city'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "StateOrProvince";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['county'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "PostalCode";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_WAATKcustomers['post_code'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "Country";
$PP_DirectPayment_required[1][$nextIndex] = "".$row_rs_country_list['currency_code'] ."";
$nextIndex = count($PP_DirectPayment_required[0]);
$PP_DirectPayment_required[0][$nextIndex] = "UseSandbox";
$PP_DirectPayment_required[1][$nextIndex] = "true";
$PP_DirectPayment_itemized[0][0] = "OrderTotal";
$PP_DirectPayment_itemized[1][0] = "".number_format(round($GrandTotal,2), 2) ."";
$PP_DirectPayment_itemized[0][1] = "OrderDescription";
$PP_DirectPayment_itemized[1][1] = "";
XXXXXX CODE TO GO HERE XXXXXXX
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "MerchantSessionID";
$PP_DirectPayment_optional[1][$nextIndex] = "".session_id() ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "Payer";
$PP_DirectPayment_optional[1][$nextIndex] = "".$row_WAATKcustomers['email'] ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "Street2";
$PP_DirectPayment_optional[1][$nextIndex] = "".$row_WAATKcustomers['address1'] ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "Phone";
$PP_DirectPayment_optional[1][$nextIndex] = "".$row_WAATKcustomers['phone'] ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "CVV2";
$PP_DirectPayment_optional[1][$nextIndex] = "".$row_WAATKcustomers['cvv'] ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "ItemTotal";
$PP_DirectPayment_optional[1][$nextIndex] = "".number_format(round($SubTotal,2), 2) ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "ShippingTotal";
$PP_DirectPayment_optional[1][$nextIndex] = "".$delivery ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "HandlingTotal";
$PP_DirectPayment_optional[1][$nextIndex] = "".$charges - $discount ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "TaxTotal";
$PP_DirectPayment_optional[1][$nextIndex] = "".number_format(round($VAT,2), 2) ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "InvoiceID";
$PP_DirectPayment_optional[1][$nextIndex] = "".$order_id ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_Name";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["first_name_ship"]))?$_POST["first_name_ship"]:"") ." ".((isset($_POST["last_name_ship"]))?$_POST["last_name_ship"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_Street1";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["address1_ship"]))?$_POST["address1_ship"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_Street2";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["address2_ship"]))?$_POST["address2_ship"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_CityName";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["town_city_ship"]))?$_POST["town_city_ship"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_StateOrProvince";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["county_ship"]))?$_POST["county_ship"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_PostalCode";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["post_code_ship"]))?$_POST["post_code_ship"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_Country";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["country_ship_code"]))?$_POST["country_ship_code"]:"") ."";
$nextIndex = count($PP_DirectPayment_optional[0]);
$PP_DirectPayment_optional[0][$nextIndex] = "SH_Phone";
$PP_DirectPayment_optional[1][$nextIndex] = "".((isset($_POST["phone_ship"]))?$_POST["phone_ship"]:"") ."";
$WAGatewayResponse = PP_DirectPayment_Post($PP_DirectPayment_required,$PP_DirectPayment_itemized,$PP_DirectPayment_optional);
if ($WAGatewayResponse) {
mysql_query("INSERT INTO orders_master (customer_id, order_id, symbol, discount, charges, delivery, tax, exchange_rate, country) VALUES ('$customer_id', '$order_id', '$symbol', '$discount', '$charges', '$delivery', '$tax', '$exchange_rate', '$Countryid')");
foreach ($orderquery as $eachquery) {
$query_db = mysql_query($eachquery) or die (mysql_error());
}
$RecipientEmail = "".$row_WAATKcustomers['email'] ."";include("WA_Universal_Email/WAUE_order_2cc.php");
$RecipientEmail = "pete@largeformatreview.com";include("WA_Universal_Email/WAUE_order_1cc.php");
$Tech8_Spares_eCart1->ClearCart();
$Tech8_Spares_eCart1->cartAction = "ClearCart";
header('location: order_confirmation.php?no='.$order_id.'');
exit;
}
else if ("order_failure.php" != "") {
header("Location: ". "order_failure.php");
exit();
}
}
?>
ASKER
I want the code in the array on line 44 (This is already in a repeat area)
to replace line 140.
to replace line 140.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks you have helped me realise what I am doing wrong.
ASKER
foreach ($paypalquery as $eachquery2) {
$query_db = mysql_query($eachquery2) or die (mysql_error());
}