php mysql multiply database value with form selection

Question

Hello I am really struggling with this. I was asked to develop a script to calculate oil price but cannot get it to work. I have been able to setup a form to update fuel price.

I have a table called fuel_price. In this table will be cost per litre of fuel which is stored under Price. For example if oil price per litre is £0.50 I need to multiply this value by value selected within form dropdown.

Can anyone please guide me on what I am supposed to do??

Ok heres an update code preview.

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

<select name="fueltype">
<option>- Select fuel type -</option>
<option value="Diesel">Diesel</option>
<option value="Red Diesel">Red Diesel</option>
<option value="Home Heating Oil">Home Heating Oil</option>
</select>
<select name="qtylitres">
<option>- Qty in Litres -</option>
<option value="100">100</option>
<option value="200">200</option>
<option value="400">400</option>
<option value="500">500</option>
<option value="900">900</option>
<option value="1000">1000</option>
</select>

<input type="hidden" name="id" value="" />
<input type="submit" name="submit" value="Submit" />
</form>

<?php

include 'mysql_connect.php';

$pdo = '';

    $stmt = $pdo->prepare("SELECT `Oil` from `fuel_price` WHERE id = '1'"); 
    if (!$stmt->execute()) { die($stmt->errorInfo[2]); } 
    $row = $stmt->fetch(); 

    $price = $row['Oil'];

    echo $_POST['qtylitres'] * $price;

?>

Anyone know where I am going wrong??

Thanks

What differentiates prices in your database? It will be good if you post the database echema may be with sample data — Stefano Mtangoo
– Stefano Mtangoo, Commented Aug 29, 2011 at 15:51
@Stefano likely the type of the fuel, as that is his first <select> — Madara's Ghost
– Madara's Ghost, Commented Aug 29, 2011 at 15:55
You should never echo $_SERVER['PHP_SELF'] to the browser. It is vulnerable to XSS attacks. (see seancoates.com/blogs/xss-woes) — Mike
– Mike, Commented Aug 29, 2011 at 16:25

Madara's Ghost · Accepted Answer · 2011-08-29 15:54:40Z

0

<?php

    //Connect to database here. In this example, I'll assume you connected using PDO
    //Although the same logic applies on any engine.

    $stmt = $pdo->prepare("SELECT `price` from `fuel_price` WHERE `type` = :type"); //Prepare a query
    $stmt->bindValue(':type', $_POST['type']); //Assuming the first <select> is named type
    if (!$stmt->execute()) { die($stmt->errorInfo[2]); } //Display an error and terminate script if query failed.
    $row = $stmt->fetch(); //Assuming you have only one row, fetch should only be called once.

    $price = $row['price'];

    echo $_POST['qtylitres'] * $price; //Multiply quantity with price and print result.

?>

Note that I have not tested it, but it should work. Your markup is incomplete, it lacks the opening for the first <select>. Read the comments and you should be good to go.

answered Aug 29, 2011 at 15:54

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

phpnoob Over a year ago

getting Undefined variable: pdo. I have posted full code above. Please help??

Benjamin Crouzier · Accepted Answer · 2011-08-30 12:15:42Z

0

assuming that you have a column 'price' in your table, and that the only result contains the correct price:

include 'mysql_connect.php';
if (isset($_POST['submit'])) {
    // edit: added fueltype in the where clause
    $fueltype = mysql_real_escape_string($_POST['fueltype']);
    $q = "SELECT * FROM fuel_price WHERE id = '1' AND fueltype='$fueltype'";


    $result = mysql_query($q);
    $row= mysql_fetch_array($result);
    $price = $row['price'] * $_POST['qtylitres'];
    echo $price;

edited Aug 30, 2011 at 12:15

answered Aug 29, 2011 at 15:56

Benjamin Crouzier

42.2k48 gold badges179 silver badges240 bronze badges

2 Comments

phpnoob Over a year ago

Hello still haven't this fully operational. I have it calculating properly but now need a query for fuel type. Eg $query = "SELECT * FROM fuel_price WHERE FuelType='{$_POST['fueltype']}'" ; then to echo result echo $_POST['qtylitres'] * $price ['Price']; Can you help??

Benjamin Crouzier Over a year ago

I added fueltype in the where clause.

Collectives™ on Stack Overflow

php mysql multiply database value with form selection

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related