php mysql 总和,如何从PHP中的数据库中获取时间总和？

I wanted to get the sum of this column in my database and display it in home page. Here is the screen shot

I use this code to save data on my Database

$timeanddate=$_POST['timeanddate'];

$time=$_POST['tst'];

$name=$_POST['name'];

$number=$_POST['number'];

$disposition=$_POST['disposition'];

$remarks=$_POST['remarks'];

$times=$_POST['timetoday'];

$dates=$_POST['datetoday'];

if(isset($_POST['submit']))

{

session_start();

$con=mysqli_connect("localhost","root","","hsncs_db");

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$sql="INSERT INTO hsncs_tbl (id, name, number, call_disposition, remarks, time, date, time_duration, hsncs_user)

VALUES

('', '$_POST[name]', '$_POST[number]', '$_POST[disposition]', '$_POST[remarks]', '$_POST[timetoday]', '$_POST[datetoday]', '$_POST[tst]', '$_SESSION[fname]')";

if (!mysqli_query($con,$sql))

{

die('Error: ' . mysqli_error($con));

}

mysqli_close($con);

解决方案

If this column time is of data type "time" in mysql then your query would be

SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `time_duration` ) ) ) AS timeSum FROM hsncs_tbl;