Tài liệu How to create Web sites and applications with HTML, CSS, Javascript, PHP and MySQL

Contents 3
About TheWeb Book 8
Our Recommended Hosting Companies .9
Who’s Written This Book? And Why ? 9
Why We’re Here . 10
From Word Processor to Web Site .13
But How Long will All This Take? .14
What Is aWeb Site Anyway? . 15
How the Web Works 15
Domain Names 16
The Simple Option 20
The Flexible Option .21
About Web Content . 24
Do you need a development server? . 25
Getting Everything Together .26
Domain Name and Hosting .28
It’s Not Rude to Point 35
Some More About Hosting 37
Shared Hosting . 37
Reseller Hosting . 38
Dedicated Servers . 38
Virtual Servers 39
Shared Hosting Signup with Site5 40
HTML Editor and FTP Client .46
Amaya . 47
Make A Web Work Folder . 47
Filezilla 47
Your First Web Page with Hostmonster 51
Your First Page with Site5 .56
Now step away from the computer! 59
WWW – What, Why , Who? . 59
Importing Existing Content .60
Writing For The Web .61
Fonts and Colours . 62
Hyperlinks 63
Linking to Other Sites . 65
Mailto: Links 65
Understanding The Basics ofHTML .67
Meta tags . 70
HTML Accessibility , Accuracy and Privacy 71
Validating your HTML .71
A Bit More about Accessibility . 72
Cascading Style Sheets .74
About DOCTY PEs . 75
Getting Started with CSS . 75
A Word About Fonts . 82
Classes . 84
Making Sty les Work For You . 85
HTML Tags Names .86
A Better CSS Editor .86
ID-based Sty les .89
Extreme CSS 90
Page Layouts and Div Tags 93
The CSS Box Model .98
Pictures On Pages .99
About Image Sizes 100
Pictures As Links . 101
Finding Images to Use on Your Site .102
A Browser Icon for your Site .103
Short Cuts to Great Web Pages . 107
Using an Open Source Design .109
Tweaking the Text 110
Changing the Pictures .111
Changing the CSS Sty les . 112
Which Sty le Is This? . 114
Adding Pages and Navigation . 116
Uploading the Finished Files 120
Rules,Tables and Image Maps 122
Horizontal Rules 122
Tables .124
Image Maps 126
Password-Protecting yourWeb Pages 129
The .htaccess File .129
The .htpasswd File . 131
Protecting Multiple Folders 133
CMSes and Other Software 134
CMSes and Templates 136
Automatic Installers . 137
Try Before You Install 138
A Word about Patching 140
Setting Up A Database 140
General Installation Procedures 143
Uninstalling 143
Joomla . 145
Uploading the Files 145
Configuring Joomla .146
Your New Joomla Site 152
WordPress 157
Downloading the Software 157
Make a Database 157
Configure WordPress . 157
Upload The Software 159
Final Configuration 159
phpBB 164
File Permissions 165
Plogger . 172
Getting Started 172
The Installation Process . 174
Uploading Your Pictures 176
Avoiding Data Overload . 178
Installing the PSPad Editor .180
Javascript 184
Choose Your Side .184
Javascript and Semicolons .192
Email Address Obfuscation 192
Why Upload? .193
Security and Cookies 194
Morning All! 196
Getting the Screen Size . 197
Javascript Toolkits and Frameworks . 197
Finding Out More 198
Web-hosted Databases with MySQL 200
Databases, Tables, Fields, Rows and Columns 201
Normalization .201
Referential Integrity 204
Creating A Database 205
Port Problems 208
Using phpMyAdmin .210
Creating The Customers Table 211
Inserting Some Data 216
Query ing the Customers Table 219
Introducing PHP . 228
Don’t Panic! . 228
Your First PHP Program . 229
Some More PHP .236
Random Numbers 236
Sending Email with PHP . 240
Passing Information to PHP 243
Never Forget to Sanitize 245
Loop the Loop 248
Arrays .251
User-Defined Functions 255
HTML Forms .257
Creating a Form with Amaya . 259
Naming the Form Objects 262
Handling Form Data and Quote Marks . 265
Testing The Form . 267
Retrieving Textarea and Dropdown Data 270
Checkbox Array s 271
Feedback Forms . 273
Hidden Fields . 274
Accessing MySQL Databases with PHP 276
Counting Rows . 278
Reading Data 280
Searching A Table . 285
Preventing SQL Injection Attacks . 290
Adding Data to a Table .291
Editing a Data Record . 298
Deleting Data . 305
Putting it All Together . 306
Debugging and Global Variables 308
Syntax Errors .308
Coding Errors . 309
The $_SERVER Variables 313
Application Structure Revisited 316
Web Servers and the Real World .317
Saving State .318
How to Back Up yourWeb Site .319
Don't Forget the Data .319
Restoring Lost Information . 322
Promoting and Profiting 323
Promoting Your Site 323
Making Money 325
Accepting Online Payments . 327
Managing your Marketing . 330
Search Engine Optimisation .334
SEO Tips 334
Keeping the Crawlers Away . 336
If at First you Don’t Succeed, Pay 337
The End. So, What Now? .339
Appendix A – Building a Test Server . 340
Our Goal 340
First Install the OS .341
Some Useful Commands . 342
Get Updated . 343
Test Your Web Server 344
Install the Telnet Server 344
An FTP server . 345
Webmin . 347
Webalizer . 348
PHP and MySQL . 349