Ejemplo n.º 1
0
<?php

//view confirmation page
$lib_path = $_SERVER['DOCUMENT_ROOT'] . '/lib/';
require_once $lib_path . 'EShopDb.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/inc/standardfuncs.php';
require_once $_SERVER['DOCUMENT_ROOT'] . '/inc/display_price.php';
@($pmt_id = $_GET['pmt_id']);
if (!$pmt_id) {
    print "Invalid Page Access.";
    die;
}
$db_cart = EShopDb::inst();
$query = "SELECT paypal_transaction.line1, paypal_transaction.line2, paypal_transaction.city, paypal_transaction.postal_code, paypal_transaction.payer_email, cart_transactions.price, cart_transactions.id, cart_transactions.product_id_list, cart_transactions.quantity_list FROM cart_transactions LEFT JOIN paypal_transaction ON paypal_transaction.transaction_id=cart_transactions.id WHERE paypal_transaction.payment_id = ?";
$result = $db_cart->query($query, $pmt_id);
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
    $line1 = $row['line1'];
    @($line2 = $row['line2']);
    $city = $row['city'];
    $postal_code = $row['postal_code'];
    $payer_email = $row['payer_email'];
    $price = '£' . $row['price'];
    $txn_id = $row['id'];
    $product_id_list = $row['product_id_list'];
    $quantity_list = $row['quantity_list'];
}
$product_ids = explode(';', $product_id_list);
$quantities = explode(';', $quantity_list);
$product_title_array = array();
$product_description_array = array();
$product_price_array = array();
<?php

$docRoot = $_SERVER['DOCUMENT_ROOT'];
require_once $docRoot . '/lib/EShopDb.php';
require_once $docRoot . '/inc/display_price.php';
$db_eshop = EShopDb::inst();
$id = (int) $_GET['id'];
$productDisplay = "";
$optionTitle = array();
$optionDesc = array();
$optionId = array();
$sql_query = "SELECT * FROM products WHERE id=? LIMIT 1";
$sql_result = $db_eshop->query($sql_query, $id);
if ($sql_result->rowCount() > 0) {
    while ($row = $sql_result->fetch(PDO::FETCH_ASSOC)) {
        $title = $row['title'];
        $price = $row['price'];
        $weight = $row['weight'];
        $allergyinfo = $row['allergyinfo'];
        $description = $row['description'];
        $category = $row['category'];
        $live = $row['live'];
        $option = $row['options'];
        $dateadded = $row['dateadded'];
        $extraimg = $row['extraimg'];
        $prevchoc = $row['preview_chocs'];
        $prevchocarray = explode(';', $prevchoc);
        //check for extra image and create preview image
        $previewImg = '<div class="extra-product-image"><img width="62" height="47" alt="' . $title . '" class="thumb" src="/images/chocolates/' . $category . '/' . $id . '.png">';
        if ($extraimg == 1) {
            $previewImg .= '<img width="62" height="47" alt="' . $title . '" class="thumb" src="/images/chocolates/' . $category . '/' . $id . '_' . $id . '.png"></div>';