Wednesday 14 October 2015

How to directly insert values on MySQL database through phpmyadmin

There are two various type of methods present on web development area to store values on MySQL database. First one is to insert from html text forms and other is directly throw information through phpmyadmin control panel area. Phpmyadmin gives us the facility to add values directly into MySQL db tables ( Rows, Columns ).

Where can i need this type of information add functionality.

The basic intention to add outright data into MySQL db is where you have to define login -functionality on your php website. With the help of pre-define data in database you can set login username and password straight. So after login from login form it will automatically check username and password key.

Add directly value on MySQL db tables using phpmyadmin.


1. Start Apache & MySQL server from xampp control panel.



2. Open localhost/phpmyadmin in your web browser.

3. Select your MySQL database -> Select Table by clicking on table name ( In which you want to insert data. ).

4. Click on Insert tab.


5. After that your table structure will be open, Just enter the values in table using given forms then click on Go button.


Conformation message after successfully information submission is " 1 Row inserted. "


1 comment:

  1. Interesting one. Its is an amazing task to put values into phpmyadmin while doing windows application development.

    ReplyDelete