Beginning PHP and MySQL

by Gilmore, W. Jason

• ISBN13: 9781430231141
• ISBN10: 1430231149
• Edition: 4th
• Format: Paperback
• Copyright: 2010-09-15
• Publisher: Apress

Summary

Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmorers"s authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more.Yours"ll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but yours"ll also learn how to effectively integrate them in order to build robust data-driven applications. Gilmore has seven years of experience working with these technologies, and he has packed this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide. What yours"ll learn How to install and configure Apache, PHP 5.3, and MySQL PHP and object-oriented programming basics New PHP 5.3 features and how to use them How to move beyond basic PHP, including using the Zend Framework How to use MySQL to securely store your website's data How to use MySQL Workbench to manage your database Who this book is forDevelopers who want to harness PHP and MySQL to create powerful web applications Table of Contents Introducing PHP Configuring Your Environment PHP Basics Functions Arrays Object-Oriented PHP Advanced OOP Features Error and Exception Handling Strings and Regular Expressions Working with the File and Operating System PEAR Date and Time Forms Authenticating Your Users Handling File Uploads Networking PHP and LDAP Session Handlers Templating with Smarty Web Services Secure PHP Programming SQLite Building Web Sites for the World MVC and the Zend Framework Introducing MySQL Installing and Configuring MySQL The Many MySQL Clients MySQL Storage Engines and Datatypes Securing MySQL Using PHP with MySQL Introducing PDO Stored Routines MySQL Triggers MySQL Views Practical Database Queries Indexes and Searching Transactions Importing and Exporting Data

Table of Contents

Introducing PHP

Configuring Your Environment

PHP Basics

Functions

Arrays

Object-Oriented PHP

Advanced OOP Features

Error and Exception Handling

Strings and Regular Expressions

Working with the File and Operating System

PEAR

Date and Time

Forms

Authenticating Your Users

Handling File Uploads

Networking

PHP and LDAP

Session Handlers

Templating with Smarty

Web Services

Secure PHP Programming

SQLite

Building Web Sites for the World

MVC and the Zend Framework

Introducing MySQL

Installing and Configuring MySQL

The Many MySQL Clients

MySQL Storage Engines and Datatypes

Securing MySQL

Using PHP with MySQL

Introducing PDO

Stored Routines

MySQL Triggers

MySQL Views

Practical Database Queries

Indexes and Searching

Transactions

Importing and Exporting Data

Table of Contents provided by Publisher. All Rights Reserved.