to write php variable in html option tag

Question

i want to write a php variable inside a html option tag, but my code is not working.

<html>

<body>
    <?php $host="localhost" ; 
    $mysql_db="db" ; 
    $mysql_u="root" ; 
    $mysql_p="" ; 
    mysql_connect( "$host", "$mysql_u", "$mysql_p"); 
    mysql_select_db( "$mysql_db"); 
    $sel="select * from site" ; 
    $val=mysql_query($sel);
    while($row=m ysql_fetch_array($val, MYSQL_ASSOC)) 
    { 
            $a=$row[ 'a'];
            <option value="$a" name="a">$a</option>
    } ?>
</body>

</html>

i saved this file in .html extn is it right?

I'm sure this has been answered several times in several sites. This site is not a debugging service. — givanse, Jun 21 '14 at 16:36
Saved it as a html file?? I think you should start learning the basics first. There are a huge amount of examples to find — Navelpluisje, Jun 21 '14 at 21:38

score 1 · Accepted Answer · edited May 23 '17 at 10:32

1

You should echo it:

echo '<option value="'.$a.'" name="a">'.$a.'</option>';

And concatenate your vars.

Also, don't use the mysql extension, either use the mysqli or PDO extensions and prepared statements. Here's why: Why shouldn't I use mysql_* functions in PHP?.

edited May 23 '17 at 10:32

Community

1
1

answered Jun 21 '14 at 16:17

arielnmz

8,354
9
38
66

1

Don't forget the mysql deprecation and removal. – Ohgodwhy Jun 21 '14 at 16:17
sorry i can't get the output i saved this file in .html extn is it right? – user3763227 Jun 21 '14 at 16:28
The file's extension must be `.php`, you have to setup an `http` server with php support. – arielnmz Jun 21 '14 at 16:35
Thanks now its working i changed my file extn as .php – user3763227 Jun 21 '14 at 16:52

score 0 · Answer 2 · answered Jun 21 '14 at 16:20

0

first print the select

echo '<select>';
......
......

 while($row=m ysql_fetch_array($val, MYSQL_ASSOC)) 
    { 
            $a=$row['a'];
            echo "<option value=".$a." name='a'>".$a."</option>";
    } ?>
....
...
echo '</select>';

answered Jun 21 '14 at 16:20

ɹɐqʞɐ zoɹǝɟ

4,342
3
22
35

to write php variable in html option tag

2 Answers2