PHP, MySQL, JavaScript & HTML5 All-In-One For Dummies -- About the Authors -- Dedication -- Authors' Acknowledgments -- Contents at a Glance -- Table of Contents -- Introduction -- About This Book -- Foolish Assumptions -- How This Book Is Organized -- Icons Used in This Book -- Where to Go from Here -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book I: Getting Started with PHP & MySQL -- Chapter 1: Understanding the Languages of the Web -- Understanding How the Web Works -- Understanding Web Page Languages -- Understanding the Language of Web Servers -- Choosing How You Want to Develop -- Setting Up Your Local Computer for Development -- Chapter 2: Installing a Web Server -- Testing Your Web Server -- Obtaining Apache -- Installing Apache -- Starting and Stopping Apache -- Getting Information from Apache -- Configuring Apache -- Chapter 3: Installing PHP -- Checking the PHP Installation -- Obtaining PHP -- Installing PHP -- Configuring Your Web Server for PHP -- Configuring PHP -- Testing PHP -- Troubleshooting -- Chapter 4: Setting Up MySQL -- Checking the MySQL Installation -- Obtaining MySQL -- Installing MySQL -- Configuring MySQL -- Starting and Stopping the MySQL Server -- Testing MySQL -- Troubleshooting MySQL -- The MySQL Administration Program -- Activating MySQL Support -- Troubleshooting PHP and MySQL -- Chapter 5: Setting Up Your Web Development Environment with the XAMPP Package -- Obtaining XAMPP -- Installing XAMPP -- Using the XAMPP Control Panel -- Testing Your Development Environment -- Configuring Your Development Environment -- Uninstalling and Reinstalling XAMPP -- Troubleshooting -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book II: HTML and CSS -- Chapter 1: Creating a Basic Page with HTML -- Understanding the HTML Building Blocks -- Sections of an HTML Document -- Creating Good HTML -- Practicing Creating a Table.

Including Links and Images on Your Web Page -- Writing Valid HTML -- Validating Your HTML -- Chapter 2: Adding Style with CSS -- Discovering What CSS Can and Can't Do for Your Web Page -- Connecting CSS to a Page -- Targeting Styles -- Changing Fonts -- Adding Borders -- Changing List Styles -- Adding a Background -- Creating Page Layouts -- Adding Headers and Footers to a Page -- Chapter 3: Creating and Styling Web Forms -- Using Web Forms to Get Information -- Creating a Form -- Using CSS to Align Form Fields -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book III: JavaScript -- Chapter 1: Understanding JavaScript Basics -- Viewing the World of JavaScript -- Examining the Ways to Add JavaScript to a Page -- Chapter 2: Building a JavaScript Program -- Getting Started with JavaScript Programming -- Testing Things with Conditionals -- Performing Actions Multiple Times with Loops -- Using Functions to Avoid Repeating Yourself -- Objects in Brief -- Working with HTML Documents -- Working with Web Browsers -- Chapter 3: Adding jQuery -- jQuery Introduced -- Installing jQuery -- Adding jQuery to a Page -- Incorporating the jQuery ready() Function -- Selecting Elements with jQuery -- Working with HTML Using jQuery -- Changing Attributes and Styles -- Chapter 4: Reacting to Events with JavaScript and jQuery -- Understanding Events -- Working with Forms -- Monitoring Mouse Events -- Reacting to Keyboard Events -- Chapter 5: Troubleshooting JavaScript Programs -- Employing Basic JavaScript Troubleshooting Techniques -- Identifying JavaScript Problems with Firebug -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book IV: PHP -- Chapter 1: Understanding PHP Basics -- How PHP Works -- Examining the Structure of a PHP Script -- Looking at PHP Syntax -- Writing PHP Code -- Displaying Content in a Web Page -- Using PHP Variables -- Using PHP Constants.

Understanding Data Types -- Using Arrays -- Using Dates and Times -- Understanding PHP Error Messages -- Adding Comments to Your PHP Script -- Chapter 2: Building PHP Scripts -- Setting Up Conditions -- Using Conditional Statements -- Repeating Actions with Loops -- Using Functions -- Organizing Scripts -- Chapter 3: PHP and Your Operating System -- Managing Files -- Using Operating System Commands -- Using FTP -- Reading and Writing Files -- Exchanging Data with Other Programs -- Using SQLite -- Chapter 4: Object-Oriented Programming -- Introducing Object-Oriented Programming -- Developing an Object-Oriented Script -- Defining a Class -- Using a Class in a Script -- Using Abstract Methods in Abstract Classes and Interfaces -- Preventing Changes to a Class or Method -- Handling Errors with Exceptions -- Copying Objects -- Comparing Objects -- Getting Information about Objects and Classes -- Destroying Objects -- Chapter 5: Considering PHP Security -- Securing the Server -- Securing Apache -- Setting Security Options in php. ini -- Handling Errors Safely -- Sanitizing Variables -- Chapter 6: Tracking Visitors with Sessions -- Understanding Sessions and Cookies -- Using Sessions to Pass Data -- Understanding Other Session Options -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book V: MySQL -- Chapter 1: Introducing MySQL -- Examining How MySQL Works -- Understanding Database Structure -- Communicating with MySQL -- Protecting Your MySQL Databases -- Chapter 2: Administering MySQL -- Understanding the Administrator Responsibilities -- Default Access to Your Data -- Controlling Access to Your Data -- Setting Up MySQL Accounts -- Backing Up Your Database -- Restoring Your Data -- Upgrading MySQL -- Chapter 3: Designing and Building a Database -- Designing a Database -- Designing a Sample Database -- Writing Down Your Design -- Building a Database.

Changing the Database Structure -- Chapter 4: Using the Database -- Adding Information to a Database -- Looking at the Data in a Database -- Retrieving Information from a Database -- Updating Information in a Database -- Removing Information from a Database -- Chapter 5: Communicating with the Database from PHP Scripts -- Knowing How MySQL and PHP Work Together -- PHP Functions That Communicate with MySQL -- Communicating with MySQL -- Selecting a Database -- Handling MySQL Errors -- Using Other Helpful mysqli Functions -- Converting mysqli Functions to mysql Functions -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book VI: Web Applications -- Chapter 1: Improving Your PHP Programs -- Automatically Including Helper Functions -- Reusing Code -- Chapter 2: Creating and Using a Web Service -- Understanding Web Services -- Returning Data from a Web Service -- Accepting Input to a Web Service -- Chapter 3: Validating Web Forms with JavaScript and PHP -- Understanding How to Validate Web Forms -- Performing Basic JavaScript Validation -- Performing PHP Validation -- Chapter 4: Building a Members-Only Website -- Understanding a Members-Only Site -- Creating the User Database -- Creating Base Functions -- Creating Web Forms -- Creating a User Object -- Adding Authenticated Pages -- Adding E-mail Functionality -- CoCnotnetnetns tas ta at aG lGalnacnece -- Book VII: PHP and Templates -- Chapter 1: Configuring PHP -- Understanding the php. ini -- Understanding Common Configuration Changes -- Chapter 2: Building a Templating System -- Understanding Template Systems -- Building a PHP Template -- Extending the Template -- Symbols -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- K -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V -- W -- X -- Y -- Z -- Index.