passing a value from row to paypal - using variables

[davids_media]

I have an online store where users can either purchase products or add them to carts for future purchasing.

 

Here is the code for item.php

 

<?php

error_reporting(E_ALL ^ E_NOTICE);
ini_set("display_errors", 1);

require ('includes/config.inc.php');

include ('./includes/header.html');

require (MYSQL);

include ('./includes/main.html');

if($id = isset($_GET['prodID']))
{
$query = "SELECT `prodID`, `product`, `prod_descr`, `image`, `price` FROM product WHERE `prodID`='{$_GET['prodID']}'";
$r = mysqli_query($dbc, $query);

$showHeader = true;
echo "<div id='right'>";

while($row = mysqli_fetch_array($r))
{
if($showHeader)
{
            //Display category header
echo "<h1>" . "<span>" . "# " . "</span>" . $row['product'] .  "<span>" . " #" . "</span>" . "</h1>";
echo "<h2>" . $row['prod_descr'] . "</h2>";
echo "<img src='db/images/".$row['image']."' />";
$showHeader = false;

$price = $row['price'];
$product = $row['product'];

echo '<form target="paypal" action="https://www.sandbox.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_s-xclick">
<input type="hidden" name="item_name" value="<?php echo $product; ?>">
<input type="hidden" name="amount_x" value="<?php echo $price; ?>">
<input type="hidden" name="hosted_button_id" value="7UCL9YCYYXL3J">
<input type="image" src="https://www.sandbox.paypal.com/en_US/i/btn/btn_cart_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.sandbox.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>';

}
}

echo "</div>";

}

include ('./includes/footer.html');

?>

 

It displays a product based from a search made. Here is what I want to do? (I have already created test accounts, buttons, etc using PayPal Sandbox)

 

1. Dynamically pass a variable from when I add a chosen item

2. When my cart loads in Sandbox testing, display the appropriate price, product name, etc, based on the variable or value passed.

 

When I set this up (Add To Cart button) I created default item name and price values, yet I do not want to do this manually using Sandbox.

 

I apologise is this appears rather confusing and still being someone relatively new to PHP, I could do with a better understanding of this but I need some serious help please with this dilemma.