Free eBooK : Mastering phpMyAdmin for Effective MySQL Management

Mastering phpMyAdmin for Effective MySQL Management

This book is a comprehensive guide to unlocking the full potential of phpMyAdmin. Whether you are an experienced developer, system administrator, web designer or new to MySQL and phpMyAdmin, this book will show you how to increase your productivity and control when working with your MySQL.

phpmyAdmin is one of the most widely used open source applications, but few users are aware of hidden power and features. In this book you’ll learn about:

• Installing, configuring, and customizing phpMyAdmin.
• MySQL administration.
• Managing databases, table data and structures.
• Managing indexes.
• Exporting databases and table data and structures.
• Searching databases and tables
• Using metadata and bookmarks
• Generating multiple SQL queries
• Documenting table structures
• Mime-based transformation
Along the way you’ll build a more detailed understanding of SQL and how it works in MySQL.
--------------------------------
Download Link : Mirror 1

Free eBook : PHP Web 2.0 Mashup Projects

PHP Web 2.0 Mashup Projects

Book Description

This practical tutorial has detailed, carefully explained case studies using PHP to build new, effective mashup applications, which combine data from multiple external online sources into an integrated Web 2.0 experience. If you are confident with PHP programming and interested in mashing things up, this book is for you! All you need to know about formats, protocols, web services, and web APIs is covered as you learn to write PHP code to remotely consume services like Google Maps, Flickr, Amazon, YouTube, MSN Search, Yahoo!, Last.fm, the Internet UPC Database, and even the California Highway Patrol Traffic data! The 5 real-world PHP projects each start with an overview of technologies and protocols needed and then dive into the tools used and details of creating the project, and you can download each project's source code. You will learn how these technologies work with each other and how to use this information, together with your imagination, to build your own cutting-edge websites.
----------------------------------------------
Download Link : Mirror 1

Free eBook : Learning PHP Data Objects

Learning PHP Data Objects

This book is for PHP developers who need to use PHP Data Objects (PDO) for data abstraction. Covering an overview of PDO, getting started, error handling, prepared statements, handling rowsets, advanced uses, and use in an MVC application, it first describes the topic, then gives step-by-step instructions for a particular example. A final appendix covers the object-oriented features of PHP 5. Readers should be familiar with PHP and aware of the basics of data abstraction. Lighter, faster, more powerful than existing data abstraction interfaces, PDO is an open-source query abstraction layer for accessing databases and manipulating returned records that is used with a database-specific PDO driver to access a particular database. It has the same role as classic database abstraction layers such as ODBC and JDBC. PDO ships with PHP 5.1, and is available as a PECL extension for PHP 5.0; PDO requires the new OO features in the core of PHP 5, and so will not run with earlier versions of PHP.
-----------------------------------
Download Link : Mirror 1

Free eBook : PHP Programming Solutions

PHP Programming Solutions

Find real-world solutions to PHP programming problems

Simplify and shorten the PHP application development cycle using the in-depth information contained in this hands-on guide. PHP Programming Solutions clearly lays out more than 250 programming challenges alongside practical solutions, functioning code, detailed explanations, and usage tips.

Inside, you'll learn to manipulate strings and arrays, work with HTML and Web pages, accept and validate user input, parse XML code, and resolve programming problems using PEAR and PECL widgets and extensions. Plus, you'll get detailed coverage of PHP security issues, SQL database interaction, debugging techniques, and error processing.

• Work with numbers, strings, dates, times, files, and directories
• Build complex data structures using PHP's array manipulation API
• Use functions and classes to build modular, reusable code
• Create, update, and cache HTML documents and Web content
• Obtain and process user input submitted via online forms
• Protect, log, and debug PHP script actions
• Authenticate and track users with sessions and cookies
• Traverse, validate, and transform XML documents
• Store and retrieve data from MySQL, PostgreSQL, and Oracle databases
• Interface with different server types, network protocols, and file formats
• Perform efficient exception handling and error processing

------------------------------------
Download Link : Mirror 1

Free eBook : The PHP Anthology: 101 Essential Tips, Tricks & Hacks

The PHP Anthology: 101 Essential Tips, Tricks & Hacks

The PHP Anthology: 101 Essential Tips, Tricks & Hacks, 2nd Edition is a collection of powerful PHP 5 solutions to the most common programming problems.

Featuring best-practice code and a commonsense approach to development, this book includes coverage of:

Manage errors gracefully.

Build functional forms, tables, and SEO-friendly URLs.

Reduce load time with client- and server-side caching.

Produce and utilize web services with XML.

Secure your site using access control systems.

Easily work with files, emails, and images.

And much more

The question and answer format will allow you to to quickly find and reference any of the 101 solutions, saving you hours of Internet research or painful trial & error.

About the Author

Ben Balbo was born in Germany, grew up in the UK, lives in Melbourne, and likes Guinness. While he isn't drinking Guinness (which is most of the time in Melbourne, as it just doesn't taste the same), he earns a living as a PHP developer and trainer, security consultant, and Open Source developer. He has been known to talk in public about web development-related topics, which comes as part of the package of being on the committees of both the Melbourne PHP User Group and Open Source Developers' Club. Although he wouldn't admit this, he participates at this level only in order to go to restaurants or pubs after the meetings. Harry Fuecks is a technical writer, programmer, and system engineer. He has worked in corporate IT since 1994, having completed a Bachelor's degree in Physics. He first came across PHP in 1999, while putting together a small Intranet. Today, he's the lead developer of a corporate Extranet, where PHP plays an important role in delivering a unified platform for numerous back office systems. Davey Shafik is a full time PHP Developer with many year of experience in PHP and related technologies. An avid magazine writer and book author, Davey keeps his mind sharp by trying to tackle problems from a unique perspective. Ligaya Turmelle is a full-time goddess, occasional PHP programmer, and obsessive world traveler. Actively involved with the PHP community as a founding Principal of phpwomen.org, administrator at codewalkers.com, roving reporter for the Developer Zone on Zend.com, and PHP blogger and long-time busybody of #phpc on freenode, she hopes to one day actually meet the people she talks to. When not sitting at her computer staring at the screen, Ligaya can usually be found either playing golf, scuba diving, snorkeling, kayaking, hiking, or just playing with the dogs outside. Ligaya Turmelle is a Zend Certified Engineer. Matthew Weier O'Phinney is a full-time father of two and spends his free time developing in PHP. He is a PEAR developer, core contributor to Zend Framework, and all-around PHP 5 proponent-though PHP 6 cannot come soon enough for him.

----------------------------
Download Now : Mirror 1 , Mirror 2

Free E-Book: MySQL/PHP Database Applications, 2nd Edition

MySQL/PHP Database Applications, 2nd EditionSite Source:
Amazon.com

Editorial Reviews
Amazon.com
How could the combination of PHP and MySQL--which is feature-rich, highly reliable combination, capable of dealing with large traffic volumes, and absolutely free of charge in most cases--be any better? In MySQL/PHP Database Applications, Jay Greenspan and Brad Bulger explain how to work with the capable pair, primarily for applications you might use on a Web site. If you take the time to study the advice and work through your own tests of the concepts presented, it's pretty much certain that you'll walk away with the knowledge you need to do serious development work with the PHP scripting language and the MySQL database server.

Rather than make up trivial programs just to illustrate aspects of the MySQL/PHP environment, this book features code snippets, each half a page or so in length, that illustrate the behavior of key code structures. For example, in explaining conditional statements in PHP, the book gives you a no-frills IF statement with real values in place. It's not always obvious how the code structures will behave in practice, but the book does a consistently good job of commenting intelligently on the place of each aspect of the language in a well-designed application. The latter half of the book attacks specific problems--a chat system, a guest book, and so on--and walks through the setup of MySQL and each important PHP function for each. --David Wall

Topics covered: The PHP server-side scripting language and the MySQL database server, explained for people who have neither a lot of database administration background nor programming experience. Matters of creating and querying databases, and of performing simple and advanced operations with PHP scripting, are covered adroitly. --This text refers to the Paperback edition.

-----------------------------------------------
Download Link :
Mirror 1