如何将多个选项值附加到数据库的单个列中


How to append the multiple option value in a single column in my database

 <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     .....