MySQL / PHP Database Applications: Brad Bulger/ Jay Greenspan/ David Wall
Practical PHP and MySQL Website Databases:A Simplified Approach Adrian W. West
Web Database Applications with PHP and MySQL: Hugh E. Williams
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 PHP 7 MySQL 8 and MariaDB Website Databases:A Simplified Approach to Developing Database-Driven Websites Adrian W. West/ Steve Prettyman
Practical PHP 7 MySQL 8 and MariaDB Website Databases:A Simplified Approach to Developing Database-Driven Websites. 2nd ed Adrian W. West/ Steve Prettyman
PHP is experiencing a renaissance, though it may be difficult to tell with all of the outdated PHP tutorials online. With this practical guide, you?ll learn how PHP has become a full-featured, mature language with object-orientation, namespaces, and a growing collection of reusable component libraries. Author Josh Lockhart?creator of PHP The Right Way, a popular initiative to encourage PHP best practices?reveals these new language features in action. You?ll learn best practices for application architecture and planning, databases, security, testing, debugging, and deployment. If you have a basic understanding of PHP and want to bolster your skills, this is your book. * Learn modern PHP features, such as namespaces, traits, generators, and closures * Discover how to find, use, and create PHP components * Follow best practices for application security, working with databases, errors and exceptions, and more * Learn tools and techniques for deploying, tuning, testing, and profiling your PHP applications * Explore Facebook?s HVVM and Hack language implementations?and how they affect modern PHP * Build a local development environment that closely matches your production server
Want to understand a certain PHP programming technique? Or learn how to accomplish a particular task? This cookbook is the first place to look. With more than 350 code-rich recipes revised for PHP 5.4 and 5.5, this third edition provides updated solutions for generating dynamic web content?everything from using basic data types to querying databases, and from calling RESTful APIs to testing and securing your site. Each recipe includes code solutions that you can freely use, along with a discussion of how and why they work. Whether you?re an experienced PHP programmer or coming to PHP from another language, this book is an ideal on-the-job resource. You?ll find recipes to help you with: * Basic data types: strings, numbers, arrays, and dates and times * Program building blocks: variables, functions, classes, and objects * Web programming: cookies, forms, sessions, and authentication * Database access using PDO, SQLite, and other extensions * RESTful API clients and servers, including HTTP, XML, and OAuth * Key concepts: email, regular expressions, and graphics creation * Designing robust applications: security and encryption, error handling, debugging and testing, and performance tuning * Files, directories, and PHP?s Command Line Interface * Libraries and package managers such as Composer and PECL