Can't get data from Dropdown List PHP to Xampp MySQL

Question

I'm trying to get that from a dropdown list from my html.

<FORM ID="" ACTION="save.php">
            <TABLE BORDER=1 WIDTH=90%>
                    <TR>
                        <TH><p style="color:red">Time</p></TH>
                    </TR>
                <TR>  
                    <TD>
                    <SELECT NAME="Time" ID="Time" style="width:220px">
                        <OPTION>
                        <OPTION>7:30-8:30
                        <OPTION>7:30-9:00
                        <OPTION>7:30-10:30
                    </SELECT>
                    </TD>

What happens is when the user click the submit button, it automatically call save.php

<?php
$time = $_POST['Time'];

//create connection_aborted
$conn = mysqli_connect("localhost", "root", "", "scheduling");
//check connection
if($conn-> connect_error) {
    die ("connection failed; ". $conn-> connect_error);
}
$sql = "INSERT INTO sched (Time)VALUES ('$time')";

$conn->close();
?>

This technique works on textbox, I don't know why can't get data from drop down list. Am I missing something? Please help to fix.

set the option value

dianeryanto
– dianeryanto

2019-03-01 02:22:25 +00:00
Commented Mar 1, 2019 at 2:22 — dianeryanto
– dianeryanto, Commented Mar 1, 2019 at 2:22

dianeryanto · Accepted Answer · 2019-03-01 02:30:52Z

1

You need set the option value like this:

<select id="Time" required>
  <option value="">Please Select</option>
  <option value="7:30-8:30">7:30-8:30</option>
  <option value="7:30-9:00">7:30-9:00</option>
  <option value="7:30-10:30">7:30-10:30</option>
</select>

And if you have option with blank value, good to check in php first before insert like this

if (!empty($_POST['Time'])) $Time = $_POST['Time'];

edited Mar 1, 2019 at 2:30

answered Mar 1, 2019 at 2:25

dianeryanto

6002 gold badges6 silver badges18 bronze badges

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

Comments

strikemike2k · Accepted Answer · 2019-03-01 02:25:31Z

1

Your option tags need a value attribute to send to the server. Try this:

<SELECT NAME="Time" ID="Time" style="width:220px">
  <OPTION value=""></OPTION>
  <OPTION value="7:30-8:30">7:30-8:30</OPTION>
  <OPTION value="7:30-9:00">7:30-9:00</OPTION>
  <OPTION value="7:30-10:30">7:30-10:30</OPTION>
</SELECT>

answered Mar 1, 2019 at 2:25

strikemike2k

1611 silver badge5 bronze badges

Comments

Amit Chauhan · Accepted Answer · 2019-03-01 05:37:37Z

0

<select id="Time" name="Time">
  <option disabled="disabled" selected="selected" value="">Please Select One</option>
  <option value="7:30-8:30">7:30-8:30</option>
  <option value="7:30-9:00">7:30-9:00</option>
  <option value="7:30-10:30">7:30-10:30</option>
</select>

answered Mar 1, 2019 at 5:37

Amit Chauhan

366 bronze badges

Collectives™ on Stack Overflow

Can't get data from Dropdown List PHP to Xampp MySQL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related