Leave default option value empty in html select

Question

I have an html select that is populated with DATA from a query using a foreach loop. It looks something like this

$client = $wpdb->get_results("SELECT string FROM `file` WHERE 
`code` = 002 AND `status` = 2");

echo 'Filter by client: ';
  echo '<select name="client_list">';
  foreach ($client as $key => $row) {
    $value = $row->string;
    echo 
  '<option value='.$value.'>'
  .$value. '</option>';
  }
  $client = $_GET['client_list'];
  echo '</select>';

It serves as a filter to display data based on the selected option value. The table that it filters looks somehting like this

   |client  | file              | 
   |------  |-------------------|
   |client1 | file00000         |
   |client2 | file00002         |

Now I want to make the first option value (the default value) of the html empty. How do I do this?

Joel Harkes · Accepted Answer · 2017-10-05 09:35:43Z

1

Add an empty option first:

echo '<select name="client_list"><option value=""></option>';

on submit if client_list is empty you know someone didn't choose anything.

answered Oct 5, 2017 at 9:35

Joel Harkes

11.7k3 gold badges49 silver badges71 bronze badges

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

2 Comments

R1ddler Over a year ago

That works to create an empty value but when I hit submit, it doesn't give the desired results. When I submit with empty client list I want to display a clean unfiltered query but instead it doesn't give me any results.

Joel Harkes Over a year ago

that is another question than original. You should not use the $client = $_GET['client_list']; in your query if its empty

Shubham Saini · Accepted Answer · 2017-10-05 10:09:01Z

0

you can use this

      $client = $wpdb->get_results("SELECT string FROM `file` WHERE 
     `code` = 002 AND `status` = 2");

    echo 'Filter by client: ';
    echo '<select name="client_list"><option value=""></option>';
    foreach ($client as $key => $row) {
        $value = $row->string;
        echo 
       '<option value='.$value.'>'
        .$value. '</option>';
    }
    $client = $_GET['client_list'];
    echo '</select>';

edited Oct 5, 2017 at 10:09

answered Oct 5, 2017 at 9:38

Shubham Saini

1828 bronze badges

3 Comments

R1ddler Over a year ago

That gives two empty values. You're missing / in option.

Funk Forty Niner Over a year ago

@R1ddler You wrote "That gives two empty values. You're missing / in option" - So I for one am confused by that comment and whether or not it does solve the question completely and doesn't have anything to do with your new question stackoverflow.com/q/46588904/1415724

R1ddler Over a year ago

If you ommit the closing / in option, that does give two empty values. This solved the question, I only needed to add / to option and it worked. My new question is different from this one and has nothing to do with this one.

Collectives™ on Stack Overflow

Leave default option value empty in html select

2 Answers 2

2 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Linked

Related