duanchun5520 2019-02-08 09:06 采纳率: 0%
浏览 124

使用复选框将数据放入我的数据库

I am making a project where user can create a schedule and post it, so I am using a check box for the days and a date beside them, I found this code online and I'm having trouble understanding it's process maybe if I know how it works I can create my own..

<?php
            include('../dist/includes/dbcon.php');
            $query=mysqli_query($con,"select * from time where days='mwf' order by time_start")or die(mysqli_error());

            while($row=mysqli_fetch_array($query)){
                    $id=$row['time_id'];
                    $start=date("h:i a",strtotime($row['time_start']));
                    $end=date("h:i a",strtotime($row['time_end']));
    ?>
                          <tr >
                            <td><?php echo $start."-".$end;?></td>
                            <td><input type="checkbox" id="check" name="m[]" value="<?php echo $id;?>" style="width: 20px; height: 20px;"></td>
                            <td><input type="checkbox" id="check" name="w[]" value="<?php echo $id;?>" style="width: 20px; height: 20px;"></td>
                            <td><input type="checkbox" id="check" name="f[]" value="<?php echo $id;?>" style="width: 20px; height: 20px;"></td>

                          </tr>

    <?php }?>                     
    </table> 

I know how he get's data from the database, the question is how did he input the data into the database. the database called schedule has these fields (time_id, days, subject) so it is understandable that when a user check m then the data would be input in the days but how did he input the time_id? the time database contains these fields (time_id,time_start, time_end) so basically if the user chose 7:00-8:00 that has the time_id of one, then choose W, the schedule database would look like these sched_id =1, time_id = 1, days = w..but how should I write that? thanks in advance

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
    • ¥20 Python安装cvxpy库出问题
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误
    • ¥15 python天天向上类似问题,但没有清零
    • ¥30 3天&7天&&15天&销量如何统计同一行
    • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
    • ¥15 C#调用python代码(python带有库)
    • ¥15 活动选择题。最多可以参加几个项目?
    • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
    • ¥15 vs2019中数据导出问题