Still troubled with SESSION and VAT function
Posted: Fri Jan 14, 2011 5:23 am
Hi, I could really do with some help putting the prices from two drop down boxes into sessions
To start with the user can choose two seats one from each drop down box
at the moment I have this :
What I need is $endPrice1 and $endPrice2 in $_SESSIONS so i an INSERT them in to the database 3 pages away from this query/VAT fucntion.
A look at the syntax and structure of the query would be a great help too =)
Can anyone help? Thanks.
To start with the user can choose two seats one from each drop down box
Code: Select all
//DROP DOWN BOX ONE
$extract =mysql_query("SELECT * FROM ride WHERE rideID ='1'");
$numrows = mysql_num_rows($extract);
//start of form
echo '<form method="post" name="f1" action="card.php">';
echo 'Please choose a seat: ';
echo"<select name='seat' >";
while( $row = mysql_fetch_assoc($extract))
{
$rideID = $row ['rideID'];
$name = $row ['name'];
$seatNumber = $row ['seatNumber'];
$time = $row ['time'];
$price = $row ['price'];
echo "<option name='seat'> $seatNumber </option>";
$_SESSION['extract']=$_POST['seat'];
}
echo '</select><br>';
//DROP DOWN BOX TWO
$extract2 =mysql_query("SELECT * FROM ride WHERE rideID ='1'");
$numrows = mysql_num_rows($extract2);
//start of form
echo '<form method="post" name="f2" action="card.php">';
echo 'Please choose a seat: ';
echo"<select name='seat2' >";
while( $row = mysql_fetch_assoc($extract2))
{
$rideID = $row ['rideID'];
$rideName = $row ['rideName'];
$seatNumber = $row ['seatNumber'];
$time = $row ['time'];
$price = $row ['price'];
echo "<option name='seat2'> $seatNumber </option>";
$_SESSION['extract2']=$_POST['seat2'];
}
echo '</select><br>';
Code: Select all
$query =mysql_query("SELECT price FROM ride WHERE rideID ='1' LIMIT 1");
while ($row=mysql_fetch_array($query))
{
echo $row['price'];
echo "<br>";
$seatPrice1=($row['price']);
$seatPrice2=($row['price']*2);
$vat1=17.5;
function vat($vat, $row['price'])
{
return sprintf("%01.2f", ($vat*$row['price]/ 100));
}
$vatprice = vat(17.5, 2.50);
$total1=($vatprice);
$total2=($vatprice*2);
$endPrice1= ($total1+$seatPrice1);
$endPrice2= ($total2+$seatPrice2);
What I need is $endPrice1 and $endPrice2 in $_SESSIONS so i an INSERT them in to the database 3 pages away from this query/VAT fucntion.
A look at the syntax and structure of the query would be a great help too =)
Can anyone help? Thanks.