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. 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 Provides an in-depth guide to combining the two open source tools to create dynamic Web sites, updated to incorporate the new features of PHP 5.1 and MySQL 5.1, that encompasses a new section on Ajax, enhanced focus on security issues and Web security, coverage of the PEAR repository of PHP extensions and applications, and new projects. Original. (Intermediate) 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]. David M. Beazley. Includes Index. Previous Ed.: Indianapolis, Ind.: New Riders, 2001.