Pull database info and display to html problem?

Pull database info and display to html problem?

I'm trying to display the information from the database to the html page but it is only displaying the message "connected successfully". The name of the database is "admin" and the table within that database is called "users". I have no idea how to get past the message and just display the table I have created.

I'm trying to display the information from the database to the html page but it is only displaying the message "connected successfully". The name of the database is "admin" and the table within that database is called "users". I have no idea how to get past the message and just display the table I have created.

Index page (index.php):

<?php
include_once('connection.php');
$query="select * from users";
$result=mysql_query($query);
?>
<!DOCTYPE html>
<html>
<title>
    <head> Fetch Data Frome Database</head>
</title>
<body>

<table align="center" border="1px" style="width:250px; line-height: 30px;"> <tr> <th colspan="4"><h2>Account Record</h2></th> </tr> <t> <th>ID</th> <th>Username</th> <th>Password</th> </t>

&lt;?php

while($rows=mysql_fetch_assoc($result))
{
?&gt;

&lt;tr&gt;
    &lt;td&gt;&lt;?php echo $rows['ID'];?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $rows['username'];?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $rows['password'];?&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;?php
}

?&gt;

</table>

</body> </html>

CONNECTION PAGE (connection.php):

<?php
//Include your own values for username, password and     dbase name

$host = "localhost"; $username = "root"; $password = "root"; $dbname = "admin";

// Create connection $conn = new mysqli($host, $username, $password, $dbname);

// Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ?>


Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

Build a Register & Login Form using PHP, HTML, CSS, Bootstrap and MySQL

In this tutorial you will learn and build a Responsive PHP Registration & Login Form using PHP, HTML, CSS, Bootstrap and MySQL

PHP / MySQL - Count how many table in database contain Specific name

I'm building an admin to control an interactive game, and I'm using PHP/MySql to store all the data for all the rounds. Each of the tables that I want to load into the game via PHP are titled "Puzzle*" with the * being an incremental index number. There are a few other tables in my database for global game data and bonus rounds.

Sending an HTML email on a PHP code gives me a Syntax Error

Good morning, I'm having problems when I execute my code, I think I'm having problems with the quotes, etc.