Unable to connect to mysql database through HTML php script

Question

I have a raspberry pi (OS: Ubuntu 18.04, local IP: 192.168.1.84) running MariaDB and I have it configured so that my desktop (OS: Ubuntu 18.04, local IP: 192.168.1.76) can access it. I ran a interactive php shell on my desktop and everything was fine:

$ php -v
PHP 7.2.24-0ubuntu0.18.04.6 (cli) (built: May 26 2020 13:09:11) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.2.0, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.2.24-0ubuntu0.18.04.6, Copyright (c) 1999-2018, by Zend Technologies
$ php -a
php > $conn = new mysqli("192.168.1.84", "root", "", "test");
php > $result = $conn->query("SELECT * FROM testing");
php > echo $result->num_rows;
3

However, I wrote a quick html script to show those info:

<html>
<body>

<?php
$conn = new mysqli("192.168.1.84", "root", "", "test");
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

echo "<p>Connection successful</p>";
?>

</body>
</html>

When I tried to open the html file in browser, this is how it looks like (a page with a section of php code as written). I have no idea what is going on with the page.

I'm new to html/php, any help is appreciated.

score 2 · Accepted Answer · edited Aug 10 '20 at 02:14

PHP is a server side scripting language. You can't run it directly by just opening the PHP file into your browser because it needs an interpreter to be feed into and then you will get your desired output.

What you did in the command line was exactly how it's supposed to work. You fed your php code into the PHP interactive shell and then it executed the code using the interpreter accordingly and showed you the output.

As you have mentioned that you are using Ubuntu so in order to execute the code in a browser you need to install PHP along with an HTTP server like Apache or Nginx etc.

After installing both of them then you will start the HTTP server process and then you will create a file with .php extension under /var/www/html/ assuming you installed Apache HTTP Server.

When you do so you will be able to visit your file through the browser using the following link as:

http://localhost/index.php

You can execute the following commands to get a working server in Ubuntu:

sudo add-apt-repository ppa:ondrej/apache2

sudo apt-get update

sudo apt-get install apache2

sudo apt-get install php7.2

sudo service apache2 start

If you want to setup a VHOST which is recommended always, you can do so the following way:

Execute the command to create the VHOST config file:

sudo nano /etc/apache2/sites-available/project1.loc.conf

Then copy the following config and paste it in the file and save the conf file:

<VirtualHost *:80>
    ServerName project1.loc
    ServerAlias project1.loc
    ServerAdmin webmaster@localhost
    DocumentRoot /var/www/html/project1.loc
    <Directory /var/www/html/project1.loc/>
            Options All
            AllowOverride All
            Require all granted
    </Directory>
    ErrorLog ${APACHE_LOG_DIR}/error.log
    CustomLog ${APACHE_LOG_DIR}/access.log combined
</VirtualHost>

Next, enable the VHOST and restart apache:

sudo a2ensite project1.loc.conf

sudo systemctl restart apache2

Add the following line in your /etc/hosts as well:

127.0.0.1 project1.loc

Flush the DNS cache after each change in your hosts file:

sudo systemd-resolve --flush-cache

Next execute the following command to create the project directory:

sudo mkdir /var/www/html/project1.loc

Next, execute the following command to create your PHP file (where your code will reside):

touch /var/www/html/project1.loc/index.php

Then you can visit your file using the following link in the browser as:

http://project1.loc/index.php

Of course it will be blank at the beginning just edit /var/www/html/project1.loc/index.php to go further. Good luck!

biesior · Answer 2 · 2020-08-10T01:18:11.360

You cannot execute PHP code in HTML file, rename the file to index.php. There is no such thing like HTML script. HTML stands for HyperText Markup Language, no mention about scripting.

However, if your HTTP server is configured properly to handle files with *.php extension, you can generate HTML code including PHP code fragments as you did in your sample.

Additionally, as I can see you need to install some HTTP server i.e. XAMPP and add a virtual host. You can't just open PHP file in the browser and live with hope it will work.

As you are using Ubuntu probably you can install the stack using apt (damn yeah oldschool-cool) see this aricle.

Please go with @UmairShahYousafzai's answer as it describes problem specifically to your operating system. — biesior, Aug 10 '20 at 01:31

score 0 · Answer 3 · edited Aug 10 '20 at 01:11

0

First, Change the file extension to from .html to .php.

Second, use a local HTTP server like WAMP, XAMPP, or Laragon (or other suitable to your system) in order to run PHP.

edited Aug 10 '20 at 01:11

biesior

55,207
10
121
181

answered Aug 10 '20 at 00:46

Paul Robert

50
5

Unable to connect to mysql database through HTML php script

3 Answers3