public function GetSum($total_ded){
$db=new Database();
$conn=$db->Connect_DB();
if($conn){
$query = "SELECT SUM(total_ded) FROM february";

$result=mysqli_query($conn, $query);
if($result){
$sum=mysqli_fetch_array($result);
return $sum[0];
}else{
return false;
}
}else{
return false;
}
}


my question is how do i display this code in a table and connect it to database

I am trying to sum up a column....

Pls any help is appreciated
thank in advance

Mysqli_query first parameter takes the connection handle while the second parameter takes your SQL query.

To answer your question, are you trying to display all the results from the query or just the sum?

nicolas247:
public function GetSum($total_ded){
$db=new Database();
$conn=$db->Connect_DB();
if($conn){
$query = "SELECT SUM(total_ded) FROM february";

$result=mysqli_query($conn, $query);
if($result){
$sum=mysqli_fetch_array($result);
return $sum[0];
}else{
return false;
}
}else{
return false;
}
}


my question is how do i display this code in a table and connect it to database

I am trying to sum up a column....

Pls any help is appreciated
thank in advance

Echo the results in a html table , Google it to see examples.

Modified: Check out this link, it should give you an idea.

http://stackoverflow.com/questions/14430174/use-php-to-display-mysql-results-in-html-table

It's a bad practice to echo result from a function, rather use return.

Urine:


Echo the results in a html table , Google it to see examples.

Adesege:
It's a bad practice to echo result from a function, rather use return.

Baba, all I did was to give him an idea of how to go about it, did you see the "Google" part? It was for him to get his search right. If you feel you have a better answer, help the young man out.

No p na. It'll be useful for any who views it later.

Urine:


Baba, all I did was to give him an idea of how to go about it, did you see the "Google" part? It was for him to get his search right. If you feel you have a better answer, help the young man out.

Thank you all for your earnest response but I have done all I could even Google all but still can't figure it.... Pls I will appreciate a code that can display this function..

I take it you've gotten all the database connections part right so I'm going to leave that part as is. Rather than using an SLQ SUM in your query it makes more sense do an SQL SELECT of the required row (in this case total_ded) and return the values as an array. You can then Loop through the array and display the necessary table. Finally sum the array and equally display the sum. Here's what the code will look like

<?php public funtion get_all_ded()
	$db=new Database();
	$conn=$db->Connect_DB();
	if($conn){
		$query = "SELECT total_ded FROM february";
		$result=mysqli_query($conn, $query);
		if($result){
			$deds=mysqli_fetch_array($result);
			return $deds; 
		}else{
			return false;
		}
	}else{
		return false;
	}
}

//
$all_deds = get_all_deds();
?>
<table>
<tr><td>Deds</td></tr>
<?php
foreach($all_deds as $ded){
echo "<tr><td>".$ded."</td></tr>"
}
?>
</table>
<div>Total Deds: <?php echo  array_sum($all_deds) ?></div>

kudaisi:
I take it you've gotten all the database connections part right so I'm going to leave that part as is. Rather than using an SLQ SUM in your query it makes more sense do an SQL SELECT of the required row (in this case total_ded) and return the values as an array. You can then Loop through the array and display the necessary table. Finally sum the array and equally display the sum. Here's what the code will look like

<?php public funtion get_all_ded()
	$db=new Database();
	$conn=$db->Connect_DB();
	if($conn){
		$query = "SELECT total_ded FROM february";
		$result=mysqli_query($conn, $query);
		if($result){
			$deds=mysqli_fetch_array($result);
			return $deds; 
		}else{
			return false;
		}
	}else{
		return false;
	}
}

//
$all_deds = get_all_deds();
?>
<table>
<tr><td>Deds</td></tr>
<?php
foreach($all_deds as $ded){
echo "<tr><td>".$ded."</td></tr>"
}
?>
</table>
<div>Total Deds: <?php echo  array_sum($all_deds) ?></div>

hmm..nice..but won't use a foreach on a large dataset (performance wise ) and would check falsity of $all_feds before displaying the table

jacob05:



hmm..nice..but won't use a foreach on a large dataset (performance wise ) and would check falsity of $all_feds before displaying the table

Agreed, but I'm not trying to build his entire application for him. I only meant for the code to be used as guide. But it's worth mentioning.

Mysqli_fetch_array() requires two argument and not one

Hello everyone, Please I need your
support so please go to >>> http:///votesaviour and
please vote for me in the Microsoft #YouthSpark Challenge for change. I'm one of the two Nigerian students among the 15 global finalists. Please help me make my dream of changing the world with science and technology become true. It won't take up to 10 seconds so please stop whatever your doing now and vote for me please. I really appreciate. It will go a long way in actualizing my career. Please vote>>> http:///votesaviour

#youthspark #youthsparkchallenge #microsoftafrica #microsoft #challengeforchange