数据库中的PHP总和

试试这个

<?php
$data = $this->db->get_where('tablename',array('amount = '=>1))->sum(amount)->result();
foreach($data as $row): 
echo $row['amount'];  //if array output
echo $row->amount; //object output
endforeach;
?>

 <div class="col-md-4 col-lg-4">
            <div class="panel panel-bordered panel-black">
                <div class="panel-heading">
     <h3 class="panel-title"><?php echo translate('Total Amount ');?></h3>
                 </div>
                <div class="panel-body">
                    <div class="text-center">
                        <h1>
<?php 
 echo $this->db->select('SUM(amount) as Total');
 $getData =  $this->db->get_where('tablename',array('amount = '!=0))->first_row();
 echo $getData->Total; 
 ?>
                        </h1>
                    </div>
                </div>
            </div>
        </div>