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 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.

Practical HTML5 Projectsis a collection of valuable web techniques that any developer or designer can use. This book is all about saving time.Busy web developers should not have to plow through pages of theory or history only to discover that no practical applications are provided, nor should they have to read a paragraph five times to extract some meaning from it. All of the techniques within this book are explained using fully worked examples that you can immediately apply to your own projects. With each technique the book provides: A practical and useful example (and a screen shot of the end result where applicable). The markup for a fully worked example. A downloadable template to adapt for use in your own websites. With Practical HTML5 Projects, you can dive straight into the book at the required chapter and immediately find answers to your websiteproblems, and find the sample code you can use to get it right. Start creating websites using the practical examples, summaries, and templates. What you'll learn Discover new techniques for creating interesting, attractive and accessible websites Save time spent researching poorly documented techniques Avoid lengthy trial-and-error testing andhours spent reading single topic manuals Download templates and quickly adapt them for your own use Keep pace with the latest developments and recommendations in web design Accumulate a useful tool kit of resources and templates Who this book is for

Practical HTML5Projects acknowledges the fact that designers, teachers, and students would rather produce something than spend hours researching how to produce it. Web developers and designers can dive right into the book, take a template and adapt it. IT teachers can set student projects based on the techniques and templates revealed in the book. Table of Contents Moving to HTML5 A Rollover Picture Gallery Backgrounds RolloverMenus Moving to CSS3 Adding Audio, Video andSlide Shows Rounded Corners Drop Shadows Create Collages and Galleries Add PayPal Secure Feedback Methods Monitor Mayhem Appearance and Usefulness Accessibility Dump those Deprecated Items Search Engine Optimization Printing, Counting, and Redirecting Validation Troubleshooting Appendix

Learn the fundamentals of modern web design, rather than relying on CMS programs, such as WordPress or Joomla!. You will be introduced to the essentials of good design and how to optimize for search engines. You will discover how to register a domain name and migrate a website to a remote host. Because you will have built the web pages yourself, you will know exactly how HTML and CSS work. You have will complete control over your websites and their maintenance. Practical Website Design for Absolute Beginners centers around introducing small amounts of new code in short practical chapters and provides many website templates that can be easily adapted for your own websites. Each chapter builds on the templates created in the previous chapter. You are provided with a practical project to complete in most chapters, and taught to produce practical web pages right from the start. In the first chapter you will install and configure a free text editor, then you will produce the structure for your first web page. You will then gradually learn to create more sophisticated and increasingly practical web pages and websites. In this book you will be encouraged by means of a series of achievable goals, and you will be rewarded by the knowledge that you are learning something valuable and really worthwhile. You will not have to plow through daunting chapters of disembodied code theory because the code is described and explained in context within each project. Because each project is fully illustrated, you will see clearly what you are expected to achieve as you create each web page. What You'll Learn Provides instructions for installing a text editor for producing HTML and CSS Shows you step-by-step how to build and test web pages and websites Teaches you how to ensure that your websites are attractive and useful Describes how to make the most effective use of color and images Teaches you the essential features of search engine optimization Shows you how to migrate your website to a remote host Who This Book Is For Practical Website Design for Absolute Beginners is for people who want to begin designing their own websites. It uses a highly motivational, easily assimilated step-by-step approach where you will start learning practical skills from the very first chapter. The book is an excellent choice for people who have computer skills but would also like to learn HTML and CSS. For readers who have little or no knowledge of HTML and CSS, the book will teach enough to complete all the projects in the book.