HOW TO CREATE A TABLE IN MYSQL USING PHPMYADMIN

-

 

In this tutorial, you will learn how to create a database and table in MYSQL using PHPMYADMIN. Before beginning, you need to download and install MYSQL, PHP, APACHE SERVER and PHPMYADMIN in your system.

1. Download MYSQL and Install it. Download MYSQL.

 

2. Download PHPMYADMIN. Download PHPMYADMIN.

 

3. Open a browser and type in URL http://localhost/phpMyAdmin-4.7.5-all-languages/  

 

4. Sign in to your PHPMYADMIN: 

 5. After Sign in to your PHPMYADMIN, Click on the Databases:

To create a table in Mysql first we need to Create a Database.





6. Create a Database:

Enter your database name. Give it a name "Demo"


7. After creating a database now create a table:

Enter the name of the table and numbers of rows and click on Go. (ex. Name = "user" and Rows="4").


8. After clicking on Go, Now add details about row: 

Make sure all fields look the same as below and click on Save.


9. Table Created Successfully.

Now you can Add, Edit, Delete rows in your table.




Comments

Post a Comment

Popular posts from this blog

HOW TO UPDATE+FETCH DATA IN PHP - CULT CODE

-
Image
   In this tutorial, we will learn how to UPDATE+FETCH data in PHP using HTML form.   1. Create a table name user.   Use the code below to create a table:   CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(251) NOT NULL, `email` varchar(251) NOT NULL, `password` varchar(251) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;                   2. Now create a file connect.php: This file will help us to connect PHP to Mysql. <?php    $connect = mysqli_connect("localhost", "root", "password", "demo");    ?>   3. Now create a file index.php: In this file, we will create an HTML form and fetch data using PHP. <?php  include('connect.php'); include('update.php'); $data_query = "SELECT * FROM user LIMIT 1"; $data_result = mysqli_query($connect, $data_query); if(mysqli_num_rows($data_result) > 0)...
Read more

LOGIN/SIGNUP FORM WITH SESSION IN PHP MYSQL - CULT CODE

-
Image
In this tutorial, We will learn how to create a Signup and Login form in PHP MySql with Session Management and Exist condition. 1. Create a table name user.   Use the code below to create a table: CREATE TABLE `user` ( `id` int(251) NOT NULL, `username` text NOT NULL, `email` text NOT NULL, `password` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; 2. Now create a file connect.php: This file will help us to connect PHP to Mysql. <?php $connect = mysqli_connect("localhost", "root", "password", "demo"); ?>   3. Now create a file index.php: After Signup/Sign-in user will be redirected to this page. <?php session_start(); if (!isset($_SESSION['username'])) { header("location: login.php"); } elseif (isset($_GET['logout'])) { session_destroy(); unset($_SESSION['username']); header("location: login.php"); } ?> <!DOCTYPE ht...
Read more

HOW TO FETCH DATA FROM MYSQL WITH WHERE CONDITION USING PHP - CULT CODE

-
Image
    In this tutorial, we will learn how to fetch Selected rows from a table in PHP with the WHERE condition.     1. Create a table name user.   Use the code below to create a table:   CREATE TABLE `user` ( `id` int(11) NOT NULL, `name` varchar(251) NOT NULL, `email` varchar(251) NOT NULL, `password` varchar(251) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;       2. Now create a file connect.php: This file will help us to connect PHP to Mysql. <?php $connect = mysqli_connect("localhost", "root", "password", "demo"); ?>   3. Now create a file index.php: Paste the below code in your index.php file. <?php include('connect.php'); $data_query = "SELECT * FROM user WHERE id='5'"; $data_result = mysqli_query($connect, $data_query); if(mysqli_num_rows($data_result) > 0) { while($row = mysqli_fetch_array($data_resu...
Read more