that a user selected from a drop down menu? I have a dropdown that
allows a user to select an amount based on ounces. The shopping cart
was set up to take the variable $price into the cart. In the
database, I have $price, $price1, $price2, $3price. If the user
selects $price2 from the dropdown, I need the $price variable to
change to what is inside $price2. I know I need some type of case of
switch, but I do not know how to do that so that it changes
$price? Any help greatly appreciated.....
<?php
// Check to see the URL variable is set and that it exists in the
database
if (isset($_GET['id'])) {
// Connect to the MySQL database
include "storescripts/connect_to_mysql.php";
$id = preg_replace('#[^0-9]#i', '', $_GET['id']);
// Use this var to check to see if this ID exists, if yes then get
the product
// details, if no then exit this script and give message why
$sql = mysql_query("SELECT * FROM products WHERE id='$id' LIMIT 1");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0) {
// get all the product details
while($row = mysql_fetch_array($sql)){
$product_name = $row['product_name'];
$price = $row['price'];
$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$oz = $row['oz'];
$oz1 = $row['oz1'];
$oz2 = $row["oz2"];
$oz3 = $row["oz3"];
$details = $row["details"];
}
} else {
echo "That item does not exist.";
exit();
}
} else {
echo "Data to render this page is missing.";
exit();
}
?>
<?php
mysql_close();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $product_name; ?></title>
<link rel="stylesheet" href="style/style.css" type="text/css"
media="screen" />
<style type="text/css">
<!--
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
-->
</style></head>
<body>
<div align="center" id="mainWrapper">
<?php include_once("templates/template_header.php");?>
<div id="pageContent">
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="19%" valign="top"><img src="inventory_images/<?php echo
$id; ?>.jpg" width="188" height="188" alt="<?php echo $product_name; ?
>" />
<a href="inventory_images/<?php echo $id; ?>.jpg">View Full Size
Image</a></td>
<td width="81%" valign="top"><h2><?php echo $product_name; ?></h2>
<h1>
<label>Please select a amount</label>
<select name="price"id="price">
<option value="">Choose</option>
<option value="price1"><?php echo $price1 ." "?><?php echo $oz1 ?
></option>
<option value="price2"><?php echo $price2 ." "?><?php echo $oz2 ?
></option>
<option value="price3"><?php echo $price3 ." "?><?php echo $oz3 ?
></option>
</select>
</h1>
<h1><?php echo $details; ?></h1>
<br />
<form id="form1" name="form1" method="post"
action="cart.php">
<input type="hidden" name="pid" id="pid" value="<?php echo
$id; ?>" />
<input type="submit" name="button" id="button" value="Add to
Shopping Cart" />
</form> </td>
</tr>
</table>
</div>
<?php include_once("templates/template_footer.php");?>
</div>
</body>
</html>
--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
No comments:
Post a Comment