Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

© Adrian W. West and Steve Prettyman 2018

Adrian W. West and Steve PrettymanPractical PHP 7, MySQL 8, and MariaDB Website Databaseshttps://doi.org/10.1007/978-1-4842-3843-1_1

1. Create and Test a Database and Table

Adrian W. West¹  and Steve Prettyman²

(1)

Colyton, Devon, UK

(2)

Key West, Florida, USA

 

This chapter introduces the concept of a database and a practical way of testing it. Using the examples, you will create a MariaDB or MySQL database and a table. As you work through the examples, you will become familiar with the database administration interface.

After completing this chapter, the student will be able to

• Define and design a database and table

• Install and use a WAMP package

• Use phpMyAdmin to create a database and table

• Secure phpMyAdmin and ...