CURRENT BASKET VALUE
£0.00
ABOUT THIS BOOK
PHP and MySQL by Example
£43.99

PHP AND MYSQL BY EXAMPLE

MIXED MEDIA PRODUCT BY QUIGLEY, ELLIE; GARGENTA, MARKO

£43.99

ISBN
9780131875081
IMPRINT
PRENTICE HALL
 
 
EDITION
PUBLISHER
PEARSON EDUCATION (US)
STOCK FOR DELIVERY
ORDER NOW - DESPATCH SUBJECT TO AVAILABILITY
FORMAT
MIXED MEDIA PRODUCT
PAGES
912 pages
PUBLICATION DATE
22 NOV 2006

DESCRIPTION

Quickly master dynamic, database-driven Web development-no experience necessary!Even if you're completely new to PHP, MySQL, and Web database development, this book will guide you through every step of building powerful, database-driven, dynamic Web sites. Direct from the world's top scripting instructor, Ellie Quigley, PHP and MySQL by Example illuminates every concept with tested code examples, screen shots showing program output, and clear, line-by-line explanations. Classroom-tested in Ellie Quigley's Silicon Valley training courses and at Marko Gargenta's Marakana training company in San Francisco, this book takes you from the simplest PHP scripting and SQL querying techniques all the way to dynamic, database driven Web site construction with PHP and MySQL. From simple fill-in forms to program security and debugging, it's the only PHP/MySQL book you'll ever need!This book coversComplete PHP fundamentals, including operators, strings, conditionals, loops, arrays, functions, and more PHP QuickStart for more advanced readers-makes you productive with PHP in the space of just fifteen book pages Essential Web development techniques, from file handling to validating user input with regular expressions Powerful PHP features, including user-defined functions and self-processing PHP Forms Day-to-day MySQL administration A complete SQL tutorial for creating queries, retrieving data, and writing data with MySQL Session management and cookies Object Oriented PHP Best practices for using PHP and MySQL togetherNearly 100,000 professionals and power users have relied on Ellie Quigley's books to master scripting languages. With PHP and MySQL by Example, you can, too. And once you've become an expert, you'll turn to this book constantly as your go-to source for reliable answers, solutions, and code.About the CD-ROMThe CD-ROM contains versions of PHP and MySQL for Windows and UNIX/Linux, plus a comprehensive code library for creating your own sites and database-enabled Web applications, including this book's powerful Art Gallery case study application.Lab SolutionsSolutions to the end-of-chapter labs are available at www.prenhallprofessional.com/title/0131875086.

CONTENTS

Preface xxiiiAcknowledgments xxivChapter 1: Introduction 11.1 From Static to Dynamic Web Sites 11.2 About PHP 41.3 About MySQL 71.4 Chapter Summary 11Chapter 2: Getting Started 132.1 The Life Cycle of a Web Page 132.2 The Anatomy of a PHP Script 152.3 Some Things to Consider 212.4 Review 312.5 Chapter Summary 37Chapter 2 Lab 38Chapter 3: PHP Quick Start 413.1 Quick Start, Quick Reference 413.2 Chapter Summary 57Chapter 4: The Building Blocks: Data Types, Literals, Variables, and Constants 594.1 Data Types 594.2 Variables 704.3 Constants 994.4 Chapter Summary 104Chapter 4 Lab 105Chapter 5: Operators 1075.1 About PHP Operators and Expressions 1075.2 Chapter Summary 145Chapter 5 Lab 146Chapter 6: Strings 1496.1 What Is a String? 1496.2 String Functions 1556.3 Other String Functions 2146.4 Chapter Summary 218Chapter 6 Lab 219Chapter 7: Conditionals and Loops 2217.1 Control Structures, Blocks, and Compound Statements 2217.2 Loops 2327.3 Chapter Summary 243Chapter 7 Lab 244Chapter 8: Arrays 2478.1 What Is an Array? 2478.2 Modifying Arrays (Unsetting, Deleting, Adding, and Changing Elements) 3108.3 Chapter Summary 335Chapter 8 Lab 336Chapter 9: User-Defined Functions 3379.1 What Is a Function? 3379.2 Chapter Summary 376Chapter 9 Lab 377Chapter 10: More on PHP Forms 37910.1 Introduction 37910.2 Review of HTML Forms 37910.3 PHP and Forms 39010.4 Chapter Summary 438Chapter 10 Lab 439Chapter 11: Files and Directories 44111.1 Files 44111.2 The Web Server, PHP, and Permissions 44611.3 Directories 48311.4 Managing Content with Include Files 48711.5 Chapter Summary 494Chapter 12: Regular Expressions and Pattern Matching 49712.1 What Is a Regular Expression? 49712.2 Pattern-Matching Functions 49912.3 Chapter Summary 565Chapter 12 Lab 566Chapter 13: Introduction to MySQL 56713.1 About Databases 56713.2 The Anatomy of a Relational Database 57013.3 Connecting to the Database 57513.4 The MySQL Privilege System 58213.5 Chapter Summary 593Chapter 14: SQL Language Tutorial 59514.1 What Is SQL? 59514.2 SQL Data Manipulation Language (DML) 60314.3 SQL Data Definition Language 62014.4 SQL Functions 63314.5 Chapter Summary 642Chapter 14 Lab 643Chapter 15: PHP and MySQL Integration 64715.1 Introduction 64715.2 The Guest Book Example 66315.3 Chapter Summary 671Chapter 15 Lab 671Chapter 16: Cookies and Sessions 67316.1 What Is Stateless? 67316.2 What Are Cookies? 67316.3 PHP and Cookies 67716.4 What Is a Session? 69416.5 Chapter Summary 736Chapter 16 Lab 738Chapter 17: Objects 73917.1 What Are Objects? 73917.2 Working with Classes 74117.3 Some PHP 5 Object Features 77217.4 Chapter Summary 780Chapter 17 Lab 781Appendix A: Building an Art Gallery 783A.1 Project Overview 783A.2 The Public and the Private 783A.3 Creating the Web Site 785A.4 Installing the Art Gallery 805A.5 Conclusion 808Appendix B: PHP and E-Mail 809B.1 The Mail Server 809B.2 MIME (Multipurpose Internet Mail Extensions) 810B.3 Runtime Configuration Options 810B.4 The mail() Function 811B.5 Sending a Simple E-Mail Message 811B.6 Example: Sending an HTML Message 813Appendix C: PHP and Date/Time 819C.1 Formatting Dates and Times 819C.2 Getting the Timestamp 824C.3 Getting the Date and Time 829Appendix D: Security and Debugging 833D.1 About Security 833D.2 Securing PHP and MySQL 834D.3 Debugging 841Appendix E: Installation Procedures 849E.1 About Web Servers 849E.2 Installing Apache on Windows 849E.3 Installing PHP on Windows 850E.4 Installing PHP on Linux/UNIX 851E.5 Installing PHP on Mac OS X 851E.6 Configuring Apache to use PHP Module (All Platforms) 851E.7 Configuring php.ini (All Platforms) 853E.8 Installing MySQL on Windows 854E.9 Installing MySQL on Linux/UNIX 854E.10 Installing MySQL on Mac OS X 854E.11 Read the Manual 854Index 855