8. Nginx – Deploying a Performance-centric Web Server | CentOS System Administration Essentials

Create dynamic web content

To demonstrate how easily we can create dynamic web pages that will connect to the database using PHP from the Nginx server, we will create a new PHP page in /var/www/html. So fire up your favorite editor, and we will create the page within the document root, /var/www/html/db.php:

<h2>Databases</h2>
<?php
      $dbh=mysqli_connect("localhost","root","Password1");
      $result=mysqli_query($dbh, "SHOW DATABASES");
      while ($row = mysqli_fetch_assoc($result)) {
        echo $row['Database'] . "<BR>";
      }
?>

The code again is kept as simple as possible, and ideally we would include the connection credentials stored within another file that was not accessible to the web server, allowing access only from the PHP process; however, keeping the code to a minimum does aide the learning process at this early stage.

In this PHP file, you can see that we mix a little HTML code with the PHP code, starting with heading tags before entering into...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

CentOS System Administration Essentials

By : Andrew Mallett

CentOS System Administration Essentials

By: Andrew Mallett

Overview of this book

Create dynamic web content

CentOS System Administration Essentials

By : Andrew Mallett

CentOS System Administration Essentials

By: Andrew Mallett

Overview of this book

Create dynamic web content

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access