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. Table of Contents......Page 9 1 Introduction......Page 20 What You Will Learn from This Book......Page 21 How This Book Is Organized......Page 22 Acknowledgments......Page 24 I: The Objective-C 2.0 Language......Page 26 Compiling and Running Programs......Page 28 Explanation of Your First Program......Page 37 Displaying the Values of Variables......Page 41 Exercises......Page 44 What Is an Object, Anyway?......Page 46 Instances and Methods......Page 47 An Objective-C Class for Working with Fractions......Page 49 The @interface Section......Page 52 The @implementation Section......Page 56 The program Section......Page 57 Accessing Instance Variables and Data Encapsulation......Page 63 Exercises......Page 66 Data Types and Constants......Page 68 Arithmetic Expressions......Page 75 Assignment Operators......Page 83 A Calculator Class......Page 84 Bit Operators......Page 86 Exercises......Page 92 5 Program Looping......Page 96 The for Statement......Page 97 The while Statement......Page 108 The do Statement......Page 113 The break Statement......Page 114 Exercises......Page 115 The if Statement......Page 118 The switch Statement......Page 139 Boolean Variables......Page 142 The Conditional Operator......Page 147 Exercises......Page 148 Separate Interface and Implementation Files......Page 152 Synthesized Accessor Methods......Page 158 Accessing Properties Using the Dot Operator......Page 159 Multiple Arguments to Methods......Page 160 Local Variables......Page 165 The self Keyword......Page 168 Allocating and Returning Objects from Methods......Page 169 Exercises......Page 175 It All Begins at the Root......Page 176 Extension Through Inheritance: Adding New Methods......Page 181 Overriding Methods......Page 194 Extension Through Inheritance: Adding New Instance Variables......Page 200 Abstract Classes......Page 202 Exercises......Page 203 Polymorphism: Same Name, Different Class......Page 206 Dynamic Binding and the id Type......Page 210 Compile Time Versus Runtime Checking......Page 212 The id Data Type and Static Typing......Page 213 Exception Handling Using @try......Page 219 Exercises......Page 222 Initializing Classes......Page 224 Scope Revisited......Page 226 Storage Class Specifiers......Page 232 Enumerated Data Types......Page 234 The typedef Statement......Page 237 Data Type Conversions......Page 239 Exercises......Page 241 Categories......Page 244 Protocols......Page 250 Composite Objects......Page 254 Exercises......Page 255 The #define Statement......Page 258 The #import Statement......Page 266 Conditional Compilation......Page 269 Exercises......Page 272 13 Underlying C Language Features......Page 274 Arrays......Page 275 Functions......Page 281 Structures......Page 290 Pointers......Page 302 Unions......Page 321 Miscellaneous Language Features......Page 324 How Things Work......Page 329 Exercises......Page 331 II: The Foundation Framework......Page 334 Foundation Documentation......Page 336 15 Numbers, Strings, and Collections......Page 340 Number Objects......Page 341 String Objects......Page 345 Array Objects......Page 360 Synthesized AddressCard Methods......Page 368 Fast Enumeration......Page 373 Sorting Arrays......Page 381 Dictionary Objects......Page 386 Set Objects......Page 389 Exercises......Page 394 16 Working with Files......Page 396 Managing Files and Directories: NSFileManager......Page 397 Working with Paths: NSPathUtilities.h......Page 408 The Autorelease Pool......Page 424 Reference Counting......Page 425 An Autorelease Example......Page 437 Summary of Memory-Management Rules......Page 438 Garbage Collection......Page 439 Exercises......Page 441 18 Copying Objects......Page 442 The copy and mutablecopy Methods......Page 443 Shallow Versus Deep Copying......Page 445 Implementing the Protocol......Page 448 Copying Objects in Setter and Getter Methods......Page 451 Exercises......Page 453 Archiving with XML Property Lists......Page 454 Archiving with NSKeyedArchiver......Page 456 Writing Encoding and Decoding Methods......Page 459 Using NSData to Create Custom Archives......Page 466 Using the Archiver to Copy Objects......Page 469 Exercises......Page 471 III: Cocoa and the iPhone SDK......Page 472 Framework Layers......Page 474 Cocoa Touch......Page 475 Your First iPhone Application......Page 478 An iPhone Fraction Calculator......Page 495 Summary......Page 510 Exercises......Page 511 IV: Appendixes......Page 514 A......Page 516 D......Page 517 G......Page 518 L......Page 519 P......Page 520 S......Page 521 Z......Page 522 B: Objective-C 2.0 Language Summary......Page 524 C: Address Book Source Code......Page 588 D: Resources......Page 594 A......Page 598 C......Page 600 D......Page 603 F......Page 605 I......Page 607 L......Page 609 M......Page 610 N......Page 611 O......Page 612 P......Page 613 S......Page 615 T......Page 617 V......Page 618 X – Y - Z......Page 619 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 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].