我有这样的形式html:
<html>
<head>
<body>
<form action='upload_data.php' method="POST" enctype="multipart/form-data">
<input type="text" name="total_container">
<button id="submit">Add</button>
</form>
</body>
</head>
</html>
upload_data.php
include 'connect.php';
$total_container = $_POST["total_container"];
if (!empty($total_container)){
$fill="INSERT INTO `container`(`total_container`, `time`)VALUES($total_container,'blabla')";
$data=mysql_query($fill);
if(isset($data)){
echo "<script>alert ('Great');</script>";
} else {
echo "<script>alert('No...');</script>";
}
}
我想这样填充我的数据库表(容器):
id_block | total_container | time |
---------------------------------------
1 | 1 | 00:00:20 |
2 | 2 | 00:00:40 |
3 | 3 | 00:01:00 |
4 | 6 | 00:02:00 |
因此,我应该在查询中做什么?我想自动填写时间字段,乘以20秒。
试试这个
INSERT INTO `container`(`total_container`, `time`)
VALUES($total_container, SEC_TO_TIME($total_container*20) )
请参阅SEC_TO_TIME的参考
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句