Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 - Info and Reading Options

"Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5" Table Of Contents:

• 1- Preface
• 2- Introduction to Dynamic Web Content
• 3- HTTP and HTML: Berners-Lee's Basics
• 4- The Request/Response Procedure
• 5- The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5
• 6- Using PHP
• 7- Using MySQL
• 8- Using JavaScript
• 9- Using CSS
• 10- And Then There's HTML5
• 11- The Apache Web Server
• 12- About Open Source
• 13- Bringing It All Together
• 14- Questions
• 15- Setting Up a Development Server
• 16- What Is a WAMP, MAMP, or LAMP?
• 17- Installing XAMPP on Windows
• 18- Testing the Installation
• 19- Installing XAMPP on Mac OS X
• 20- Accessing the Document Root
• 21- Installing a LAMP on Linux
• 22- Working Remotely
• 23- Logging In
• 24- Using FTP
• 25- Using a Program Editor
• 26- Using an IDE
• 27- Questions
• 28- Introduction to PHP
• 29- Incorporating PHP Within HTML
• 30- This Book's Examples
• 31- The Structure of PHP
• 32- Using Comments
• 33- Basic Syntax
• 34- Variables
• 35- Operators
• 36- Variable Assignment
• 37- Multiple-Line Commands
• 38- Variable Typing
• 39- Constants
• 40- Predefined Constants
• 41- The Difference Between the echo and print Commands
• 42- Functions
• 43- Variable Scope
• 44- Questions
• 45- Expressions and Control Flow in PHP
• 46- Expressions
• 47- TRUE or FALSE?
• 48- Literals and Variables
• 49- Operators
• 50- Operator Precedence
• 51- Associativity
• 52- Relational Operators
• 53- Conditionals
• 54- The if Statement
• 55- The else Statement
• 56- The elseif Statement
• 57- The switch Statement
• 58- The ? Operator
• 59- Looping
• 60- while Loops
• 61- do ... while Loops
• 62- for Loops
• 63- Breaking Out of a Loop
• 64- The continue Statement
• 65- Implicit and Explicit Casting
• 66- PHP Dynamic Linking
• 67- Dynamic Linking in Action
• 68- Questions
• 69- PHP Functions and Objects
• 70- PHP Functions
• 71- Defining a Function
• 72- Returning a Value
• 73- Returning an Array
• 74- Do Not Pass Arguments by Reference
• 75- Returning Global Variables
• 76- Recap of Variable Scope
• 77- Including and Requiring Files
• 78- The include Statement
• 79- Using include_once
• 80- Using require and require_once
• 81- PHP Version Compatibility
• 82- PHP Objects
• 83- Terminology
• 84- Declaring a Class
• 85- Creating an Object
• 86- Accessing Objects
• 87- Cloning Objects
• 88- Constructors
• 89- PHP 5 Destructors
• 90- Writing Methods
• 91- Static Methods in PHP 5
• 92- Declaring Properties
• 93- Declaring Constants
• 94- Property and Method Scope in PHP 5
• 95- Static Properties and Methods
• 96- Inheritance
• 97- Questions
• 98- PHP Arrays
• 99- Basic Access
• 100- Numerically Indexed Arrays
• 101- Associative Arrays
• 102- Assignment Using the array Keyword
• 103- The foreach ... as Loop
• 104- Multidimensional Arrays
• 105- Using Array Functions
• 106- is_array
• 107- count
• 108- sort
• 109- shuffle
• 110- explode
• 111- extract
• 112- compact
• 113- reset
• 114- end
• 115- Questions
• 116- Practical PHP
• 117- Using printf
• 118- Precision Setting
• 119- String Padding
• 120- Using sprintf
• 121- Date and Time Functions
• 122- Date Constants
• 123- Using checkdate
• 124- File Handling
• 125- Checking Whether a File Exists
• 126- Creating a File
• 127- Reading from Files
• 128- Copying Files
• 129- Moving a File
• 130- Deleting a File
• 131- Updating Files
• 132- Locking Files for Multiple Accesses
• 133- Reading an Entire File
• 134- Uploading Files
• 135- System Calls
• 136- XHTML or HTML5?
• 137- Questions
• 138- Introduction to MySQL
• 139- MySQL Basics
• 140- Summary of Database Terms
• 141- Accessing MySQL via the Command Line
• 142- Starting the Command-Line Interface
• 143- Using the Command-Line Interface
• 144- MySQL Commands
• 145- Data Types
• 146- Indexes
• 147- Creating an Index
• 148- Querying a MySQL Database
• 149- Joining Tables Together
• 150- Using Logical Operators
• 151- MySQL Functions
• 152- Accessing MySQL via phpMyAdmin
• 153- Questions
• 154- Mastering MySQL
• 155- Database Design
• 156- Primary Keys: The Keys to Relational Databases
• 157- Normalization
• 158- First Normal Form
• 159- Second Normal Form
• 160- Third Normal Form
• 161- When Not to Use Normalization
• 162- Relationships
• 163- One-to-One
• 164- One-to-Many
• 165- Many-to-Many
• 166- Databases and Anonymity
• 167- Transactions
• 168- Transaction Storage Engines
• 169- Using BEGIN
• 170- Using COMMIT
• 171- Using ROLLBACK
• 172- Using EXPLAIN
• 173- Backing Up and Restoring
• 174- Using mysqldump
• 175- Creating a Backup File
• 176- Restoring from a Backup File
• 177- Dumping Data in CSV Format
• 178- Planning Your Backups
• 179- Questions
• 180- Accessing MySQL Using PHP
• 181- Querying a MySQL Database with PHP
• 182- The Process
• 183- Creating a Login File
• 184- Connecting to a MySQL Database
• 185- A Practical Example
• 186- The $_POST Array
• 187- Deleting a Record
• 188- Displaying the Form
• 189- Querying the Database
• 190- Running the Program
• 191- Practical MySQL
• 192- Creating a Table
• 193- Describing a Table
• 194- Dropping a Table
• 195- Adding Data
• 196- Retrieving Data
• 197- Updating Data
• 198- Deleting Data
• 199- Using AUTO_INCREMENT
• 200- Performing Additional Queries
• 201- Preventing Hacking Attempts
• 202- Steps You Can Take
• 203- Using Placeholders
• 204- Preventing HTML Injection
• 205- Using mysqli Procedurally
• 206- Questions
• 207- Form Handling
• 208- Building Forms
• 209- Retrieving Submitted Data
• 210- register_globals: An Old Solution Hangs On
• 211- Default Values
• 212- Input Types
• 213- Sanitizing Input
• 214- An Example Program
• 215- What's New in HTML5?
• 216- The autocomplete Attribute
• 217- The autofocus Attribute
• 218- The placeholder Attribute
• 219- The required Attribute
• 220- Override Attributes
• 221- The width and height Attributes
• 222- Features Awaiting Full Implementation
• 223- The form Attribute
• 224- The list Attribute
• 225- The min and max Attributes
• 226- The step Attribute
• 227- The color Input Type
• 228- The number and range Input Types
• 229- Date and Time Pickers
• 230- Questions
• 231- Cookies, Sessions, and Authentication
• 232- Using Cookies in PHP
• 233- Setting a Cookie
• 234- Accessing a Cookie
• 235- Destroying a Cookie
• 236- HTTP Authentication
• 237- Storing Usernames and Passwords
• 238- Salting
• 239- Using Sessions
• 240- Starting a Session
• 241- Ending a Session
• 242- Setting a Time-Out
• 243- Session Security
• 244- Questions
• 245- Exploring JavaScript
• 246- JavaScript and HTML Text
• 247- Using Scripts Within a Document Head
• 248- Older and Nonstandard Browsers
• 249- Including JavaScript Files
• 250- Debugging JavaScript Errors
• 251- Using Comments
• 252- Semicolons
• 253- Variables
• 254- String Variables
• 255- Numeric Variables
• 256- Arrays
• 257- Operators
• 258- Arithmetic Operators
• 259- Assignment Operators
• 260- Comparison Operators
• 261- Logical Operators
• 262- Variable Incrementing and Decrementing
• 263- String Concatenation
• 264- Escaping Characters
• 265- Variable Typing
• 266- Functions
• 267- Global Variables
• 268- Local Variables
• 269- The Document Object Model
• 270- But It's Not That Simple
• 271- Using the DOM
• 272- About document.write
• 273- Using console.log
• 274- Using alert
• 275- Writing into Elements
• 276- Questions
• 277- Expressions and Control Flow in JavaScript
• 278- Expressions
• 279- Literals and Variables
• 280- Operators
• 281- Operator Precedence
• 282- Associativity
• 283- Relational Operators
• 284- The with Statement
• 285- Using onerror
• 286- Using try ... catch
• 287- Conditionals
• 288- The if Statement
• 289- The else Statement
• 290- The switch Statement
• 291- The ? Operator
• 292- Looping
• 293- while Loops
• 294- do ... while Loops
• 295- for Loops
• 296- Breaking Out of a Loop
• 297- The continue Statement
• 298- Explicit Casting
• 299- Questions
• 300- JavaScript Functions, Objects, and Arrays
• 301- JavaScript Functions
• 302- Defining a Function
• 303- Returning a Value
• 304- Returning an Array
• 305- JavaScript Objects
• 306- Declaring a Class
• 307- Creating an Object
• 308- Accessing Objects
• 309- The prototype Keyword
• 310- JavaScript Arrays
• 311- Numeric Arrays
• 312- Associative Arrays
• 313- Multidimensional Arrays
• 314- Using Array Methods
• 315- Questions
• 316- JavaScript and PHP Validation and Error Handling
• 317- Validating User Input with JavaScript
• 318- The validate.html Document (Part 1)
• 319- The validate.html Document (Part 2)
• 320- Regular Expressions
• 321- Matching Through Metacharacters
• 322- Fuzzy Character Matching
• 323- Grouping Through Parentheses
• 324- Character Classes
• 325- Indicating a Range
• 326- Negation
• 327- Some More-Complicated Examples
• 328- Summary of Metacharacters
• 329- General Modifiers
• 330- Using Regular Expressions in JavaScript
• 331- Using Regular Expressions in PHP
• 332- Redisplaying a Form After PHP Validation
• 333- Questions
• 334- Using Ajax
• 335- What Is Ajax?
• 336- Using XMLHttpRequest
• 337- Your First Ajax Program
• 338- Using Get Instead of Post
• 339- Sending XML Requests
• 340- Using Frameworks for Ajax
• 341- Questions
• 342- Introduction to CSS
• 343- Importing a Style Sheet
• 344- Importing CSS from Within HTML
• 345- Embedded Style Settings
• 346- Using IDs
• 347- Using Classes
• 348- Using Semicolons
• 349- CSS Rules
• 350- Multiple Assignments
• 351- Using Comments
• 352- Style Types
• 353- Default Styles
• 354- User Styles
• 355- External Style Sheets
• 356- Internal Styles
• 357- Inline Styles
• 358- CSS Selectors
• 359- The Type Selector
• 360- The Descendant Selector
• 361- The Child Selector
• 362- The ID Selector
• 363- The Class Selector
• 364- The Attribute Selector
• 365- The Universal Selector
• 366- Selecting by Group
• 367- The CSS Cascade
• 368- Style Sheet Creators
• 369- Style Sheet Methods
• 370- Style Sheet Selectors
• 371- Calculating Specificity
• 372- The Difference Between div and span Elements
• 373- Measurements
• 374- Fonts and Typography
• 375- font-family
• 376- font-style
• 377- font-size
• 378- font-weight
• 379- Managing Text Styles
• 380- Decoration
• 381- Spacing
• 382- Alignment
• 383- Transformation
• 384- Indenting
• 385- CSS Colors
• 386- Short Color Strings
• 387- Gradients
• 388- Positioning Elements
• 389- Absolute Positioning
• 390- Relative Positioning
• 391- Fixed Positioning
• 392- Pseudoclasses
• 393- Shorthand Rules
• 394- The Box Model and Layout
• 395- Setting Margins
• 396- Applying Borders
• 397- Adjusting Padding
• 398- Object Contents
• 399- Questions
• 400- Advanced CSS with CSS3
• 401- Attribute Selectors
• 402- Matching Parts of Strings
• 403- The box-sizing Property
• 404- CSS3 Backgrounds
• 405- The background-clip Property
• 406- The background-origin Property
• 407- The background-size Property
• 408- Using the auto Value
• 409- Multiple Backgrounds
• 410- CSS3 Borders
• 411- The border-color Property
• 412- The border-radius Property
• 413- Box Shadows
• 414- Element Overflow
• 415- Multicolumn Layout
• 416- Colors and Opacity
• 417- HSL Colors
• 418- HSLA Colors
• 419- RGB Colors
• 420- RGBA Colors
• 421- The opacity Property
• 422- Text Effects
• 423- The text-shadow Property
• 424- The text-overflow Property
• 425- The word-wrap Property
• 426- Web Fonts
• 427- Google Web Fonts
• 428- Transformations
• 429- 3D Transformations
• 430- Transitions
• 431- Properties to Transition
• 432- Transition Duration
• 433- Transition Delay
• 434- Transition Timing
• 435- Shorthand Syntax
• 436- Questions
• 437- Accessing CSS from JavaScript
• 438- Revisiting the getElementById Function
• 439- The O Function
• 440- The S Function
• 441- The C Function
• 442- Including the Functions
• 443- Accessing CSS Properties from JavaScript
• 444- Some Common Properties
• 445- Other Properties
• 446- Inline JavaScript
• 447- The this Keyword
• 448- Attaching Events to Objects in a Script
• 449- Attaching to Other Events
• 450- Adding New Elements
• 451- Removing Elements
• 452- Alternatives to Adding and Removing Elements
• 453- Using Interrupts
• 454- Using setTimeout
• 455- Cancelling a Time-Out
• 456- Using setInterval
• 457- Using Interrupts for Animation
• 458- Questions
• 459- Introduction to jQuery
• 460- Why jQuery?
• 461- Including jQuery
• 462- Choosing the Right Version
• 463- Downloading
• 464- Using a Content Delivery Network
• 465- Always Using the Latest Version
• 466- Customizing jQuery
• 467- jQuery Syntax
• 468- A Simple Example
• 469- Avoiding Library Conflict
• 470- Selectors
• 471- The css Method
• 472- The Element Selector
• 473- The ID Selector
• 474- The Class Selector
• 475- Combining Selectors
• 476- Handling Events
• 477- Waiting Until the Document Is Ready
• 478- Event Functions and Properties
• 479- The blur and focus Events
• 480- The this Keyword
• 481- The click and dblclick Events
• 482- The keypress Event
• 483- Considerate Programming
• 484- The mousemove Event
• 485- Other Mouse Events
• 486- Alternative Mouse Methods
• 487- The submit Event
• 488- Special Effects
• 489- Hiding and Showing
• 490- The toggle Method
• 491- Fading In and Out
• 492- Sliding Elements Up and Down
• 493- Animations
• 494- Stopping Animations
• 495- Manipulating the DOM
• 496- The Difference Between the text and html Methods
• 497- The val and attr Methods
• 498- Adding and Removing Elements
• 499- Dynamically Applying Classes
• 500- Modifying Dimensions
• 501- The width and height Methods
• 502- The innerWidth and innerHeight Methods
• 503- The outerWidth and outerHeight Methods
• 504- DOM Traversal
• 505- Parent Elements
• 506- Child Elements
• 507- Sibling Elements
• 508- Selecting the Next and Previous Elements
• 509- Traversing jQuery Selections
• 510- The is Method
• 511- Using jQuery Without Selectors
• 512- The $.each Method
• 513- The $.map Method
• 514- Using Ajax
• 515- Using the post Method
• 516- Using the get Method
• 517- Plug-Ins
• 518- The jQuery User Interface
• 519- Other Plug-Ins
• 520- jQuery Mobile
• 521- Questions
• 522- Introduction to HTML5
• 523- The Canvas
• 524- Geolocation
• 525- Audio and Video
• 526- Forms
• 527- Local Storage
• 528- Web Workers
• 529- Web Applications
• 530- Microdata
• 531- Summary
• 532- Questions
• 533- The HTML5 Canvas
• 534- Creating and Accessing a Canvas
• 535- The toDataURL Function
• 536- Specifying an Image Type
• 537- The fillRect Method
• 538- The clearRect Method
• 539- The strokeRect Method
• 540- Combining These Commands
• 541- The createLinearGradient Method
• 542- The addColorStop Method in Detail
• 543- The createRadialGradient Method
• 544- Using Patterns for Fills
• 545- Writing Text to the Canvas
• 546- The strokeText Method
• 547- The textBaseline Property
• 548- The font Property
• 549- The textAlign Property
• 550- The fillText Method
• 551- The measureText Method
• 552- Drawing Lines
• 553- The lineWidth Property
• 554- The lineCap and lineJoin Properties
• 555- The miterLimit Property
• 556- Using Paths
• 557- The moveTo and lineTo Methods
• 558- The stroke Method
• 559- The rect Method
• 560- Filling Areas
• 561- The clip Method
• 562- The isPointInPath Method
• 563- Working with Curves
• 564- The arc Method
• 565- The arcTo Method
• 566- The quadraticCurveTo Method
• 567- The bezierCurveTo Method
• 568- Manipulating Images
• 569- The drawImage Method
• 570- Resizing an Image
• 571- Selecting an Image Area
• 572- Copying from a Canvas
• 573- Adding Shadows
• 574- Editing at the Pixel Level
• 575- The getImageData Method
• 576- The data Array
• 577- The putImageData Method
• 578- The createImageData Method
• 579- Advanced Graphical Effects
• 580- The globalCompositeOperation Property
• 581- The globalAlpha Property
• 582- Transformations
• 583- The scale Method
• 584- The save and restore Methods
• 585- The rotate Method
• 586- The translate Method
• 587- The transform Method
• 588- The setTransform Method
• 589- Summary
• 590- Questions
• 591- HTML5 Audio and Video
• 592- About Codecs
• 593- The <audio> Element
• 594- Supporting Non-HTML5 Browsers
• 595- The <video> Element
• 596- The Video Codecs
• 597- Supporting Older Browsers
• 598- Summary
• 599- Questions
• 600- Other HTML5 Features
• 601- Geolocation and the GPS Service
• 602- Other Location Methods
• 603- Geolocation and HTML5
• 604- Local Storage
• 605- Using Local Storage
• 606- The localStorage Object
• 607- Web Workers
• 608- Offline Web Applications
• 609- Drag and Drop
• 610- Cross-Document Messaging
• 611- Microdata
• 612- Other HTML5 Tags
• 613- Summary
• 614- Questions
• 615- Bringing It All Together
• 616- Designing a Social Networking Site
• 617- On the Website
• 618- functions.php
• 619- The Functions
• 620- header.php
• 621- setup.php
• 622- index.php
• 623- signup.php
• 624- Checking for Username Availability
• 625- Logging In
• 626- checkuser.php
• 627- login.php
• 628- profile.php
• 629- Adding the "About Me" Text
• 630- Adding a Profile Image
• 631- Processing the Image
• 632- Displaying the Current Profile
• 633- members.php
• 634- Viewing a User's Profile
• 635- Adding and Dropping Friends
• 636- Listing All Members
• 637- friends.php
• 638- messages.php
• 639- logout.php
• 640- styles.css
• 641- javascript.js
• 642- Solutions to the Chapter Questions
• 643- Online Resources
• 644- MySQL's FULLTEXT Stopwords
• 645- MySQL Functions
• 646- jQuery Selectors, Objects, and Methods
• 647- Index

Read “Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5”:

Read “Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5” by choosing from the options below.