Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5, 4th Edition

Book Description

The fully revised, updated and extended 4th edition of the hugely popular web development book – includes CSS, HTML5, jQuery and the mysqli extension.

Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you only have basic HTML knowledge. With this popular hands-on guide, you’ll tackle dynamic web programming with the help of today’s core technologies: PHP, MySQL, JavaScript, jQuery, CSS, and HTML5.
Explore each technology separately, learn how to use them together, and pick up valuable web programming practices along the way. At the end of the book, you’ll put everything together to build a fully functional social networking site, using XAMPP or any development stack of your choice.

• Learn PHP in-depth, along with the basics of object-oriented programming
• Explore MySQL, from database structure to complex queries
• Use the mysqli Extension, PHP’s improved MySQL interface
• Create dynamic PHP web pages that tailor themselves to the user
• Manage cookies and sessions, and maintain a high level of security
• Master the JavaScript language–and enhance it with jQuery
• Use Ajax calls for background browser/server communication
• Acquire CSS2 & CSS3 skills for professionally styling your web pages
• Implement all the new HTML5 features, including geolocation, audio, video, and the canvas

Table of Contents

Chapter 1. Introduction to Dynamic Web Content
Chapter 2. Setting Up a Development Server
Chapter 3. Introduction to PHP
Chapter 4. Expressions and Control Flow in PHP
Chapter 5. PHP Functions and Objects
Chapter 6. PHP Arrays
Chapter 7. Practical PHP
Chapter 8. Introduction to MySQL
Chapter 9. Mastering MySQL
Chapter 10. Accessing MySQL Using PHP
Chapter 11. Form Handling
Chapter 12. Cookies, Sessions, and Authentication
Chapter 13. Exploring JavaScript
Chapter 14. Expressions and Control Flow in JavaScript
Chapter 15. JavaScript Functions, Objects, and Arrays
Chapter 16. JavaScript and PHP Validation and Error Handling
Chapter 17. Using Ajax
Chapter 18. Introduction to CSS
Chapter 19. Advanced CSS with CSS3
Chapter 20. Accessing CSS from JavaScript
Chapter 21. Introduction to jQuery
Chapter 22. Introduction to HTML5
Chapter 23. The HTML5 Canvas
Chapter 24. HTML5 Audio and Video
Chapter 25. Other HTML5 Features
Chapter 26. Bringing It All Together

Appendix A. Solutions to the Chapter Questions
Appendix B. Online Resources
Appendix C. MySQL’s FULLTEXT Stopwords
Appendix D. MySQL Functions
Appendix E. jQuery Selectors, Objects, and Methods

中文：

书名：Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5, 4th Edition

这本广受欢迎的网络开发书籍的第四版经过全面修订、更新和扩展，包括了css、HTML5、jQuery和mysqli扩展。

用开源技术和网络标准的有效结合来构建交互式的、数据驱动的网站，即使你只有基本的HTML知识。有了这本广受欢迎的动手指南，你将借助当今的核心技术：PHP、MySQL、JavaScript、jQuery、CSS和HTML5来处理动态Web编程。
单独探索每种技术，学习如何一起使用它们，并在此过程中获得有价值的Web编程实践。在这本书的最后，您将使用XAMPP或您选择的任何开发堆栈，将所有东西整合在一起，构建一个功能齐全的社交网站。

• 深入学习PHP以及面向对象编程的基础知识
• Explore MySQL, from database structure to complex queries
• 使用mysqli扩展，这是PHP改进的MySQL界面
• 创建为用户量身定做的动态PHP网页
• 管理Cookie和会话，并保持高级别的安全性
• 掌握JAVASCRIPT语言，并用jQuery增强它
• Use Ajax calls for background browser/server communication
• 掌握CSS2和CSS3技能，以专业的方式设置网页样式
• 实施所有HTML5新功能，包括地理位置、音频、视频和画布

Table of Contents

Chapter 1. Introduction to Dynamic Web Content
Chapter 2. Setting Up a Development Server
Chapter 3. Introduction to PHP
Chapter 4. Expressions and Control Flow in PHP
第5章.PHP函数和对象
Chapter 6. PHP Arrays
Chapter 7. Practical PHP
Chapter 8. Introduction to MySQL
Chapter 9. Mastering MySQL
第10章：使用PHP访问MySQL
Chapter 11. Form Handling
Chapter 12. Cookies, Sessions, and Authentication
Chapter 13. Exploring JavaScript
Chapter 14. Expressions and Control Flow in JavaScript
Chapter 15. JavaScript Functions, Objects, and Arrays
Chapter 16. JavaScript and PHP Validation and Error Handling
Chapter 17. Using Ajax
Chapter 18. Introduction to CSS
Chapter 19. Advanced CSS with CSS3
Chapter 20. Accessing CSS from JavaScript
第二十一章。JQuery简介
Chapter 22. Introduction to HTML5
Chapter 23. The HTML5 Canvas
Chapter 24. HTML5 Audio and Video
Chapter 25. Other HTML5 Features
第二十六章。把所有这些都放在一起

Appendix A. Solutions to the Chapter Questions
Appendix B. Online Resources
附录C.MySQL的全文停止字
Appendix D. MySQL Functions
Appendix E. jQuery Selectors, Objects, and Methods