How to get the sum in a column using MySQL and PHP [duplicate]

Question

I've been searching for the better part of five days (no joke, don't want to bother you guys for nothing), but I can't seem to be getting this right. I want to display the total amount of a column (tech) on the screen using a function in PHP. Don't worry, the $day part works in other functions. I don't think it is part of the problem. Thank you in advance.

function calc_tech($day){

    include("connect.php"); // include database connection

    $res = $mysqli -> query(" SELECT * FROM sales WHERE day = $day ") or die($mysqli->error); // Fetch data from the table

    while($val = $res -> fetch_array()){
        $tech_total = $val[tech] += $val[tech];
    }

    echo $tech_total; // Echo the result
    //echo "42";

    $res -> free(); // Free the query results
    $mysqli -> close(); // Close mysqli object

}

My database table looks like this:

select sum(tech) from sales where day='$day';

JYoThI
– JYoThI

2017-05-09 04:02:55 +00:00
Commented May 9, 2017 at 4:02 — JYoThI
– JYoThI, Commented May 9, 2017 at 4:02
What output do you want here?

Tim Biegeleisen
– Tim Biegeleisen

2017-05-09 04:03:34 +00:00
Commented May 9, 2017 at 4:03 — Tim Biegeleisen
– Tim Biegeleisen, Commented May 9, 2017 at 4:03
So, what isn't working?

Sloan Thrasher
– Sloan Thrasher

2017-05-09 04:04:47 +00:00
Commented May 9, 2017 at 4:04 — Sloan Thrasher
– Sloan Thrasher, Commented May 9, 2017 at 4:04
42+0+0+42 = 42 how is it 42 ? @adesgangne ??

JYoThI
– JYoThI

2017-05-09 04:09:15 +00:00
Commented May 9, 2017 at 4:09 — JYoThI
– JYoThI, Commented May 9, 2017 at 4:09

Your Common Sense · Accepted Answer · 2023-03-09 06:39:14Z

1

You need to make the SUM() the column in the query :

function calc_tech($mysqli,$day){
    //Prepare your query first
    $stmt = $mysqli->prepare("SELECT SUM(tech) FROM sales WHERE day=?"); 
    // then bind the parameter
    $stmt->bind_param("s", $day);
    // then execute the query
    $stmt->execute();
    $result = $stmt->get_result();
    // fetch and return the result
    return $result->fetch_row()[0];
}

include("connect.php"); // include database connection
echo calc_tech($mysqli,$day); // get the result

edited Mar 9, 2023 at 6:39

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

answered May 9, 2017 at 4:08

Mahdi

8358 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

How to get the sum in a column using MySQL and PHP [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related