How can I show my sql database to an admin login?

Question

I am trying to show the database for people logged in as an administrator on my website can some please help?

Answer 1

Well just write an sql query that displays this information and generate a html table from the result set. That's all I can say without details of the particular technology you are using :)

Answer 2

That depends on what exactly you want to show to the admin, table names, number of records, last updated? And also might differ for every type of database engine how it can be done.

Answer 3

I was wanting to show an admin the names, ids, and dobs of users in one table but not allow them to be edited without permission