TY - BOOK AU - Valade,Janet AU - Suehring,Steve TI - PHP, MySQL, JavaScript and HTML5 All-in-One for Dummies® SN - 9781118228746 AV - QA76.625 U1 - 006.76 PY - 2013/// CY - Somerset PB - John Wiley & Sons, Incorporated KW - HTML (Document markup language) KW - Internet programming KW - JavaScript (Computer program language) KW - MySQL (Electronic resource) KW - PHP (Computer program language) KW - Relational databases KW - Electronic books N1 - 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 N2 - 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 UR - https://ebookcentral.proquest.com/lib/buse-ebooks/detail.action?docID=827043 ER -