Step-by-step instruction helps users learn how to get MySQL, Apache, and PHP4 up and running on a Windows or Linux machine. The companion Web site has sample code for downloading.

Introduction

xix

PART I GETTING STARTED

1

(42)

Installing and Configuring MySQL

3

(16)

Installing Apache

19

(12)

Installing PHP

31

(12)

PART II THE ABSOLUTE BASICS OF CODING IN PHP

43

(42)

Mixing PHP and HTML

45

(12)

Introducing Variables and Operators

57

(16)

Using Variables

73

(12)

PART III START WITH SIMPLE STUFF

85

(72)

Displaying Dynamic Content

87

(18)

Sending E-Mail

105

(20)

Using Your File System

125

(24)

Uploading Files to Your Web Site

149

(8)

PART IV GETTING TO KNOW YOUR DATABASE

157

(64)

Establishing a Connection

159

(18)

Creating a Database Table

177

(16)

Inserting Data into a Table

193

(12)

Selecting and Displaying Data

205

(16)

PART V USER AUTHENTICATION AND TRACKING

221

(44)

Database-Driven User Authentication

223

(14)

Using Cookies

237

(12)

Session Basics

249

(16)

PART VI CREATING YOUR OWN CONTACT MANAGEMENT SYSTEM

265

(102)

Planning Your System

267

(16)

Adding Contacts

283

(14)

Modifying Contacts

297

(22)

Deleting Contacts

319

(18)

Working with Contacts

337

(30)

PART VII ADDITIONAL ADMINISTRATION SCRIPTS

367

(40)

Managing a Simple Mailing List

369

(20)

Creating Custom Logs and Reports

389

(18)

PART VIII APPENDIXES

407

(66)

Appendix A Additional Configuration Options

409

(6)

Appendix B Basic PHP Language Reference

415

(32)

Appendix C Writing Your Own Functions

447

(6)

Appendix D Basic MySQL Reference

453

(8)

Appendix E Database Normalization

461

(8)

Appendix F Getting Help

469

(4)

Index

473

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.