If option is choosen then to price times quantity

Question

1.00/5 (1 vote)

See more:

Hello I want to change the price when the user changes the quantity of the product. so if the price = 3 euro and you want 3 items then the code should do 3*3 how do I do this ??

<?php 
session_start();
error_reporting(E_ALL);
ini_set('display_errrors', '1');
// session_destroy();
?>
<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" />
        <meta name="description" content="" />
        <meta name="author" content="" />
        <title>Cart</title>
        <!-- Favicon-->
        <link rel="icon" type="image/x-icon" href="assets/favicon.ico" />
        <!-- Bootstrap icons-->
        <link href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.5.0/font/bootstrap-icons.css" rel="stylesheet" />
        <!-- Core theme CSS (includes Bootstrap)-->
        <link href="css/styles.css" rel="stylesheet" />
        <link href="css/stylecart.css" rel="stylesheet" />
        <script src="js/scripts.js" async></script>

    </head>
    <style>
    body {
        font-size: 20px;
    }

    </style>
<body>
<a class="back" href="index.php"> class="bi bi-arrow-left-circle-fill bi-5x"></a>
<?php 
include "config.php";
        ?>
        <div class="text-center" style="font-size: 100px;">🛍</div>
        <h2 class="text-center">Winkelmandje</h2><br>
        <section class="container content-section">
            <!-- <h2 class="section-header">CART</h2> -->
            <div class="cart-row">
                ITEM
                PRICE
                QUANTITY 
            </div>  
            <?php 
             $broodjes_ID = $_GET['broodjes_ID'];
                        
                        // //$basket =  $_SESSION['basket'][$i];
                        $sql = "SELECT broodjes_ID, broodnaam, prijs FROM broodjes WHERE broodjes_ID = ?";
                        // uitvoeren, resultaat tonen in tabel.
                        $stmt = $conn->prepare($sql);
                        $stmt->bind_param("i", $broodjes_ID); 
                        $stmt->execute();
                        $result = $stmt->get_result(); // get the mysqli result
                        //while loop zorgt er volgens mij voor dat hij blijft optellen
                        if($row = $result-> fetch_assoc()){
                            $sum = 0;     
                            echo '<div class="cart-items">';
                            echo '<div class="cart-row">';
                            echo '<div class="cart-item cart-column">';
                            echo ''. $row['broodnaam'] . '';
                            echo '</div>';
                            echo ' €'. $row['prijs'] . '';
                            $sum = $row['prijs']; 
                            
                            echo '<form name="quantity" method="POST" action="action_page.php">
                                   <select id="quantity" value="quantity">
                                         <option value="1">1</option>
                                         <option value="2">2</option>
                                         <option value="3">3</option>
                                         <option value="4">4</option>
                                     </select>
                                     </form>
                                 '; 
                            echo '</div>';
                            echo '</div>';
                            //$sumtotal = $sum * 2;
                            echo '<br>';
                            echo '<div class="text-center">
                            <button class="btn btn-outline-primary"  type="button"><a href="bestellen.php?broodjes_ID='. $row['broodjes_ID'].'" method="POST">PURCHASE</a></button>
                            </div>';
                            
                        }
                
                        
                    
                ?>
               
                    <div class="cart-total">
                        class="cart-total-title">Total
                         € <?php $sumtotal = $_GET['sumtotal'];  echo $sumtotal;?>
                    </div>
            
                <!-- 
                <div class="cart-total">
                    class="cart-total-title">Total
                     € 0
                </div>
             -->




        </section>
                </body>

action page
problem with this page tough is that it won't remember the $row['prijs']; variable if you do a separete page

<?php
 $sql = "SELECT broodjes_ID, broodnaam, prijs FROM broodjes WHERE broodjes_ID = ?";
 // uitvoeren, resultaat tonen in tabel.
 $stmt = $conn->prepare($sql);
 $stmt->bind_param("i", $broodjes_ID); 
 $stmt->execute();
 $result = $stmt->get_result(); // get the mysqli result
 //while loop zorgt er volgens mij voor dat hij blijft optellen
 if($row = $result-> fetch_assoc()){
    if($_POST['quantity']){
        if ("quantity" == 1) {
            $Qty = 1;
            $sumtotal = $Qty * $row['prijs'];
            echo '<a href="cart.php?prijs='. $sumtotal.'" method="POST">';
            echo $sumtotal;
        } elseif ("quantity" == 2) {
            $Qty = 2;
            $sumtotal = $Qty * $row['prijs'];
            echo '<a href="cart.php?prijs='. $sumtotal.'" method="POST">';
            echo $sumtotal;
        } elseif ("quantity" == 3) {
            $Qty = 3;
            $sumtotal = $Qty * $row['prijs'];
            echo '<a href="cart.php?prijs='. $sumtotal.'" method="POST">';
            echo $sumtotal;
        }elseif ("quantity" == 4){
            $Qty = 4;
            $sumtotal = $Qty * $row['prijs'];
            echo '<a href="cart.php?prijs='. $sumtotal.'" method="POST">';
            echo $sumtotal;
        }
    }
 }                    
?>

What I have tried:

tried to use get and post method but I kinda wanna use it on the same page

Posted 10-Jan-22 3:25am

Rebecca2002

Updated 10-Jan-22 22:15pm

v7

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2022-01-10T04:07:00

Solution 1

Just us the standard math operators (PHP: Operators - Manual[^]). For example:

PHP

$Qty = 2;
$Price = 3.00;
$Total = $Qty * $Price;

Posted 10-Jan-22 4:07am

Richard MacCutchan

Comments

Rebecca2002 10-Jan-22 13:14pm

yes thats also what I wanted to use but how do I make $qty change depending on what option the user chooses? for example user chooses from the dropdown menu option 2 then I want $qty also to be 2 how do I do that

Richard MacCutchan 10-Jan-22 15:06pm

See HTML select tag[^].

Rebecca2002 10-Jan-22 15:28pm

I'm sorry ( maybe I don't understand your anwser) but I did and it just tells me how to make it. I know how to make a select tag with option values in there. I already made one in the code but now I want to do something when the user presses an option( for example when user presses 2 do the calculation that you made) that's what I'm not understanding how to do

Richard MacCutchan 10-Jan-22 16:12pm

The link I gave you has an example that explains it.

Rebecca2002 10-Jan-22 16:20pm

it goes to a page called action_page.php??

Richard MacCutchan 10-Jan-22 16:35pm

Yes, the information is posted back to the PHP code on the page. So your PHP code needs to deal with the returned value (tagged 'quantity' in the posted data) and do the calculations. It can then rebuild the page with the newly calculated value.

Rebecca2002 11-Jan-22 1:14am

but my price depends on my $row['price'] value how will I bring this there????

Richard MacCutchan 11-Jan-22 3:41am

The selected item of the select list is sent to the back end code when the form is submitted. The backend then needs to process that information and rebuild the page with the correct values. This is standard PHP processing, the same as submitting any information from a web page.

Rebecca2002 11-Jan-22 3:52am

wait I will show you what I have right now I will update the post with the extra file because I don't think I can explain it very well. I do understand the part of the backend my problem still is with calculating it in the seperate file. because $row['prijs'] how will I tell the file to use that right there it doesn't seem to understand it right now? maybe make new connection??

Richard MacCutchan 11-Jan-22 3:59am

If you are going to post it to a separate page, then you need to pass all the required variables to that page.

Rebecca2002 11-Jan-22 4:16am

updated the post I'm so sorry I guess the probelm is that when I select something inside the dropdown it doesn't go to the action page and because of this it doesn't show the price

Rebecca2002 11-Jan-22 1:16am

@Richard-MacCutchan right now tried to do it on the same page but no results

Richard MacCutchan 11-Jan-22 7:58am

There is a complete tutorial at PHP Select Option[^].