Bekend worden met database en phpMyAdmin

PhpMyAdmin is a tool designed to handle any MySQL tasks in a browser. It allows the user to create, edit and delete databases or certain fields, tables and rows. In using phpMyAdmin for MySQL, it is important to become familiar with the interface of the databases and tables you will create.

The guide below will help you understand all the things you need to confidently navigate through phpMyAdmin and your databases with ease:

Klik hier voor de video

1. Becoming familiar with database and phpMyAdmin.

2. Log in to phpMyAdmin. From the phpMyAdmin screen, we can have access directly to the database demo1234_members listed on the left side of the screen. A database consists of one or more tables, and it is in the tables that database information is recorded. This particular database has two tables called Details and Information and they are listed right below the database name. Now click the database name.

3. On the next page, we can see more information about the tables contained in the database, as well as perform several actions.

4. We can browse a table to see the individual records by clicking on the Browse icon.

5. In order to see the structure of a table and perform certain actions just click on the Structure icon.

6. We can also search through a table for specific keywords through the Search icon.

7. We can insert new rows or fields into a table by clicking on the Insert icon.

8. We can delete the contents of a table through the Delete icon.

9. Or, we can delete or drop an entire table altogether by clicking on the Drop icon.

10. We can alternatively click on the Structure Link above the page to view the database structure.

11. We can open an SQL query window for entering direct queries to the database.

12. We can click the Search icon to do a search.

13. The Query icon also opens an SQL Query window but provides an easier step-by-step way to make queries.

14. The Export icon enables us to export databases to our local computer.

15. We can also import previously exported databases through the Import icon.

16. The Operations icon allows us to do a number of other tasks or operations such as creating new tables, copying or renaming databases from the same page. To check the structure of the details table, click on the Details icon under the database name.

17. The structure of the Details table lists all table’s fields, along with the type of field, etc.

18. Scroll to the right side of the page.

19. Scroll one more time to the right side of the page until the last few columns of the table appear.

20. If we check the Field column, it tells us that the primary key field is the id field.

21. Click on the Details icon under the database name again.

22. If you want further help with SQL, you can click on the SQL Documentation icon.

23. If you need help with phpMyAdmin, you can click on the phpMyAdmin Documentation icon with a question mark sign.

24. Just beside the phpMyAdmin documentation icon is another icon called Query Window which allows us to open the SQL Query window.

25. Clicking the Exit button (log out icon) logs you out of phpMyAdmin. Click the Home icon to return to the main screen.

26. This is the end of the demo. You should now be more familiar with phpMyAdmin, and what you can use it to do. Be sure to check out our other tutorials for more detailed instructions.

27. Thank you for watching our video tutorial. Be sure to let us know if you have any questions about any information above that you are perplexed about.

Our Solutions


Social Link