Book Description

MariaDB is a database server that offers drop-in replacement functionality for MySQL. Built by some of the original authors of MySQL, with assistance from the broader community of free and open source software developers, MariaDB offers a rich set of feature enhancements to MySQL, including alternate storage engines, server optimizations, and patches.

MariaDB Crash Course teaches you all you need to know to be immediately productive with MariaDB. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of users who simply want to interact with data.

Learn how to:

• Retrieve and sort data
• Filter data using comparisons, regular expressions, and full text search
• Join relational data
• Create and alter tables
• Insert, update, and delete data
• Leverage the power of stored procedures and triggers
• Use views and cursors
• Manage transactional processing
• Create user accounts and manage security via access control Download Now »

Book Description

It hasn’t taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open-source combination. Add this book to the mix, and there’s no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for beginning to intermediate level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest features and techniques with PHP and MySQL. Also new to this edition are chapters introducing jQuery and object-oriented programming techniques.

Table of Contents
Introduction
Chapter 1. Introduction to PHP
Chapter 2. Programming with PHP
Chapter 3. Creating Dynamic Web Sites
Chapter 4. Introduction to MySQL Download Now »

Book Description

If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming.

The important stuff you need to know:

• Get a running start. Write PHP scripts and create a web form right away.
• Learn the language. Get up to speed on PHP and SQL syntax quickly.
• Build a database. Use MySQL to store user information and other data.
• Make it dynamic. Create pages that change with each new viewing.
• Be ready for mistakes. Plan error messages to help direct users.
• Manage your content. Use the file system to access user data, including images and other binary files.
• Control operations. Create an administrative interface to oversee your site.

Table of Contents
Part I: PHP and MySQL Basics
Chapter 1. PHP: What, Why, and Where?
Chapter 2. PHP Syntax: Weird and Wonderful Download Now »

Book Description

Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination

Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons.

When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises.

Lessons include:

• Getting started with PHP
• Setting up your workspace
• Adding PHP to a web page
• Learning PHP syntax
• Working with variables
• Debugging code
• Working with complex data Download Now »

Book Description

A complete lifecycle guide to planning and building a site with DrupalDrupal allows you to quickly and easily build a wide variety of web sites, from very simple blog sites to extremely complex sites that integrate with other systems. In order to maximize what Drupal can do for you, you need to plan. Whether you are building with Drupal 6 or 7, this book details the steps necessary to plan your site so you can make informed decisions before you start to build.

• Explains how to define the scope of your project
• Shows you how to create a design plan taking into consideration how Drupal works
• Helps you make informed decisions regarding development methodologies, environments, standards, and site security
• Reviews ways to assess the use of existing and/or custom Drupal modules
• Teaches you how to avoid common pitfalls that can impact a successful site launch
• Walks you through preparing for post-launch site maintenance and management tasks
• Details incorporating the nature of open source systems into your management strategies
• Identifies ways to interact with members of the Drupal community

The processes and techniques provided in this book will empower you to create a successful and sustainable site with Drupal.

From the Back Cover
Plan and execute each phase of your Drupal website

Download Now »

Book Description

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look.

But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user’s experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.

Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require.

Through a sophisticated sample application–Hugh and Dave’s Wine Store–all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. Download Now »