OReilly PHP and MySQL, The Missing Manual 2nd (2013).pdf

PHP & MySQL

Second Edition

The book that should have been in the box®

Brett McLaughlin

PHP & MySQL: The Missing Manual, Second Edition

by Brett McLaughlin

Printed in the United States of America.

Published by O’Reilly Media, Inc.,

1005 Gravenstein Highway North, Sebastopol, CA 95472.

O’Reilly books may be purchased for educational, business, or sales promotional use.

Online editions are also available for most titles ( http://my.safaribooksonline.com ).

For more information, contact our corporate/institutional sales department: (800)

998-9938 or corporate@oreilly.com.

November 2011:

First Edition.

November 2012:

Second Edition.

Revision History for the Second Edition:

2012-11-5 First release

See http://oreilly.com/catalog/errata.csp?isbn=0636920024927 for release details.

The Missing Manual is a registered trademark of O’Reilly Media, Inc. The Missing

Manual logo, and “The book that should have been in the box” are trademarks of

O’Reilly Media, Inc. Many of the designations used by manufacturers and sellers to

distinguish their products are claimed as trademarks. Where those designations

appear in this book, and O’Reilly Media is aware of a trademark claim, the

designations are capitalized.

While every precaution has been taken in the preparation of this book, the publisher

assumes no responsibility for errors or omissions, or for damages resulting from the

use of the information contained in it.

[LSI]

ISBN: 978-1-449-32557-2

Contents

The Missing Credits ....................................... vii

Introduction ................................................ 1

PartOne: PHP and MySQL Basics

CHAPTER 1:

PHP: What, Why, and Where? .............................. 15

PHP Comes in Two Flavors: Local and Remote. . . . . . . . . . . . . . . . . . . . . . . . . 15

PHP: Going Local ..................................................21

Write Your First Program ...........................................38

Run Your First Program ............................................ 40

But Where’s That Web Server? ......................................42

CHAPTER2:

PHP Meets HTML .......................................... 45

Script or HTML? ....................................................46

PHP Talks Back ....................................................51

Run PHP Scripts Remotely ..........................................54

CHAPTER 3:

PHP Syntax: Weird and Wonderful ........................ 61

Get Information from a Web Form ...................................62

Working with Text in PHP ...........................................69

The $_REQUEST Variable Is an Array ..................................83

What Do You Do with User Information? ..............................90

CHAPTER 4:

MySQL and SQL: Database and Language ................. 91

What Is a Database?. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91

Installing MySQL ...................................................95

SQL Is a Language for Talking to Databases ..........................104

Par t Two: Dynamic Web Pages

CHAPTER 5:

Connecting PHP to MySQL ................................ 119

Writing a Simple PHP Connection Script .............................120

Cleaning Up Your Code with Multiple Files ...........................132

Building a Basic SQL Query Runner .................................138

iii

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: