Learning PHP, MySQL & JavaScript: With JQuery, CSS & HTML5

Front Cover
"O'Reilly Media, Inc.", Dec 2, 2014 - Computers - 812 pages

Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you have only 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 you choose.

  • 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 and CSS3 skills for professionally styling your web pages
  • Implement all of the new HTML5 features, including geolocation, audio, video, and the canvas
 

Contents

Chapter 1 Introduction to Dynamic Web Content
1
Chapter 2 Setting Up a Development Server
15
Chapter 3 Introduction to PHP
35
Chapter 4 Expressions and Control Flow in PHP
63
Chapter 5 PHP Functions and Objects
95
Chapter 6 PHP Arrays
123
Chapter 7 Practical PHP
139
Chapter 8 Introduction to MySQL
165
Chapter 18 Introduction to CSS
413
Chapter 19 Advanced CSS with CSS3
451
Chapter 20 Accessing CSS from JavaScript
479
Chapter 21 Introduction to jQuery
499
Chapter 22 Introduction to HTML5
557
Chapter 23 The HTML5 Canvas
565
Chapter 24 HTML5 Audio and Video
617
Chapter 25 Other HTML5 Features
631

Chapter 9 Mastering MySQL
209
Chapter 10 Accessing MySQL Using PHP
233
Chapter 11 Form Handling
265
Chapter 12 Cookies Sessions and Authentication
287
Chapter 13 Exploring JavaScript
309
Chapter 14 Expressions and Control Flow in JavaScript
331
Chapter 15 JavaScript Functions Objects and Arrays
351
Chapter 16 JavaScript and PHP Validation and Error Handling
371
Chapter 17 Using Ajax
395
Chapter 26 Bringing It All Together
653
Appendix A Solutions to the Chapter Questions
689
Appendix B Online Resources
711
Appendix C MySQLs FULLTEXT Stopwords
715
Appendix D MySQL Functions
719
Appendix E jQuery Selectors Objects and Methods
729
Index
753
About the Author
781
Copyright

Other editions - View all

Common terms and phrases

About the author (2014)

Robin Nixon has worked with and written about computers since the early 1980s (his first computer was a Tandy TRS 80 Model 1 with a massive 4KB of RAM!). One of the web sites he developed presented the world's first radio station licensed by the music copyright holders. In order to enable people to continue to surf while listening, Robin also developed the first known pop-up windows. He has also worked full time for one of Britain's main IT magazine publishers, where he held several roles including editorial, promotions, and cover disc editing.

Bibliographic information