How to get sum of values in mysql database on HTML using PHP

Question

0.00/5 (No votes)

See more:

how to get the total sum of rows by grouping values and output on html form in a table

What I have tried:

PHP

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbName = "satapp";

$conn = new mysqli($servername, $username, $password, $dbName);

if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
$query = "SELECT indiname,  baseline from indicators GROUP BY indiname";
$result = $conn->query($query);
?>
<!DOCTYPE html>
	<title>get Records
<div style="width: 500px">
	<!--<a href="one.php"<h3 align="center">get Records</h3>-->
<?php
if ($result->num_rows > 0) {
  while($row = $result->fetch_assoc()) {
?>
<?php
}

}	
$conn->close();?>
<table><tbody><tr><th>Intervention Area</th><th>Target</th><th>Progress</th></tr><tr><td><?php echo $row["Interventionarea"];?></td><td><?php echo $row["target"];?></td><td><?php $number=array("progress"); echo array_sum($number);?></td></tr></tbody></table>

</div>

Posted 24-Jul-17 14:12pm

ezrasoft

Updated 24-Jul-17 19:43pm

Mohibur Rashid

v2

Add a Solution

Comments

Mohibur Rashid 25-Jul-17 1:23am

your $number contains only one string, how do you expect to have sum? and why did you do that?

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)

Kornfeld Eliyahu Peter · Answer 1 · 2017-07-24T19:43:00

Solution 1

1. Your SQL query will not even run, GROUP BY[^] must have some aggregate functions in the SELECT list...
2. Do not run sum in code - do it in SQL!

Posted 24-Jul-17 19:43pm

Kornfeld Eliyahu Peter

Comments

CPallini 25-Jul-17 3:03am

5.

Kornfeld Eliyahu Peter 25-Jul-17 3:37am

Thank you...

ezrasoft 26-Jul-17 5:52am

thank you for your response to my question.
how would you suggest i do it. i have a table in a database i want to sum up a specific field when data is printed on html .

Kornfeld Eliyahu Peter 26-Jul-17 6:10am

select a, b, c from table where...
union
select null, null, sum(c) from table where...