Php, Mysql, & JavaScript All-In-One for Dummies

Explore the engine that drives the internet

It takes a powerful suite of technologies to drive the most-visited websites in the world. PHP, mySQL, JavaScript, and other web-building languages serve as the foundation for application development and programming projects at all levels of the web.

Dig into this all-in-one book to get a grasp on these in-demand skills, and figure out how to apply them to become a professional web builder. You'll get valuable information from seven handy books covering the pieces of web programming, HTML5 & CSS3, JavaScript, PHP, MySQL, creating object-oriented programs, and using PHP frameworks.
* Helps you grasp the technologies that power web applications
* Covers PHP version 7. 2
* Includes coverage of the latest updates in web development
* Perfect for developers to use to solve problems
This book is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who've made it through an online course or boot camp will also find great value in how this book builds on what you already know.

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