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?

use echo like, echo '<option value="'.$a.'" name="a">'.$a.'</option>'; — web2students.com
– web2students.com, Commented Jun 21, 2014 at 16:17
I'm sure this has been answered several times in several sites. This site is not a debugging service. — givanse
– givanse, Commented Jun 21, 2014 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
– Navelpluisje, Commented Jun 21, 2014 at 21:38

Community · Accepted Answer · 2017-05-23 10:32:20Z

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, 2017 at 10:32

CommunityBot

11 silver badge

answered Jun 21, 2014 at 16:17

arielnmz

9,21510 gold badges43 silver badges73 bronze badges

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

4 Comments

Ohgodwhy Over a year ago

Don't forget the mysql deprecation and removal.

user3763227 Over a year ago

sorry i can't get the output i saved this file in .html extn is it right?

arielnmz Over a year ago

The file's extension must be .php, you have to setup an http server with php support.

user3763227 Over a year ago

Thanks now its working i changed my file extn as .php

ɹɐqʞɐ zoɹǝɟ · Accepted Answer · 2014-06-21 16:20:38Z

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, 2014 at 16:20

ɹɐqʞɐ zoɹǝɟ

4,3703 gold badges25 silver badges36 bronze badges

Collectives™ on Stack Overflow

to write php variable in html option tag

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related