Learning phpMyAdmin

MySQL is one of the most widely used database systems for dynamic websites and content management systems. And phpMyAdmin is the most common method of administering a MySQL database, included in many CMSs as well as the XAMPP and MAMP testing environments.

Updated for phpMyAdmin 4.5, this introductory course shows designers and developers how to set up local user accounts, create a database, and design tables. Author David Powers also explains how to import data from CSV files, spreadsheets, and SQL dump files, and how to export data for backup or to transfer to another database. You'll also learn how to run database queries within its intuitive form-based interface, and monitor server performance.
Topics include:

  • Why use phpMyAdmin when you just use command line?
  • Setting up a user account
  • Creating a database in the phpMyAdmin console
  • Getting the type right: Choosing the right column types for tables
  • Inserting data manually
  • Importing and exporting data from MySQL dump files, text files, CSV files and other types of files
  • Dealing with foreign keys and foreign key constraints
  • Building and running queries
  • Creating views
  • Creating stored procedures and functions
  • Checking performance

Did you know...?

PHP is a widely-used scripting language intended for use in web pages to create dynamic content.

PHP runs on a web server, which interprets the PHP scripts behind the scenes and sends the results to the client. The client may not even know that a script was used to produce the contents of the webpage that they are viewing.

Although PHP is considered to be a simple language, it comes with an extensive list of features that allow it to be used in thousands of different ways to enhance websites and web applications. These uses include, but are by no means limited to:

  • Solving Math Problems
  • Parsing Text
  • Formatting, Manipulating and Displaying Current Dates & Times
  • Handling Form Data
  • Sending & Receiving Cookies to store handy information on the user's computer
  • Collecting Information About Your Website's Visitors
  • Tools to Read From & Write Data to Databases
  • Creating/Modifying Images with PHP extensions like GD; or crreating SVG
  • Creating Shopping Carts
  • Interacting With a Secure 3rd Party to Pay For Online Merchandise

Requirement to run PHP are either one of the following two options: either a web host that supports PHP; or a web server and PHP installed on your own computer.

Subject: 
Campus: 

Reviews

There are no reviews available... for now.

What do you think?

Do you have experience with this? write a review