How to show database of login page and registation page

Question

To show all the data at one place of person's who have registered

Answer 1

In MySQL, the word "all" means "*"

I consider,
The table name the Customers
The Customer's username as Xyz, It is under the column name: username
Ph_number be 1234567890
Id be 1111100000

Then, you query like,

SELECT *FROM Customers WHERE "username"="Xyz"

Then it displays all the details stored to Xyz i.e. username, Ph_number, Id

If suppose you are integrating MySQL with PHP and in order to generalize it more, you can store the name in a variable and can call the variable when you require to show the details.