1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| foreach($paypal_product['items'] as $key=>$p_item)
{
$buyerEmail = urldecode($httpParsedResponseAr["EMAIL"]);
$buyerPrenom = urldecode($httpParsedResponseAr["FIRSTNAME"]);
$buyerNom = urldecode($httpParsedResponseAr["LASTNAME"]);
$buyerAdresse = urldecode($httpParsedResponseAr["SHIPTOSTREET"]);
$buyerCp = urldecode($httpParsedResponseAr["SHIPTOZIP"]);
$buyerVille = urldecode($httpParsedResponseAr["SHIPTOCITY"]);
$buyerPays = urldecode($httpParsedResponseAr["SHIPTOCOUNTRYNAME"]);
$transactionID = urldecode($httpParsedResponseAr["TRANSACTIONID"]);
$transactionDate = urldecode($httpParsedResponseAr["TIMESTAMP"]);
$transactionStatus = urldecode($httpParsedResponseAr["CHECKOUTSTATUS"]);
$MontantPanier = urldecode($httpParsedResponseAr["AMT"]);
$FraisDePort = urldecode($httpParsedResponseAr["SHIPPINGAMT"]);
$insert_row = $conn->query("INSERT INTO commande
(
id_transaction,
date_transaction,
nom_client,
prenom_client,
email_client,
adresse_client,
cp_client,
ville_client,
pays_client,
id_produit,
name_produit,
qte_produit,
price_produit,
options_produit,
tx_panier,
total_panier,
payment_status
)
VALUES
(
'".$transactionID."',
'".$transactionDate."',
'".$buyerNom."',
'".$buyerPrenom."',
'".$buyerEmail."',
'".$buyerAdresse."',
'".$buyerCp."',
'".$buyerVille."',
'".$buyerPays."',
'".$p_item['itm_code']."',
'".$p_item['itm_name']."',
'".$p_item['itm_qty']."',
'".$p_item['itm_price']."',
'".$p_item['itm_options']."',
'".$FraisDePort."',
'".$MontantPanier."',
'".$transactionStatus."'
)");
$insert_row->execute();
}
if($insert_row){
print 'Success!<br />';
}else{
die('Error : ('. $mysqli->errno .') '. $mysqli->error);
} |
Partager