How to fetch data from an select field in php and load into database?

Question

How can i fetch the data from the option-field and load the chosen option-field into the database ?

<div class="form-group col-md-5">
                <label class="control-label">Date of birth:*</label>
                <div class="form-group">
                    <div class="col-md-4">
                        <select type="text" class="form-control" id="day" >
                            <option>--Day--</option>
                            <?php
                               $day = array(range(1,31));
                                for ($i = 1; $i <= 31; $i++) {
                                    echo "<option name='day'>".$i."</option>";
                                }
                            ?>
                        </select>
                    </div>
                    <div class="col-md-4">
                        <select type="text" class="form-control" id="month">
                            <option>--Month--</option>
                            <?php
                                for ($i = 1; $i <= 12; $i++) {
                                    echo "<option name='month'>".$i."</option>";
                                }
                            ?>
                        </select>
                    </div>
                    <div class="col-md-4">
                        <select type="text" class="form-control" id="year">
                            <option>--Year--</option>
                            <?php
                                for ($i = 1900; $i <= 2016; $i++) {
                                    echo "<option name='year'>".$i."</option>";
                                }
                            ?>
                        </select>
                    </div>
                </div>
            </div>

I know i can use https://eonasdan.github.io/bootstrap-datetimepicker/ cause im using bootstrap. but there it's the same. i dont know how to fetch the choosen data.

You need to put value on your option fields <option name='year' value='$i'>".$i."</option> .. for day and month also — S.I.
– S.I., Commented Oct 10, 2016 at 7:19
@S.I.: agreed with u, but OP also need to add name attribute in <select> as i mentioned in answer — devpro
– devpro, Commented Oct 10, 2016 at 7:30
Yes, down in my answer is fixed since I can't edit this comment anymore. — S.I.
– S.I., Commented Oct 10, 2016 at 7:31
@Blueblazer,. I have provided with some general checks over to the solutions that i had provided for the select tags. And find that and use for the next projects. — Naresh Kumar P
– Naresh Kumar P, Commented Oct 10, 2016 at 7:40

Blueblazer172 · Accepted Answer · 2016-10-10 08:18:08Z

I don't know your server side part of code but here you missing values on option fields. This value is what you save in database. So if everything else is okay with your code you should make something like this:

            <label class="control-label">Date of birth:*</label>
            <div class="form-group">
                <div class="col-md-4">
                    <select name="day" type="text" class="form-control" id="day" >
                        <option>--Day--</option>
                        <?php
                           $day = array(range(1,31));
                            for ($dayOfBirth = 1; $dayOfBirth <= 31; $dayOfBirth++) {
                                echo '<option  value="'.$dayOfBirth.'">"'.$dayOfBirth.'"</option>';
                            }
                        ?>
                    </select>
                </div>
                <div class="col-md-4">
                    <select name="month" type="text" class="form-control" id="month">
                        <option>--Month--</option>
                        <?php
                            for ($monthOfBirth = 1; $monthOfBirth <= 12; $monthOfBirth++) {
                                echo '<option  value="'.$monthOfBirth.'">"'.$monthOfBirth.'"</option>';
                            }
                        ?>
                    </select>
                </div>
                <div class="col-md-4">
                    <select name="year" type="text" class="form-control" id="year">
                        <option>--Year--</option>
                        <?php
                            for ($yearOfBirth = 1900; $yearOfBirth <= 2016; $yearOfBirth++) {
                                echo '<option  value="'.$yearOfBirth.'">"'.$yearOfBirth.'"</option>';
                            }
                        ?>
                    </select>
                </div>
            </div>

S.I. · Accepted Answer · 2016-10-10 07:53:57Z

2

You just need to add name attribute in <select> box and add $i value in <option> as:

<select type="text" class="form-control" id="day" name='day'>
<option>--Day--</option>
<?php
$day = array(range(1,31));
for ($i = 1; $i <= 31; $i++) {
?>
<option value="<?=$i?>"><?=$i?></option>
<?php
}
?>
</select>

Here i am using name='day' in <select> tag, and value="<?=$i?>" in <option> tag.

Same as for YEAR and MONTH fields.

edited Oct 10, 2016 at 7:53

S.I.

3,38112 gold badges53 silver badges87 bronze badges

answered Oct 10, 2016 at 7:25

devpro

16.1k3 gold badges29 silver badges39 bronze badges

4 Comments

Naresh Kumar P Over a year ago

I have provide with some general checks so that it might be useful for that developer right in future to check by himself and fix it.

Blueblazer172 Over a year ago

may you explain what '<?=$i?>' means

devpro Over a year ago

@Blueblazer <?=?> is a short tag which is equal to <?php echo $i; ?>

devpro Over a year ago

@Blueblazer: glad to help u if answer work for u, dont forget to accept it, this will help to others.

Mr Lister · Accepted Answer · 2016-10-16 18:22:54Z

2

You need to change two things here.

First, give name to the <select> instead of <option>.

Second set the value attribute of the <option> to get the value of selected option.

So the code for selection box you've written will look something like this,

<select type="text" class="form-control" id="year" name="year">
    <option>--Year--</option>
    <?php
        for ($i = 1900; $i <= 2016; $i++) {
            echo "<option value='".$i."'>".$i."</option>";
        }
    ?>
</select>

Now if the form method is POST access the year value in php script using $_POST and if it's GET then access it using $_GET.

edited Oct 16, 2016 at 18:22

Mr Lister

46.8k15 gold badges118 silver badges156 bronze badges

answered Oct 10, 2016 at 7:26

Alok Patel

8,0726 gold badges35 silver badges48 bronze badges

Comments

Naresh Kumar P · Accepted Answer · 2016-10-10 07:25:37Z

1

Check Points for getting value form the Select tag

If you need to pull out the data from the select tag you have to check for the following conditions.

Whether you have provided the name for the select tag.
Whether you have provided the value for the option fields.

if so you do the above two alone you can fetch out or pull out the data from the select tag.

Example:

Select tag: With name and option values

<select name="age">
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>

Then in the PHP you can fetch out the data like this.

<?php
if(isset($_POST['age'])
{
  echo $_POST['age'];
}
?>

answered Oct 10, 2016 at 7:25

Naresh Kumar P

4,2802 gold badges19 silver badges34 bronze badges

Collectives™ on Stack Overflow

How to fetch data from an select field in php and load into database?

4 Answers 4

Comments

4 Comments

Comments

Check Points for getting value form the Select tag

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

4 Comments

Comments

Check Points for getting value form the Select tag

Comments

Your Answer

Sign up or log in

Post as a guest

Related