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

MySQL

MariaDB

需积分: 0 11 浏览量更新于2024-07-18 收藏 14.4MB PDF 举报

身份认证购VIP最低享 7 折!

30元优惠券

资源详情

资源推荐

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页未读，继续阅读

SorelCheung

粉丝: 61
资源: 120

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

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

centos7把已安装的mysql替换成mariadb

linux安装数据库MySQL或MariaDB

linux系统上用mysql好还是mariadb好

mariadb已经运如何换到mysql_怎样将 MySQL 迁移到 MariaDB 上

mariadb能替代mysql吗

mysql安装完后显示mariadb

mysql8.0.32版本对应mariadb哪个版本

arch完全卸载mysql和mariadb 并重新安装mariadb

mysql和mariadb哪个性能更高

ubuntu怎么从mariadb切换回mysql

RUN yum -y update && yum -y install epel-release && \ yum -y install httpd php php-mysql php-gd php-xml mariadb mariadb-server && \ yum clean all

centos7安装mariadb后安装mysql

rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps什么意思

rpm -qa | grep -i -E mysql \ |mariadb | xargs -n1 sudo rpm -e --nodeps

mariaDB怎么链接mysql数据库

没有安装了 MySQL 或者 MariaDB 数据库引擎。怎么安装

为什么有些mysql的版本是mariadb

MariaDB和MySQL有什么区别

can't connect to local mysql server through socket ‘/app/Mariadb/mysql.sock’

最新资源