Php, Mysql, & JavaScript All-In-One for Dummies (Paperback)

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