PHP and MySQL Web Development (4th Edition) (Developer's Library)

This is quite simply, the best computer book I've ever read, and the book I wish I'd had ten years ago when I was just starting with websites. It explains PHP and MySQL and how to create even large and complicated websites clearly and concisely. Its examples are well chosen for both their practical uses and how they illustrate the concepts at hand and explained with just about the right mixture of code and explanation, but it doesn't limit itself to just that. It doesn't really ever bog itself down in the minutiae, but stays clear on covering the concepts. For some, this might be a weakness because it doesn't walk you by the hand through every single function php has, but personally I'd rather use the manual for the details and was rather hoping for something that explained as the more complicated concepts behind how to use the functions, which precisely this does. It also handles concepts like security, how to organize code, and what you should want out of a website, whether you're programming brochureware or a technically innovative ecommerce site. Which strictly might not fall directly under PHP or MySQL, but considering the audience for this type of book, is some damn useful information. I'm relatively experienced, but I still feel that I learned a lot from this book, and am recommending it to some friends who have been making noises about learning to program some basic websites as the best starter book once you know some HTML. Table of Contents......Page 8 Introduction......Page 26 I: The Python Language......Page 28 Running Python......Page 30 Variables and Arithmetic Expressions......Page 32 Conditionals......Page 34 File Input and Output......Page 35 Strings......Page 36 Lists......Page 37 Tuples......Page 39 Sets......Page 40 Dictionaries......Page 41 Iteration and Looping......Page 42 Functions......Page 43 Generators......Page 44 Coroutines......Page 45 Objects and Classes......Page 46 Exceptions......Page 47 Modules......Page 48 Getting Help......Page 49 Line Structure and Indentation......Page 50 Numeric Literals......Page 51 String Literals......Page 52 Containers......Page 54 Decorators......Page 55 Source Code Encoding......Page 56 Object Identity and Type......Page 58 Reference Counting and Garbage Collection......Page 59 References and Copies......Page 60 First-Class Objects......Page 61 Built-in Types for Representing Data......Page 62 Built-in Types for Representing Program Structure......Page 72 Built-in Types for Interpreter Internals......Page 76 Object Behavior and Special Methods......Page 79 Operations on Numbers......Page 90 Operations on Sequences......Page 92 String Formatting......Page 95 Advanced String Formatting......Page 97 Operations on Dictionaries......Page 99 Augmented Assignment......Page 100 Conversion Functions......Page 101 Boolean Expressions and Truth Values......Page 102 Order of Evaluation......Page 103 Conditional Expressions......Page 104 Conditional Execution......Page 106 Loops and Iteration......Page 107 Exceptions......Page 109 Context Managers and the with Statement......Page 114 Assertions and __debug__......Page 116 Functions......Page 118 Parameter Passing and Return Values......Page 120 Scoping Rules......Page 121 Functions as Objects and Closures......Page 123 Decorators......Page 126 Generators and yield......Page 127 Coroutines and yield Expressions......Page 129 Using Generators and Coroutines......Page 131 List Comprehensions......Page 133 Generator Expressions......Page 134 Declarative Programming......Page 135 Recursion......Page 137 Documentation Strings......Page 138 Function Attributes......Page 139 eval(), exec(), and compile()......Page 140 The class Statement......Page 142 Scoping Rules......Page 143 Inheritance......Page 144 Polymorphism Dynamic Binding and Duck Typing......Page 147 Static Methods and Class Methods......Page 148 Properties......Page 149 Descriptors......Page 151 Data Encapsulation and Private Attributes......Page 152 Object Memory Management......Page 153 Object Representation and Attribute Binding......Page 156 __slots__......Page 157 Operator Overloading......Page 158 Types and Class Membership Tests......Page 159 Abstract Base Classes......Page 161 Metaclasses......Page 163 Class Decorators......Page 166 Modules and the import Statement......Page 168 Importing Selected Symbols from a Module......Page 170 Execution as the Main Program......Page 171 Module Loading and Compilation......Page 172 Packages......Page 174 Distributing Python Programs and Libraries......Page 177 Installing Third-Party Libraries......Page 179 Reading Command-Line Options......Page 182 Files and File Objects......Page 183 Standard Input, Output, and Error......Page 186 The print Statement......Page 187 Variable Interpolation in Text Output......Page 188 Generating Output......Page 189 Unicode String Handling......Page 190 Unicode I/O......Page 192 Object Persistence and the pickle Module......Page 196 Interpreter Options and Environment......Page 198 Interactive Sessions......Page 200 Launching Python Applications......Page 201 Per-user Site Packages......Page 202 Enabling Future Features......Page 203 Program Termination......Page 204 Documentation Strings and the doctest Module......Page 206 Unit Testing and the unittest Module......Page 208 The Python Debugger and the pdb Module......Page 211 Program Profiling......Page 215 Tuning and Optimization......Page 216 II: The Python Library......Page 224 Built-in Functions and Types......Page 226 Built-In Exceptions......Page 237 Built-In Warnings......Page 241 future_builtins......Page 242 copy......Page 244 gc......Page 245 inspect......Page 247 pickle......Page 251 sys......Page 254 traceback......Page 260 types......Page 262 warnings......Page 263 weakref......Page 265 decimal......Page 268 fractions......Page 275 math......Page 276 numbers......Page 277 random......Page 279 abc......Page 282 array......Page 284 bisect......Page 286 collections......Page 287 contextlib......Page 292 functools......Page 293 heapq......Page 294 itertools......Page 295 operator......Page 298 codecs......Page 302 re......Page 306 string......Page 312 struct......Page 315 unicodedata......Page 318 Relational Database API Specification......Page 322 sqlite3 Module......Page 328 DBM-Style Database Modules......Page 335 shelve Module......Page 336 bz2......Page 338 filecmp......Page 339 fnmatch......Page 341 gzip......Page 342 shutil......Page 343 tarfile......Page 344 tempfile......Page 348 zipfile......Page 349 zlib......Page 353 commands......Page 356 configParser, Configparser......Page 357 datetime......Page 361 errno......Page 368 fcntl......Page 372 io......Page 374 logging......Page 380 mmap......Page 394 msvcrt......Page 397 optparse......Page 399 os......Page 403 os.path......Page 421 signal......Page 424 subprocess......Page 427 time......Page 430 winreg......Page 433 Basic Concepts......Page 438 Concurrent Programming and Python......Page 439 multiprocessing......Page 440 threading......Page 461 queue, Queue......Page 469 Coroutines and Microthreading......Page 471 Network Programming Basics......Page 474 asynchat......Page 477 asyncore......Page 480 select......Page 484 socket......Page 494 ssl......Page 511 SocketServer......Page 514 ftplib......Page 522 http Package......Page 525 smtplib......Page 538 urllib Package......Page 539 xmlrpc Package......Page 549 23 Web Programming......Page 556 cgi......Page 558 cgitb......Page 564 wsgiref......Page 565 webbrowser......Page 569 base64......Page 570 binascii......Page 572 csv......Page 573 email Package......Page 577 hmac......Page 584 HTMLParser......Page 586 json......Page 588 mimetypes......Page 591 quopri......Page 592 xml Package......Page 593 Python Services......Page 610 Operating System Modules......Page 611 Internationalization......Page 612 Miscellaneous......Page 613 III: Extending and Embedding......Page 614 Extension Modules......Page 616 Embedding the Python Interpreter......Page 633 ctypes......Page 637 Advanced Extending and Embedding......Page 644 Jython and IronPython......Page 645 Who Should Be Using Python 3?......Page 646 Set Literals......Page 647 Extended Iterable Unpacking......Page 648 Function Annotations......Page 649 Keyword-Only Arguments......Page 650 Chained Exceptions......Page 651 Advanced Metaclasses......Page 652 Text Versus Bytes......Page 654 print() and exec() Functions......Page 656 Use of Iterators and Views......Page 657 File Names, Arguments, and Environment Variables......Page 658 Porting Code to Python 2.6......Page 659 Using the 2to3 Tool......Page 660 A Practical Porting Strategy......Page 662 Participate......Page 663 Index......Page 664 A......Page 665 B......Page 668 C......Page 670 D......Page 677 E......Page 682 F......Page 686 G......Page 690 H......Page 695 I......Page 697 J......Page 701 L......Page 702 M......Page 705 N......Page 709 O......Page 711 P......Page 713 Q......Page 718 R......Page 719 S......Page 723 T......Page 732 U......Page 736 W......Page 739 X......Page 741 Z......Page 742 PHP and MySQL Web Development, Fourth Edition
The definitive guide to building database-drive Web applications with PHP and MySQL

PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.

PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.

This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, connecting to Web services using XML, and developing Web 2.0 applications with Ajax-based interactivity.

The fourth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP 5 through version 5.3, such as namespaces and closures, as well as features introduced in MySQL 5.1.

TABLE OF CONTENTS

Part I: Using PHP
1 PHP Crash Course
2 Storing and Retrieving Data
3 Using Arrays
4 String Manipulation and Regular Expressions
5 Reusing Code and Writing Functions
6 Object-Oriented PHP
7 Error and Exception Handling

Part II: Using MySQL
8 Designing Your Web Database
9 Creating Your Web Database
10 Working with Your MySQL Database
11 Accessing Your MySQL Database from the Web with PHP
12 Advanced MySQL Administration
13 Advanced MySQL Programming

Part III: E-Commerce and Security
14 Running an E-Commerce Site
15 E-commerce Security Issues
16 Web Application Security
17 Implementing Authentication with PHP and MySQL
18 Implementing Secure Transactions with PHP and MySQL

Part IV: Advanced PHP Techniques
19 Interacting with the File System and the Server
20 Using Network and Protocol Functions
21 Managing the Date and Time
22 Generating Images
23 Using Session Control in PHP
24 Other Useful Features

Part V: Building Practical PHP and MySQL Projects
25 Using PHP and MySQL for Large Projects
26 Debugging
27 Building User Authentication and Personalization
28 Building a Shopping Cart
29 Building a Web-Based Email Service
30 Building a Mailing List Manager
31 Building Web Forums
32 Generating Personalized PDF Documents
33 Connecting to Web Services with XML and SOAP
34 Building Web 2.0 Applications with Ajax

Part VI: Appendixes
Appendix A: Installing PHP and MySQL Appendix B: Web Resources

An intermediate to advanced guide to PHP and MySQL, the free, open-sourced Web development products. Offers coverage of object-oriented Web programming, creating services using SSL and authentication, and other applications. The CD-ROM includes full versions of PHP, MySQL, and Apache for Windows and Linux/Unix systems, several graphics libraries, files containing the code listings in the book, and the entire book in PDF format.

The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1

MySQL is an open source relational database management system that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications.

In MySQL, Paul DuBois provides a comprehensive guide to using and administering MySQL effectively and productively. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers.

The fourth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.0, as well as to add new coverage of features introduced with MySQL 5.1.

“One of the best technical books I have read on any subject.”

–Gregory Haley, C Vu, The Association of C & C++ Users

“A top-notch user’s guide and reference manual, and in my opinion, the only book you’ll need for the daily operation and maintenance of MySQL databases.”

–Eugene Kim, Web Techniques

Introduction 1

Part I: General MySQL Use

Chapter 1: Getting Started with MySQL 13

Chapter 2: Using SQL to Manage Data 101

Chapter 3: Data Types 201

Chapter 4: Stored Programs 289

Chapter 5: Query Optimization 303

Part II: Using MySQL Programming Interfaces

Chapter 6: Introduction to MySQL Programming 341

Chapter 7: Writing MySQL Programs Using C 359

Chapter 8: Writing MySQL Programs Using Perl DBI 435

Chapter 9: Writing MySQL Programs Using PHP 527

Part III: MySQL Administration

Chapter 10: Introduction to MySQL Administration 579

Chapter 11: The MySQL Data Directory 585

Chapter 12: General MySQL Administration 609

Chapter 13: Access Control and Security 699

Chapter 14: Database Maintenance, Backups, and Replication 737

Part IV: Appendixes

Appendix A: Obtaining and Installing Software 777

Appendix B: Data Type Reference 797

Appendix C: Operator and Function Reference 813

Appendix D: System, Status, and User Variable Reference 889

Appendix E: SQL Syntax Reference 937

Appendix F: MySQL Program Reference 1037

Note: Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book.

Appendix G: C API Reference 1121

Appendix H: Perl DBI API Reference 1177

Appendix I: PHP API Reference 1207

Index 1225

Library Journal

MySql is a very popular relational database for a number of reasons: it is free for most applications; while not open source it is heavily used by the open source community; and it runs easily on Windows and UNIX. The author's approach is to use two sample databases to explain SQL (structured query) databases with Perl, PHP, and C; administering MySql; and security. This book will be very popular with users who already understand relational databases and are trying to move from Microsoft or Oracle to MySql. Copyright 2000 Cahners Business Information.\

This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. The Definitive Guide to Using, Programming, and Administering MySQL 5.0 and 5.1 MySQL is an open source relational database management system that has experienced a phenomenal growth in popularity and use. Known for its speed and ease of use, MySQL has proven itself to be particularly well-suited for developing database-backed websites and applications. In MySQL, Paul DuBois provides a comprehensive guide to using and administering MySQL effectively and productively. He describes everything from the basics of getting information into a database and formulating queries, to using MySQL with PHP or Perl to generate dynamic web pages, to writing your own programs that access MySQL databases, to administering MySQL servers. The fourth edition of this bestselling book has been meticulously revised and updated to thoroughly cover the latest features and capabilities of MySQL 5.0, as well as to add new coverage of features introduced with MySQL 5.1. “One of the best technical books I have read on any subject.” –Gregory Haley, C Vu, The Association of C & C++ Users “A top-notch user's guide and reference manual, and in my opinion, the only book you'll need for the daily operation and maintenance of MySQL databases.” –Eugene Kim, Web Techniques Introduction 1 Part I: General MySQL Use Chapter 1: Getting Started with MySQL 13 Chapter 2: Using SQL to Manage Data 101 Chapter 3: Data Types 201 Chapter 4: Stored Programs 289 Chapter 5: Query Optimization 303 Part II: Using MySQL Programming Interfaces Chapter 6: Introduction to MySQL Programming 341 Chapter 7: Writing MySQL Programs Using C 359 Chapter 8: Writing MySQL Programs Using Perl DBI 435 Chapter 9: Writing MySQL Programs Using PHP 527 Part III: MySQL Administration Chapter 10: Introduction to MySQL Administration 579 Chapter 11: The MySQL Data Directory 585 Chapter 12: General MySQL Administration 609 Chapter 13: Access Control and Security 699 Chapter 14: Database Maintenance, Backups, and Replication 737 Part IV: Appendixes Appendix A: Obtaining and Installing Software 777 Appendix B: Data Type Reference 797 Appendix C: Operator and Function Reference 813 Appendix D: System, Status, and User Variable Reference 889 Appendix E: SQL Syntax Reference 937 Appendix F: MySQL Program Reference 1037 Note: Appendixes G, H, and I are located online and are accessible either by registering this book at informit.com/register or by visiting www.kitebird.com/mysql-book. Appendix G: C API THE #1 BESTSELLING BOOK ON OBJECTIVE-C 2.0 Programming in Objective-C 2.0 provides the new programmer a complete, step-by-step introduction to Objective-C, the primary language used to develop applications for the iPhone, iPad, and Mac OS X platforms. The book does not assume previous experience with either C or object-oriented programming languages, and it includes many detailed, practical examples of how to put Objective-C to use in your everyday iPhone/iPad or Mac OS X programming tasks. A powerful yet simple object-oriented programming language that's based on the C programming language, Objective-C is widely available not only on OS X and the iPhone/iPad platform but across many operating systems that support the gcc compiler, including Linux, Unix, and Windows systems. The second edition of this book thoroughly covers the latest version of the language, Objective-C 2.0. And it shows not only how to take advantage of the Foundation framework's rich built-in library of classes but also how to use the iPhone SDK to develop programs designed for the iPhone/iPad platform. Table of Contents 1 Introduction Part I: The Objective-C 2.0 Language 2 Programming in Objective-C 3 Classes, Objects, and Methods 4 Data Types and Expressions 5 Program Looping 6 Making Decisions 7 More on Classes 8 Inheritance 9 Polymorphism, Dynamic Typing, and Dynamic Binding 10 More on Variables and Data Types 11 Categories and Protocols 12 The Preprocessor 13 Underlying C Language Features Part II: The Foundation Framework 14 Introduction to the Foundation Framework 15 Numbers, Strings, and Collections 16 Working with Files 17 Memory Management 18 Copying Objects 19 Archiving Part III: Cocoa and the iPhone SDK 20 Introduction to Cocoa 21 Writing iPhone Applications Part IV: Appendixes A Glossary B Objective-C 2.0 Language Summary C Address Book Source Code D Resources "Linux Kernel Development" details the design and implementation of the Linux kernel, presenting the content in a manner that is beneficial to those writing and developing kernel code, as well as to programmers seeking to better understand the operating system and become more efficient and productive in their coding. The book details the major subsystems and features of the Linux kernel, including its design, implementation, and interfaces. It covers the Linux kernel with both a practical and theoretical eye, which should appeal to readers with a variety of interests and needs. The author, a core kernel developer, shares valuable knowledge and experience on the 2.6 Linux kernel. Specific topics covered include process management, scheduling, time management and timers, the system call interface, memory addressing, memory management, the page cache, the VFS, kernel synchronization, portability concerns, and debugging techniques. This book covers the most interesting features of the Linux 2.6 kernel, including the CFS scheduler, preemptive kernel, block I/O layer, and I/O schedulers. The third edition of Linux Kernel Development includes new and updated material throughout the book: An all-new chapter on kernel data structures Details on interrupt handlers and bottom halves Extended coverage of virtual memory and memory allocation Tips on debugging the Linux kernel In-depth coverage of kernel synchronization and locking Useful insight into submitting kernel patches and working with the Linux kernel community Linux Kernel Development details the design and implementation of the Linux kernel, presenting the content in a manner that is beneficial to those writing and developing kernel code. While the book discusses topics that are theoretical, it does so with the goal of assisting programmers so they better understand the topics and become more efficient and productive in their coding.The book discusses the major subsystems and features of the Linux kernel, including design and implementation, their purpose and goals, and their interfaces. Important computer science and operating system design details are also addressed. The book covers the Linux kernel from both angles -- theoretical and applied -- which should appeal to both types of readers.The author is involved in Linux kernel development, so the latest kernel version is detailed, as the author has access to the not-yet-released development releases.Specific topics covered will include: all the important algorithms, relevant subsystems, process management, scheduling, time management and timers, system call interface, memory addressing, memory management, paging strategies, caching layers, VFS, kernel synchronization, and signals. This is an eBook version of a printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. Objective-C has become the standard programming language for application development on the Mac OS X and iOS platforms. A powerful yet simple object-oriented programming language that's based on the C programming language, Objective-C is widely available not only on Apple platforms but across many operating systems that support the gcc compiler, including Linux, Unix, and Windows systems. ¿ Programming in Objective-C 2.0 provides the new programmer a complete, step-by-step introduction to the Objective-C language. The book does not assume previous experience with either C or object-oriented programming languages, and it includes many detailed, practical examples of how to put Objective-C to use in your everyday programming needs. ¿ The second edition of this book covers Objective-C 2.0. It shows not only how to take advantage of the Foundation framework's rich built-in library of classes but also how to use the iOS SDK to develop programs designed specifically for iOS devices like the iPhone. ¿ Presents An Introduction To Objective-c 2.0, Covering Such Topics As Classes And Objects, Data Types, Polymorphism, Foundation Framework, Memory Management, And Archiving. 1. Introduction -- 2. Programming In Objective-c -- 3. Classes, Objects, And Methods -- 4. Data Types And Expressions -- 5. Program Looping -- 6. Making Decisions -- 7. More On Classes -- 8. Inheritance -- 9. Polymorphism, Dynamic Typing, And Dynamic Binding -- 10. More On Variables And Data Types -- 11. Categories And Protocols -- 12. Preprocessor -- 13. Underlying C Language Features -- 14. Introduction To The Foundation Framework -- 15. Numbers, Strings, And Collections -- 16. Working With Files -- 17. Memory Management -- 18. Copying Objects -- 19. Archiving -- 20. Introduction To Cocoa -- 21. Writing Iphone Applications -- App. A. Glossary -- App. B. Objective-c 2.0 Language Summary -- App. C. Address Book Source Code -- App. D. Resources. Stephen G. Kochan. A Complete Introduction To The Objective-c Language For Mac Os X And Iphone Development--cover. Includes Bibliographical References (p. [575]-578) And Index. In the second edition of MySQL Paul DuBois provides an updated, comprehensive guide to one of the most popular relational database systems. MySQL is the most popular open source database server in the world, with more than 2 million installations and customers including Yahoo!, MP3.com, Motorola, and NASA. MySQL 4.0, now generally available, is a long-awaited update to the database management system that has many new features, including a new table definition file format, enhanced replication, and more functions for a full text search. Instead of giving readers merely an overview of MySQL 4.0, Dubois continues to include the most sought-after answers to the questions he hears most often from the community. This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. Python Essential Reference, 3rd Edition, is a comprehensive reference to the Python programming language. The focus of this latest edition is to add coverage of significant new features and new library modules added to the language over the past five years. Clearly written with concise organization, the new features covered include new style classes, unification of types and classes, xmlrpclip, intertools, bz2 and optparse, making it the most up-to-date Python book on the market. Python Essential Reference is the definitive guide to the Python programming language and it covers the core language, modules in standard library and the techniques used to extend Python with compiled procedures in C/C++. This 3rd edition includes, - New language features and libraries found in Python version 2.4 - Python library references - Coverage of network programming - Handling operating system specific routines on Windows and Mac OS environments - Coverage of email, logging, decimals, urllib2 and XML packages - Python profiling and debugging techniques This practical guide helps programmers better understand the Linux kernel, and to write and develop kernel code. It provides in-depth coverage of all the major subsystems and features of the Linux 2.6 kernel The accompanying CD-ROM contains "full versions of PHP, MySQL, Apache, several graphics libraries, files containing the code listings in the book, and the entire book in pdf format."--Page [696].