简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

mysql时间存储有关问题

WBOY
Release： 2016-06-13 13:32:06
Original
1146 people have browsed it

mysql时间存储问题
时间前台显示 xx时xx分 时间是前台填写的 怎么存进数据库和读取？

------解决方案--------------------
有字段类型是什么类型啊。存成对应的类型格式就好了啊

像DATE xxxx-xx-xx
DATETIME xxxx-xx-xx xx:xx:xx
TIME xx:xx:xx

------解决方案--------------------
$s = '16时48分';
//$s = '16:48';
echo date('H:i:s' , strtotime(preg_replace('/[^\d]/', '', $s)));

得到 16:48:00
这就是你需要写入 time 类型字段的数据

Related labels：
date strtotime
source：php.cn
Previous article： 网站发一条信息自动推送到各微博功能怎么实现 Next article： 用asp写的sql语句如何转变成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
"Laravel 10 - API key not recognized in .env file" I'm using LaravelFramework10.15.0. I tried loading my API key in the following way: $apiKe...
From 2023-08-30 11:26:11
0
1
166
Post request uses $_SERVER['QUERY_STRING'] to get the parameters of the url. Why only the first one is obtained? For example, if you submit a request for /xx/post/1?a='a'&b='b' and use $_SERVER['QUER...
From 2021-11-19 16:58:45
0
1
581
Simple html code to implement website page <!DOCTYPE html><html><head><meta charset="utf-8"><tit...
From 2019-03-11 23:41:18
0
2
856
The second page after searching does not display the searched content. After searching, click on the second page and there is no keywords=xx on the link, so the ...
From 2018-10-03 15:47:40
0
3
1213
How to transfer the logged in username to the index.php file? In the end, how to transfer the logged-in username to the index.php file? For example, the...
From 2018-04-18 23:09:37
0
0
868
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！