Advertisement

Practical PHP 7, MySQL 8, and MariaDB Website Databases

A Simplified Approach to Developing Database-Driven Websites

  • Adrian W. West
  • Steve Prettyman

Table of contents

  1. Front Matter
    Pages i-xx
  2. Adrian W. West, Steve Prettyman
    Pages 1-31
  3. Adrian W. West, Steve Prettyman
    Pages 33-74
  4. Adrian W. West, Steve Prettyman
    Pages 75-110
  5. Adrian W. West, Steve Prettyman
    Pages 111-150
  6. Adrian W. West, Steve Prettyman
    Pages 151-190
  7. Adrian W. West, Steve Prettyman
    Pages 191-236
  8. Adrian W. West, Steve Prettyman
    Pages 237-286
  9. Adrian W. West, Steve Prettyman
    Pages 287-334
  10. Adrian W. West, Steve Prettyman
    Pages 335-376
  11. Adrian W. West, Steve Prettyman
    Pages 377-429
  12. Adrian W. West, Steve Prettyman
    Pages 431-478
  13. Adrian W. West, Steve Prettyman
    Pages 479-505
  14. Back Matter
    Pages 507-546

About this book

Introduction

Build interactive, database-driven websites with PHP 7, MySQL 8, and MariaDB. The focus of this book is on getting you up and running as quickly as possible with real-world applications. In the first two chapters you will set up your development and testing environment, and then build your first PHP and MariaDB or MySQL database-driven website. You will then increase its sophistication, security, and functionality throughout the course of the book. 

The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MariaDB/MySQL to create powerful database-driven websites. 

Each project is fully illustrated, so you will see clearly what you are building as you create your own database-driven website. You will build a form for registering users, and then build an interface so that an administrator can view and administer the user database. You will create a message board for users and a method for emailing them. You will also learn the best practices for ensuring that your website databases are secure. Later chapters describe how to create a product catalog, and a simple e-commerce site. You will also discover how to migrate a database to a remote host. The final chapter will demonstrate the advantages of migrating to Oracle's MySQL 8. You will be shown step by step migration directions along with a demonstration of the tools available in SQL Workbench.

Because you are building the interactive pages yourself, you will know exactly how MySQL, MariaDB, and PHP all work together, and you will be able to add database interactivity to your own websites with ease.

You will:

  • Build a secure database-driven website using PHP 7, MySQL 8, and MariaDB
  • Create a product catalog
  • Write a message board
  • Move towards e-commerce
  • Employ security and validation measures
  • Migrate to Oracle's MySQL 8 Server platform

Keywords

php mysql MariaDB web database data driven build code practical software application

Authors and affiliations

  • Adrian W. West
    • 1
  • Steve Prettyman
    • 2
  1. 1.Colyton, DevonUK
  2. 2.Key WestUSA

Bibliographic information

Industry Sectors
Finance, Business & Banking
Electronics
IT & Software
Energy, Utilities & Environment