Authors:
A practical, hands-on book that explains how to create interactive web sites step-by step
Learn how PHP, MySQL and MariaDB quickly through real-world applications
Build your own database-driven website
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (12 chapters)
-
Front Matter
-
Back Matter
About this book
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
Who This Book Is For
Web developers with HTML, CSS and a limited Bootstrap experience. Readers need little to no prior experience with PHP and MySQL.
Authors and Affiliations
-
Colyton, Devon, UK
Adrian W. West
-
Key West, USA
Steve Prettyman
About the authors
Steve Prettyman earned his bachelor of arts degree in education from Oglethorpe University in 1979. He quickly began his teaching career as a high school mathematics instructor while continuing his education by earning a master’s degree in business information systems from Georgia State University (1985). Since then, Steve has spent over 30 years in the IT industry. The last, almost 20 years, he has been an instructor and professor at Chattahoochee Technical College, Kennesaw State University, and Southern Polytechnic State University. He is currently the Computer Science Department Chair for Florida Keys Community College, Key West, Florida. His primary teaching responsibilities include programming, web design, and web application development.
Bibliographic Information
Book Title: Practical PHP 7, MySQL 8, and MariaDB Website Databases
Book Subtitle: A Simplified Approach to Developing Database-Driven Websites
Authors: Adrian W. West, Steve Prettyman
DOI: https://doi.org/10.1007/978-1-4842-3843-1
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Professional and Applied Computing (R0), Apress Access Books
Copyright Information: Adrian W. West and Steve Prettyman 2018
Softcover ISBN: 978-1-4842-3842-4Published: 29 September 2018
eBook ISBN: 978-1-4842-3843-1Published: 28 September 2018
Edition Number: 2
Number of Pages: XX, 546
Number of Illustrations: 177 b/w illustrations
Topics: Web Development, Data Structures and Information Theory, Programming Languages, Compilers, Interpreters