[Database E-books] Mastering phpMyAdmin 3.3.x for Effective MySQL Management

 [Database E books] Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

Publisher: Packt Publishing | ISBN: 1849513546 | edition 2010 | PDF | 412 pages | 23.4 mb

phpMyAdmin is an open source tool written in PHP to handle MySQL administration over the World Wide Web. It can execute SQL statements and manage users and their permissions. However, when it comes to exploiting phpMyAdmin to its full potential, even experienced developers and system administrators are left baffled.

Mastering phpMyAdmin 3.3.x for Effective MySQL Management is an easy-to-follow, step-by-step guide that walks you through every facet of this efficient tool. Author Marc Delisle draws on his experience as one of the leading developers and project administrator of phpMyAdmin and uses his unique tutorial approach to take full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.

The book helps you get started with installing and configuring phpMyAdmin and looks at its features. You then work on a sample project with two basic tables and perform basic actions such as creating, editing, and deleting data, tables, and databases. You will learn how to create up-to-date backups and import the data that you have exported. You will then explore different search mechanisms and options for querying across multiple tables.

The book gradually proceeds to advanced features such as defining inter-table relations and installing the linked-tables infrastructure. Some queries are out of the scope of the interface and this book will show you how to accomplish these tasks with SQL commands.

Download link from Mediafire.com:

Mastering phpMyAdmin 3.3.x for Effective MySQL Management

[Puzzle Game] A Magnetic Adventure

A Magnetic Adventure
Welcome to an adventure of magnetic proportions! Using a small magnet, solve physics-based puzzles that will stretch your gray matter in ways you never imagined. Once you learn to utilize the magnetic force of your little hero, you’ll be able to manipulate a variety of mechanisms, all of which are holding a totem you need in order to protect your world. Open safes, repair clocks and activate teleporters in this innovative Puzzle game, and go on A Magnetic Adventure!
* Clever gameplay
* Perplexing puzzles
* Use a mighty magnet!
System Requirements:
* OS: Windows XP/Vista
* CPU: 1.6 GHz
* RAM: 256 MB
* DirectX: 9.0
* Hard Drive: 54 MB

Download link from Mediafire.com:

A Magnetic Adventure

[Programming E-books] Learning PHP Data Objects

learning php data objects [Programming E books] Learning PHP Data Objects

Learning PHP Data Objects

Learning PHP Data Objects
Publisher: Packt Publishing | ISBN: 1847192661 | edition 2007 | PDF | 185 pages | 2.7 mb

BOOK DESCRIPTION:

In Detail

PDO is lighter, faster, and more powerful than existing PHP data abstraction interfaces. PDO is a common interface to different databases that must be used with a database-specific PDO driver to access a particular database server: the PDO extension does not provide a database abstraction by itself; it doesn’t rewrite SQL, emulate missing database features, or perform any database functions using by itself. It performs the same role as other classic database abstraction layers such as ODBC and JDBC: it’s a query abstraction layer that abstracts the mechanism for accessing a database and manipulating the returned records; each database driver that implements the PDO interface can also expose database-specific features as regular extension functions. ¬ PDO ships with PHP 5.1, and is available as an extension for PHP 5.0; it requires the new object-oriented features of PHP 5, and cannot run with earlier versions of PHP.

This book will teach you how to use the PDO, including its advanced features. Readers need to be aware of the basics of data abstraction and should be familiar with PHP.

What you will learn from this book?

This book covers:

An overview of the technology
Getting started with PDO
Error handling, prepared statements, and handling rowsets
Advanced features, like getting column metadata and setting connection parameters with examples
Approach

This book describes the topic first and then gives step-by-step instructions on how to go about a particular example.

Who this book is written for?

PHP developers who need to use PDO for data abstraction.

BOOK DETAILS:

Paperback: 188 pages
Publisher: Packt Publishing (August 30, 2007)
Language: English
ISBN-10: 1847192661
ISBN-13: 978-1847192660

Download link from Mediafire.com:

Learning PHP Data Objects