| Introduction |
|
ix | |
|
Chapter 1 Introduction to PHP |
|
|
1 | (34) |
|
|
|
2 | (4) |
|
Sending Data to the Browser |
|
|
6 | (4) |
|
|
|
10 | (4) |
|
|
|
14 | (4) |
|
|
|
18 | (3) |
|
|
|
21 | (2) |
|
|
|
23 | (3) |
|
|
|
26 | (3) |
|
Single vs. Double Quotation Marks |
|
|
29 | (3) |
|
|
|
32 | (2) |
|
|
|
34 | (1) |
|
Chapter 2 Programming with PHP |
|
|
35 | (40) |
|
|
|
36 | (5) |
|
|
|
41 | (4) |
|
Conditionals and Operators |
|
|
45 | (4) |
|
|
|
49 | (6) |
|
|
|
55 | (15) |
|
|
|
70 | (3) |
|
|
|
73 | (2) |
|
Chapter 3 Creating Dynamic Web Sites |
|
|
75 | (38) |
|
|
|
76 | (9) |
|
Handling HTML Forms, Revisited |
|
|
85 | (6) |
|
|
|
91 | (4) |
|
Creating Your Own Functions |
|
|
95 | (17) |
|
|
|
112 | (1) |
|
Chapter 4 Introduction to MySQL |
|
|
113 | (18) |
|
|
|
114 | (2) |
|
Choosing Your Column Types |
|
|
116 | (4) |
|
Choosing Other Column Properties |
|
|
120 | (3) |
|
|
|
123 | (7) |
|
|
|
130 | (1) |
|
Chapter 5 Introduction to SQL |
|
|
131 | (36) |
|
Creating Databases and Tables |
|
|
132 | (3) |
|
|
|
135 | (5) |
|
|
|
140 | (2) |
|
|
|
142 | (3) |
|
|
|
145 | (2) |
|
|
|
147 | (2) |
|
|
|
149 | (2) |
|
|
|
151 | (2) |
|
|
|
153 | (2) |
|
|
|
155 | (11) |
|
|
|
166 | (1) |
|
Chapter 6 Database Design |
|
|
167 | (38) |
|
|
|
168 | (13) |
|
|
|
181 | (3) |
|
Using Different Table Types |
|
|
184 | (2) |
|
|
|
186 | (5) |
|
|
|
191 | (6) |
|
|
|
197 | (7) |
|
|
|
204 | (1) |
|
Chapter 7 Advanced SQL and MySQL |
|
|
205 | (38) |
|
|
|
206 | (10) |
|
Grouping Selected Results |
|
|
216 | (4) |
|
|
|
220 | (4) |
|
Performing FULLTEXT Searches |
|
|
224 | (8) |
|
|
|
232 | (4) |
|
|
|
236 | (3) |
|
|
|
239 | (3) |
|
|
|
242 | (1) |
|
Chapter 8 Error Handling and Debugging |
|
|
243 | (24) |
|
Error Types and Basic Debugging |
|
|
244 | (6) |
|
|
|
250 | (2) |
|
Adjusting Error Reporting in PHP |
|
|
252 | (3) |
|
Creating Custom Error Handlers |
|
|
255 | (5) |
|
|
|
260 | (4) |
|
SQL and MySQL Debugging Techniques |
|
|
264 | (2) |
|
|
|
266 | (1) |
|
Chapter 9 Using PHP with MySQL |
|
|
267 | (38) |
|
|
|
268 | (2) |
|
|
|
270 | (5) |
|
|
|
275 | (9) |
|
|
|
284 | (4) |
|
|
|
288 | (5) |
|
Counting Returned Records |
|
|
293 | (3) |
|
Updating Records with PHP |
|
|
296 | (8) |
|
|
|
304 | (1) |
|
Chapter 10 Common Programming Techniques |
|
|
305 | (32) |
|
Sending Values to a Script |
|
|
306 | (4) |
|
|
|
310 | (6) |
|
|
|
316 | (7) |
|
|
|
323 | (8) |
|
|
|
331 | (5) |
|
|
|
336 | (1) |
|
Chapter 11 Web Application Development |
|
|
337 | (44) |
|
|
|
338 | (6) |
|
|
|
344 | (12) |
|
|
|
356 | (8) |
|
Understanding HTTP Headers |
|
|
364 | (6) |
|
|
|
370 | (4) |
|
|
|
374 | (6) |
|
|
|
380 | (1) |
|
Chapter 12 Cookies and Sessions |
|
|
381 | (36) |
|
|
|
382 | (3) |
|
Making the Login Functions |
|
|
385 | (5) |
|
|
|
390 | (14) |
|
|
|
404 | (8) |
|
Improving Session Security |
|
|
412 | (4) |
|
|
|
416 | (1) |
|
Chapter 13 Security Methods |
|
|
417 | (42) |
|
|
|
418 | (7) |
|
|
|
425 | (6) |
|
|
|
431 | (4) |
|
|
|
435 | (3) |
|
Using the Filter Extension |
|
|
438 | (4) |
|
Preventing SQL Injection Attacks |
|
|
442 | (7) |
|
Securing Passwords with PHP |
|
|
449 | (9) |
|
|
|
458 | (1) |
|
Chapter 14 Perl-Compatible Regular Expressions |
|
|
459 | (24) |
|
|
|
460 | (4) |
|
|
|
464 | (3) |
|
|
|
467 | (2) |
|
|
|
469 | (3) |
|
|
|
472 | (4) |
|
|
|
476 | (2) |
|
Matching and Replacing Patterns |
|
|
478 | (4) |
|
|
|
482 | (1) |
|
Chapter 15 Introducing jQuery |
|
|
483 | (36) |
|
|
|
484 | (2) |
|
|
|
486 | (3) |
|
|
|
489 | (3) |
|
|
|
492 | (3) |
|
|
|
495 | (4) |
|
|
|
499 | (6) |
|
|
|
505 | (13) |
|
|
|
518 | (1) |
|
|
|
519 | (28) |
|
|
|
520 | (3) |
|
|
|
523 | (15) |
|
|
|
538 | (8) |
|
|
|
546 | (1) |
|
Chapter 17 Example---Message Board |
|
|
547 | (40) |
|
|
|
548 | (8) |
|
|
|
556 | (9) |
|
|
|
565 | (1) |
|
|
|
566 | (5) |
|
|
|
571 | (5) |
|
|
|
576 | (10) |
|
|
|
586 | (1) |
|
Chapter 18 Example---User Registration |
|
|
587 | (48) |
|
|
|
588 | (6) |
|
Writing the Configuration Scripts |
|
|
594 | (8) |
|
|
|
602 | (2) |
|
|
|
604 | (10) |
|
|
|
614 | (3) |
|
Logging In and Logging Out |
|
|
617 | (7) |
|
|
|
624 | (10) |
|
|
|
634 | (1) |
|
|
|
635 | (27) |
|
|
|
636 | (3) |
|
|
|
639 | (2) |
|
|
|
641 | (5) |
|
Testing Your Installation |
|
|
646 | (3) |
|
|
|
649 | (3) |
|
|
|
652 | (10) |
| Index |
|
662 | |