Developing Management Information System (MIS) in PHP/MYSQL Track

Course Title: Developing Management Information System (MIS) in PHP/MYSQL Track
Course Duration: 1 Year

Module I: HTML and DHTML

Part 1: HTML Document Structure
Task 1: How to Write a Tag 2
Task 2: Structuring an HTML Document 4
Task 3: Defining Meta Tag Keywords 6
Task 4: Defining Meta Tag Descriptions 8
Task 5: Defining the Author of a Document Using Meta Tags 10
Task 6: Defining Meta Tag Expiration Dates 12
Task 7: Refreshing Page Content Using Meta Tags 14
Task 8: Defining Meta Tag Robot Values 16
Task 9: Controlling the Document Background 18
Task 10: Working with Source Code in the Browser 20
Part 2: Working with Text
Task 11: Working with Headings 24
Task 12: Working with Paragraphs 26
Task 13: Applying Fonts 28
Task 14: Setting the Font Size 30
Task 15: Setting the Font Color 32
Task 16: Applying Physical Styles 34
Task 17: Applying Logical Styles 36
Task 18: Inserting Character Entities 38
Task 19: Using the Preformatted Text Element 40
Task 20: Using the Blockquote Element 42
Task 21: Setting Document Margins 44
Task 22: Creating an Ordered List 46
Task 23: Modifying Ordered List Styles 48
Task 24: Modifying an Ordered List’s Starting Character 50
Task 25: Creating an Unordered List 52
Task 26: Modifying Bullet Styles 54
Task 27: Nesting Lists 56
Task 28: Creating Definition Lists 58
Part 3: Working with Images
Task 29: Inserting Images 62
Task 30: Controlling Image Alignment and Spacing 64
Task 31: Resizing Images Using Photoshop Elements 66
Task 32: Optimizing GIF Images Using Photoshop Elements 68
Task 33: Optimizing JPEG Images Using Photoshop Elements 70
Task 34: Optimizing PNG Images Using Photoshop Elements 72
Part 4: Audio and Video
Task 35: Embedding Audio Files 76
Task 36: Adding Background Sounds 78
Task 37: Embedding Video 80
Task 38: Embedding Java Applets 82
Part 5: Hyperlinks
Task 39: Defining Hyperlinks 86
Task 40: Defining Pathnames 88
Task 41: Creating mailto Links 90
Task 42: Linking to Named Anchors 92
Part 6: Building Tables
Task 43: Defining Tables 96
Task 44: Working with Table Borders 98
Task 45: Spanning Cells 100
Task 46: Aligning Table Elements 102
Task 47: Defining Dimensions for Table Elements 104
Task 48: Working with Table Background Properties 106
Task 49: Nesting Tables 108
Task 50: Organizing Table Data 110

Part 7: Working with Forms
Task 51: Defining Form Elements 114
Task 52: Formatting Text Fields 116
Task 53: Formatting Password Fields 118
Task 54: Formatting Text Areas 120
Task 55: Formatting Check Boxes 122
Task 56: Formatting Radio Buttons 124
Task 57: Formatting Selection Menus 126
Task 58: Formatting Selection Lists 128
Task 59: Formatting File Fields 130
Task 60: Formatting Submit and Reset Buttons 132
Task 61: Using Graphic Images for Submit Buttons 134
Task 62: Using Hidden Fields 136
Task 63: Specifying the Focus Order of Form Controls 138
Task 64: Using Field Sets 140
Part 8: Working with Frames
Task 65: Defining Frameset Documents 144
Task 66: Specifying Frame Dimensions 146
Task 67: Specifying Border Properties 148
Task 68: Controlling Frame Margins and Scroll Bars 150
Task 69: Nesting Framesets 152
Task 70: Targeting Frames 154
Task 71: Providing noframes Content 156
Task 72: Working with Inline Frames



Module II: CSS

Chapter 1. General
Section 1.0. Introduction
Recipe 1.1. Using CSS with HTML
Recipe 1.2. Using Different Selectors to Apply Styles
Recipe 1.3. Determining When to Use Class and ID Selectors
Recipe 1.4. Understanding CSS Properties
Recipe 1.5. Understanding the Box Model
Recipe 1.6. Understanding DOCTYPES and Effects on Browser Layout
Recipe 1.7. Associating Styles to a Web Page
Recipe 1.8. How to Use Different Types of Style Sheets
Recipe 1.9. Adding Comments Within CSS
Recipe 1.10. Organizing the Contents of a Style Sheet
Recipe 1.11. Organizing Style Sheet Files
Recipe 1.12. Working with Shorthand Properties
Recipe 1.13. Setting up an Alternate Style Sheet
Recipe 1.14. Using Floats with Images
Recipe 1.15. Using Absolute Positioning
Recipe 1.16. Using Relative Positioning
Recipe 1.17. Using CSS in Adobe Dreamweaver
Recipe 1.18. Using CSS in Microsoft Expression Web Designer
Chapter 2. Web Typography
Section 2.0. Introduction
Recipe 2.1. Specifying Fonts
Recipe 2.2. Specifying Font Measurements and Sizes
Recipe 2.3. Gaining More Control over Font Sizes
Recipe 2.4. Enforcing Font Sizes
Recipe 2.5. Centering Text
Recipe 2.6. Setting Text to Be Justified
Recipe 2.7. Removing Space Between Headings and Paragraphs
Recipe 2.8. Setting a Simple Initial Cap
Recipe 2.9. Setting a Larger, Centered Initial Cap
Recipe 2.10. Setting an Initial Cap with Decoration (Imagery)
Recipe 2.11. Creating a Heading with Stylized Text
Recipe 2.12. Creating a Heading with Stylized Text and Borders
Recipe 2.13. Stylizing a Heading with Text and an Image
Recipe 2.14. Creating a Pull Quote with HTML Text
Recipe 2.15. Creating a Pull Quote with Borders
Recipe 2.16. Creating a Pull Quote with Images
Recipe 2.17. Setting the Indent in the First Line of a Paragraph
Recipe 2.18. Setting the Indent of Entire Paragraphs
Recipe 2.19. Creating a Hanging Indent
Recipe 2.20. Styling the First Line of a Paragraph
Recipe 2.21. Styling the First Line of a Paragraph with an Image
Recipe 2.22. Creating a Highlighted Text Effect
Recipe 2.23. Changing Line Spacing
Recipe 2.24. Adding a Graphic Treatment to HTML Text
Recipe 2.25. Placing Shadow Behind Text
Recipe 2.26. Adjusting the Spacing Between Letters and Words
Chapter 3. Images
Section 3.0. Introduction
Recipe 3.1. Placing a Border Around an Image
Recipe 3.2. Removing Borders Set on Images by Default in Some Browsers
Recipe 3.3. Setting a Background Image
Recipe 3.4. Creating a Line of Background Images
Recipe 3.5. Placing a Background Image on a Web Page
Recipe 3.6. Using Multiple Background Images on One Selector
Recipe 3.7. Creating a Stationary Background Image
Recipe 3.8. Overlaying HTML Text on an Image
Recipe 3.9. Replacing HTML Text with an Image
Recipe 3.10. Replacing HTML Text with Flash Text
Recipe 3.11. Using Multiple PNGs with Transparency
Recipe 3.12. Building a Panoramic Image Presentation
Recipe 3.13. Combining Different Image Formats
Recipe 3.14. Rounding Corners with Fixed-Width Columns
Recipe 3.15. Rounding Corners (Sliding Doors Technique)
Recipe 3.16. Rounding Corners (Mountaintop Technique)
Recipe 3.17. Rounding Corners with JavaScript
Recipe 3.18. Placing a Drop Shadow Behind an Image
Recipe 3.19. Placing a Smooth Drop Shadow Behind an Image
Recipe 3.20. Making Images Scalable
Recipe 3.21. Making Word Balloons
Recipe 3.22. Hindering People from Stealing Your Images
Recipe 3.23. Inserting Reflections on Images Automatically
Recipe 3.24. Using Image Sprites
Chapter 4. Page Elements
Section 4.0. Introduction
Recipe 4.1. Eliminating Page Margins
Recipe 4.2. Coloring the Scrollbar
Recipe 4.3. Techniques for Centering Elements on a Web Page
Recipe 4.4. Placing a Page Border
Recipe 4.5. Customizing a Horizontal Rule
Recipe 4.6. Adding a Lightbox
Chapter 5. Lists
Section 5.0. Introduction
Recipe 5.1. Changing the Format of a List
Recipe 5.2. Writing Cross-Browser Indentation in Lists
Recipe 5.3. Place Dividers Between List Items
Recipe 5.4. Creating Custom Text Markers for Lists
Recipe 5.5. Creating Custom Image Markers for Lists
Recipe 5.6. Inserting Large Custom Image Markers for Lists
Recipe 5.7. Making a List Presentation Rich with Imagery
Recipe 5.8. Creating Inline Lists
Recipe 5.9. Making Hanging Indents in a List
Recipe 5.10. Moving the Marker Inside the List
Chapter 6. Links and Navigation
Section 6.0. Introduction
Recipe 6.1. Removing Underlines from Links (and Adding Other Decorations)
Recipe 6.2. Changing Link Colors
Recipe 6.3. Changing Link Colors in Different Sections of a Page
Recipe 6.4. Placing an Icon at the End of the Link
Recipe 6.5. Changing Cursors
Recipe 6.6. Creating Rollovers Without JavaScript
Recipe 6.7. Creating Text Navigation Menus and Rollovers
Recipe 6.8. Building Horizontal Navigation Menus
Recipe 6.9. Building a Navigation Menu with Access Keys
Recipe 6.10. Creating Breadcrumb Navigation
Recipe 6.11. Creating Image-Based Rollovers
Recipe 6.12. Creating Collapsible Menus
Recipe 6.13. Creating Contextual Menus
Recipe 6.14. Making Tool Tips with the Title Attribute
Recipe 6.15. Designing a Dynamic Visual Menu
Recipe 6.16. Apply Styles Dynamically to a Web Page
Chapter 7. Forms
Section 7.0. Introduction
Recipe 7.1. Modifying the Spacing Around a Form
Recipe 7.2. Setting Styles for Input Elements
Recipe 7.3. Applying Different Styles to Different Input Elements in the Same Form
Recipe 7.4. Setting Styles for textarea Elements
Recipe 7.5. Setting Styles for Select and Option Elements
Recipe 7.6. Creating a Macintosh-Styled Search Field
Recipe 7.7. Styling Form Buttons
Recipe 7.8. Creating an Image Submit Button
Recipe 7.9. Setting Up a Submit-Once-Only Button
Recipe 7.10. Creating a Submit Button That Looks Like HTML Text
Recipe 7.11. Making an HTML Text Link Operate Like a Submit Button
Recipe 7.12. Designing a Web Form Without Tables
Recipe 7.13. Designing a Two Column Form Without Tables
Recipe 7.14. Highlighting Form Fields
Recipe 7.15. Integrating Form Feedback with a Form
Recipe 7.16. Styling Access Keys in Web Forms
Recipe 7.17. Grouping Common Form Elements
Recipe 7.18. Entering Data into a Form Like a Spreadsheet
Recipe 7.19. Sample Design: A Login Form
Recipe 7.20. Sample Design: A Registration Form
Chapter 8. Tables
Section 8.0. Introduction
Recipe 8.1. Setting the Cell Spacing
Recipe 8.2. Setting the Borders and Cell Padding
Recipe 8.3. Setting the Style for Caption
Recipe 8.4. Setting the Styles Within Table Cells
Recipe 8.5. Setting Styles for Table Header Elements
Recipe 8.6. Removing Gaps from Images Placed in Table Cells
Recipe 8.7. Eliminating Gaps Between Table Cells
Recipe 8.8. Creating Alternating Background Colors in Table Rows
Recipe 8.9. Adding a Highlighting Effect on a Table Row
Recipe 8.10. Sample Design: An Elegant Calendar
Chapter 9. Page Layouts
Section 9.0. Introduction
Recipe 9.1. Building a One-Column Layout
Recipe 9.2. Building a Two-Column Layout
Recipe 9.3. Building a Two-Column Layout with Fixed-Width Columns
Recipe 9.4. Creating a Flexible Multicolumn Layout with Floats
Recipe 9.5. Creating a Fixed-Width Multicolumn Layout with Floats
Recipe 9.6. Creating a Flexible Multicolumn Layout with Positioning
Recipe 9.7. Creating a Fixed-Width Multicolumn Layout with Positioning
Recipe 9.8. Using Floats to Display Columns in Any Order
Recipe 9.9. Designing an Asymmetric Layout
Chapter 10. Print
Section 10.0. Introduction
Recipe 10.1. Creating a Printer-Friendly Page
Recipe 10.2. Making a Web Form Print-Ready
Recipe 10.3. Displaying URIs After Links
Recipe 10.4. Inserting Special Characters Before Links
Recipe 10.5. Sample Design: A Printer-Friendly Page with CSS
Chapter 11. Hacks, Workarounds, and Troubleshooting
Section 11.0. Introduction
Recipe 11.1. Isolating Styles for Netscape Navigator 4.x
Recipe 11.2. Delivering Specific Styles to Internet Explorer 5.x for Windows
Recipe 11.3. Removing Web Page Flicker in Internet Explorer 5.x for Windows
Recipe 11.4. Keeping Background Images Stationary in Internet Explorer 6 for Windows
Recipe 11.5. Using Internet Explorer for Windows' Conditional Comments to Deliver Styles
Recipe 11.6. Keeping CSS Rules from Internet Explorer 5 for Macintosh
Recipe 11.7. Setting Up an Intelligent Hack Management System
Recipe 11.8. Diagnosing CSS Bugs and Browser Issues
Recipe 11.9. Testing a Site Design on More Than One Platform with Only One Computer
Recipe 11.10. Installing More Than One Version of Internet Explorer for Windows on a Computer
Recipe 11.11. Testing a Web Site with a Text Browser
Chapter 12. Designing with CSS
Section 12.0. Introduction
Recipe 12.1. Enlarging Text Excessively
Recipe 12.2. Creating Unexpected Incongruity
Recipe 12.3. Combining Unlike Elements to Create Contrast
Recipe 12.4. Leading the Eye with Contrast
Recipe 12.5. Checking for Enough Color Contrast
Recipe 12.6. Emphasizing a Quotation



Module III: PHP and Apache
Part I: Installation
Task1. Installing and Configuring Apache
Choosing the Appropriate Installation Method
Installing Apache on Linux/Unix
Installing Apache on Windows
Apache Configuration File Structure
Apache Log Files
Apache-Related Commands
Starting Apache for the First Time
Troubleshooting
Summary

Task 2. Installing and Configuring PHP
Building PHP on Linux/Unix with Apache
Installing PHP Files on Windows
php.ini Basics
Testing Your Installation
Getting Installation Help
The Basics of PHP Scripts
Summary



Part II: Basic Language Elements
Task 3. The Building Blocks of PHP
Variables
Data Types
Operators and Expressions
Constants
Summary


Task 4. Flow Control Functions in PHP
Switching Flow
Loops
Code Blocks and Browser Output
Summary


Task 5. Working with Functions
What Is a Function?
Calling Functions
Defining a Function
Returning Values from User-Defined Functions
Dynamic Function Calls
Variable Scope
Saving State Between Function Calls with the static Statement
More About Arguments
Creating Anonymous Functions
Testing for the Existence of a Function
Summary


Task 6. Learning Basic SQL Commands
Learning the MySQL Data Types
Learning the Table Creation Syntax
Using the INSERT Command
Using the SELECT Command
Using WHERE in Your Queries
Selecting from Multiple Tables
Using JOIN
Using the UPDATE Command to Modify Records
Using the REPLACE Command
Using the DELETE Command
Summary


Task 7. Interacting with MySQL Using PHP
Connecting to MySQL with PHP
Working with MySQL Data
Summary


Part III: Getting Involved with the Code
Task 8. Working with Forms
Predefined Variables
Creating a Simple Input Form
Accessing Form Input with User-Defined Arrays
Combining HTML and PHP Code on a Single Page
Using Hidden Fields to Save State
Redirecting the User
Sending Mail on Form Submission
Creating the Form
Creating the Script to Send the Mail
Working with File Uploads
Summary


Task 9. Working with Files
Including Files with include()
include_once()
Testing Files
Creating and Deleting Files
Opening a File for Writing, Reading, or Appending
Reading from Files
Writing or Appending to a File
Working with Directories
Summary


Task 10. Working with Dates and Times
Using Date and Time Functions in PHP
Using Date and Time Functions in MySQL
Summary


Task 11. Creating a Simple Calendar
Building a Simple Display Calendar
Creating a Calendar Library
Summary


Task 12. Working with Strings
Formatting Strings with PHP
Investigating Strings in PHP
Manipulating Strings with PHP
Frequently Used String Functions in MySQL
Summary


Task 13. Creating a Simple Discussion Forum
Types of Table Relationships
Understanding Normalization
Following the Design Process
Creating a Discussion Forum
Summary


Task 14. Restricting Access to Your Applications
Authentication Overview
Apache Authentication Module Functionality
Using Apache for Access Control
Combining Apache Access Methods
Limiting Access Based on HTTP Methods
Introducing Cookies
Setting a Cookie with PHP
Restricting Access Based on Cookie Values
Summary

Task 15. Working with User Sessions
Session Function Overview
Starting a Session
Working with Session Variables
Passing Session IDs in the Query String
Destroying Sessions and Unsetting Variables

Module IV: Javascript

Part 1: JavaScript Basics
Task 1: Creating a scriptBlock 2
Task 2: Hiding Your JavaScript Code 4
Task 3: Providing Alternatives to Your JavaScript Code 6
Task 4: Including Outside Source Code 8
Task 5: Commenting Your Scripts 10
Task 6: Writing a JavaScript Command 12
Task 7: Temporarily Removing a Command from a Script 14
Task 8: Using Curly Brackets 16
Task 9: Writing Output to the Browser 18
Task 10: Creating a Variable 20
Task 11: Outputting a Variable 22
Task 12: Creating a String 24
Task 13: Creating a Numeric Variable 26
Task 14: Performing Math 28
Task 15: Concatenating Strings 30
Task 16: Searching for Text in Strings 32
Task 17: Replacing Text in Strings 34
Task 18: Formatting Strings 36
Task 19: Applying Multiple Formatting Functions to a String 38
Task 20: Creating Arrays 40
Task 21: Populating an Array 42
Task 22: Sorting an Array 44
Task 23: Splitting a String at a Delimiter 46
Task 24: Calling Functions 48
Task 25: Alerting the User 50
Task 26: Confirming with the User 52
Task 27: Creating Your Own Functions 54
Task 28: Passing an Argument to Your Functions 56
Task 29: Returning Values from Your Functions 58
Task 30: Passing Multiple Parameters to Your Functions 60
Task 31: Calling Functions from Tags 62
Task 32: Calling Your JavaScript Code after the Page Has Loaded 64
Task 33: Using forLoops 66
Task 34: Testing Conditions with if 68
Task 35: Using Short-Form Condition Testing 70
Task 36: Looping on a Condition 72
Task 37: Looping through an Array 74
Task 38: Scheduling a Function for Future Execution 76
Task 39: Scheduling a Function for Recurring Execution 78
Task 40: Canceling a Scheduled Function 80
Task 41: Adding Multiple Scripts to a Page 82
Task 42: Calling Your JavaScript Code after the Page Has Loaded 84
Task 43: Check If Java Is Enabled with JavaScript 86
Part 2: Outputting to the Browser
Task 44: Accessing the documentObject 90
Task 45: Outputting Dynamic HTML 92
Task 46: Including New Lines in Output 94
Task 47: Outputting the Date to the Browser 96
Task 48: Outputting the Date and Time in a Selected Time Zone 98
Task 49: Controlling the Format of Date Output 100
Task 50: Customizing Output by the Time of Day 102
Task 51: Generating a Monthly Calendar 104
Task 52: Customizing Output Using URL Variables 106
Task 53: Dynamically Generating a Menu 108
Task 54: Replacing the Browser Document with a New Document 110
Task 55: Redirecting the User to a New Page 112
Task 56: Creating a “Page Loading ...” Placeholder 114
Part 3: Images and Rollovers
Task 57: Accessing an HTML-Embedded Image in JavaScript 118
Task 58: Loading an Image Using JavaScript 120
Task 59: Detecting MouseOver Events on Images 122
Task 60: Detecting Click Events on Images 124
Task 61: Switching an Image Programatically 126
Task 62: Using Multiple Rollovers in One Page 128
Task 63: Displaying a Random Image 130
Task 64: Displaying Multiple Random Images 132
Task 65: Using a Function to Create a Rollover 134
Task 66: Using a Function to Trigger a Rollover 136
Task 67: Using Functions to Create Multiple Rollovers in One Page 138
Task 68: Creating a Simple Rollover Menu System 140
Task 69: Creating a Slide Show in JavaScript 142
Task 70: Randomizing Your Slide Show 144
Task 71: Triggering Slide Show Transitions from Links 146
Task 72: Including Captions in a Slide Show 148
Task 73: Testing If an Image Is Loaded 150
Task 74: Triggering a Rollover in a Different Location with a Link 152
Task 75: Using Image Maps and Rollovers Together 154
Task 76: Generating Animated Banners in JavaScript 156
Task 77: Displaying a Random Banner Ad 158
Part 4: Working with Forms
Task 78: Preparing Your Forms for JavaScript 162
Task 79: Accessing Text Field Contents 164
Task 80: Dynamically Updating Text Fields 166
Task 81: Detecting Changes in Text Fields 168
Task 82: Accessing Selection Lists 170
Task 83: Programmatically Populating a Selection List 172
Task 84: Dynamically Changing Selection List Content 174
Task 85: Detecting Selections in Selection Lists 176
Task 86: Updating One Selection List Based on Selection in Another 178
Task 87: Using Radio Buttons instead of Selection Lists 180
Task 88: Detecting the Selected Radio Button 182
Task 89: Detecting Change of Radio Button Selection 184
Task 90: Updating or Changing Radio Button Selection 186
Task 91: Creating Check Boxes 188
Task 92: Detecting Check Box Selections 190
Task 93: Changing Check Box Selections 192
Task 94: Detecting Changes in Check Box Selections 194
Task 95: Verifying Form Fields in JavaScript 196
Task 96: Using the onSubmit Attribute of the Form Tag to Verify Form Fields
Task 97: Verifying Form Fields Using INPUT TYPE=”button”
Instead of TYPE=”submit” 200
Task 98: Validating E-mail Addresses 202
Task 99: Validating Zip Codes 204
Task 100: Validating Phone Numbers 206
Task 101: Validating Credit Card Numbers 208
Task 102: Validating Selection List Choices 210
Task 103: Validating Radio Button Selections 212
Task 104: Validating Check Box Selections 214
Task 105: Validating Passwords 216
Task 106: Validating Phone Numbers with Regular Expressions 218
Task 107: Creating Multiple Form Submission Buttons Using
INPUT TYPE=”button”Buttons 220
Task 108: Reacting to Mouse Clicks on Buttons 222
Task 109: Using Graphical Buttons in JavaScript 224
Task 110: Controlling the Form Submission URL 226
Task 111: Validating a Numeric Text Field with Regular Expressions 228
Task 112: Encrypting Data before Submitting It 230
Task 113: Using Forms for Automatic Navigation Jumping 232
Part 5: Manipulating Browser Windows
Task 114: Using the WindowObject 236
Task 115: Popping Up an Alert Dialog Box 238
Task 116: Popping Up Confirmation Dialog Boxes 240
Task 117: Popping Up JavaScript Prompts 242
Task 118: Creating New Browser Windows 244
Task 119: Opening a New Browser Window from a Link 246
Task 120: Setting the Size of New Browser Windows 248
Task 121: Setting the Location of New Browser Windows 250
Task 122: Controlling Toolbar Visibility for New Browser Windows 252
Task 123: Determining the Availability of Scroll Bars for New Browser Windows 254
Task 124: Restricting Resizing of New Browser Windows 256
Task 125: Loading a New Document into a Browser Window 258
Task 126: Controlling Window Scrolling from JavaScript 260
Task 127: Opening a Full-Screen Window in Internet Explorer 262
Task 128: Handling the Parent-Child Relationship of Windows 264
Task 129: Updating One Window’s Contents from Another 266
Task 130: Accessing a Form in Another Browser Window 268
Task 131: Closing a Window in JavaScript 270
Task 132: Closing a Window from a Link 272
xiv JavaScript in 10 Simple Steps or Less
Task 133: Creating Dependent Windows in Netscape 274
Task 134: Sizing a Window to Its Contents in Netscape 276
Task 135: Loading Pages into Frames 278
Task 136: Updating One Frame from Another Frame 280
Task 137: Sharing JavaScript Code between Frames 282
Task 138: Using Frames to Store Pseudo-Persistent Data 284
Task 139: Using One Frame for Your Main JavaScript Code 286
Task 140: Using a Hidden Frame for Your JavaScript Code 288
Task 141: Working with Nested Frames 290
Task 142: Updating Multiple Frames from a Link 292
Task 143: Dynamically Creating Frames in JavaScript 294
Task 144: Dynamically Updating Frame Content 296
Task 145: Referring to Unnamed Frames Numerically 298
Part 6: Manipulating Cookies
Task 146: Creating a Cookie in JavaScript 302
Task 147: Accessing a Cookie in JavaScript 304
Task 148: Displaying a Cookie 306
Task 149: Controlling the Expiry of a Cookie 308
Task 150: Using a Cookie to Track a User’s Session 310
Task 151: Using a Cookie to Count Page Access 312
Task 152: Deleting a Cookie 314
Task 153: Creating Multiple Cookies 316
Task 154: Accessing Multiple Cookies 318
Task 155: Using Cookies to Present a Different Home Page for New Visitors 320
Task 156: Creating a Cookie Function Library 322
Task 157: Allowing a Cookie to be Seen for all Pages in a Site 324
Part 7: DHTML and Style Sheets 327
Task 158: Controlling Line Spacing 328
Task 159: Determining an Object’s Location 330
Task 160: Placing an Object 332
Task 161: Moving an Object Horizontally 334
Task 162: Moving an Object Vertically 336
Task 163: Moving an Object Diagonally 338
Task 164: Controlling Object Movement with Buttons 340
Task 165: Creating the Appearance of Three-Dimensional Movement 342
Task 166: Centering an Object Vertically 344
Task 167: Centering an Object Horizontally 346
Task 168: Controlling Line Height in CSS 348
Task 169: Creating Drop Shadows with CSS 350
Task 170: Modifying a Drop Shadow 352
Task 171: Removing a Drop Shadow 354
Task 172: Placing a Shadow on a Nonstandard Corner 356
Task 173: Managing Z-Indexes in JavaScript 358
Task 174: Setting Fonts for Text with CSS 360
Task 175: Setting Font Style for Text with CSS 362
Task 176: Controlling Text Alignment with CSS 364
Task 177: Controlling Spacing with CSS 366
Task 178: Controlling Absolute Placement with CSS 368
Task 179: Controlling Relative Placement with CSS 370
Task 180: Adjusting Margins with CSS 372
Task 181: Applying Inline Styles 374
Task 182: Using Document Style Sheets 376
Task 183: Creating Global Style Sheet Files 378
Task 184: Overriding Global Style Sheets for Local Instances 380
Task 185: Creating a Drop Cap with Style Sheets 382
Task 186: Customizing the Appearance of the First Line of Text 384
Task 187: Applying a Special Style to the First Line of Every Element on the Page 386
Task 188: Applying a Special Style to All Links 388
Task 189: Accessing Style Sheet Settings 390
Task 190: Manipulating Style Sheet Settings 392
Task 191: Hiding an Object in JavaScript 394
Task 192: Displaying an Object in JavaScript 396
Task 193: Detecting the Window Size 398
Task 194: Forcing Capitalization with Style Sheet Settings 400
Task 195: Detecting the Number of Colors 402
Task 196: Adjusting Padding with CSS 404
Part 8: Dynamic User Interaction 407
Task 197: Creating a Simple Pull-Down Menu 408
Task 198: Creating Two Pull-Down Menus 410
Task 199: Detecting and Reacting to Selections in a Pull-Down Menu 412
Task 200: Generating a Drop-Down Menu with a Function 414
Task 201: Placing Menu Code in an External File 416
Task 202: Inserting a Prebuilt Drop-Down Menu 418
Task 203: Creating a Floating Window 420
Task 204: Closing a Floating Window 422
xvi JavaScript in 10 Simple Steps or Less
Task 205: Resizing a Floating Window 424
Task 206: Moving a Floating Window 426
Task 207: Changing the Content of a Floating Window 428
Task 208: Detecting Drag and Drop 430
Task 209: Moving a Dragged Object in Drag and Drop 432
Task 210: Changing Cursor Styles 434
Task 211: Determining the Current Scroll Position 436
Task 212: Creating an Expanding/Collapsing Menu 438
Task 213: Creating a Highlighting Menu Using Just Text and CSS—No JavaScript 440
Task 214: Creating a Highlighting Menu Using Text, CSS, and JavaScript 442
Task 215: Placing Content Offscreen 444
Task 216: Sliding Content into View 446
Task 217: Creating a Sliding Menu 448
Task 218: Auto-Scrolling a Page 450
Part 9: Handling Events 453
Task 219: Responding to the onMouseOverEvent 454
Task 220: Taking Action When the User Clicks on an Object 456
Task 221: Responding to Changes in a Form’s Text Field 458
Task 222: Responding to a Form Field Gaining Focus with onFocus 460
Task 223: Taking Action When a Form Field Loses Focus with onBlur 462
Task 224: Post-Processing Form Data with onSubmit 464
Task 225: Creating Code to Load When a Page Loads with onLoad 466
Task 226: Executing Code When a User Leaves a Page for Another 468
Task 227: Taking Action When a User Makes a Selection in a Selection List 470
Part 10: Bookmarklets 473
Task 228: Downloading and Installing Bookmarklets 474
Task 229: Checking Page Freshness with a Bookmarklet 476
Task 230: Checking for E-mail Links with a Bookmarklet 478
Task 231: E-mailing Selected Text with a Bookmarklet in Internet Explorer 480
Task 232: E-mailing Selected Text with a Bookmarklet in Netscape 482
Task 233: Displaying Images from a Page with a Bookmarklet 484
Task 234: Changing Background Color with a Bookmarklet 486
Task 235: Removing Background Images with a Bookmarklet 488
Task 236: Hiding Images with a Bookmarklet 490
Task 237: Hiding Banners with a Bookmarklet 492
Task 238: Opening All Links in a New Window with a Bookmarklet 494
Task 239: Changing Page Fonts with a Bookmarklet 496
Task 240: Highlighting Page Links with a Bookmarklet 498
Task 241: Checking the Current Date and Time with a Bookmarklet 500
Task 242: Checking Your IP Address with a Bookmarklet 502
Task 243: Searching Yahoo! with a Bookmarklet in Internet Explorer 504
Task 244: Searching Yahoo! with a Bookmarklet in Netscape 506
Part 11: Cross-Browser Compatibility and Issues 509
Task 245: Detecting the Browser Type 510
Task 246: Detecting the Browser Version 512
Task 247: Browser Detection Using Object Testing 514
Task 248: Creating Browser Detection Variables 516
Task 249: Dealing with Differences in Object Placement in Newer Browsers 518
Task 250: Creating Layers with the div Tag 520
Task 251: Controlling Layer Placement in HTML 522
Task 252: Controlling Layer Size in HTML 524
Task 253: Controlling Layer Visibility in HTML 526
Task 254: Controlling Layer Ordering in HTML 528
Task 255: Changing Layer Placement and Size in JavaScript 530
Task 256: Changing Layer Visibility in JavaScript 532
Task 257: Changing Layer Ordering in JavaScript 534
Task 258: Fading Objects 536
Task 259: Creating a Page Transition in Internet Explorer 538
Task 260: Installing the X Cross-Browser Compatibility Library 540
Task 261: Showing and Hiding Elements with X 542
Task 262: Controlling Stacking Order with X 544
Task 263: Changing Text Color with X 546
Task 264: Setting a Background Color with X 548
Task 265: Setting a Background Image with X 550
Task 266: Repositioning an Element with X 552
Task 267: Sliding an Element with X 554
Task 268: Changing Layer Sizes with X



Module V: MYSQL

Part I: MySQL Basics
Chapter 1. Installing MySQL
Installing on Linux
Installing on Windows
Installing on OS X
Configuring Your System
Checking Your System Works
Setting the Root Password
Deleting Anonymous Accounts
Creating an Account for Basic Use
Summary


Chapter 2. Quick Tour
MySQL Directory Structure
Overview of Executables
Overview of User Interfaces
Quick Introduction to the MySQL Monitor
Summary



Part II: Designing and Creating Databases with MySQL
Chapter 3. Database Design Crash Course
Database Concepts and Terminology
Database Design Principles
Normalization
Summary

Chapter 4. Creating Databases, Tables, and Indexes
Case Sensitivity
Identifiers in MySQL
Creating a Database
Selecting a Database
Creating Tables
Column and Data Types in MySQL
Creating Indexes
Deleting Databases, Tables, and Indexes
Altering Existing Table Structures
Summary


Part III: Using MySQL
Chapter 5. Inserting, Deleting, and Updating Data
Using INSERT
Using REPLACE
Using DELETE
Using TRUNCATE
Using UPDATE
Uploading Data with LOAD DATA INFILE
Summary

Chapter 6. Querying MySQL
Overview of SELECT
Simple Queries
Selecting Particular Columns
Specifying Absolute Databases and Tables
Aliases
Using the WHERE Clause to Select Particular Rows
Removing Duplicates with DISTINCT
Using the GROUP BY Clause
Selecting Particular Groups with HAVING
Sorting Search Results with ORDER BY
Limiting Search Results with LIMIT
Summary


Chapter 7. Advanced Queries
Using Joins to Run Queries over Multiple Tables
Understanding the Different Join Types
Writing Subqueries
Using SELECT Statement Options
Summary


Chapter 8. Using MySQL Built-In Functions with SELECT
Operators
Control Flow Functions
String Functions
Numeric Functions
Date and Time Functions
Cast Functions
Other Functions
Functions for Use with GROUP BY Clauses
Summary
Part IV: MySQL Table Types and Transactions
Chapter 9. Understanding MySQL's Table Types
ISAM Tables
MyISAM Tables
InnoDB Tables
BerkeleyDB (BDB) Tables
MERGE Tables
HEAP Tables
Summary

Chapter 10. Using Transactions with InnoDB Tables
What Are Transactions?
Using Transactions in MySQL
The InnoDB Transaction Model
Summary


Part V: Administering MySQL
Chapter 11. Managing User Privileges
Creating User Accounts with GRANT and REVOKE
Privilege Levels
Evaluating Privileges
Using the REVOKE Statement
Understanding the Privilege Tables
Summary


Chapter 12. Configuring MySQL
Setting MySQL Configuration Options
Setting InnoDB Configuration Options
Multi-Install Configuration Options
Configuring for Internationalization
Summary


Chapter 13. Administering Your Database
Starting Up and Shutting Down the MySQL Server
Getting Information About the Server and Databases
Setting Variables
Killing Threads
Clearing Caches
Understanding the Log Files
Summary


Chapter 14. Backup and Disaster Recovery
Backing Up and Restoring Your Database
Testing Your Backup
Checking and Repairing Tables
Summary
Chapter 15. Securing Your MySQL Installation
How the Privilege System Works in Practice
Securing Accounts
Securing Your Installation Files
Filtering User Data
Other Tips
Summary


Chapter 16. Replicating Your Database
Replication Principles
Setting Up and Configuring for Replication
Advanced Topologies
Replication Future
Summary


Part VI: Optimizing MySQL
Chapter 17. Optimizing Your MySQL Server Configuration
Compiling and Linking for Speed
Tuning Server Parameters
Tuning Other Factors
Summary


Chapter 18. Optimizing Your Database
What's Slow in MySQL Databases?
Making the Right Design Choices
Indexing for Optimization
ANALYZE TABLE
Using OPTIMIZE TABLE
Summary


Chapter 19. Optimizing Your Queries
Finding Slow Queries
Benchmarking Your Queries
Using the Slow Query Log
Using EXPLAIN to See How Queries Are Executed
Understanding MySQL's Built-In Query Optimization
Optimization Tips
Summary

Module VI: Adobe Photoshop
Part I. Getting Started
Hour 1. The Basics
Finding Your Way Around
The Toolbox
Tool Options Bar
What's on the Menus?
Setting Preferences
Summary
Workshop
Hour 2. Opening and Saving
Working with Files
Saving Your Work
Undoing and Redoing
Summary
Workshop
Hour 3. Making Selections
The Selection Tools
The Selection Menu
Selecting Large Areas
Cutting and Copying
Cropping
Summary
Workshop
Hour 4. Transformations
Resizing
Rotating
Flipping
Selection Transformations
Warp and Liquify
Summary
Workshop
Hour 5. Color Modes and Color Models
Color Models
The Modes and Models of Color
Color Bit Depth and Why It Matters
Summary
Workshop
Hour 6. Adjusting Color
Adjusting by Eye with Variations
Making Other Adjustments
Adjustment Layers
Understanding Channels
Summary
Workshop
Hour 7. Paintbrushes and Art Tools
The Brushes Menu
The Painting Tools
Summary
Workshop
Hour 8. Digital Painting
Foreground and Background Colors
Selecting Colors
Blending Modes
Summary
Workshop
Hour 9. Moving Paint
Smudges
Focus Tools
The Toning Tools
Summary
Workshop
Part II. More Tools and Tricks
Hour 10. Advanced Painting Techniques
Simulating Different Media
Summary
Workshop
Hour 11. Layers
Using the Layers Palette
Working with Multiple Layers
Summary
Workshop
Hour 12. Using Masks
Applying Masks
Using Quick Mask
Layer Masks
Summary
Workshop
Hour 13. Paths
Creating Paths
Editing Paths
Using Paths
Summary
Workshop
Part III. Fun with Filters
Hour 14. Filters That Improve Your Picture
Sharpen Filters
Blur Filters
Fading Filters
Summary
Workshop
Hour 15. Filters to Make Your Picture Artistic
Artistic Filters
Brush Strokes
Sketch Filters
Summary
Workshop
Hour 16. Filters to Distort and Other Funky Effects
Distort Filters
Pixelate Filters
The Stylize Filter
Combining Filters
Summary
Workshop
Part IV. Text Effects and Getting Plugged In
Hour 17. Adding Type to Pictures
The Type Tools
Setting Type
Creating Drop Shadows
Cutting and Filling Type
Adding Glows
Creating Bevel and Emboss Effects
Warping Text
Setting Type on a Path
Checking Your Spelling
Summary
Workshop
Hour 18. Special Effects and Useful Tricks
Glows
Lighting Effects
Reflections
Extracting Selections
Notepad
Contact Sheets and Picture Packages
Working Efficiently
Summary
Workshop
Hour 19. Photoshop Plug-Ins and Add-Ons
Where to Get Plug-Ins
How to Install Plug-Ins
Alien Skin's Eye Candy
Kai's Power Tools
Auto FX Photo/Graphic Edges
Flaming Pear
Genuine Fractals
Andromeda
Digimarc
Summary
Workshop
Part V. Photo Repair and Enhancement
Hour 20. Compositing
Image Sources
Making One Picture from Two
Realistic Composites
Replacing a Background
Composites from Nothing
Photomerge
Summary
Workshop
Hour 21. Photo RepairBlack and White
Easy Fixes
Using the Eyedropper
Using the Clone Stamp
Healing Brush and Patch Tools
Cleaning Up a Picture, Step by Step
Applying Tints
Vignetting
Summary
Workshop
Hour 22. Photo RepairColor
Color Retouching
Removing
Summary
Workshop
Part VI. Picture Publishing on Paper and Otherwise
Hour 23. Printing and Publishing
Choosing a Printer
Preparing to Print
Printing the Page
Preparing the Image
Picking the Paper
Placing Photoshop Images in Other Programs
Summary
Workshop
Hour 24. Photoshop for the Web
Jumping into ImageReady
File Formats and File Size
Preparing Backgrounds
Building Animations
Web Photo Gallery
Creating Slices
Preparing Text for the Web
Emailing Your Pictures
Making Pages Load Faster
Summary
Workshop

Module VII: Flash

Part I. Getting Started with ActionScript
Hour 1. Your First Look at ActionScript
What Scripts Are
What Scripts Can Do
Where Scripts Go
Task: Your First Script


Hour 2. Using the Script Editing Window
Accessing the Actions Panel
Normal Mode
Task: Writing Code in Normal Mode
Using Flash's Help System
Expert Mode
Task: Writing Code in Expert Mode
Summary


Hour 3. Learning to Program
How Computers Think
Commands, Functions and Operations
Variables
Conditions
Loops
Achieving the Impossible
Writing Bug-Free Code
Summary


Hour 4. Writing Code in Flash
Parts of a Script
Output Window
Task: Send a Message to the Output Window
Local and Global Variables
Comparisons and Operations
Task: Operations Quiz
Conditions
Loops
Functions
Dot Syntax
Comments
Debugging
Summary



Part II. Navigation and Animation with ActionScript
Hour 5. Controlling the Flow of the Movie
Stopping the Movie
Jumping from Frame to Frame
Creating Buttons
Task: Slideshow
Task: Simple Presentation
Summary


Hour 6. Controlling Movie Clips
Telling Movie Clips What to Do
Task: Animation Playback Controller
Targeting Movie Clips
Movie Clip Scripts
Task: Backward Movie Clip
Task: Clips Controlling Other Clips
Summary


Hour 7. Moving and Changing Movie Clips
Position
Task: Bouncing Ball
Mouse Location
Task: Follow the Mouse
Move Clip Rotation
Task: A Rotating Movie Clip
Stretching and Shrinking Movie Clips
Task: Simulated 3D Scaling
Visibility
Task: Fading Movie Clip
Summary


Hour 8. Selecting and Dragging Movie Clips
Selection
Task: Keypad Lock
Dragging
Drag and Drop
Task: Matching Game
Summary



Part III. Manipulating Information with ActionScript
Hour 9. Getting Input from the User
Detecting Keypresses
Task: Keyboard-Controlled Movie Clip
Input Text
String Operations and Functions
Task: User Input Form
Summary


Hour 10. Creating and Controlling Text
Dynamic Text
External Variables
Task: News Ticker
Task: Flashy Text
Summary


Hour 11. Working with Numbers
Numerical Operators and Functions
Trigonometry Functions
Strings and Numbers
Random Numbers
Task: Simple Calculator
Task: Orbiting Planets
Task: Random Snowflakes


Hour 12. Objects and Arrays
Custom Variable Objects
Color Objects
Date Objects
Arrays
Task: Word Animation
Task: Dragging with Trails
Summary


Part IV. User Interface Elements
Hour 13. Rollovers
Creating Custom Cursors
Task: Full-Time Custom Cursor
Task: Rollover Custom Cursor
Information Rollovers
Task: Quick Reference Application
Summary


Hour 14. Scrolling
Scrollbar Elements
Dynamic Text Scrolling
Task: Simple Text Scrolling
Task: Full-Featured Text Scrolling
Summary
Q&A
Workshop

Hour 15. User Input Elements
Check Boxes
Radio Buttons
Task: Simple Survey
Input Text Tab Order
Restricting Text Input
Task: Checking for a Valid Input
Summary


Hour 16. Pull-Down Menus and Dynamic Buttons
Simple Pull-Down Menus
Task: Using Pull-Down Menus
Push Pull-Down Menus
Dynamic Buttons
Task: Using Dynamic Buttons
Summary




Part V. Controlling External Events with ActionScript
Hour 17. Browser Navigation and Communication
Loading Browser Pages
Task: Navigation Bar
ActionScript and JavaScript
Task: Open a New Window
Task: JavaScript-Controlled Slideshow
Special Projector Commands
Summary


Hour 18. Sending Information to the Server
The LoadVars Object
Server-Side Applications
Task: Recording Survey Results
Summary


Hour 19. Using XML with Flash
XML Basics
The XML Object
Task: XML-Powered Display
Recursive XML Parsing
Summary


Hour 20. Printing
Setting Up Your Movie for Printing
The Print Commands
Task: Printable Form
Summary


Part VI. Advanced Topics
Hour 21. Using Components
ActionScript for Flash's Built-In Components
Task: Form with Components
Changing the Style of a Component
Summary

Hour 22. Controlling Sound with ActionScript
Playing a Sound
Task: Panning Sound
Sound Transforms
Task: Beat Box
Summary


Hour 23. Managing Movie Streaming
Monitoring Loading
Task: Simple Loader
Task: Complex Loader
Loading External Media
Summary

Hour 24. Drawing with ActionScript
Drawing Lines
Task: Allowing the User to Draw
Creating New Movie Clips
Task: Dynamic Snowflakes
Creating Text
Task: Flying Words
Summary


Module VIII: Real-life Project