PHP not working on HTML file

Question

This PHP code does not work inside an HTML file but it works if its a PHP file

$con = mysql_connect("localhost","root","aaaa");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("maptemp", $con);


$sql = "SELECT * FROM users";
$rs = mysql_query($sql) or die(mysql_error());
$selectbox='<select name=\'userst\'>';
while ($row = mysql_fetch_assoc($rs)) {
$selectbox.='<option value=\"' . $row['username'] . '\">' . $row['username'] .  '</option>';
}
$selectbox.='</select>';
mysql_free_result($rs);
echo $selectbox;

You need to configure the webserver to interpret HTML files as PHP. — Bart, Mar 09 '13 at 14:34
@Bart Sure you *can*, but judging by the user's apparent knowledge I would say that may be bad starting advice. — Wesley Murch, Mar 09 '13 at 14:35
@Wesley Murch I agree that is doesn't make much sense. But it's pretty much doable. We could also state that mixing HTML and PHP is bad advice. — Bart, Mar 09 '13 at 14:43
Is it just me or has there been quite a number of topics involving running PHP from inside a HTML file today? — asprin, Mar 09 '13 at 14:55

score 6 · Answer 1 · edited May 23 '17 at 10:29

Many (maybe most, all?) webservers aren't configured to look for php script inside html files out of the box.

Apache, a very popular webserver that you might be running, is an example of such a webserver.

You can, however, configure a webserver, like Apache, to do exactly what you want. If you can't access the Apache configuration files in the Apache directory itself (which is typical on shared servers, which, again, you most likely have), you can configure on a per-directory basis using .htaccess files.

Doing this is pretty simple: open up your favorite text editor, throw this line in there:

AddType application/x-httpd-php .html

and save it as .htaccess in the same folder as your .html file. And that should do it.

I'd advise against this, though, as people (like webservers) don't expect there to be php script inside an html file. It's good practice to just stick to .php files for your php script.

By doing this when I refresh the page its download something without any extension. — Sanjay Goswami, Jan 20 '17 at 00:02

PHP not working on HTML file

1 Answers1

Linked