Learning PHP, MySQL, and JavaScript

19.08.2009

Englisch

9780596157135

O'Reilly and Associates

Nein

Robin Nixon

526

1

Unbekannter Einband

mysql, YUI, Apache, dynamic, PEAR

Inhaltsverzeichnis * Chapter 1 Introduction to Dynamic Web Content * HTTP and HTML: Berners-Lee’s Basics * The Benefits of PHP, MySQL, and JavaScript * The Apache Web Server * About Open Source * Bringing It All Together * Test Your Knowledge: Questions * Chapter 2 Setting Up a Development Server * What Is a WAMP, MAMP, or LAMP? * Installing a WAMP on Windows * Installing a MAMP on Mac OS X * Installing a LAMP on Linux * Working Remotely * Using a Program Editor * Using an IDE * Test Your Knowledge: Questions * Chapter 3 Introduction to PHP * Incorporating PHP Within HTML * This Book’s Examples * The Structure of PHP * Test Your Knowledge: Questions * Chapter 4 Expressions and Control Flow in PHP * Expressions * Operators * Conditionals * Looping * Implicit and Explicit Casting * PHP Dynamic Linking * Test Your Knowledge: Questions * Chapter 5 PHP Functions and Objects * PHP Functions * Including and Requiring Files * PHP Version Compatibility * PHP Objects * Test Your Knowledge: Questions * Chapter 6 PHP Arrays * Basic Access * The foreach.as Loop * Multidimensional Arrays * Using Array Functions * Test Your Knowledge: Questions * Chapter 7 Practical PHP * Using printf * Date and Time Functions * File Handling * System Calls * XHTML * Test Your Knowledge: Questions * Chapter 8 Introduction to MySQL * MySQL Basics * Summary of Database Terms * Accessing MySQL via the Command Line * Indexes * MySQL Functions * Accessing MySQL via phpMyAdmin * Test Your Knowledge: Questions * Chapter 9 Mastering MySQL * Database Design * Normalization * Relationships * Transactions * Using EXPLAIN * Backing Up and Restoring * Test Your Knowledge: Questions * Chapter 10 Accessing MySQL Using PHP * Querying a MySQL Database with PHP * A Practical Example * Practical MySQL * Test Your Knowledge: Questions * Chapter 11 Form Handling * Building Forms * Retrieving Submitted Data * An Example Program * Test Your Knowledge: Questions * Chapter 12 Templating with Smarty * Why Smarty? * Installation * Creating Scripts * Creating Templates * A Practical Example * Test Your Knowledge: Questions * Chapter 13 Cookies, Sessions, and Authentication * Using Cookies in PHP * HTTP Authentication * Using Sessions * Test Your Knowledge: Questions * Chapter 14 Exploring JavaScript * JavaScript and HTML Text * Using Comments * Semicolons * Variables * Operators * Variable Typing * Functions * Global Variables * The Document Object Model * Test Your Knowledge: Questions * Chapter 15 Expressions and Control Flow in JavaScript * Expressions * Operators * The with Statement * Using onError * Using try.catch * Conditionals * Looping * Explicit Casting * Test Your Knowledge: Questions * Chapter 16 JavaScript Functions, Objects, and Arrays * JavaScript Functions * JavaScript Objects * JavaScript Arrays * Test Your Knowledge: Questions * Chapter 17 JavaScript and PHP Validation and Error Handling * Validating User Input with JavaScript * Regular Expressions * Redisplaying a Form After PHP Validation * Test Your Knowledge: Questions * Chapter 18 Using Ajax * What Is Ajax? * Using XMLHttpRequest * Test Your Knowledge: Questions * Chapter 19 Using YUI for Ajax and More * Choosing a Framework * Using YUI * Other Uses for YUI * Test Your Knowledge: Questions * Chapter 20 Bringing It All Together * Designing a Social Networking Site * On the Website * rnfunctions.php * rnheader.php * rnsetup.php * index.php * rnsignup.php * rnsignup.php (YUI version) * rncheckuser.php * rnlogin.php * rnprofile.php * rnmembers.php * rnfriends.php * rnmessages.php * rnlogout.php * Appendix Solutions to the Chapter Questions * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Answers * Appendix Online Resources * PHP Resource Sites * MySQL Resource Sites * JavaScript Resource Sites * Ajax Resource Sites * Miscellaneous Resource Sites * O’Reilly Resource Sites * Appendix MySQL’s FULLTEXT Stopwords * Appendix MySQL Functions * String Functions * Date Functions * Time Functions * Appendix Using PEAR and PHPUnit * Installation * Creating a Connect Instance * Rewriting to Use PEAR * Adding Other PEAR Packages * Unit Testing with PHPUnit * Colophon