PHP and MySQL Web Development (5th Edition)

Name: PHP and MySQL Web Development (5th Edition)
ISBN: 9787111587736

Luke Welling / Laura ThomsonChina Machine Press2018

3.5

Word count: 450 words
Chapters: 34
Series: Web Development Technology Series
ISBN: 9787111587736

Report an error Find this book

Summary

This book is a classic guide to building database-driven web applications with PHP and MySQL. A long-standing bestseller since its first edition, the 5th edition has been fully updated for PHP 5.6/7 and newer MySQL versions. The Chinese edition was translated by Xiong Huizhen, Wu Xin, and Luo Yunfeng, and comprises five parts and 31 chapters. Part I (Chapters 1–7) introduces PHP fundamentals, including a quick start, storing and retrieving data, arrays, string manipulation and regular expressions, code reuse and function writing, object-oriented features, and error and exception handling. Part II (Chapters 8–13) turns to MySQL, covering designing and creating web databases, accessing MySQL from the web with PHP, and advanced MySQL administration and programming (stored procedures, triggers, privilege management, etc.). Part III (Chapters 14–16) focuses on web application security: sources of risk, building secure applications, and implementing authentication with PHP. Part IV (Chapters 17–24) covers advanced PHP techniques: interacting with the file system and server, network and protocol functions, date and time management, internationalization and localization, image generation, session control, and integrating JavaScript with PHP. Part V (Chapters 25–31) closes with practical projects: organizing large projects, debugging and logging, user authentication and personalization, a web mail client, social media integration, and a shopping cart, with an appendix on installing and configuring Apache, PHP, and MySQL. The book's hallmark is learning by doing, woven around a car parts store example, with an emphasis on code reuse and security practices; it suits readers who want a systematic grasp of traditional server-rendered web development, read cover to cover.

Editor's review

在讲 PHP 与 MySQL 的书里，这一本属于“先讲透原理，再带你做完一个项目”的类型。它的写法不是零散地罗列函数手册，而是从第 1 章就带着读者做出一个能提交表单、能算总价的小应用，随后逐步把数组、字符串处理、函数、面向对象、异常处理补齐，再过渡到数据库设计与 SQL，最后把前后端接起来。第 5 版的更新是实打实的：跟随 PHP 7 调整了示例代码，补充了安全章节的内容，也加入 JavaScript 与 PHP 集成、社交媒体集成、Web 邮件客户端等更贴近实际工作的项目。它对安全的重视在同类书中比较突出，SQL 注入、XSS、会话劫持、最低权限原则这些内容不是附录里的顺带一提，而是独立成篇。需要提醒的是，中文版成书于 2018 年，示例以传统服务端渲染为主，没有覆盖近年的框架化与容器化实践。把它当作打地基、理解“请求—脚本—数据库—响应”这条主线的教材，而不是查询最新语法的手册，会得到最划算的阅读体验。

Who it's for

A good fit for

有一点编程基础、想系统学习 PHP 与 MySQL 配合开发的在校学生
需要维护或改造传统 PHP 站点、想补齐数据库与安全知识的在职开发者
希望用一个完整项目把语法、SQL、会话与安全串起来自学的转行者
讲授 Web 开发课程、需要一本结构清晰、案例完整的教材的高校教师

Not a good fit for

已有多年 PHP 经验、只想查阅最新语法与框架用法的高级开发者
希望直接学习 Laravel、Symfony 等现代框架而不打算补语言基础的读者
完全零编程经验、需要从计算机基础概念起步的入门者

Reading tips

按篇顺序通读，边读边把书中示例代码敲一遍，不要只翻不写。
读到第二篇时同步搭好本地 MySQL 环境，亲手建库、建表、跑通查询。
把第三篇的安全内容作为重点，回头检查自己写过的表单与查询是否存在注入风险。
读完第四、五篇后，用书中项目结构改写一个自己感兴趣的小网站，作为结课练习。

About the publisher

China Machine Press China · Founded in 1950

In addition to science and technology and professional publishing, the books in our catalog from China Machine Press also reflect a sustained focus on psychology, computing, management, finance and economics, and social sciences. In psychology, the catalog includes works by C. G. Jung and introductions to analytical psychology, as well as applied topics such as stress and health, and addiction and healing. In computing, it features Structure and Interpretation of Computer Programs (JavaScript Edition). Management and finance titles include Administrative Behavior (4th Edition), The Price of Inequality (Collector's Edition), and This Time Is Different: Eight Centuries of Financial Folly (Commemorative Edition). In the philosophy and history of science, there is The Worldview: The Third Edition. Relevant authors include C. G. Jung, William McGuire, Sonu Shamdasani, and Gabor Maté. Public information is limited; the above summarizes the publisher's profile based solely on the books in our catalog.

Part I Using PHP
Chapter 1 PHP Quick Start Tutorial
Chapter 2 Storing and Retrieving Data
Chapter 3 Using Arrays
Chapter 4 String Manipulation and Regular Expressions
Chapter 5 Code Reuse and Function Writing
Chapter 6 Object-Oriented PHP
Chapter 7 Error and Exception Handling
Part II Using MySQL
Chapter 8 Designing Web Databases
Chapter 9 Creating Web Databases
Chapter 10 Using MySQL Databases
Chapter 11 Accessing MySQL from the Web with PHP
Chapter 12 Advanced MySQL Administration
Chapter 13 Advanced MySQL Programming
Part III Web Application Security
Chapter 14 Web Application Security Risks
Chapter 15 Building Secure Web Applications
Chapter 16 Implementing Authentication Methods with PHP
Part IV Advanced PHP Programming Techniques
Chapter 17 Interacting with the File System and Server
Chapter 18 Using Network and Protocol Functions
Chapter 19 Managing Dates and Times
Chapter 20 Internationalization and Localization
Chapter 21 Generating Images
Chapter 22 Using Session Control in PHP
Chapter 23 Integrating JavaScript with PHP
Chapter 24 Other Useful Features
Part V Building Practical PHP and MySQL Projects
Chapter 25 Developing Large Projects with PHP and MySQL
Chapter 26 Debugging and Logging
Chapter 27 Building User Authentication and Personalization
Chapters 28–31 Web Mail Client, Social Media Integration, and Shopping Cart Projects
Appendix A Installing Apache, PHP, and MySQL

FAQ

这本书适合完全没有编程基础的人吗？

不太适合。书中默认读者了解 HTML 和基本的编程概念（变量、循环等），开篇就直接进入 PHP 语法与表单处理。完全零基础建议先补一门入门编程课或读一本 HTML/CSS 基础书，再回来阅读。

第 5 版和旧的第 4 版有什么区别？

第 5 版对应 PHP 5.6/7 与较新的 MySQL 版本重写示例，强化了 Web 安全章节，新增 JavaScript 与 PHP 集成、社交媒体集成、Web 邮件客户端等项目内容。第 4 版对应 PHP 5.3，若手头已有第 4 版，学习主线差别不大，但代码示例偏旧。

书中内容还适合现在的开发环境吗？

核心概念——请求处理、SQL、会话、认证、安全防护——并不过时。但中文版成书于 2018 年，示例没有覆盖现代框架、Composer 生态与容器化部署，部分函数写法在高版本 PHP 中需要注意调整。建议把它当基础教材，实践时对照官方文档。

需要提前准备哪些软件环境？

需要 Apache（或 Nginx）、PHP 和一个 MySQL 数据库，书中附录 A 专门讲解三者的安装与配置。也可以直接使用 XAMPP、phpStudy 等集成环境更快上手，把精力放在代码理解上。

读完这本书能到什么水平？

能独立完成一个具备用户注册登录、数据增删改查、会话管理与基本安全防护的中小型动态网站，并读懂传统 PHP 项目的代码结构。若想进入企业级开发，还需继续学习框架、版本控制与数据库优化等内容。

Comments

Find this book

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.