Hjem

;Advance Praise for Head First PHP & MySQL;Praise for Head First HTML with CSS & XHTML;Praise for Head First JavaScript;Author(s) of Head First PHP & MySQL;How to Use This Book: Intro; Who is this book for?; Who should probably back away from this book?; We know what you''re thinking; We know what your brain is thinking; Metacognition: thinking about thinking; Here''s what WE did:; Here''s what YOU can do to bend your brain into submission; Read Me; The technical review team; Acknowledgments; Safari Books Online;
Chapter 1: Add Life to your Static Pages: It''s Alive;
1.1 HTML is static and boring;
1.2 PHP brings web pages to life;
1.3 Dogs in space;
1.4 A form helps Owen get the whole story;
1.5 Forms are made of HTML;
1.6 The HTML form has problems;
1.7 HTML acts on the CLIENT;
1.8 PHP acts on the SERVER;
1.9 PHP scripts run on the server;
1.10 Use PHP to access the form data;
1.11 PHP scripts must live on a server!;
1.12 Get your PHP scripts to the server;
1.13 The server turns PHP into HTML;
1.14 Deconstructing Owen''s PHP script;
1.15 A few PHP rules to live code by;
1.16 Finding the perfect variable name;
1.17 Variables are for storing script data;
1.18 $-POST is a special variable that holds form data;
1.19 $-POST transports form data to your script;
1.20 Creating the email message body with PHP;
1.21 Even plain text can be formatted... a little;
1.22 Newlines need double-quoted strings;
1.23 Assemble an email message for Owen;
1.24 Variables store the email pieces and parts;
1.25 Sending an email message with PHP;
1.26 Owen starts getting emails;
1.27 Owen starts losing emails;
1.28 Your PHP & MySQL Toolbox;
Chapter 2: Connecting to MySQL: How it fits together;
2.1 Owen''s PHP form works well. Too well...;
2.2 MySQL excels at storing data;
2.3 Owen needs a MySQL database;
2.4 Create a MySQL database and table;
2.5 The INSERT statement in action;
2.6 Use SELECT to get table data;
2.7 Let PHP handle the tedious SQL stuff;
2.8 PHP lets data drive Owen''s web form;
2.9 Connect to your database from PHP;
2.10 Insert data with a PHP script;
2.11 Use PHP functions to talk to the database;
2.12 Get connected with mysqli_connect();
2.13 Build the INSERT query in PHP;
2.14 Query the MySQL database with PHP;
2.15 Close your connection with mysqli-close();
2.16 $-POST provides the form data;
2.17 Owen needs help sifting through his data;
2.18 Owen''s on his way to finding Fang;
Chapter 3: Create and Populate a Database: Creating your own data;
3.1 The Elvis store is open for business;
3.2 Elmer needs an application;
3.3 Visualize Elmer''s application design;
3.4 It all starts with a table;
3.5 Make contact with the MySQL server;
3.6 Create a database for Elmer''s emails;
3.7 Create a table inside the database;
3.8 We need to define our data;
3.9 Take a meeting with some MySQL data types;
3.10 Create your table with a query;
3.11 Getting the cart table in front of the horse database;
3.12 USE the database before you use it;
3.13 DESCRIBE reveals the structure of tables;
3.14 Elmer''s ready to store data;
3.15 Create the Add Email script;
3.16 The other side of Elmer''s application;
3.17 The nuts and bolts of the Send Email script;
3.18 First things first, grab the data;
3.19 mysqli_fetch_array() fetches query results;
3.20 Looping for a WHILE;
3.21 Looping through data with while;
3.22 You''ve got mail...from Elmer!;
3.23 Sometimes people want out;
3.24 Removing data with DELETE;
3.25 Use WHERE to DELETE specific data;
3.26 Minimize the risk of accidental deletions;
3.27 MakeMeElvis.com is a web application;
3.28 Your PHP & MySQL Toolbox;
Chapter 4: Realistic and Practical Applications: Your Application on the Web;
4.1 Elmer has some irritated customers;
4.2 Protecting Elmer from... Elmer;
4.3 Demand good form data;
4.4 The logic behind Send Email validation;
4.5 Your code can make decisions with IF;
4.6 Testing for truth;
4.7 IF checks for more than just equality;
4.8 The logic behind Send Email validation;
4.9 PHP functions for verifying variables;
4.10 Test multiple conditions with AND and OR;
4.11 Form users need feedback;
4.12 Ease in and out of PHP as needed;
4.13 Use a flag to avoid duplicate code;
4.14 Code the HTML form only once;
4.15 A form that references itself;
4.16 Point the form action at the script;
4.17 Check to see if the form has been submitted;
4.18 Some users are still disgruntled;
4.19 Table rows should be uniquely identifiable;
4.20 Primary keys enforce uniqueness;
4.21 The five rules of primary keys:;
4.22 From checkboxes to customer IDs;
4.23 Loop through an array with foreach;
4.24 Your PHP & MySQL Toolbox;
Chapter 5: Working with Data Stored in Files: When a database just isn''t enough;
5.1 Virtual guitarists like to compete;
5.2 The proof is in the rockin'' picture;
5.3 The application needs to store images;
5.4 Planning for image file uploads in Guitar Wars;
5.5 The high score database must be ALTERed;
5.6 How do we get an image from the user?;
5.7 Insert the image filename into the database;
5.8 Find out the name of the uploaded file;
5.9 Where did the uploaded file go?;
5.10 Create a home for uploaded image files;
5.11 Shared data has to be shared;
5.12 Shared script data is required;
5.13 Think of require_once as "insert";
5.14 Timing Order is everything with high scores;
5.15 Honoring the top Guitar Warrior;
5.16 Format the top score with HTML and CSS;
5.17 Only small images allowed;
5.18 File validation makes the app more robust;
5.19 Plan for an Admin page;
5.20 Generate score removal links on the Admin page;
5.21 Scripts can communicate with each other;
5.22 Of GETs and POSTs;
5.23 GET, POST, and high score removal;
5.24 Isolate the high score for deletion;
5.25 Control how much you delete with LIMIT;
5.26 Your PHP & MySQL Toolbox;
Chapter 6: Securing your Application: Assume they''re all out to get you;
6.1 The day the music died;
6.2 Where did the high scores go?;
6.3 Securing the teeming hordes;
6.4 Protecting the Guitar Wars Admin page;
6.5 HTTP authentication requires headers;
6.6 Take control of headers with PHP;
6.7 Authenticating with headers;
6.8 Create an Authorize script;
6.9 Guitar Wars Episode II
: Attack of the High Score Clones;
6.10 Subtraction by addition;
6.11 Security requires humans;
6.12 Plan for moderation in Guitar Wars;
6.13 Make room for approvals with ALTER;
6.14 Unapproved scores aren''t worthy;
6.15 The million-point hack;
6.16 Everything in moderation... ?;
6.17 How exactly did she do it?;
6.18 Tricking MySQL with comments;
6.19 The Add Score form was SQL injected;
6.20 Protect your data from SQL injections;
6.21 A safer INSERT (with parameters);
6.22 Form validation can never be too smart;
6.23 Cease fire!;
6.24 Your PHP & MySQL Toolbox;
Chapter 7: building personalized web apps: Remember me?;
7.1 They say opposites attract;
7.2 Mismatch is all about personal data;
7.3 Mismatch needs user log-ins;
7.4 Come up with a user log-in gameplan;
7.5 Prepping the database for log-ins;
7.6 Constructing a log-in user interface;
7.7 Encrypt passwords with SHA();
7.8 Decrypting Comparing passwords;
7.9 Authorizing users with HTTP;
7.10 Logging In Users with HTTP Authentication;
7.11 A form for signing up new users;
7.12 Give users a chance to sign up;
7.13 Sometimes you just need a cookie;
7.14 What''s in a cookie?;
7.15 Bake Use cookies with PHP;
7.16 Rethinking the flow of log-ins;
7.17 A cookie-powered log-in;
7.18 Navigating the Mismatch application;
7.19 Logging out means deleting cookies;
7.20 Sessions aren''t dependent on the client;
7.21 The life and times of sessions;
7.22 Keeping up with session data;
7.23 Renovate Mismatch with sessions;
7.24 Log out with sessions;
7.25 Complete the session transformation;
7.26 Users aren''t feeling welcome;
7.27 Sessions are short-lived...;
7.28
... but cookies can last forever!;
7.29 Sessions + Cookies = Superior log-in persistence;
Chapter 8: Eliminate Duplicate Code: Sharing is caring;
8.1 Mismatch is in pieces;
8.2 Rebuilding Mismatch from a template;
8.3 Rebuild Mismatch with templates;
8.4 Mismatch is whole again... and much better organized;
Chapter 9: Control your Data, Control your World: Harvesting data;
9.1 Making the perfect mismatch;
9.2 Mismatching is all about the data;
9.3 Break down the Mismatch data;
9.4 Model a database with a schema;
9.5 Wire together multiple tables;
9.6 Foreign keys in action;
9.7 Tables can match row for row;
9.8 One row leads to many;
9.9 Matching rows many-to-many;
9.10 Build a Mismatch questionnaire;
9.11 Get responses into the database;
9.12 We can drive a form with data;
9.13 Speaking of efficiency...;
9.14 Generate the Mismatch questionnaire form;
9.15 The data is now driving the form;
9.16 Strive for a bit of normalcy;
9.17 When normalizing, think in atoms;
9.18 Why be normal, really?;
9.19 Three steps to a normal database;
9.20 Altering the Mismatch database;
9.21 So is Mismatch really normal?;
9.22 A query within a query within a query...;
9.23 Let''s all join hands tables;
9.24 Connect the with dots;
9.25 Surely we can do more with inner joins;
9.26 Simplifying ON with USING;
9.27 Nicknames for tables and columns;
9.28 Joins to the rescue;
9.29 Love is a numbers game;
9.30 Five steps to a successful mismatch;
9.31 Prepare for the mismatch search;
9.32 Compare users for "mismatchiness";
9.33 All we need is a FOR loop;
9.34 Finishing the mismatching;
9.35 Your PHP & MySQL Toolbox;
Chapter 10: String and Custom Functions: Better living through functions;
10.1 A good risky job is hard to find;
10.2 The search leaves no margin for error;
10.3 SQL queries can be flexible with LIKE;
10.4 Explode a string into individual words;
10.5 implode() builds a string from substrings;
10.6 Preprocess the search string;
10.7 Replace unwanted search characters;
10.8 The query needs legit search terms;
10.9 Copy non-empty elements to a new array;
10.10 Sometimes you just need
part of a string;
10.11 Extract substrings from either end;
10.12 Multiple queries can sort our results;
10.13 Functions le