PHP, MySQL, & JavaScript All-in-One For Dummies

Richard Blum has more than 30 years of experience as a systems administrator and programmer. He teaches online courses in PHP, JavaScript, HTML5, and CSS3 programming, and authored the latest edition of Linux For Dummies.

• Introduction 1About This Book 1Foolish Assumptions 2Icons Used in This Book 3Beyond the Book 3Where to Go from Here 3Book 1: Getting Started With Web Programming 5Chapter 1: Examining the Pieces of Web Programming 7Creating a Simple Web Page 7Creating a Dynamic Web Page 17Storing Content 25Chapter 2: Using a Web Server 27Recognizing What’s Required 27Considering Your Server Options 31Tweaking the Servers 41Chapter 3: Building a Development Environment 51Knowing Which Tools to Avoid 51Working with the Right Tools 53Book 2: Html5 and Css3 71Chapter 1: The Basics of HTML5 73Diving into Document Structure 73Looking at the Basic HTML5 Elements 81Marking Your Text 85Working with Characters 90Making a List (And Checking It Twice) 92Building Tables 96Chapter 2: The Basics of CSS3 103Understanding Styles 103Styling Text 112Working with the Box Model 119Styling Tables 121Positioning Elements 125Chapter 3: HTML5 Forms 135Understanding HTML5 Forms 135Using Input Fields 138Adding a Text Area 146Using Drop-Down Lists 147Enhancing HTML5 Forms 149Using HTML5 Data Validation 154Chapter 4: Advanced CSS3 157Rounding Your Corners 157Using Border Images 159Looking at the CSS3 Colors 162Playing with Color Gradients 164Adding Shadows 166Creating Fonts 168Handling Media Queries 171Chapter 5: HTML5 and Multimedia 177Working with Images 177Playing Audio 185Watching Videos 190Getting Help from Streamers 194Book 3: Javascript 195Chapter 1: Introducing JavaScript 197Knowing Why You Should Use JavaScript 197Seeing Where to Put Your JavaScript Code 199The Basics of JavaScript 203Controlling Program Flow 209Working with Functions 220Chapter 2: Advanced JavaScript Coding 223Understanding the Document Object Model 223Finding Your Elements 233Working with Document Object Model Form Data 238Chapter 3: Using jQuery 243Loading the jQuery Library 244Using jQuery Functions 246Finding Elements 247Replacing Data 250Changing Styles 254Changing the Document Object Model 259Playing with Animation 261Chapter 4: Reacting to Events with JavaScript and jQuery 263Understanding Events 263Focusing on JavaScript and Events 267Looking at jQuery and Events 276Chapter 5: Troubleshooting JavaScript Programs 283Identifying Errors 283Working with Browser Developer Tools 285Working Around Errors 295Book 4: PHP 301Chapter 1: Understanding PHP Basics 303Seeing the Benefits of PHP 303Understanding How to Use PHP 305Working with PHP Variables 310Using PHP Operators 317Including Files 320Chapter 2: PHP Flow Control 325Using Logic Control 325Looping 331Building Your Own Functions 336Working with Event-Driven PHP 339Chapter 3: PHP Libraries 349How PHP Uses Libraries 349Text Functions 354Math Functions 361Date and Time Functions 365Image-Handling Functions 369Chapter 4: Considering PHP Security 375Exploring PHP Vulnerabilities 375PHP Vulnerability Solutions 384Chapter 5: Object-Oriented PHP Programming 395Understanding the Basics of Object-Oriented Programming 395Using Magic Class Methods 401Loading Classes 409Extending Classes 414Chapter 6: Sessions and Carts 419Storing Persistent Data 419PHP and Cookies 424PHP and Sessions 430Shopping Carts 436Book 5: MYSQL 443Chapter 1: Introducing MySQL 445Seeing the Purpose of a Database 445Presenting MySQL 454Advanced MySQL Features 458Chapter 2: Administering MySQL 465MySQL Administration Tools 465Managing User Accounts 477Chapter 3: Designing and Building a Database 489Managing Your Data 489Creating Databases 492Building Tables 500Chapter 4: Using the Database 513Working with Data 513Searching for Data 524Playing It Safe with Data 531Chapter 5: Communicating with the Database from PHP Scripts 541Database Support in PHP 541Using the mysqli Library 543Putting It All Together 554Book 6: Creating Object-Oriented Programs 561Chapter 1: Designing an Object-Oriented Application 563Determining Application Requirements 563Creating the Application Database 565Designing the Application Objects 571Designing the Application Layout 579Coding the Website Layout 582Chapter 2: Implementing an Object-Oriented Application 593Working with Events 593Bidder Object Events 595Item Object Events 605Logging Out of a Web Application 614Testing Web Applications 616Chapter 3: Using AJAX 619Getting to Know AJAX 619Communicating Using JavaScript 621Using the jQuery AJAX Library 629Transferring Data in AJAX 635Modifying the AuctionHelper Application 643Chapter 4: Extending WordPress 651Getting Acquainted with WordPress 651Installing WordPress 655Examining the Dashboard 662Using WordPress 664Exploring the World of Plugins 669Creating Your Own Widget 674Book 7: Using PHP Frameworks 681Chapter 1: The MVC Method 683Getting Acquainted with MVC 683Comparing MVC to Other Web Models 691Seeing How MVC Fits into N-Tier Theory 693Implementing MVC 694Chapter 2: Selecting a Framework 695Getting to Know PHP Frameworks 695Knowing Why You Should Use a Framework 702Focusing on Popular PHP Frameworks 704Looking At Micro Frameworks 710Chapter 3: Creating an Application Using Frameworks 715Building the Template 715Creating an Application Scaffold 721Modifying the Application Scaffold 725Index 735