Posted By

raymondeu on 08/02/15

Tagged

database
php

Versions (?)

Last Edited at 08/02/15 12:52am

Statistics

Viewed 1065 times

Favorited by 0 user(s)

Related snippets

Save multiple row of checkbox value into database

/ Published in: PHP

I have been trying to solve my problems on stackoverflow, but none seems to help. Hopefully someone here could help me.

Highlighted TextExpand

//handleschedule.php//
<?php
                if (mysqli_connect_errno($con)) {
                    echo "Failed to connect to MySQL: " . mysqli_connect_error();
                } else {
                    if ($_POST['startTime']) {
                    foreach ($_POST["startTime"] as $key => $value) {

$endTime = $_POST["endTime"][$key];
                            $monday = isset($_POST["Monday"][$key]) ? 1 : 0;
                            $tuesday = isset($_POST["Tuesday"][$key]) ? 1 : 0;
                            $wednesday = isset($_POST["Wednesday"][$key]) ? 1 : 0;
                            $thursday = isset($_POST["Thursday"][$key]) ? 1 : 0;
                            $friday = isset($_POST["Friday"][$key]) ? 1 : 0;

$sql = "INSERT INTO timetableschedule ( startTime, endTime, Monday, Tuesday, Wednesday, Thursday, Friday) " .
                                    "VALUES ('$value', '$endTime', '$monday', '$tuesday', '$wednesday', '$thursday', '$friday')";
                            mysqli_query($con, $sql);
                    }
                    }

echo "1 record added";
                    mysqli_close($con);
                }
                ?>

URL: http://stackoverflow.com/questions/31761272/save-multiple-row-of-checkbox-value-into-database/31761745?noredirect=1#comment51458029_31761745

Report this snippet Tweet