<legend>Day And Time Available:</legend>
<input type="checkbox" class="day" name="day[]" value="monday" onclick="show(this);"/>Monday<br/>
<input type="checkbox" class="day" name="day[]" value="tuesday" onclick="show(this);"/>Tuesday<br/>
星期一
<label for="FromtimeMonday">From Time</label>
<select name="FromtimeMonday" id="FromtimeMonday">
<option value="Monday6Am">6Am</option>
<option value="Monday7Am">7Am</option>
<option value="Monday8Am">8Am</option>
</select>
<label for="TotimeMonday">To Time</label>
<select name="TotimeMonday" id="TotimeMonday">
<option value="Monday6Am">6Am</option>
<option value="Monday7Am">7Am</option>
<option value="Monday8Am">8Am</option>
</select>
<p>Tuesday</p>
<label for="FromtimeTueday">From Time</label>
<select name="FromtimeTueday" id="FromtimeTueday">
<option value="Tueday6Am">6Am</option>
<option value="Tueday7Am">7Am</option>
<option value="Tueday8Am">8Am</option>
</select>
<label for="TotimeTueday">To Time</label>
<select name="TotimeTueday" id="TotimeTueday">
<option value="Tueday6Am">6Am</option>
<option value="Tueday7Am">7Am</option>
<option value="Tueday8Am">8Am</option>
</select>
Here is my php code:
<?php
if(isset($_POST['submit']))
{
include('manager/connection.php');
$time=',';
$d=$_POST['day'];
$day=implode(",",$d);
$FromtimeMonday=$_POST['FromtimeMonday'];
$TotimeMonday=$_POST['TotimeMonday'];
$FromtimeTueday=$_POST['FromtimeTueday'];
$TotimeTueday=$_POST['TotimeTueday'];
$time.= $FromtimeMonday;
$time.= $TotimeMonday.",";
$time.= $FromtimeTueday;
$time.= $TotimeTueday;
$sql=mysql_query("insert into timing (day,timing) values ('".$day."','".$time."')");
}
}
?>
在这里,我将值附加到时间变量。我正在创建带有列名 day 的数据库,计时如何将数据带到特定列。因为我正在创建这样的数据库。更多 这取决于人的日期和时间,所以对于每个人来说,它可能会有所不同。如何使数据库列适合于此。这里的表单标签日是数组。如果你看到我的数据库结构,你就能理解。如果用户选择星期一,星期二,星期四,星期三,如何将数据带入计时列,请放心。
id day timing
7 monday,tuesday ,Monday6AmTO6Am,Tueday6AmTO6Am
你在数据库中存储时间的方式是完全错误的。考虑使用日期(时间戳(而不是表示Monday6AM
和东西的字符串文字。还要考虑规范化数据库。
MYSQL中的timestamp
同时具有日期和时间。
您将实现如下目标:
id Date(Timestamp) other columns
8 01-01-2015 06:04:03.678 .....