PHP

phpMyAdmin localhost 8080 various functionalities using Wamp server

phpMyAdmin, Description :

phpMyAdmin localhost 8080  various functionalities using Wamp server-in this article you will learn about the various functionalities of phpmyadmin using localhost 8080 for that I am using wampserver. Main purpose of the phpMyAdmin tool is to manage the databases.

Without any further delay lets started!!!


Amazon Purchase Links:

Top Gaming Computers

Best Laptops

Best Graphic Cards

Portable Hard Drives

Best Keyboards

Best High Quality PC Mic

Computer Accessories

*Please Note: These are affiliate links. I may make a commission if you buy the components through these links. I would appreciate your support in this way!

Databases tab:

When you open phpMyAdmin’s home page, click the Databases tab, and then pick a database to manage by clicking on its name.

phpMyAdmin

On the page that opens you will see a list of the database tables, the activities permitted with them, the number of records, the storage system, the collation, the sizes of the tables, and the overheads.

phpMyAdmin

The possible actions to be taken at a table of your choosing are:

Browse

Through pressing the browse button you will see all the records inserted by you and you can show all the records in full detail.

phpMyAdmin

You can update the record data in a table after updating the data by clicking the edit button and then click the go button to save all the data you are updating.

phpMyAdmin



Structure:

Clicking the structure button will show you all the work you can perform on a table Such as

fields name and their types

collations, attributes, null, comments, extra ,action

change drop and more option will see in action

Clicking on change will allow you to change all the field attributes.

phpMyAdmin

Search

Using the Search button you will create a search query for the chosen table.

phpMyAdmin

Using the Query method to perform an example search. Just use different fields to arrange your search query, and press the Go button to execute it.

For example, you should first select the fields you want to show if you want to view all records with a field value beginning with “a.” Choose the LIKE operator from the drop-down menu, and enter the corresponding field value “a percent” (percent is a wildcard string). To see the results, click the Go button.


Insert:

When you insert a record into a particular table, press the Insert button

phpMyAdmin

Empty

You press the Empty button to delete all the inserted data from any table

phpMyAdmin


Drop

You can press the drop button when you want to remove any record type of the database.

phpMyAdmin

SQL tab:

Clicking on the SQL tab an editor like a panel will be opened in this editor you can run your SQL query

phpMyAdmin

Status:

You’ll find all the information of MySQL server in this section of PHPMyAdmin and u can see in the image below. In this section, you will see traffic and connection details

phpMyAdmin


 

User accounts:

In this section of PHPMyAdmin, you can find everything about user account s in this section where you can find your username and password for your localhost. As you can see below.

phpMyAdmin

Export:

This is the most important feature of PHPMyAdmin in this section, you can export your database and save the data on your computer because if you lose the project so you have a copy of you project database. the main part of your project that is the database that can be saved via the export tab.

phpMyAdmin


Import:

This is also a very important feature in PHPMyAdmin in this section, you can import the database that you have exported. You can just click on the screen to choose and pick the file and press the go button

phpMyAdmin

 

 

Engr Fahad

My name is Shahzada Fahad and I am an Electrical Engineer. I have been doing Job in UAE as a site engineer in an Electrical Construction Company. Currently, I am running my own YouTube channel "Electronic Clinic", and managing this Website. My Hobbies are * Watching Movies * Music * Martial Arts * Photography * Travelling * Make Sketches and so on...

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button