Table of Contents
Preface xxi
HTTP and HTML: Berners-Lee’s Basics 2
The Request/Response Procedure 2
The Benefits of PHP, MySQL, JavaScript, CSS, and HTML5 5
Using PHP 6
Using MySQL 7
Using JavaScript 8
Using CSS 9
And Then There’s HTML5 10
The Apache Web Server 11
About Open Source 12
Bringing It All Together 12
Questions 14
What Is a WAMP, MAMP, or LAMP? 16
Installing a WAMP on Windows 16
Testing the Installation 28
Alternative WAMPs 31
Installing a MAMP on Mac OS X 31
Configuring MySQL 35
Ensuring MySQL Starts on Booting 36
Testing the Installation 36
Installing a LAMP on Linux 38
Working Remotely 38
Logging In 38
Using FTP 39
Using a Program Editor 40
Using an IDE 41
Questions 43
Incorporating PHP Within HTML 45
This Book’s Examples 47
The Structure of PHP 48
Using Comments 48
Basic Syntax 49
Variables 50
Operators 55
Variable Assignment 57
Multiple-Line Commands 60
Variable Typing 62
Constants 63
Predefined Constants 64
The Difference Between the echo and print Commands 64
Functions 65
Variable Scope 66
Questions 71
Expressions 73
TRUE or FALSE? 73
Literals and Variables 75
Operators 76
Operator Precedence 77
Associativity 78
Relational Operators 80
Conditionals 84
The if Statement 84
The else Statement 85
The elseif Statement 87
The switch Statement 88
The ? Operator 91
Looping 92
while Loops 93
do ... while Loops 94
for Loops 95
Breaking Out of a Loop 97
The continue Statement 98
Implicit and Explicit Casting 98
PHP Dynamic Linking 99
Dynamic Linking in Action 100
Questions 101
PHP Functions 104
Defining a Function 106
Returning a Value 106
Returning an Array 108
Passing by Reference 108
Returning Global Variables 110
Recap of Variable Scope 111
Including and Requiring Files 111
The include Statement 111
Using include_once 112
Using require and require_once 112
PHP Version Compatibility 113
PHP Objects 113
Terminology 114
Declaring a Class 115
Creating an Object 116
Accessing Objects 116
Cloning Objects 118
Constructors 119
PHP 5 Destructors 120
Writing Methods 120
Static Methods in PHP 5 121
Declaring Properties 122
Declaring Constants 122
Property and Method Scope in PHP 5 123
Static Properties and Methods 124
Inheritance 125
Questions 129
Basic Access 131
Numerically Indexed Arrays 131
Associative Arrays 133
Assignment Using the array Keyword 134
The foreach ... as Loop 135
Multidimensional Arrays 137
Using Array Functions 140
is_array 140
count 140
sort 140
shuffle 141
explode 141
extract 142
compact 143
reset 144
end 144
Questions 144
Using printf 147
Precision Setting 148
String Padding 150
Using sprintf 151
Date and Time Functions 151
Date Constants 154
Using checkdate 154
File Handling 155
Checking Whether a File Exists 155
Creating a File 155
Reading from Files 157
Copying Files 158
Moving a File 158
Deleting a File 158
Updating Files 159
Locking Files for Multiple Accesses 160
Reading an Entire File 162
Uploading Files 162
System Calls 167
XHTML or HTML5? 169
Questions 169
MySQL Basics 171
Summary of Database Terms 172
Accessing MySQL via the Command Line 172
Starting the Command-Line Interface 173
Using the Command-Line Interface 177
MySQL Commands 178
Data Types 183
Indexes 192
Creating an Index 192
Querying a MySQL Database 198
Joining Tables Together 207
Using Logical Operators 209
MySQL Functions 209
Accessing MySQL via phpMyAdmin 210
Using phpMyAdmin 214
Questions 214
Database Design 217
Primary Keys: The Keys to Relational Databases 218
Normalization 219
First Normal Form 220
Second Normal Form 222
Third Normal Form 224
When Not to Use Normalization 226
Relationships 227
One-to-One 227
One-to-Many 228
Many-to-Many 229
Databases and Anonymity 230
Transactions 230
Transaction Storage Engines 231
Using BEGIN 232
Using COMMIT 232
Using ROLLBACK 233
Using EXPLAIN 234
Backing Up and Restoring 235
Using mysqldump 235
Creating a Backup File 237
Restoring from a Backup File 239
Dumping Data in CSV Format 239
Planning Your Backups 240
Questions 240
Querying a MySQL Database with PHP 241
The Process 242
Creating a Login File 242
Connecting to MySQL 243
A Practical Example 248
The $_POST Array 251
Deleting a Record 252
Displaying the Form 252
Querying the Database 253
Running the Program 254
Practical MySQL 255
Creating a Table 255
Describing a Table 256
Dropping a Table 257
Adding Data 257
Retrieving Data 258
Updating Data 259
Deleting Data 260
Using AUTO_INCREMENT 260
Performing Additional Queries 262
Preventing SQL Injection 263
Using Placeholders 265
Preventing HTML Injection 266
Questions 268
Querying a MySQL Database with mysqli 269
Creating a Login File 269
Connecting to MySQL 270
A Practical Example 274
Using mysqli Procedurally 276
Questions 277
Building Forms 279
Retrieving Submitted Data 281
register_globals: An Old Solution Hangs On 282
Default Values 283
Input Types 284
Sanitizing Input 291
An Example Program 292
What’s New in HTML5? 295
The autocomplete Attribute 295
The autofocus Attribute 295
The placeholder Attribute 296
The required Attribute 296
Override Attributes 296
The width and height Attributes 297
Features Awaiting Full Implementation 297
The form Attribute 297
The list Attribute 297
The min and max Attributes 298
The step Attribute 298
The color Input Type 298
The number and range Input Types 298
Date and time Pickers 298
Questions 299
Using Cookies in PHP 301
Setting a Cookie 303
Accessing a Cookie 304
Destroying a Cookie 304
HTTP Authentication 304
Storing Usernames and Passwords 307
Salting 308
Using Sessions 312
Starting a Session 312
Ending a Session 315
Setting a Timeout 317
Session Security 317
Questions 320
JavaScript and HTML Text 324
Using Scripts Within a Document Head 325
Older and Nonstandard Browsers 325
Including JavaScript Files 326
Debugging JavaScript Errors 327
Using Comments 329
Semicolons 329
Variables 330
String Variables 330
Numeric Variables 330
Arrays 331
Operators 332
Arithmetic Operators 332
Assignment Operators 332
Comparison Operators 333
Logical Operators 333
Variable Incrementing and Decrementing 334
String Concatenation 334
Escaping Characters 334
Variable Typing 335
Functions 336
Global Variables 336
Local Variables 336
The Document Object Model 338
But It’s Not That Simple 340
Another Use for the $ Symbol 340
Using the DOM 341
Questions 342
Expressions 343
Literals and Variables 344
Operators 345
Operator Precedence 346
Associativity 346
Relational Operators 347
The with Statement 350
Using onerror 351
Using try ... catch 352
Conditionals 353
The if Statement 353
The else Statement 353
The switch statement 354
The ? Operator 355
Looping 356
while Loops 356
do ... while Loops 357
for Loops 357
Breaking Out of a Loop 358
The continue Statement 359
Explicit Casting 360
Questions 360
JavaScript Functions 363
Defining a Function 363
The arguments Array 364
Returning a Value 365
Returning an Array 367
JavaScript Objects 368
Declaring a Class 368
Creating an Object 369
Accessing Objects 370
The prototype Keyword 370
JavaScript Arrays 372
Numeric Arrays 373
Associative Arrays 374
Multidimensional Arrays 375
Using Array Methods 376
Questions 380
Validating User Input with JavaScript 381
The validate.html Document (Part One) 382
The validate.html Document (Part Two) 384
Regular Expressions 387
388
Using Regular Expressions in JavaScript 395
Using Regular Expressions in PHP 396
Redisplaying a Form After PHP Validation 397
Questions 403
What Is Ajax? 405
Using XMLHttpRequest 406
Your First Ajax Program 408
Using GET Instead of POST 413
Sending XML Requests 415
Using Frameworks for Ajax 420
Questions 421
Importing a Style Sheet 424
Importing CSS from Within HTML 424
Embedded Style Settings 425
Using IDs 425
Using Classes 425
Using Semicolons 426
CSS Rules 426
Multiple Assignments 426
Using Comments 427
Style Types 428
Default Styles 428
User Styles 428
External Style Sheets 429
Internal Styles 429
Inline Styles 430
CSS Selectors 430
The Type Selector 430
The Descendant Selector 430
The Child Selector 431
The ID Selector 432
The Class Selector 433
The Attribute Selector 434
The Universal Selector 434
Selecting by Group 435
The CSS Cascade 435
Style Sheet Creators 436
Style Sheet Methods 436
Style Sheet Selectors 437
Calculating Specificity 437
The Difference Between Div and Span Elements 439
Measurements 440
Fonts and Typography 442
font-family 442
font-style 443
font-size 443
font-weight 444
Managing Text Styles 444
Decoration 445
Spacing 445
Alignment 446
Transformation 446
Indenting 446
CSS Colors 447
Short Color Strings 447
Gradients 448
Positioning Elements 449
Absolute Positioning 449
Relative Positioning 450
Fixed Positioning 450
Pseudo-Classes 452
Shorthand Rules 454
The Box Model and Layout 454
Setting Margins 455
Applying Borders 457
Adjusting Padding 458
Object Contents 459
Questions 459
Attribute Selectors 461
The ^ Operator 462
The $ Operator 462
The * Operator 463
The box-sizing Property 463
CSS3 Backgrounds 463
The background-clip Property 464
The background-origin Property 465
The background-size Property 466
Multiple Backgrounds 467
CSS3 Borders 469
The border-color Property 469
The border-radius Property 469
Box Shadows 472
Element Overflow 473
Multicolumn Layout 473
Colors and Opacity 475
HSL Colors 475
HSLA Colors 476
RGB Colors 476
RGBA Colors 477
The opacity Property 477
Text Effects 477
The text-shadow Property 477
The text-overflow Property 478
The word-wrap Property 479
Web Fonts 479
Google Web Fonts 480
Transformations 481
3D Transformations 483
Transitions 483
Properties to Transition 484
Transition Duration 484
Transition Delay 484
Transition Timing 485
Shorthand Syntax 485
Questions 487
Revisiting the getElementById Function 489
The O function 489
The S Function 490
The C Function 491
Including the Functions 492
Accessing CSS Properties from JavaScript 493
Some Common Properties 494
Other Properties 495
Inline JavaScript 497
The this Keyword 497
Attaching Events to Objects in a Script 498
Attaching to Other Events 499
Adding New Elements 500
Removing Elements 501
Alternatives to Adding and Removing Elements 502
Using Interrupts 503
Using setTimeout 503
Canceling a Timeout 504
Using setInterval 504
Using Interrupts for Animation 506
Questions 508
The Canvas 510
Geolocation 511
Audio and Video 513
Forms 514
Local Storage 515
Web Workers 515
Web Applications 515
Microdata 516
Summary 516
Questions 516
Creating and Accessing a Canvas 517
The toDataURL Function 519
Specifying an Image Type 521
The fillRect Method 521
The clearRect Method 521
The strokeRect Method 522
Combining These Commands 522
The createLinearGradient Method 523
The addColorStop Method in Detail 525
The createRadialGradient Method 526
Using Patterns for Fills 528
Writing Text to the Canvas 530
The strokeText Method 530
The textBaseLine Property 531
The font Property 531
The textAlign Property 531
The fillText Method 532
The measureText Method 533
Drawing Lines 533
The lineWidth Property 533
The lineCap and lineJoin Properties 533
The miterLimit Property 535
Using Paths 536
The moveTo and LineTo Methods 536
The stroke Method 537
The rect Method 537
Filling Areas 537
The clip Method 539
The isPointInPath Method 542
Working with Curves 543
The arc Method 543
The arcTo Method 546
The quadraticCurveTo Method 547
The bezierCurveTo Method 548
Manipulating Images 549
The drawImage Method 549
Resizing an Image 550
Selecting an Image Area 550
Copying from a Canvas 552
Adding Shadows 552
Editing at the Pixel Level 554
The getImageData Method 554
The data Array 555
The putImageData Method 557
The createImageData Method 557
Advanced Graphical Effects 558
The globalCompositeOperation Property 558
The globalAlpha Property 561
Transformations 561
The scale Method 561
The save and restore Methods 562
The rotate Method 562
The translate Method 564
The transform Method 565
The setTransform Method 567
Summary 567
Questions 567
About Codecs 570
The <audio> Element 571
Supporting Non-HTML5 Browsers 573
The <video> Element 574
The Video Codecs 575
Supporting Older Browsers 578
Summary 580
Questions 580
Geolocation and the GPS Service 581
Other Location Methods 582
Geolocation and HTML5 583
Local Storage 586
Using Local Storage 587
The localStorage Object 587
Web Workers 589
Offline Web Applications 591
Drag and Drop 593
Cross Document Messaging 595
Microdata 598
Other HTML5 Tags 601
Summary 601
Questions 602
Designing a Social Networking Site 603
On the Website 604
functions.php 604
The Functions 605
header.php 607
setup.php 608
index.php 610
signup.php 610
Checking for Username Availability 611
Logging In 611
checkuser.php 614
login.php 615
profile.php 617
Adding the “About Me” Text 618
Adding a Profile Image 618
Processing the Image 618
Displaying the Current Profile 619
members.php 622
Viewing a User’s Profile 622
Adding and Dropping Friends 622
Listing All Members 622
friends.php 625
messages.php 628
logout.php 631
styles.css 632
javascript.js 636
A. Solutions to the Chapter Questions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 639
B. Online Resources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 659
C. MySQL’s FULLTEXT Stopwords. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 663
D. MySQL Functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 667
Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 677
Preface
The combination of PHP and MySQL is the most convenient approach to dynamic, database-driven web design, holding its own in the face of challenges from integrated frameworks—such as Ruby on Rails—that are harder to learn. Due to its open source roots (unlike the competing Microsoft .NET Framework), it is free to implement and is therefore an extremely popular option for web development.
Any would-be developer on a Unix/Linux or even a Windows/Apache platform will need to master these technologies. And, combined with the partner technologies of JavaScript, CSS, and HTML5, you will be able to create websites of the caliber of industry standards like Facebook, Twitter, and Gmail.
Audience
This book is for people who wish to learn how to create effective and dynamic websites. This may include webmasters or graphic designers who are already creating static websites but wish to take their skills to the next level, as well as high school and college students, recent graduates, and self-taught individuals. In fact, anyone ready to learn the fundamentals behind the Web 2.0 technology known as Ajax will obtain a thorough grounding in all of these core technologies: PHP, MySQL, JavaScript, CSS, and HTML5.
Assumptions This Book Makes
This book assumes that you have a basic understanding of HTML and can at least put together a simple, static website, but does not assume that you have any prior knowledge of PHP, MySQL, JavaScript, CSS, or HTML5—although if you do, your progress through the book will be even quicker.
Organization of This Book
The chapters in this book are written in a specific order, first introducing all of the core technologies it covers and then walking you through their installation on a web development server so that you will be ready to work through the examples. In the first section, you will gain a grounding in the PHP programming language, covering the basics of syntax, arrays, functions, and object-oriented programming. Then, with PHP under your belt, you will move on to an introduction to the MySQL database system, where you will learn everything from how MySQL databases are structured to how to generate complex queries.
After that, you will learn how you can combine PHP and MySQL to start creating your own dynamic web pages by integrating forms and other HTML features. Following that, you will get down to the nitty-gritty practical aspects of PHP and MySQL development by learning a variety of useful functions and how to manage cookies and sessions, as well as how to maintain a high level of security.
In the next few chapters, you will gain a thorough grounding in JavaScript, from simple functions and event handling to accessing the Document Object Model and in-browser validation and error handling. With an understanding of all three of these core technologies, you will then learn how to make behind-the-scenes Ajax calls and turn your websites into highly dynamic environments.
Next, you’ll spend two chapters learning all about using CSS to style and lay out your web pages, before moving on to the final section on the new features built into HTML5, including geolocation, audio, video, and the canvas. After this, you’ll put together everything you’ve learned in a complete set of programs that together constitute a fully functional social networking website.
Along the way, you’ll also find plenty of pointers and advice on good programming practices and tips that could help you find and solve hard-to-detect programming errors. There are also plenty of links to websites containing further details on the topics covered.
