<input type="time" /> value doesn't insert in mysql db

Question

I want to insert value in a database and it inserted empty. I want help for this necessary. This is the variable of time :

$rm_time = $_POST['rm-time'];

PHP

    if(empty($_POST['rm-name']) or empty($_POST['rm-details'])){
            ?>
            <h3 style="margin-top: 30px;text-align: center;font-size: 25px;color: red;" dir="rtl">Error</h3>
            <?php
        }else{
            $rm_name = $_POST['rm-name'];
            $rm_details = $_POST['rm-details'];
            $rm_date = $_POST['rm-date'];
            $rm_time = $_POST['rm-time'];
            $rm_insert_query = $db->query("INSERT INTO reminders (r_name, r_details, r_date, r_time) VALUES ('$rm_name', '$rm_details', '$rm_date', '$rm_time')");
        }
    }
    ?>
    <form action="reminder.php?rm=make" method="post">
        <table class="rm" width="auto" border="0px">
            <tr>
                <td class="rm-form-text">Reminder date/time :</td>
                <td><input autofocus="" name="rm-date" type="date" id="rm" /> / <input name"rm-time" type="time" id="rm" /></td>
            </tr>
            <tr>
                <td class="rm-form-text">Remimnder name :</td>
                <td><input name="rm-name" type="text" id="rm" /></td>
            </tr>
            <tr>
                <td class="rm-form-text">Reminder details :</td>
                <td><textarea dir="rtl" name="rm-details" id="rm-ta"></textarea></td>
            </tr>
            <tr>
                <td colspan="2"><input name="save-reminder" type="submit" class="sp-submit" value="Save!" /></td>
            </tr>
        </table>
    </form>
    <?
    exit;

What format is rm-time in, and what format is the column?

aynber
– aynber

2017-06-09 12:33:34 +00:00
Commented Jun 9, 2017 at 12:33 — aynber
– aynber, Commented Jun 9, 2017 at 12:33

Dhanesh · Accepted Answer · 2017-06-09 12:33:39Z

1

here your syntax is wrong.

Use

<input name= "rm-time" type="time" id="rm" />

instead of

<input name"rm-time" type="time" id="rm" />

answered Jun 9, 2017 at 12:33

Dhanesh

3242 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alil rodriguez · Accepted Answer · 2017-06-09 12:35:26Z

0

change this

FROM : <input name"rm-time" type="time" id="rm" /></td>

TO : <input name="rm-time" type="time" id="rm" /></td>

answered Jun 9, 2017 at 12:35

alil rodriguez

1247 bronze badges

Collectives™ on Stack Overflow

<input type="time" /> value doesn't insert in mysql db

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related