PHP and MySQL Web development, fourth edition

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. Cover......Page 1 Contents......Page 11 Introduction......Page 40 I: Using PHP......Page 50 1 PHP Crash Course......Page 52 Creating a Sample Application: Bob’s Auto Parts......Page 53 Embedding PHP in HTML......Page 56 Adding Dynamic Content......Page 60 Accessing Form Variables......Page 62 Understanding Identifiers......Page 67 Examining Variable Types......Page 68 Understanding Variable Scope......Page 70 Using Operators......Page 71 Working Out the Form Totals......Page 80 Understanding Precedence and Associativity......Page 81 Using Variable Functions......Page 83 Making Decisions with Conditionals......Page 85 Repeating Actions Through Iteration......Page 90 Employing Alternative Control Structure Syntax......Page 95 Next......Page 96 Saving Data for Later......Page 98 Storing and Retrieving Bob’s Orders......Page 99 Opening a File......Page 100 Writing to a File......Page 106 Closing a File......Page 108 Reading from a File......Page 110 Using Other Useful File Functions......Page 115 Locking Files......Page 117 A Better Way: Database Management Systems......Page 118 Next......Page 119 What Is an Array?......Page 120 Numerically Indexed Arrays......Page 121 Arrays with Different Indices......Page 124 Array Operators......Page 126 Multidimensional Arrays......Page 127 Sorting Arrays......Page 131 Sorting Multidimensional Arrays......Page 132 Reordering Arrays......Page 135 Loading Arrays from Files......Page 137 Performing Other Array Manipulations......Page 141 Next......Page 145 Creating a Sample Application: Smart Form Mail......Page 146 Formatting Strings......Page 149 Joining and Splitting Strings with String Functions......Page 155 Comparing Strings......Page 158 Matching and Replacing Substrings with String Functions......Page 159 Introducing Regular Expressions......Page 162 Finding Substrings with Regular Expressions......Page 168 Splitting Strings with Regular Expressions......Page 169 Next......Page 170 The Advantages of Reusing Code......Page 172 Using require() and include()......Page 173 Using Functions in PHP......Page 182 Examining Basic Function Structure......Page 185 Using Parameters......Page 187 Understanding Scope......Page 189 Passing by Reference Versus Passing by Value......Page 192 Using the return Keyword......Page 193 Implementing Recursion......Page 195 Next......Page 197 6 Object-Oriented PHP......Page 198 Understanding Object-Oriented Concepts......Page 199 Creating Classes, Attributes, and Operations in PHP......Page 201 Using Class Attributes......Page 203 Controlling Access with private and public......Page 205 Calling Class Operations......Page 206 Implementing Inheritance in PHP......Page 207 Designing Classes......Page 213 Writing the Code for Your Class......Page 214 Understanding Advanced Object-Oriented Functionality in PHP......Page 222 Next......Page 230 Exception Handling Concepts......Page 232 The Exception Class......Page 234 User-Defined Exceptions......Page 235 Exceptions in Bob’s Auto Parts......Page 238 Exceptions and PHP’s Other Error Handling Mechanisms......Page 241 Next......Page 242 II: Using MySQL......Page 244 8 Designing Your Web Database......Page 246 Relational Database Concepts......Page 247 Designing Your Web Database......Page 250 Web Database Architecture......Page 255 Next......Page 257 9 Creating Your Web Database......Page 258 Using the MySQL Monitor......Page 259 Logging In to MySQL......Page 260 Creating Databases and Users......Page 261 Introducing MySQL’s Privilege System......Page 262 Setting Up a User for the Web......Page 267 Creating Database Tables......Page 268 Understanding MySQL Identifiers......Page 274 Choosing Column Data Types......Page 275 Next......Page 280 What Is SQL?......Page 282 Inserting Data into the Database......Page 283 Retrieving Data from the Database......Page 285 Altering Tables After Creation......Page 300 Dropping a Whole Database......Page 303 Next......Page 304 11 Accessing Your MySQL Database from the Web with PHP......Page 306 How Web Database Architectures Work......Page 307 Querying a Database from the Web......Page 310 Putting New Information in the Database......Page 315 Using Prepared Statements......Page 319 Using Other PHP-Database Interfaces......Page 321 Next......Page 324 Understanding the Privilege System in Detail......Page 326 Making Your MySQL Database Secure......Page 333 Getting More Information About Databases......Page 335 Optimizing Your Database......Page 343 Backing Up Your MySQL Database......Page 344 Implementing Replication......Page 345 Next......Page 348 The LOAD DATA INFILE Statement......Page 350 Storage Engines......Page 351 Transactions......Page 352 Foreign Keys......Page 354 Stored Procedures......Page 355 Next......Page 362 III: E-commerce and Security......Page 364 Considering the Types of Commercial Websites......Page 366 Understanding Risks and Threats......Page 375 Next......Page 378 15 E-commerce Security Issues......Page 380 Security Threats......Page 381 Creating a Security Policy......Page 388 Authentication Principles......Page 389 Encryption Basics......Page 390 Digital Certificates......Page 394 Secure Web Servers......Page 395 Firewalls......Page 396 Data Backups......Page 397 Next......Page 398 Strategies for Dealing with Security......Page 400 Identifying the Threats We Face......Page 402 Understanding Who We’re Dealing With......Page 404 Securing Your Code......Page 406 Securing Your Web Server and PHP......Page 417 Database Server Security......Page 422 Protecting the Network......Page 424 Computer and Operating System Security......Page 426 Disaster Planning......Page 427 Next......Page 429 Identifying Visitors......Page 430 Implementing Access Control......Page 431 Using Basic Authentication......Page 438 Using Basic Authentication in PHP......Page 439 Using Basic Authentication with Apache’s .htaccess Files......Page 441 Using mod_auth_mysql Authentication......Page 445 Next......Page 447 Providing Secure Transactions......Page 448 Using Secure Sockets Layer (SSL)......Page 452 Providing Secure Storage......Page 456 Using Encryption in PHP......Page 458 Further Reading......Page 466 Next......Page 467 IV: Advanced PHP Techniques......Page 468 Uploading Files......Page 470 Using Directory Functions......Page 478 Interacting with the File System......Page 482 Using Program Execution Functions......Page 486 Next......Page 489 Examining Available Protocols......Page 490 Using Data from Other Websites......Page 491 Using Network Lookup Functions......Page 494 Backing Up or Mirroring a File......Page 498 Next......Page 507 Getting the Date and Time from PHP......Page 508 Converting Between PHP and MySQL Date Formats......Page 515 Calculating Dates in PHP......Page 516 Calculating Dates in MySQL......Page 517 Using the Calendar Functions......Page 519 Next......Page 520 22 Generating Images......Page 522 Understanding Image Formats......Page 523 Creating Images......Page 525 Using Automatically Generated Images in Other Pages......Page 529 Using Text and Fonts to Create Images......Page 530 Drawing Figures and Graphing Data......Page 538 Further Reading......Page 546 Next......Page 547 Understanding Basic Session Functionality......Page 548 Implementing Simple Sessions......Page 551 Creating a Simple Session Example......Page 553 Configuring Session Control......Page 555 Implementing Authentication with Session Control......Page 556 Next......Page 563 Evaluating Strings: eval()......Page 564 Serializing Variables and Objects......Page 565 Getting Information About the PHP Environment......Page 567 Temporarily Altering the Runtime Environment......Page 568 Highlighting Source Code......Page 569 Using PHP on the Command Line......Page 570 Next......Page 571 V: Building Practical PHP and MySQL Projects......Page 572 25 Using PHP and MySQL for Large Projects......Page 574 Planning and Running a Web Application Project......Page 575 Reusing Code......Page 576 Writing Maintainable Code......Page 577 Implementing Version Control......Page 581 Documenting Your Projects......Page 583 Prototyping......Page 584 Optimizing Code......Page 585 Testing......Page 587 Next......Page 588 Programming Errors......Page 590 Variable Debugging Aid......Page 598 Error Reporting Levels......Page 601 Altering the Error Reporting Settings......Page 602 Triggering Your Own Errors......Page 603 Handling Errors Gracefully......Page 604 Next......Page 606 Solution Components......Page 608 Solution Overview......Page 610 Implementing the Database......Page 612 Implementing the Basic Site......Page 613 Implementing User Authentication......Page 616 Implementing Bookmark Storage and Retrieval......Page 635 Implementing Recommendations......Page 641 Next......Page 645 Solution Components......Page 646 Solution Overview......Page 648 Implementing the Database......Page 651 Implementing the Online Catalog......Page 654 Implementing the Shopping Cart......Page 662 Implementing Payment......Page 678 Implementing an Administration Interface......Page 680 Next......Page 689 Solution Components......Page 690 Solution Overview......Page 693 Setting Up the Database......Page 694 Examining the Script Architecture......Page 696 Logging In and Out......Page 702 Setting Up Accounts......Page 705 Reading Mail......Page 710 Sending Mail......Page 721 Next......Page 725 Solution Components......Page 726 Solution Overview......Page 728 Setting Up the Database......Page 731 Defining the Script Architecture......Page 733 Implementing Login......Page 741 Implementing User Functions......Page 747 Implementing Administrative Functions......Page 760 Next......Page 779 Understanding the Process......Page 780 Solution Components......Page 781 Solution Overview......Page 782 Designing the Database......Page 783 Viewing the Tree of Articles......Page 786 Viewing Individual Articles......Page 799 Adding New Articles......Page 801 Adding Extensions......Page 808 Next......Page 809 Project Overview......Page 810 Solution Components......Page 815 Solution Overview......Page 817 Handling Problems with Headers......Page 843 Next......Page 844 Project Overview: Working with XML and Web Services......Page 846 Solution Components......Page 852 Solution Overview......Page 854 Installing the Project Code......Page 892 Further Reading......Page 893 34 Building Web 2.0 Applications with Ajax......Page 894 What Is Ajax?......Page 895 Fundamental Ajax......Page 899 Adding Ajax Elements to Earlier Projects......Page 909 For More Information......Page 923 Appendixes......Page 926 A: Installing PHP and MySQL......Page 928 Installing Apache, PHP, and MySQL Under Unix......Page 929 Installing Apache, PHP, and MySQL Under Windows......Page 938 Installing PEAR......Page 944 Setting Up Other Configurations......Page 945 PHP Resources......Page 946 Apache Resources......Page 948 Web Development......Page 949 Index......Page 950 A......Page 951 B......Page 954 C......Page 955 D......Page 959 E......Page 963 F......Page 965 H......Page 973 I......Page 974 K......Page 976 L......Page 977 M......Page 978 N......Page 981 O......Page 982 P......Page 983 R......Page 989 S......Page 991 T......Page 998 U......Page 1001 V......Page 1003 W......Page 1004 Z......Page 1007 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 Master today's best practices for succeeding with PHP 5.5 and MySQL 5.6 web database development! Long acknowledged as the clearest, most practical, and most down-to-earth guide to PHP/MySQL web development, the brand-new Fifth Edition of ""PHP and MySQL Web Development""fully reflects the latest versions of PHP and MySQL. Maintaining the approach that has made this book so successful through, Luke Welling and Laura Thomson add extensive new coverage of security, cloud and mobile development, and using the PEAR repository's massive resources. Part I offers a crash course in using PHP, including data storage/retrieval, arrays, strings, regular expressions, code reuse, objects, and error/exception handling. Next, walk through designing, creating, accessing, and programming MySQL databases. Part III turns to e-commerce, adding extensive new coverage of web security, plus up-to-the-minute discussions of authentication and secure transactions. A full section of advanced PHP techniques addresses everything from networking and filesystem interaction to image generation and session control. The authors conclude with primers on real-world development and debugging, followed by ten start-to-finish case studies, from authentication to content management, personalized PDFs to web services and Web 2.0 apps. 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