title: Send values of item to paypal cart
body: <p>I am connected up to Paypals website payments standard. I want to use their cart offsite. How can I pass values of a product that the customer has selected over to paypals cart? I am using php and sql and my website is set up so that when a customer clicks on a specific product, it is retrieved from the database.</p>
  
  <p>Then, when they click on 'add to cart' I want it to pass values of that product over to paypals cart. </p>
  
  <p>Below is the code I use to retrieve the product from the database (it is a gardening website just so you know):</p>
  
  <pre><code>/ is there a rose to view?
  // it is using $_GET to access the parameter sent via URL
  if (isset($_GET['rose_id'])) {
  
  $rose_id = $_GET['rose_id'];
  //prepare the statement
  $stmt = $conn2-&gt;prepare("SELECT * FROM rosename 
      LEFT JOIN rosevariety ON (rosename.variety_name = rosevariety.variety_name) WHERE rose_id = ?");
  
  //bind the parameters
  $stmt-&gt;bind_param("i", $rose_id);
  
  //$sql = mysql_query($query, $conn);
  $stmt-&gt;execute();
  
  //was there a good response?
  if ($stmt) {
  $result = $stmt-&gt;get_result();
  $rose = $result-&gt;fetch_assoc();
  
  //echo out rose information
      echo "&lt;h1&gt;".$rose['latin_name']."&lt;/h1&gt;";
      echo "&lt;h2&gt;".$rose['common_name']."&lt;/h2&gt;";
  </code></pre>