Ive looked up PayPal on search but cannot see clearly any archives on passing variables from a php order form to PayPal. Im selecting coursename and generating a query on a page called details.php but I would like to have an add to basket button that passes the coursename to the item field in the add to basket facility in PayPal- can anyone help?
<?php
if (isset($_GET['course'])) {
$user = "root";
$host = "localhost";
$password = "";
$connection = mysql_connect($host, $root, $password) or die ("Couldn't connect to server.");
$database = "courses";
$db = mysql_select_db($database) or die ("Couldn't select database.");
$course = mysql_real_escape_string($_GET['course']);
$res = "SELECT * FROM trainingtopics WHERE coursename = '$course'";
$result = mysql_query($res) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
// get results from query
echo '
<tr>
<td>' . $row['coursename'] . '</td>
<br>
<td>' . $row['briefdesc'] . '</td>
<br>
<td>' . $row['aimedat'] . '</td>
<br>
<td>' . $row['level1'] . '</td>
<br>
<td>' . $row['level2'] . '</td>
<br>
<td>' . $row['level3'] . '</td>
<br>
<td>' . $row['elearning'] . '</td>
<br>
<td>' . $row['facetoface'] . '</td>
<br>
<td>' . $row['blendedlearning'] . '</td>
<br>
<td>' . $row['elearntime'] . '</td>
<br>
<td>' . $row['facetime'] . '</td>
<br>
<td>' . $row['blendedtime'] . '</td>
<br>
</tr>
';
}
} else {
//course name not found
//note: the query may have failed to so maybe check for that.
}
} else {
//no course specified
}
?>
