Wednesday, 24 February 2021

Creating Table in XAMPP-PHP-MySQL Database

Create a table in PHP-MySQL database

Note: Install XAMPP PHP Web Server in your machine

Step-1: Type http://localhost/phpmyadmin/ in address bar of your browser

Step:2: From the left side bar, click any one database(Eg: test)


Step:3 Below the create table, type table name(eg:user) and specify number of columns(Eg.2), then click Go button.


Step:4 Enter table column names, type and length as follows, then click save. 


Step:5 Now you will see the following screen.


Step:6 Click the SQL Tab and then INSERT button and run the insert query as follows for inserting username and password for two users as follows

INSERT INTO `users`(`username`, `password`) VALUES ("abc","123456")


Step:7 Now you will see the following screen after successful insertion
.

Step:8 Now click table name(Eg:users) from left side, you will see the following screen will show all records present in the table.


THANK YOU