This PHP code is used to display the table content from the DB into a table in HTML

displaytablecontent.php

<?php
define("DB_HOST","localhost");//DB HOST NAME
define("DB_NAME","login");// DB NAME
define("DB_USERNAME","root");// DB USERNAME
define("DB_PASSWORD","");// DB PASSWORD
$conn=@mysqli_connect(DB_HOST,DB_USERNAME,DB_PASSWORD,DB_NAME); // CONNECT TO THE DB
$query="SELECT * from users"; // SQL QUERY TO SELECT ALL THE COLUMNS OF THE TABLE
$response =@mysqli_query($conn,$query);// GET RESPONSE FROM THE DB
if($response){            // IF RESPONSE IS TRUE
	echo '<table align="left" cellpadding="5" cellpadding="8" border="1">
	<tr><td align="left"><b>username</b></td>
	<td align="left"><b>password</b></td>
	<td align="left"><b>regno</b></td>
	<td align="left"><b>name</b></td></tr>';
	
	while($row=mysqli_fetch_array($response)){
		echo '<tr><td align="left">'.
		$row['username'] . '</td><td align="left">'.      // DISPLAY THE COLUMN WITH NAME USERNAME
		$row['password'] . '</td><td align="left">'.      // DISPLAY THE COLUMN WITH NAME PASSWORD
		$row['regno'] . '</td><td align="left">'.         // DISPLAY THE COLUMN WITH NAME REGISTER #
		$row['name'] . '</td>';  // DISPLAY THE COLUMN WITH NAME NAME
		
		echo '</tr>';		
		}
	echo '</table>';
} else{                 // IF RESPONSE IS FALSE
	echo "error";
	echo mysqli_error($conn);     // DISPLAY THE ERROR
}
mysqli_close($conn);	// CLOSE THE DB CONNECTION
?>