php script error within html file

Question

i'm relatively new to this trying to get a mysql database array of Username to be shown in a html drop down input for another form however the php script just keep being shown rather than the function. below is a screenshot of the error

http://s10.postimage.org/j4xuamkwp/untitled.png

the php script is sat within my html file

<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$db = 'fid';

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
if (!$conn)
die('Could not connect: ' . mysql_error());

mysql_select_db($db);

echo '<label class="input" for="investigator" type="input">Importance:</label><select id="investigator" name="investigator">';
$resource = mysql_query("SELECT `Username` FROM `user`");
if($resource && mysql_num_rows($resource)) {
    while ($row = mysql_fetch_assoc($resource)){
        echo '<option value="'.$row['Username'].'">'.$row['Username'].'</option>';
    }
}
echo '</select>';
mysql_close($conn)
?>

I think its an issue within the while loop however cannot fix it and its getting very frustrating!

your server won't parse files with .html extension as php. you either need to add php handler to it using htaccess or apache conf, or change extension of the file — Marko D
– Marko D, Commented Mar 19, 2013 at 17:29
Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — Mayank K. Swami
– Mayank K. Swami, Commented Mar 19, 2013 at 17:35

kylex · Accepted Answer · 2013-03-19 17:38:45Z

2

Your file needs to have a .php extension to work properly.

.html will not be recognized as a php file.

Name your file: myfile.php for files that have php code in them. NOT myfile.html

EDIT: As others have pointed out, you can add html as a php type, but that's not typically how it's done, nor would I recommend it.

edited Mar 19, 2013 at 17:38

answered Mar 19, 2013 at 17:29

kylex

14.5k36 gold badges118 silver badges177 bronze badges

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

3 Comments

Funk Forty Niner Over a year ago

Hm.. true but not entirely. You can run .html as .php by using AddType application/x-httpd-php .html .htm

Mayank K. Swami Over a year ago

nah not true can tell server to use .bla file like php

James Over a year ago

Thank you i new it would be something small affecting it problem solved!

ddavison · Accepted Answer · 2013-03-19 17:32:29Z

0

It sounds like your server isn't parsing PHP properly. Couple troubleshooting tips-

1) make sure you're PHP is enabled on the server.
2) make sure the extension of your file is ".php".
3) If you would like your server to parse ".htm|html" files as PHP, you can change your .htaccess (assuming you are using apache), by following these steps.

answered Mar 19, 2013 at 17:32

ddavison

29.3k17 gold badges90 silver badges116 bronze badges

Comments

Mattios550 · Accepted Answer · 2013-03-19 17:34:01Z

0

Yep, .html will not be read by the PHP interpreter (the part of the web server that reads and computes PHP scripts).

If you rename your file with a .php ending, for example file.php (not file.html) your script should work.

This part of your script has me confused:

if (!$conn)
die('Could not connect: ' . mysql_error());

Should it not be

if (!$conn) {
die('Could not connect: ' . mysql_error());
}

The { and } tells PHP which part of your script is if or while and which parts aren't.

answered Mar 19, 2013 at 17:34

Mattios550

3721 gold badge5 silver badges18 bronze badges

1 Comment

kylex Over a year ago

In php, a single line (and only a single line) below an if/else statement does not require curly braces.

Collectives™ on Stack Overflow

php script error within html file

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related