- eBook:Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites 2nd ed. Edition
- Author:Adrian W. West, Steve Prettyman
- Edition:2 edition
- Data:September 29, 2018
- Pages:566 pages
- Format:PDF, ePUB
The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MariaDB and 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.
What You Will Learn
- 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
Web developers with HTML, CSS and a limited Bootstrap experience. Readers need little to no prior experience with PHP and MySQL.
Chapter 2: Create Web Pages That Interact with Users
Chapter 3: Create Login/Logout Functionality for Members and an Administrator
Chapter 4: Create an Administration Interface
Chapter 5: Expand and Enrich Your Website
Chapter 6: Add the Finishing Touches: Security and Validation
Chapter 7: Migrate to a Host and Back Up Your Website Database
Chapter 8: Create a Product Catalog
Chapter 9: Join Multiple Tables and Other Enhancements
Chapter 10: Create a Message Board
Chapter 11: E-commerce: A Brief Introduction
Chapter 12: Take a Brief Look at Oracle MySQL 8