Select option with input text

Question

I try to use input text for select option and i found this script from google

<input type="text" list="airports" name="airports"> 
<datalist id="airports">
<option value="Berlin">
<option value="Los Angeles">
<option value="Moscow">
<option value="Paris">
</datalist>
<input type="submit" value="confirm">

Here my script before :

<?php
$first="select * from members";
$two=mysql_query($first)or die("You Die!"); ?>
<select>
<? while($three=mysql_fetch_array($two)){ ?>
<option value=<? echo $three['firstname'];?><? echo $three['firstname'];?></option>
<? } ?>
</select>

When i combine them :

<?php
$first="select * from members";
$two=mysql_query($first)or die("You Die!"); ?>
<select>
<input type="text" list="firstname" name="firstname">
<datalist id="firstname">
<? while($three=mysql_fetch_array($two)){ ?>
<option value=<? echo $three['firstname'];?>><? echo $three['firstname'];?></option>
<? } ?>
</datalist>
</select>

it doest work t_t"

mysql_ library is deprecated. It is recommended that you use mysqli or PDO — Ken Lee, Nov 19 '21 at 05:44
The bottom code has a select tag while the first one doesn't, is that intentional? — Ammar Aslam, Nov 19 '21 at 06:15

score 0 · Accepted Answer · answered Nov 19 '21 at 07:09

try this:

<?php
$first="select * from members";
$two=mysql_query($first)or die("You Die!"); ?>
<select>
<input type="text" list="firstname" name="firstname">
<datalist id="firstname">
<? while($three=mysql_fetch_array($two)){ ?>
<option value="<? echo $three['firstname'];?>">
<? } ?>
</datalist>
</select>

Select option with input text

1 Answers1