How to extract MySQL or MariaDB data with PHP mysqli_query?

PHP is designed to easily integrate into a website. One of its most common uses is to extract content from a database and display it on an HTML page. This tutorial explains how to establish a connection to a MySQL or MariaDB database, retrieve information from a simple table using the PHP mysqli_query() function, and display it in an HTML table.