Wow! eBook – Blog

Book Description

PHP & MySQL: Novice to Ninja is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully-functional database-driven web site using PHP & MySQL.

This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live web-based content management system.

While this is essentially a beginner’s book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL that include:

• MySQL syntax
• MySQL functions
• MysQL column types
• PHP functions for working with MySQL

Table of Contents
Chapter 1. Installation
Chapter 2. Introducing MySQL
Chapter 3. Introducing PHP
Chapter 4. Publishing MySQL Data on the Web Download Now »

Book Description

The all-in-one HTML, CSS and JavaScript beginner’s guide: covering the three most important languages for web development.

• Covers everything beginners need to know about the HTML and CSS standards and today’s JavaScript and Ajax libraries – all in one book, for the first time
• Integrated, well-organized coverage expertly shows how to use all these key technologies together
• Short, simple lessons teach hands-on skills readers can apply immediately
• By best-selling author Julie Meloni

Mastering HTML, CSS, and JavaScript is vital for any beginning web developer – and the importance of these technologies is growing as web development moves away from proprietary alternatives such as Flash. Sams Teach Yourself HTML, CSS, and JavaScript All in One brings together everything beginners need to build powerful web applications with the HTML and CSS standards and the latest JavaScript and Ajax libraries.

With this book, beginners can get all the modern web development knowledge you need from one expert source. Bestselling author Julie Meloni (Sams Teach Yourself PHP, MySQL and Apache All in One) teaches simply and clearly, through brief, hands-on lessons focused on knowledge you can apply immediately. Meloni covers all the building blocks of practical web design and development, integrating new techniques and features into every chapter. Each lesson builds on what’s come before, showing you exactly how to use HTML, CSS, and JavaScript together to create great web sites. Download Now »

Book Description

Drupal is one of the most powerful PHP Content Management Systems there is. However, why would you install a CMS for every site you build? With just one copy of Drupal you can host several sites. Drupal has long had multi-site support, and Drupal 7’s support is even better than previous versions.

Drupal 7 Multi-Sites Configuration will teach you how to host several websites on a single copy of Drupal. You will learn how to create different sites, each with its own domain, content, and theme. This valuable information will help you to save time by managing modules and sharing them across several sites as well as administering your sites all in one place.

This book will show you how to configure a system for multi-site, and then install several sites on one copy of Drupal, all with their own domain name and database. Learn how to install and share modules and themes, configure Apache, PHP, and MySQL for multi-site, and then manage the site. Once your site system is successfully set up, discover some of the advanced configurations possible with Drupal multi-site, as well as how to upgrade and maintain your sites.

What you will learn from this book

• Configure MySQL and Apache for hosting multiple sites
• Prepare Drupal 7 to host more than one site Download Now »

Book Description

phpmyAdmin is one of the most widely used open source applications, which is written in PHP. phpMyAdmin supports a wide range of operations with MySQL. Currently, it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, export data into various formats and is available in 52 languages.

phpMyAdmin is a web-based front-end to manage MySQL databases and has been adopted by a number of Open-Source distributors.

Mastering phpMyAdmin 3.4 for Effective MySQL Management is an easy-to-read, step-by-step practical guide that walks you through every facet of this legendary tool—phpMyAdmin—and takes you a step ahead in taking full advantage of its potential. This book is filled with illustrative examples that will help you understand every phpMyAdmin feature in detail.

This is the official guide to this popular MySQL web interface. It starts with installing and configuring phpMyAdmin, including the phpMyAdmin Configuration Storage, which is the key to its advanced features. This is followed by configuring authentication in phpMyAdmin and setting parameters that influence the interface as a whole.

You will also learn some advanced features such as defining inter-table relations with the advanced Designer module. You will practice synchronizing databases on different servers and managing MySQL replication to improve performance and data security. Moreover, you will also store queries as bookmarks for their quick retrieval. Download Now »

Book Description

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.

• Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
• Implement improvements in replication, high availability, and clustering
• Achieve high performance when running MySQL in the cloud
• Optimize advanced querying features, such as full-text searches
• Take advantage of modern multi-core CPUs and solid-state disks
• Explore backup and recovery strategies—including new tools for hot online backups

Table of Contents
Chapter 1. MySQL Architecture and History Download Now »

Book Description

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL.

Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence.

• Understand the source of a problem, even when the solution is simple
• Handle problems that occur when applications run in multiple threads
• Debug and fix problems caused by configuration options
• Discover how operating system tuning can affect your server
• Use troubleshooting techniques specific to replication issues
• Get a reference to additional troubleshooting techniques and tools, including third-party solutions
• Learn best practices for safe and effective troubleshooting—and for preventing problems

Table of Contents
Chapter 1. Basics Download Now »