I have form html like this:
<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>";
}
}
I want to fill my database table (container) like this:
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 |
- id_block is auto_increment
- for every total_container, its multiplied with 20 seconds in time field.
so, what should I do in my Query?, I want to fill time field automatically, multiplied with 20 seconds.