快速构建PHP7、MySQL8与MariaDB驱动网站：实战教程

需积分: 9 103 浏览量更新于2024-07-17 收藏 15.23MB PDF 举报

《Practical PHP7, MySQL8, and MariaDB Website Databases, 2nd Edition》是一本实用指南，专为开发数据库驱动网站的开发者设计。作者Adrian W. West和Steve Prettyman采用简洁的方法，帮助读者快速掌握PHP 7、MySQL 8（包括其开源版本MariaDB）的综合应用，以便在实际项目中建立交互式网站。本书首先关注于搭建开发和测试环境，确保读者有良好的基础。通过前两章，读者将学会如何构建首个PHP和数据库驱动的网站，无论是使用MariaDB还是MySQL。每个项目都伴随着详尽的插图，以便直观理解网站构建过程。书中深入介绍了PHP与数据库的集成，让读者了解如何利用PHP操作MariaDB和MySQL来创建强大且功能丰富的网站。从用户注册表单的开发，到管理员管理用户数据库，再到创建用户论坛和电子邮件系统，本书涵盖了各种关键功能的实现，强调了网站安全的最佳实践。接下来的章节，读者会学习如何构建产品目录和简单的电子商务站点，展示数据库在不同场景下的应用。迁移数据库至远程服务器的能力也不容忽视，作者详细讲解了如何进行迁移，并展示了SQL Workbench等工具的使用方法。最后，书中的结语将探讨Oracle的MySQL 8的优势，指导读者进行迁移，并提供一步步的迁移指导和相关工具演示。通过亲自动手实践，读者不仅能掌握技术细节，还能轻松地将数据库互动性应用到自己的网站开发中。《Practical PHP7, MySQL8, and MariaDB Website Databases, 2nd Edition》是一本全面而实用的教材，适合初级到中级的Web开发者，无论你是希望学习新技术，还是寻求提升现有技能，都能从中受益匪浅。

xvii

Introduction

What’s New in This Edition?

The code and instructions in the first edition of this book (written in 2012) were made obsolete by new and

very different versions of XAMPP, EasyPHP, phpMyAdmin, PHP, and MySQL/MariaDB. This second edition

contains new code and instructions to match the latest versions of the software.

With the massive increase in cybercrime and other cyber threats, this new edition has been fortified

with a much stronger emphasis on security. This book takes the approach of sanitizing any data that has

been accepted from any outside source and, additionally, sanitizing any data before it is displayed on a web

page. Most of the examples use prepared statements that ensure that any externally accepted data cannot be

executed and therefore cannot cause security vulnerabilities.

We have chosen Bootstrap to provide responsive web design (RWD) for each of the book’s example

websites. While Bootstrap provides the CSS and JavaScript to format the examples in this book for any size

device, you can easily reformat these examples with your own CSS code if you desire.

This new edition also takes a brief look at Oracle’s MySQL 8. A comparison is provided of the tools

available in each version. Step-by-step procedures provide you with the ability to upgrade to MySQL 8.

The Teaching Method

This book uses a different way of teaching website database design compared with the majority of manuals.

The usual layout starts with several lessons on PHP followed by snippets of code and may eventually

conclude with a project or two. This book abandons that approach. The primary focus is on fully worked,

practical MySQL/MariaDB database projects built into real-world web pages.

Instead of presenting PHP, SQL, and MySQL/MariaDB as completely separate topics, they are explained

in the context of each project. However, you will find a useful quick reference of PHP syntax in Appendix B.

In this book, practical databases and interactive web pages are presented as early as possible; in fact,

you will create a database and a table in the first chapter. In the second chapter, you will embed a database

into an interactive web page and test it. Each subsequent chapter will introduce you to increasingly

sophisticated and useful database-driven website pages.

We assume that you have little or no knowledge of PHP and databases. This book will demonstrate:

• How to create a free environment for testing database-driven web pages.

• How to embed PHP and interactive databases into real-world web pages. This is the

primary theme throughout the book.

• How PHP, HTML, and MySQL/MariaDB work together for creating and maintaining

a database and its data.

• How to create a user-friendly interface so that an administrator with minimum

computer skills can monitor the database.

■ INTRODUCTION

xviii

Because databases need to be viewed and tested on a server, the first part of Chapter 1 has instructions

for using a free server that can be downloaded and installed on your computer. This ensures you will have a

safe development platform for learning and testing as you explore the book’s practical projects.

Starting with a separate study of PHP theory and syntax can deter learners and prolong the time until

they get their hands on a practical application. Learners are enthused when they achieve something. This

book jumps into the database driving seat right from the beginning. Essential PHP and MySQL/MariaDB

techniques are presented in context within each tutorial where they are most relevant.

Who Is This Book For?

The book assumes you are thoroughly familiar with HTML5 and CSS3. However, we assume you have no

knowledge of MySQL/MariaDB, PHP, and phpMyAdmin. As the chapters unfold, you will progress from

intermediate level to advanced level.

You do not need to acquire an extensive knowledge of PHP to create interactive databases. We

introduce all the PHP you will need in the appropriate place within each project. Each piece of PHP code

is explained fully in plain English. The step-by-step, fully worked examples will show you what MySQL/

MariaDB and PHP can do and how to do it. This book is for web designers who want to begin developing

database-driven websites.

With this in mind, this book uses a highly motivational step-by-step approach. We recognize fully that

a sense of achievement encourages readers to look forward eagerly to the next step. The book will teach

enough PHP and MySQL/MariaDB to complete all the projects in the book. Web developers who have not

kept up-to-date with MySQL/MariaDB and PHP will also benefit from this approach. College and university

programming instructors will find that this book provides an excellent text, and the projects can form a basis

for students to adapt for their course work.

The “Quick and Easy to Learn” Myth

Books frequently state that PHP and MySQL/MariaDB databases are easily and quickly learned, but

this discourages beginners, because when they are confronted with the inevitable difficulties (and error

messages), they begin to think that they will never grasp even the basic principles.

Beginners should not be discouraged if they remember the following fact: authors claiming that PHP

and MySQL/MariaDB are easily and quickly learned have probably been using PHP and MySQL for more

than a decade, and they have forgotten the difficulties they encountered when they first began.

If you accept that some time and effort are required to learn PHP and MySQL/MariaDB, then as

you work through the book, it will become increasingly apparent that you are learning something very

worthwhile. So, have patience and persevere, and you will then begin to enjoy mastering this valuable

discipline.

The Origin of This Book

Most of the PHP/MySQL/MariaDB books tend to demonstrate the author’s deep and extensive knowledge of

PHP and MySQL/MariaDB instead of teaching how to embed MySQL/MariaDB databases into web pages. In

contrast, this book uses fully worked examples to demonstrate how to integrate databases into a website.

The boatload of PHP/MySQL/MariaDB database books that this book’s authors own (or borrowed)

were unnecessarily complicated. The authors of these books had become used to using neat tricks and

shortcuts that were second nature, but these cluttered the code and made it difficult for beginners to discern

the essential structure.

■ INTRODUCTION

xix

This book avoids this mistake; a few useful tricks are introduced gradually and are fully explained in

plain English. This book is based on a quote from the composer Brahms.

It is easy to compose but wonderfully hard to let the superfluous notes fall under the table.

Almost all the PHP/MySQL/MariaDB books were written backward; they grind away for chapter after

chapter with PHP functions and statements (yawn), and then they add the MySQL/MariaDB bit. Practical

PHP and MySQL Website Databases explains the necessary PHP and MySQL/MariaDB topics in context

within each database tutorial.

MySQL/MariaDB books are nearly always written assuming that the web designer will administer the

databases. However, small e-commerce websites, clubs, and societies cannot afford to do this and would

prefer that their membership secretary be able to administer the database using a user-friendly interface.

The majority of the databases created in this book can be administered by both an unskilled membership

secretary and the web designer.

Eventually, Adrian W. Wood concluded that he must write his own manual based on what he could

learn by concatenating snippets of information from multiple resources. He also based the manual on his

own trial-and-error approach as a raw beginner. This automatically ensured that the manual’s content was

presented in simple, logical, and progressive steps without suddenly introducing unexplained items.

The homegrown manual was so useful that he decided that it should be shared with other website

designers; the first edition of this book was the result of that decision.

Computer software and database techniques are constantly improving and updating. Because of this,

we have researched the latest versions of the scripts, tools, and the available software. This ensures that, in

this second edition, the content and illustrations will remain relevant for as long as possible.

Following the tutorials in this book requires an absolute minimum of software. Some manuals ask

readers to download and learn a new piece of software before they can proceed to each new chapter. In

fact, Adrian came across one book that required readers to download MySQL, Apache, PHP, phpMyAdmin,

Prototype 1.5, Scriptaculous, Zend Framework, Smarty Template Engine, FCK editor, jQuery, and Ajax. In

this book, besides a code editor, the software required is limited, as described next.

What Equipment Is Required

The book assumes that, as a web designer, you will already have an HTML editor such as Blue Griffon (free)

or Notepad++ (free).

You will need:

• A notebook (real or electronic) for recording the passwords and file names for your

databases and table entries. Don’t rely on memory. Write everything down.

You will need to download:

• The sample code from the book’s page, available at www.apress.com

• XAMPP or EasyPHP, which are free, all-in-one packages for testing your work

• The latest browsers (all free): Microsoft Edge, Mozilla Firefox, Safari, Chrome,

and Opera

剩余560页未读，继续阅读

m0_38106806

粉丝: 0
资源: 3

快速构建PHP7、MySQL8与MariaDB驱动网站：实战教程

Practical PHP 7, MySQL 8, and MariaDB Website Databases, Second Edition

Practical PHP 7, MySQL 8, and MariaDB Website Databases, 2nd Edition--2018

Practical PHP 7, MySQL 8, and MariaDB Website Databases

practical-php7-mysql8-mariadb-website-databases:Adrian West和Steve Prettyman的“实用PHP 7，MySQL 8和MariaDB网站数据库”的源代码-Website source code php

SQL入门之样例表脚本（MySQL (and MariaDB) SQL scripts）.zip

Learning MySQL and MariaDB 无水印pdf

Centos7 下mysql重新启动MariaDB篇

项目从MYSQL迁移至MARIADB教程

Learning-MySQL-and-MariaDB.rar_SQL_

快速构建安全的PHP 7、MySQL 8与MariaDB数据库驱动网站（第2版）

最新资源