show all tables in the selected database

show_all_db.php

<?php
/* list db structure */
function show_all_db() {
	global $db;
	global $db_name;
	$out = "";
	
	$sql = "SELECT table_name, column_name
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_schema = '$db_name'
    ORDER BY table_name, ordinal_position";
	
	$result = $db->query($sql);
	
	if(!$result) { return "Missing Main Table: $db_name "; }
	
	while($row = mysqli_fetch_assoc($result)) {	
	
		$table_name = $row['table_name'];
		$column_name = $row['column_name'];
		
		$out .= "$table_name : $column_name<br/>";
	
	}
	
	return $out;

}
?>