Displaying MYSQL info using PHP in HTML

Question

Im creating a webpage which displays the information from my MYSQL database using php code. However, when I test the page, rather then displaying the information, the code itself appears instead of the information. i cant figure out why such is happening as i have used the code before with no problem.

<!doctype html>
<html>
    <head>
        <meta charset="utf-8">
        <title>Game Portal</title>
        <style>
        //CSS CODE  
        </style>

    </head>
    <body>
            <div class="right"></div>
            <div class="center">
                <?php
                    $table_name = "";
                    $host_name = "";
                    $user_name = "";
                    $password = "";
                    $db_name = "";
                    $db_link = mysqli_connect($host_name, $user_name, $password, $db_name) or die(mysqli_error($db_link));
                    $query = "select Name, Cover from $table_name;"; 
                    $result = mysqli_query($db_link, $query) or die(mysqli_error($db_link));
                    echo "<table>";

                         while ($row = mysqli_fetch_array($result))  {
                                     echo "<tr><td>{$row[0]}</td>";
                                     echo "<td align=right>{$row[1]}</td></tr>";
                                }

                        echo "</table>";
                ?>
            </div>
        </div>
        <div class="footer">
        </div>
    </body>
</html>

Note that i removed bits of the code that aren't needed for the php part in order to make it easier to read.

Is your file .html or .php? .html files won't be parsed by PHP unless you specifically set them to. — Ali Hamze
– Ali Hamze, Commented Mar 4, 2015 at 2:42
@A22asin you don't want to change the extension for SEO purpose or for another reason? — Leandro Papasidero
– Leandro Papasidero, Commented Mar 4, 2015 at 3:01

Leandro Papasidero · Accepted Answer · 2015-03-04 03:21:40Z

1

Create a .htaccess

RemoveHandler .html .htm
AddType application/x-httpd-php .php .htm .html

Or

<FilesMatch "\.html$">
    ForceType application/x-httpd-php
</FilesMatch>

PHP File

enter image description here

Browser

enter image description here

answered Mar 4, 2015 at 3:21

Leandro Papasidero

3,7381 gold badge20 silver badges33 bronze badges

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

Comments

Ali Hamze · Accepted Answer · 2015-03-04 02:45:23Z

1

Seeing as your using .html files, if you really want to parse them as PHP (I wouldn't recommend it as if they don't contain PHP code, they will still be parsed adding overhead)

Add AddType application/x-httpd-php .html to your .htaccess (assuming your using Apache)

answered Mar 4, 2015 at 2:45

Ali Hamze

1,59013 silver badges27 bronze badges

Comments

Markus AO · Accepted Answer · 2015-03-04 03:31:35Z

1

You can rewrite requests for (.*).html into a matching .php file. Pop the following into a .htaccess file in the directory where your wares are:

RewriteEngine on
RewriteRule ^(.*)\.html$ $1.php

The page will then be visible as .html to your users, but obviously your PHP code gets processed. Presuming you have Apache as the server you use.

edited Mar 4, 2015 at 3:31

answered Mar 4, 2015 at 3:25

Markus AO

4,8892 gold badges20 silver badges29 bronze badges

Collectives™ on Stack Overflow

Displaying MYSQL info using PHP in HTML

3 Answers 3

Comments

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related