Acknowledgments |
|
xv | |
Introduction |
|
xvii | |
|
|
|
1 Setting Up Your Workstation |
|
|
5 | (30) |
|
Picking a Development Tool |
|
|
6 | (15) |
|
Full-Featured Development Packages |
|
|
7 | (1) |
|
|
8 | (13) |
|
Choosing a Testing Server |
|
|
21 | (8) |
|
|
29 | (6) |
|
|
30 | (1) |
|
Considering Other Factors |
|
|
31 | (4) |
|
2 Building Web Pages with HTML |
|
|
35 | (40) |
|
|
37 | (33) |
|
|
38 | (1) |
|
|
39 | (4) |
|
|
43 | (1) |
|
|
44 | (1) |
|
|
44 | (1) |
|
|
44 | (5) |
|
Applying Character Styles |
|
|
49 | (2) |
|
Displaying Special Characters |
|
|
51 | (2) |
|
Working with Images and Image Maps |
|
|
53 | (1) |
|
Adding Hyperlinks and Bookmarks |
|
|
54 | (2) |
|
|
56 | (4) |
|
|
60 | (2) |
|
|
62 | (7) |
|
Understanding Deprecated HTML Tags |
|
|
69 | (1) |
|
|
70 | (5) |
|
|
75 | (46) |
|
|
77 | (8) |
|
|
77 | (3) |
|
|
80 | (1) |
|
|
81 | (4) |
|
CSS Properties and Values |
|
|
85 | (36) |
|
|
85 | (7) |
|
|
92 | (4) |
|
Implementing Page Properties |
|
|
96 | (4) |
|
|
100 | (21) |
|
4 Adding Dynamic Elements with JavaScript |
|
|
121 | (66) |
|
|
123 | (2) |
|
Characteristics of JavaScript |
|
|
123 | (2) |
|
|
125 | (6) |
|
Using JavaScript with HTML Pages |
|
|
125 | (1) |
|
|
126 | (3) |
|
Writing and Testing JavaScript |
|
|
129 | (2) |
|
|
131 | (13) |
|
|
131 | (3) |
|
|
134 | (4) |
|
Statements and Expressions |
|
|
138 | (1) |
|
|
138 | (3) |
|
|
141 | (3) |
|
|
144 | (8) |
|
|
145 | (2) |
|
While and Do-While Statements |
|
|
147 | (1) |
|
|
148 | (1) |
|
|
149 | (3) |
|
Introducing Event Handlers |
|
|
152 | (1) |
|
Placing Event Handlers in Your Code |
|
|
152 | (1) |
|
Understanding Event Handler Syntax and Usage |
|
|
153 | (1) |
|
Working with the Window Event Handlers |
|
|
153 | (5) |
|
Displaying Messages When a Page Opens/Closes |
|
|
153 | (2) |
|
Placing and Removing Focus |
|
|
155 | (1) |
|
|
156 | (2) |
|
Using the Mouse and Keyboard Event Handlers |
|
|
158 | (7) |
|
Working with onclick, ondblclick, and Arrays |
|
|
158 | (3) |
|
Moving the Mouse Pointer to Trigger Events |
|
|
161 | (1) |
|
Using the Keyboard Event Handlers |
|
|
162 | (3) |
|
|
165 | (4) |
|
|
165 | (2) |
|
Creating Forms Using HTML |
|
|
167 | (2) |
|
Using JavaScript in Forms |
|
|
169 | (10) |
|
Naming Forms on a Web Page |
|
|
170 | (1) |
|
Form Properties and Methods |
|
|
171 | (4) |
|
Working with Form Element Properties and Methods |
|
|
175 | (4) |
|
|
179 | (8) |
|
|
179 | (1) |
|
Using Validation with Passwords |
|
|
179 | (8) |
|
PART II Exercising the Server with PHP |
|
|
|
|
187 | (40) |
|
|
188 | (1) |
|
|
189 | (8) |
|
Preparing a PHP Workstation |
|
|
190 | (7) |
|
|
197 | (10) |
|
Integrating PHP with HTML |
|
|
198 | (2) |
|
|
200 | (3) |
|
|
203 | (4) |
|
|
207 | (20) |
|
|
207 | (2) |
|
|
209 | (1) |
|
|
210 | (4) |
|
Statements and Expressions |
|
|
214 | (1) |
|
|
214 | (13) |
|
6 PHP Control and File Handling |
|
|
227 | (30) |
|
|
229 | (9) |
|
|
229 | (3) |
|
While and do-while Statements |
|
|
232 | (2) |
|
For and foreach Statements |
|
|
234 | (2) |
|
|
236 | (2) |
|
PHP File and Directory Management |
|
|
238 | (8) |
|
|
238 | (4) |
|
Additional File Functions |
|
|
242 | (4) |
|
Cookies and Session and Server Variables |
|
|
246 | (11) |
|
|
247 | (2) |
|
|
249 | (3) |
|
|
252 | (5) |
|
|
257 | (36) |
|
|
258 | (21) |
|
|
259 | (1) |
|
|
260 | (1) |
|
|
261 | (4) |
|
|
265 | (3) |
|
|
268 | (1) |
|
Converting Arrays To and From Strings |
|
|
269 | (2) |
|
Joining and Splitting Arrays |
|
|
271 | (4) |
|
|
275 | (3) |
|
Handling Multidimensional Arrays |
|
|
278 | (1) |
|
Building and Handling Forms |
|
|
279 | (14) |
|
|
280 | (2) |
|
|
282 | (3) |
|
Accepting and Filing Form Data in PHP |
|
|
285 | (8) |
|
|
293 | (16) |
|
|
294 | (15) |
|
|
296 | (1) |
|
|
297 | (4) |
|
|
301 | (3) |
|
|
304 | (5) |
|
PART III Creating and Using Relational Databases with MySQL |
|
|
|
9 Introduction to Relational Databases |
|
|
309 | (24) |
|
Databases and Relational Databases |
|
|
310 | (2) |
|
|
310 | (2) |
|
Understanding a Relational Database |
|
|
312 | (1) |
|
|
312 | (21) |
|
Get and Install phpMyAdmin |
|
|
312 | (4) |
|
Opening and Exploring phpMy Admin |
|
|
316 | (4) |
|
Create and Use a Database in phpMy Admin |
|
|
320 | (13) |
|
10 Fundamentals of MySQL and SQL |
|
|
333 | (36) |
|
|
334 | (14) |
|
Installing and Using MySQL Workbench |
|
|
335 | (4) |
|
|
339 | (3) |
|
|
342 | (6) |
|
Exploring the MySQL Language |
|
|
348 | (21) |
|
Reviewing MySQL Word Usage |
|
|
349 | (2) |
|
|
351 | (3) |
|
Exploring MySQL Functions |
|
|
354 | (15) |
|
11 Implementing MySQL Command Statements |
|
|
369 | (36) |
|
|
370 | (4) |
|
Understanding the MySQL Command Structure |
|
|
371 | (2) |
|
Preparing the MySQL Workbench |
|
|
373 | (1) |
|
Create Databases and Tables |
|
|
374 | (5) |
|
Creating and Using a Database |
|
|
374 | (1) |
|
Creating a Table and Its Columns |
|
|
374 | (4) |
|
Reviewing MySQL Data Types |
|
|
378 | (1) |
|
|
379 | (2) |
|
|
379 | (2) |
|
Select, Replace, Update, and Delete Data in Tables |
|
|
381 | (11) |
|
|
382 | (3) |
|
|
385 | (3) |
|
|
388 | (2) |
|
|
390 | (2) |
|
Alter, Rename, and Drop Tables and Databases |
|
|
392 | (4) |
|
Altering Tables and Databases |
|
|
393 | (2) |
|
|
395 | (1) |
|
Dropping Tables and Databases |
|
|
395 | (1) |
|
Create and Use Events, Views, and Triggers |
|
|
396 | (9) |
|
|
396 | (3) |
|
|
399 | (1) |
|
|
400 | (5) |
|
PART IV Powering Databases with MySQL and PHP |
|
|
|
12 Using a MySQL Database with PHP |
|
|
405 | (20) |
|
Bringing PHP and MySQL Together |
|
|
406 | (11) |
|
|
407 | (5) |
|
|
412 | (2) |
|
|
414 | (1) |
|
Combining PHP MySQL Functions |
|
|
415 | (2) |
|
Working with Forms and Databases |
|
|
417 | (8) |
|
Expanding PHP Form Handling |
|
|
417 | (1) |
|
Facilitating User Interaction |
|
|
418 | (1) |
|
Interacting with a Database |
|
|
419 | (1) |
|
|
419 | (6) |
|
13 Registering and Responding to Users |
|
|
425 | (74) |
|
|
427 | (17) |
|
|
428 | (11) |
|
|
439 | (5) |
|
|
444 | (55) |
|
Administrator Authentication |
|
|
444 | (14) |
|
Database Entry and Maintenance |
|
|
458 | (41) |
|
14 Handling Online Purchases |
|
|
499 | (52) |
|
|
502 | (10) |
|
|
502 | (6) |
|
|
508 | (4) |
|
Creating the Book List and Customer Sales Scripts |
|
|
512 | (26) |
|
|
513 | (3) |
|
Customer Sign-in and Verification |
|
|
516 | (17) |
|
|
533 | (5) |
|
|
538 | (13) |
|
|
538 | (6) |
|
|
544 | (1) |
|
Writing an Invoice Record |
|
|
545 | (6) |
Index |
|
551 | |