Category: MySQL

MySQL 5.5 Reference Manual

My image
  • Author: Oracle
  • Format: online HTML, PDF, EPUB
  • Price: free

This is the official reference manual for MySQL 5.5.

Chapters include:

  • Preface and Notes
  • General Information
  • Installing and Upgrading MySQL
  • Tutorial
  • MySQL Programs
  • MySQL Server Administration
  • Backup and Recovery
  • Optimization
  • Language Structure
  • Internationalization and Localization
  • Data Types
  • Functions and Operators
  • SQL Statement Syntax
  • Storage Engines
  • High Availability and Scalability
  • MySQL Enterprise Monitor
  • MySQL Workbench
  • Replication
  • Partitioning
  • Stored Programs and Views
  • INFORMATION_SCHEMA Tables
  • MySQL Performance Schema
  • Connectors and APIs
  • Extending MySQL

http://dev.mysql.com/doc/

The Web Book

My image
  • Author: Robert Schifreen
  • Format: PDF download (click the blue download button)
  • Price: Free for personal use

The Web Book is a complete 330-page book that tells you how to create a Web site from scratch. It covers everything from registering a domain name and renting some hosting space, to creating your first HTML page, to building full online database applications with PHP and MySQL. You can download The Web Book as a PDF file completely free of charge for personal use.

Contents include:

  • About The Web Book
  • Our Choice of Web Host
  • Licensing The Web Book
  • A Custom Edition For Your Company
  • Who’s Written This Book?  And Why?
  • Why We’re Here
  • From Word Processor to Web Site
  • How long should all this take?
  • What Is a Web Site Anyway?
  • How the Web Works
  • Domain Names
  • The Simple Option
  • The Flexible Option
  • About Web Content
  • Do you need a development server?
  • Getting Everything Together
  • Our Domain Name and Hosting
  • It’s Not Rude to Point
  • Our HTML Editor and FTP Client
  • Amaya
  • Make A Web Work Folder
  • Filezilla
  • Creating Your First Web Page
  • Now step away from the computer!
  • Keep On Reading
  • WWW – What, Why, Who?
  • Importing Existing Content
  • Writing For The Web
  • Fonts and Colours
  • Hyperlinks
  • Linking to Other Sites
  • Mailto: Links
  • Understanding The Basics of HTML
  • Meta tags
  • HTML and Privacy
  • Validating your HTML
  • A Bit More about Accessibility
  • Cascading Style Sheets
  • About DOCTYPEs
  • Getting Started with CSS
  • A Word About Fonts
  • Classes
  • Making Styles Work For You
  • HTML Tags Names
  • A Better CSS Editor
  • ID-based Styles
  • Extreme CSS
  • Page Layouts and Div Tags
  • The CSS Box Model
  • Pictures On Pages
  • About Image Sizes
  • Pictures As Links
  • Finding Images to Use on Your Site
  • A Browser Icon for your Site
  • The Short Cut to Great Web Pages
  • Using an Open Source Design
  • Tweaking the Text
  • Changing the Pictures
  • Changing the CSS Styles
  • Which Style Is This?
  • Adding Pages and Navigation
  • Uploading the Finished Files
  • Rules, Tables and Image Maps
  • Rules
  • Tables
  • Image Maps
  • Password-Protecting your Web Pages
  • The .htaccess File
  • The .htpasswd File
  • Protecting Multiple Folders
  • CMSes and Other Software
  • CMSes and Templates
  • Automatic Installers
  • Try Before You Install
  • A Word about Patching
  • Setting Up A Database
  • General Installation Procedures
  • Uninstalling
  • Joomla
  • Uploading the Files
  • Configuring Joomla
  • Your New Joomla Site
  • WordPress
  • Downloading the Software
  • Make a Database
  • Configure WordPress
  • Upload The Software
  • Final Configuration
  • phpBB
  • File Permissions
  • Plogger
  • Getting Started
  • The Installation Process
  • Uploading Your Pictures
  • Avoiding Data Overload
  • Installing the PSPad Editor
  • Javascript
  • Choose Your Side
  • Javascript and Semicolons
  • Email Address Obfuscation
  • Why Upload?
  • Security and Cookies
  • Morning All!
  • Getting the Screen Size
  • Javascript Toolkits and Frameworks
  • Finding Out More
  • MySQL and Web Databases
  • Databases, Tables, Fields, Rows and Columns
  • Normalization
  • Referential Integrity
  • Creating A Database
  • Using phpMyAdmin
  • Creating The Customers Table
  • Inserting Some Data
  • Querying the Customers Table
  • Introducing PHP
  • Don’t Panic
  • Your First PHP Program
  • Some More PHP
  • Random Numbers
  • Sending Email with PHP
  • Passing Information to PHP
  • Don’t Forget to Sanitize
  • Loop the Loop
  • Arrays
  • User-Defined Functions
  • HTML Forms
  • Creating a Form with Amaya
  • Naming the Form Objects
  • Handling Form Data in PHP
  • Testing The Form
  • Other Types of Form Data
  • Checkbox Arrays
  • Feedback Forms
  • Hidden Fields
  • Accessing MySQL Databases with PHP
  • Counting Rows
  • Reading Data
  • Searching A Table
  • About SQL Injection Attacks
  • Adding Data to a Table
  • Editing a Data Record
  • Deleting Data
  • Putting it All Together
  • Debugging and Global Variables
  • Syntax Errors
  • Coding Errors
  • The $_SERVER Variables
  • The Structure of a PHP Application
  • Web Servers and the Real World
  • Putting the App Together
  • Saving State
  • How to Back Up your Web Site
  • Don’t Forget the Database
  • Restoring Lost Information
  • Finance and Marketing Issues
  • Promoting Your Site
  • Making Money
  • Accepting Online Payments
  • Managing your Marketing
  • Search Engine Optimisation
  • SEO Tips
  • Keeping the Crawlers Away
  • If at First you Don’t Succeed, Pay
  • The End.  So, What Now
  • Appendix A – Building a Test Server
  • Our Goal
  • First Install the OS
  • Some Useful Commands
  • Get Updated
  • Test Your Web Server
  • Install the Telnet Server
  • An ftp server
  • Webmin
  • Webalizer
  • PHP and MySQL

Get the book: The Web Book

PHP and MySQL Programming

My image
  • Author: Wikibooks, the open-content textbooks collection
  • Format: HTML
  • Price: free

This book provides an beginners introduction  to PHP and interacting with MySQL databases. It also includes some material related to developing desktop CLI applications and processing XML.

The book is a work in progress, and there may be incomplete or missing chapters.

Chapters include:

  • Introduction to PHP
  • Syntax Overview
  • File Handling
  • Database Connectivity
  • Session Handling
  • Command Line Programming
  • Form Handling
  • Introduction to MySQL
  • Creating a Database
  • Creating a Table
  • Basic Queries
  • Common Functions and Operators
  • XML and PHP

http://en.wikibooks.org/wiki/PHP_and_MySQL_Programming