Learning PHP, MySQL & JavaScript With jQuery, CSS & HTML5 4th Edition O'Reilly Robin Nixon [pdf] [epub] [mobi] [CYCL0TR0N]

Description

Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you have only basic HTML knowledge. With this popular hands-on guide, you’ll tackle dynamic web programming with the help of today’s core technologies: PHP, MySQL, JavaScript, jQuery, CSS, and HTML5.

Explore each technology separately, learn how to use them together, and pick up valuable web programming practices along the way. At the end of the book, you’ll put everything together to build a fully functional social networking site, using XAMPP or any development stack you choose.

Learn PHP in-depth, along with the basics of object-oriented programming
Explore MySQL, from database structure to complex queries
Use the MySQLi Extension, PHP’s improved MySQL interface
Create dynamic PHP web pages that tailor themselves to the user
Manage cookies and sessions, and maintain a high level of security
Master the JavaScript language—and enhance it with jQuery
Use Ajax calls for background browser/server communication
Acquire CSS2 and CSS3 skills for professionally styling your web pages
Implement all of the new HTML5 features, including geolocation, audio, video, and the canvas

Table of Contents


Chapter 1Introduction to Dynamic Web Content
HTTP and HTML: Berners-Lee’s Basics
The Request/Response Procedure
The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5
And Then There’s HTML5
The Apache Web Server
About Open Source
Bringing It All Together
Questions
Chapter 2Setting Up a Development Server
What Is a WAMP, MAMP, or LAMP?
Installing XAMPP on Windows
Installing XAMPP on Mac OS X
Installing a LAMP on Linux
Working Remotely
Using a Program Editor
Using an IDE
Questions
Chapter 3Introduction to PHP
Incorporating PHP Within HTML
This Book’s Examples
The Structure of PHP
Questions
Chapter 4Expressions and Control Flow in PHP
Expressions
Operators
Conditionals
Looping
Implicit and Explicit Casting
PHP Dynamic Linking
Dynamic Linking in Action
Questions
Chapter 5PHP Functions and Objects
PHP Functions
Including and Requiring Files
PHP Version Compatibility
PHP Objects
Questions
Chapter 6PHP Arrays
Basic Access
The foreach...as Loop
Multidimensional Arrays
Using Array Functions
Questions
Chapter 7Practical PHP
Using printf
Date and Time Functions
File Handling
System Calls
XHTML or HTML5?
Questions
Chapter 8Introduction to MySQL
MySQL Basics
Summary of Database Terms
Accessing MySQL via the Command Line
Indexes
MySQL Functions
Accessing MySQL via phpMyAdmin
Questions
Chapter 9Mastering MySQL
Database Design
Normalization
Relationships
Transactions
Using EXPLAIN
Backing Up and Restoring
Questions
Chapter 10Accessing MySQL Using PHP
Querying a MySQL Database with PHP
A Practical Example
Practical MySQL
Preventing Hacking Attempts
Using mysqli Procedurally
Questions
Chapter 11Form Handling
Building Forms
Retrieving Submitted Data
An Example Program
What’s New in HTML5?
Features Awaiting Full Implementation
Questions
Chapter 12Cookies, Sessions, and Authentication
Using Cookies in PHP
HTTP Authentication
Using Sessions
Questions
Chapter 13Exploring JavaScript
JavaScript and HTML Text
Using Comments
Semicolons
Variables
Operators
Variable Typing
Functions
Global Variables
Local Variables
The Document Object Model
About document.write
Questions
Chapter 14Expressions and Control Flow in JavaScript
Expressions
Literals and Variables
Operators
The with Statement
Using onerror
Using try...catch
Conditionals
Looping
Explicit Casting
Questions
Chapter 15JavaScript Functions, Objects, and Arrays
JavaScript Functions
JavaScript Objects
JavaScript Arrays
Questions
Chapter 16JavaScript and PHP Validation and Error Handling
Validating User Input with JavaScript
Regular Expressions
Redisplaying a Form After PHP Validation
Questions
Chapter 17Using Ajax
What Is Ajax?
Using XMLHttpRequest
Questions
Chapter 18Introduction to CSS
Importing a Style Sheet
Using IDs
Using Classes
Using Semicolons
CSS Rules
Style Types
CSS Selectors
The CSS Cascade
Measurements
Fonts and Typography
Managing Text Styles
CSS Colors
Positioning Elements
Pseudoclasses
Shorthand Rules
The Box Model and Layout
Questions
Chapter 19Advanced CSS with CSS3
Attribute Selectors
The box-sizing Property
CSS3 Backgrounds
Multiple Backgrounds
CSS3 Borders
Box Shadows
Element Overflow
Multicolumn Layout
Colors and Opacity
Text Effects
Web Fonts
Google Web Fonts
Transformations
3D Transformations
Transitions
Questions
Chapter 20Accessing CSS from JavaScript
Revisiting the getElementById Function
Accessing CSS Properties from JavaScript
Inline JavaScript
Adding New Elements
Using Interrupts
Questions
Chapter 21Introduction to jQuery
Why jQuery?
Including jQuery
jQuery Syntax
Selectors
Handling Events
Waiting Until the Document Is Ready
Event Functions and Properties
Special Effects
Manipulating the DOM
Dynamically Applying Classes
Modifying Dimensions
DOM Traversal
Using jQuery Without Selectors
Using Ajax
Plug-Ins
Questions
Chapter 22Introduction to HTML5
The Canvas
Geolocation
Audio and Video
Forms
Local Storage
Web Workers
Web Applications
Microdata
Summary
Questions
Chapter 23The HTML5 Canvas
Creating and Accessing a Canvas
Writing Text to the Canvas
Drawing Lines
Using Paths
Filling Areas
The clip Method
The isPointInPath Method
Working with Curves
Manipulating Images
Editing at the Pixel Level
Advanced Graphical Effects
Transformations
Summary
Questions
Chapter 24HTML5 Audio and Video
About Codecs
The Element
Supporting Non-HTML5 Browsers
The Element
Summary
Questions
Chapter 25Other HTML5 Features
Geolocation and the GPS Service
Other Location Methods
Geolocation and HTML5
Local Storage
Web Workers
Offline Web Applications
Drag and Drop
Cross-Document Messaging
Microdata
Other HTML5 Tags
Summary
Questions
Chapter 26Bringing It All Together
Designing a Social Networking Site
On the Website
functions.php
header.php
setup.php
index.php
signup.php
checkuser.php
login.php
profile.php
members.php
friends.php
messages.php
logout.php
styles.css
javascript.js
Appendix Solutions to the Chapter Questions
Appendix Online Resources
Appendix MySQL’s FULLTEXT Stopwords
Appendix MySQL Functions
Appendix jQuery Selectors, Objects, and Methods


Product Details

Title: Learning PHP, MySQL & JavaScript, 4th Edition
By: Robin Nixon
Publisher: O'Reilly Media
Formats: Print Ebook Safari Books Online

Print: December 2014
Ebook: December 2014
Pages: 812
Print ISBN: 978-1-4919-1866-1
ISBN 10: 1-4919-1866-7
Ebook ISBN: 978-1-4919-1861-6
ISBN 10: 1-4919-1861-6


About the Author

Robin Nixon

Robin Nixon has worked with and written about computers since the early 1980s (his first computer was a Tandy TRS 80 Model 1 with a massive 4KB of RAM!). One of the web sites he developed presented the world's first radio station licensed by the music copyright holders. In order to enable people to continue to surf while listening, Robin also developed the first known pop-up windows. He has also worked full time for one of Britain's main IT magazine publishers, where he held several roles including editorial, promotions, and cover disc editing.