Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php 记录进行累加并显示总时长为秒的结果_php技巧

php 记录进行累加并显示总时长为秒的结果_php技巧

WBOY
Release： 2016-05-17 09:14:53
Original
1021 people have browsed it

现在有一个mysql数据库的test表里有一个duration字段，里面有三条记录：
00:22:32
13:42:21
134:42:21

表示的是时长，但是，保存类型是文本。

现在要求，用php如何将这些记录进行累加，最后显示为一个总时长为秒钟的结果？

复制代码 代码如下:

//连接数据库... 略
$total = 0; //总秒数
$sql = "select duration from test";
$rs = mysql_query($sql);
while($row = mysql_fetch_array($rs))
{
$arr=explode(":",$row[duration]);
$h = $arr[0]*60*60;
$m = $arr[1]*60;
$s = $arr[2];
$total = $h+$m+$s;
}
echo $total;


这里主要是查询出数据，然后使用explode函数，以“:”分割字符串，得到一个数组。
然后分别算出小时对应的秒数，分钟对应的秒数。然后和把这些秒数加起来。
最后得到总秒数。
Related labels：
Accumulate
source：php.cn
Previous article：php数组函数序列之next() - 移动数组内部指针到下一个元素的位置,并返回该元素值_php技巧 Next article：php数组函数序列之krsort()- 对数组的元素键名进行降序排序,保持索引关系_php技巧
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
How to use laravel components with livewire lazy placeholder I want to add the skeleton of my laravel component inside a livewire3 placeholder What I h...
From 2024-04-06 20:02:10
0
2
543
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
In mobile view, how can I close this navigation bar when the user clicks on the link? When the user clicks a link to browse the website, the navigation bar does not close? I've...
From 2024-04-06 19:23:03
0
1
411
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template