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

Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you’ll tackle dynamic web programming with the latest versions of today’s core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries.

Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way—including how to optimize websites for mobile devices. At the end of the book, you’ll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.

• 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
• Enhance the JavaScript language with jQuery and jQuery mobile libraries
• Use Ajax calls for background browser-server communication
• Style your web pages by acquiring CSS2 and CSS3 skills
• Implement HTML5 features, including geolocation, audio, video, and the canvas element
• Reformat your websites into mobile web apps

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 Asynchronous Communication
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 Jquery Mobile
Chapter 23. Introduction To Html5
Chapter 24. The Html5 Canvas
Chapter 25. Html5 Audio And Video
Chapter 26. Other Html5 Features
Chapter 27. 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