PHP, MySQL, JavaScript and HTML5 All-In-One for Dummies

Get the basics on four key web programming tools in one great book!PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. JavaScript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained minibooks cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, JavaScript, PHP with templates, and web applications. Addresses how PHP, MySQL, JavaScript, and HTML5 are vital tools for creating dynamic, database-driven websites and are especially important for e-commerce sitesServes as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooksCovers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interfaceShows how to create a secure website and how to code popular e-business applications such as login programs and shopping cartsWith seven books in one, PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies will turn your website into the center of attention in no time at all.From the Back Cover7 books in 1Web TechnologiesHTML and CSSJavaScriptPHPMySQLWeb ApplicationsPHP and TemplatesIn charge of a website? Here's what you need to know about key web technologies!Websites have become much flashier, but the building blocks to create them remain much the same. This information-packed book covers four essential web technologies: HTML and CSS, JavaScript, PHP, and MySQL. Learn how they work together to create web services, validate web forms, and set up a members-only site, plus discover how to create a templating system with PHP. You'll build on the basics and take your website to new levels with this friendly For Dummies guide.Lay the groundwork — find out how the web works and how to get and install PHP, MySQL, and a web serverStyle it — create a page with HTML, add style with CSS, build a JavaScript program, and see what jQuery can do for youRockin' with PHP — learn about PHP syntax and error messages, build a script, and use PHP to create dynamic web pagesMagical MySQL — administer MySQL and set up MySQL accounts, design and build databases, keep them updated, and connect MySQL to PHPService, please — create a web service, create and validate web forms, and set up login objectsOpen the book and find:Installation instructions for Windows, Mac, and LinuxHTML building blocksHow CSS makes creating forms easierThe difference between JavaScript and JavaTips on coding more efficiently with jQueryAn introduction to object- oriented programmingDetails of database structureHow PHP templates can help reduce codeAbout the AuthorSteven Suehring is a technology architect and the author or editor of several popular technology books. Janet Valade is a technical writer, web designer, programmer, and systems analyst. She has conducted various tech seminars and written several books, including PHP & MySQL For Dummies, 4th Edition. PHP, MySQL, JavaScript & HTML5 All-In-One For Dummies 1 About the Authors 7 Dedication 9 Authors’ Acknowledgments 9 Contents at a Glance 11 Table of Contents 13 Introduction 27 About This Book 27 Foolish Assumptions 27 How This Book Is Organized 28 Icons Used in This Book 29 Where to Go from Here 29 CoCnotnetnetns tas ta at aG lGalnacnece 32 Book I: Getting Started with PHP & MySQL 31 Chapter 1: Understanding the Languages of the Web 33 Understanding How the Web Works 33 Understanding Web Page Languages 36 Understanding the Language of Web Servers 38 Choosing How You Want to Develop 40 Setting Up Your Local Computer for Development 45 Chapter 2: Installing a Web Server 47 Testing Your Web Server 47 Obtaining Apache 48 Installing Apache 51 Starting and Stopping Apache 54 Getting Information from Apache 57 Configuring Apache 58 Chapter 3: Installing PHP 61 Checking the PHP Installation 62 Obtaining PHP 62 Installing PHP 66 Configuring Your Web Server for PHP 73 Configuring PHP 76 Testing PHP 77 Troubleshooting 79 Chapter 4: Setting Up MySQL 81 Checking the MySQL Installation 81 Obtaining MySQL 83 Installing MySQL 85 Configuring MySQL 91 Starting and Stopping the MySQL Server 92 Testing MySQL 94 Troubleshooting MySQL 95 The MySQL Administration Program 96 Activating MySQL Support 97 Troubleshooting PHP and MySQL 99 Chapter 5: Setting Up Your Web Development Environment with the XAMPP Package 101 Obtaining XAMPP 101 Installing XAMPP 102 Using the XAMPP Control Panel 104 Testing Your Development Environment 105 Configuring Your Development Environment 108 Uninstalling and Reinstalling XAMPP 110 Troubleshooting 111 CoCnotnetnetns tas ta at aG lGalnacnece 114 Book II: HTML and CSS 113 Chapter 1: Creating a Basic Page with HTML 115 Understanding the HTML Building Blocks 115 Sections of an HTML Document 117 Creating Good HTML 120 Practicing Creating a Table 131 Including Links and Images on Your Web Page 134 Writing Valid HTML 142 Validating Your HTML 143 Chapter 2: Adding Style with CSS 147 Discovering What CSS Can and Can’t Do for Your Web Page 147 Connecting CSS to a Page 149 Targeting Styles 155 Changing Fonts 160 Adding Borders 166 Changing List Styles 170 Adding a Background 173 Creating Page Layouts 181 Adding Headers and Footers to a Page 189 Chapter 3: Creating and Styling Web Forms 195 Using Web Forms to Get Information 195 Creating a Form 198 Using CSS to Align Form Fields 206 CoCnotnetnetns tas ta at aG lGalnacnece 212 Book III: JavaScript 211 Chapter 1: Understanding JavaScript Basics 213 Viewing the World of JavaScript 213 Examining the Ways to Add JavaScript to a Page 214 Chapter 2: Building a JavaScript Program 217 Getting Started with JavaScript Programming 217 Testing Things with Conditionals 223 Performing Actions Multiple Times with Loops 226 Using Functions to Avoid Repeating Yourself 229 Objects in Brief 234 Working with HTML Documents 236 Working with Web Browsers 240 Chapter 3: Adding jQuery 245 jQuery Introduced 245 Installing jQuery 246 Adding jQuery to a Page 247 Incorporating the jQuery ready() Function 249 Selecting Elements with jQuery 251 Working with HTML Using jQuery 253 Changing Attributes and Styles 258 Chapter 4: Reacting to Events with JavaScript and jQuery 267 Understanding Events 267 Working with Forms 268 Monitoring Mouse Events 273 Reacting to Keyboard Events 280 Chapter 5: Troubleshooting JavaScript Programs 287 Employing Basic JavaScript Troubleshooting Techniques 287 Identifying JavaScript Problems with Firebug 290 CoCnotnetnetns tas ta at aG lGalnacnece 296 Book IV: PHP 295 Chapter 1: Understanding PHP Basics 297 How PHP Works 297 Examining the Structure of a PHP Script 299 Looking at PHP Syntax 301 Writing PHP Code 303 Displaying Content in a Web Page 304 Using PHP Variables 307 Using PHP Constants 313 Understanding Data Types 314 Using Arrays 322 Using Dates and Times 333 Understanding PHP Error Messages 336 Adding Comments to Your PHP Script 342 Chapter 2: Building PHP Scripts 345 Setting Up Conditions 346 Using Conditional Statements 355 Repeating Actions with Loops 361 Using Functions 372 Organizing Scripts 383 Chapter 3: PHP and Your Operating System 391 Managing Files 392 Using Operating System Commands 398 Using FTP 404 Reading and Writing Files 409 Exchanging Data with Other Programs 416 Using SQLite 420 Chapter 4: Object-Oriented Programming 423 Introducing Object-Oriented Programming 423 Developing an Object-Oriented Script 426 Defining a Class 428 Using a Class in a Script 439 Using Abstract Methods in Abstract Classes and Interfaces 441 Preventing Changes to a Class or Method 444 Handling Errors with Exceptions 445 Copying Objects 446 Comparing Objects 447 Getting Information about Objects and Classes 448 Destroying Objects 449 Chapter 5: Considering PHP Security 451 Securing the Server 451 Securing Apache 452 Setting Security Options in php. ini 454 Handling Errors Safely 455 Sanitizing Variables 458 Chapter 6: Tracking Visitors with Sessions 463 Understanding Sessions and Cookies 463 Using Sessions to Pass Data 466 Understanding Other Session Options 472 CoCnotnetnetns tas ta at aG lGalnacnece 474 Book V: MySQL 473 Chapter 1: Introducing MySQL 475 Examining How MySQL Works 475 Understanding Database Structure 476 Communicating with MySQL 476 Protecting Your MySQL Databases 480 Chapter 2: Administering MySQL 483 Understanding the Administrator Responsibilities 483 Default Access to Your Data 484 Controlling Access to Your Data 485 Setting Up MySQL Accounts 488 Backing Up Your Database 494 Restoring Your Data 497 Upgrading MySQL 499 Chapter 3: Designing and Building a Database 501 Designing a Database 501 Designing a Sample Database 510 Writing Down Your Design 513 Building a Database 515 Changing the Database Structure 520 Chapter 4: Using the Database 523 Adding Information to a Database 524 Looking at the Data in a Database 528 Retrieving Information from a Database 528 Updating Information in a Database 539 Removing Information from a Database 539 Chapter 5: Communicating with the Database from PHP Scripts 541 Knowing How MySQL and PHP Work Together 541 PHP Functions That Communicate with MySQL 542 Communicating with MySQL 542 Selecting a Database 547 Handling MySQL Errors 548 Using Other Helpful mysqli Functions 549 Converting mysqli Functions to mysql Functions 552 CoCnotnetnetns tas ta at aG lGalnacnece 556 Book VI: Web Applications 555 Chapter 1: Improving Your PHP Programs 557 Automatically Including Helper Functions 557 Reusing Code 561 Chapter 2: Creating and Using a Web Service 567 Understanding Web Services 567 Returning Data from a Web Service 568 Accepting Input to a Web Service 574 Chapter 3: Validating Web Forms with JavaScript and PHP 581 Understanding How to Validate Web Forms 581 Performing Basic JavaScript Validation 583 Performing PHP Validation 600 Chapter 4: Building a Members-Only Website 613 Understanding a Members-Only Site 614 Creating the User Database 615 Creating Base Functions 617 Creating Web Forms 619 Creating a User Object 633 Adding Authenticated Pages 638 Adding E-mail Functionality 644 CoCnotnetnetns tas ta at aG lGalnacnece 660 Book VII: PHP and Templates 659 Chapter 1: Configuring PHP 661 Understanding the php. ini 661 Understanding Common Configuration Changes 662 Chapter 2: Building a Templating System 667 Understanding Template Systems 667 Building a PHP Template 668 Extending the Template 676 Symbols 681 A 681 B 683 C 684 D 687 E 689 F 690 G 694 H 694 I 695 J 696 K 697 L 698 M 699 N 701 O 702 P 704 Q 708 R 708 S 709 T 712 U 714 V 714 W 715 X 717 Y 718 Z 718 Index 681 Get the basics on four key web programming tools in one great book!

PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. JavaScript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained minibooks cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, JavaScript, PHP with templates, and web applications.

• Addresses how PHP, MySQL, JavaScript, and HTML5 are vital tools for creating dynamic, database-driven websites and are especially important for e-commerce sites
• Serves as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooks
• Covers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interface
• Shows how to create a secure website and how to code popular e-business applications such as login programs and shopping carts

With seven books in one, PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies will turn your website into the center of attention in no time at all.

Get the basics on four key web programming tools in one great book! PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. JavaScript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained minibooks cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, JavaScript, PHP with templates, and web applications. Addresses how PHP, MySQL, JavaScript, and HTML5 are vital tools for creating dynamic, database-driven websites and are especially important for e-commerce sites Serves as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooks Covers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interface Shows how to create a secure website and how to code popular e-business applications such as login programs and shopping carts With seven books in one, PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies will turn your website into the center of attention in no time at all. PHP, javascript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. javascript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained mini books cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, javascript, PHP with templates, and web applications.