Learn Php MySql JavaScript and Css

DETAIL

• Author : Robin Nixon
• Language : English
• Published : 2012
• Page : 582

CONTENTS
Preface
1. Introduction to Dynamic Web Content 
HTTP and HTML: Berners-Lee’s Basics 2
The Benefits of PHP, MySQL, JavaScript, and CSS 5
The Apache Web Server 9
About Open Source 10
Bringing It All Together 10

2. Setting Up a Development Server
What Is a WAMP, MAMP, or LAMP? 13
Installing a WAMP on Windows 14
Installing a MAMP on OS X 24
Installing a LAMP on Linux 31
Working Remotely 31
Using a Program Editor 33
Using an IDE 34

3. Introduction to PHP
Incorporating PHP Within HTML 37
This Book’s Examples 39
The Structure of PHP 40

4. Expressions and Control Flow in PHP
Expressions 65
Operators 67
Conditionals 75
Looping 82
Implicit and Explicit Casting 89
PHP Dynamic Linking 90

5. PHP Functions and Objects
PHP Functions 94
Including and Requiring Files 100
PHP Version Compatibility 102
PHP Objects 102

6. PHP Arrays
Basic Access 119
The foreach...as Loop 122
Multidimensional Arrays 124
Using Array Functions 127

7. Practical PHP
Using printf 133
Date and Time Functions 137
File Handling 141
System Calls 153
XHTML 154

8. Introduction to MySQL
MySQL Basics 161
Summary of Database Terms 162
Accessing MySQL via the Command Line 162
Indexes 181
MySQL Functions 199
Accessing MySQL via phpMyAdmin 199

9. Mastering MySQL
Database Design 205
Normalization 207
Relationships 215
Transactions 218
Using EXPLAIN 221
Backing Up and Restoring 223

10. Accessing MySQL Using PHP
Querying a MySQL Database with PHP 229
A Practical Example 236
Practical MySQL 242

11. Form Handling
Building Forms 255
Retrieving Submitted Data 256
An Example Program 267

12. Cookies, Sessions, and Authentication
Using Cookies in PHP 271
HTTP Authentication 274
Using Sessions 281

13. Exploring JavaScript
JavaScript and HTML Text 291
Using Comments 297
Semicolons 297
Variables 298
Operators 299
Variable Typing 303
Functions 303
Global Variables 304
The Document Object Model (DOM) 305

14. Expressions and Control Flow in JavaScript
Expressions 311
Operators 313
The with Statement 318
Using onerror 318
Using try...catch 319
Conditionals 320
Looping 323
Explicit Casting 327

15. JavaScript Functions, Objects, and Arrays
JavaScript Functions 329
JavaScript Objects 333
JavaScript Arrays 338

16. JavaScript and PHP Validation and Error Handling
Validating User Input with JavaScript 347
Regular Expressions 353

17. Using Ajax
What Is Ajax? 369
Using XMLHttpRequest 370
Implementing Ajax via POST Requests 372
Using GET Instead of POST 377
Sending XML Requests 379
Using Frameworks for Ajax 383

18. Introduction to CSS
Importing a Style Sheet 386
Embedded Style Settings 387
CSS Rules 388
Style Types 390
CSS Selectors 392
The CSS Cascade 398
The Difference Between

and 401
Measurements 402
Fonts and Typography 404
Managing Text Styles 407
CSS Colors 408
Positioning Elements 411
Pseudoclasses 413
Pseudoelements 415
Shorthand Rules 416
The Box Model and Layout 416

19. Advanced CSS with CSS3
Attribute Selectors 423
The box-sizing Property 425
CSS3 Backgrounds 425
CSS3 Borders 430
Box Shadows 434
Element Overflow 435
Multicolumn Layout 435
Colors and Opacity 436
Text Effects 439
Web Fonts 440
Transformations 441
Transitions 444

20. Accessing CSS from JavaScript
Revisiting the getElementById Function 449
Accessing CSS Properties from JavaScript 453
Inline JavaScript 456
Adding New Elements 459
Using Interrupts 462

21. Bringing It All Together 

Designing a Social Networking Site 469
On the Website 470
functions.php 470
header.php 472
setup.php 474
index.php 475
signup.php 475
checkuser.php 478
login.php 479
profile.php 481
members.php 485
friends.php 488
messages.php 491
logout.php 493
styles.css 495

A. Solutions to the Chapter Questions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 499
B. Online Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 513
C. MySQL’s FULLTEXT Stopwords . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 517
D. MySQL Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 521
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 533

DOWNLOAD HERE