PEAR is about code reuse. That's the primary motivation for this book. If you're a PHP programmer and you've developed any database projects, PEAR::DB is for you. Over the lifetime of PHP there have been several great database abstractions developed, some OO, some not. PEAR::DB is the standard object oriented database abstraction. As PHP continues to evolve and grow in its user base, more and more developers will be hired to maintain and modify existing code. By standardizing on PEAR, maintenance and upgrades will focus on business-specific code and not general-purpose code such as database access. In-depth coverage of: 1. Installing and configuring PEAR and PEAR::DB on Windows and Linux. 2. Using PEAR::DB to access multiple database back ends including MySQL®, PostgreSQL, Microsoft ® SQL Server, SQLite and others. 3. Much more...

XML, Data, Dates, Web Services, and Web APIs About This Book Maximize your productivity through the use of proven, powerful, reusable PHP components In-depth coverage of a range of important PEAR packages Many code examples provide a clear and practical guidance Who This Book Is For This book is for PHP developers who want to maximize their productivity through the use of proven, high-quality, reusable PEAR components. Some experience of working with PEAR classes will prove helpful, and developers who've used PEAR before can find something new to delight them. What You Will Learn Chapter 1 shows you how to access databases with the MDB2 package. You will learn: Connecting to the database, and instantiate objects Executing queries and fetching data MDB2 SQL abstraction; sequences, replace queries, sub-select support, prepared statements Using MDB2 modules Extending MDB2 to provide custom fetch and result classes, iterators, and modules Chapter 2 explains how to use PEAR packages to display data . It teaches you: Creating powerful tables of data easily with the HTML_Table package Advanced table formatting with HTML_Table_Matrix Creating Excel spreadsheets dynamically with Spreadsheet_Excel_Writer Adding formatting to these spreadsheets including colors, patterns, formulae and number formatting Creating flexible, sortable grids of data with Structures_DataGrid Adding columns to the grid, control paging, select data sources, and renderers Using File_PDF to create PDF documents on the fly Chapter 3 covers the usage of PEAR packages to work with XML and stresses on: Creating XML documents with XML_Util, XML_Fastcreate Transforming PHP objects to XML format with XML_Serializer Creating Mozilla applications with XML_XUL Parsing XML with XML_Parser Processing XML documents to PHP objects with XML_Unserializer Parsing RSS with XML_RSS Chapter 4 is an extensive tutorial on working with web services and Web API's using PEAR packages. We cover the following topics: Consuming web services Consuming XML-RPC-based web services Accessing the Google API Searching blog entries with Services_Technorati Accessing the Amazon web service Accessing the Yahoo API Offering XML-RPC-based web services Offering SOAP-based web services Offering REST-based services using XML_Serializer Chapter 5 covers PEAR's date and time functions using the PEAR::Calendar and PEAR::Date packages such as: Creating, manipulating, and comparing Date objects Data_Span arithmetic Handling time ...

This book has been carefully constructed to be your one stop resource for locating the PEAR package you need. It is the first book that devotes exclusive coverage to PEAR covering key items and topics missing in the online documentation. We have carefully selected the most useful and widely used packages for inclusion in this book. You’ll find the packages inside broken down logically by function. Each package is covered in detail, yet presented in a fashion that allows you to quickly jump to the key items you need to implement a solution. Armed with the knowledge in this book, you will be set to take your PHP development to a new level.

The PEAR Installer maintainer shows you the power of this code management and deployment system to revolutionize your PHP application development

Packed with code examples, every topic is explained in a clear, practical way. This book is for PHP developers who want to maximize their productivity through the use of proven, high-quality, reusable PEAR components. Some experience of working with PEAR classes will prove helpful, and developers who've used PEAR before can find something new to delight them.

This comprehensive tutorial and reference covers all the basics of PHP 5, a popular open source Web scripting language, and MySQL 4.012, the most popular open source database engine Explores why users need PHP and MySQL, how to get started, how to add PHP to HTML, and how to connect HTML Web pages to MySQL Offers an extensive tutorial for developing applications with PHP and MySQL Includes coverage of how to install, administer, and design MySQL databases independently of PHP; exception and error handling; debugging techniques; PostgreSQL database system; and PEAR database functions The authors provide unique case studies of how and where to use PHP drawn from their own extensive Web experience

"Mastering Moodle: A Comprehensive Guide to Learning Management" is tailored for a diverse audience of educators, instructional designers, administrators, and anyone interested in leveraging Moodle as a powerful learning management system. Specifically, this book is ideal for: 1. Educators: Whether you are a teacher, trainer, instructor, or professor, this book equips you with the knowledge and skills to design and deliver engaging online courses using Moodle. 2. Instructional Designers: If you are involved in the design and development of online learning materials, this book provides valuable insights into utilizing Moodle's features to create interactive and effective courses. 3. Administrators: For Moodle administrators responsible for managing and maintaining Moodle sites, this book offers comprehensive guidance on site setup, customization, and troubleshooting. 4. Educational Institutions: Schools, colleges, universities, corporate training departments, and other educational organizations seeking to implement or enhance their online learning programs will find this book invaluable in maximizing the potential of Moodle. 5. Anyone Interested in Online Learning: Whether you are new to online learning or looking to expand your knowledge in the field, "Mastering Moodle" serves as a comprehensive resource for understanding the functionalities and capabilities of Moodle as a learning management system. No matter your level of expertise or role in the realm of education and online learning, "Mastering Moodle" is your essential guide to unlocking the full potential of Moodle for creating engaging, interactive, and effective online learning experiences.